Table cxgn.sgn_bt.derived_from_source

Generated by
SchemaSpy

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

Dashed lines show
implied relationships

< n > number of related tables

Please support this project

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

derived_from_source_id

serial

√

nextval('derived_from_source_derived_from_source_id_seq'::regclass)

marker_derived_from.derived_from_source_id

marker_derived_from_derived_from_source_id_fkey

source_name

text

2147483647

√

null

source_schema

text

2147483647

√

null

source_table

text

2147483647

√

null

source_col

text

2147483647

√

null

cxgn_production_visible

bool

√

false

Table contained 4 rows at Thu Jun 21 23:03 EDT 2007

Indexes:

Column(s)	Type	Sort	Constraint Name	Anomalies
derived_from_source_id	Primary key	Asc	derived_from_source_pkey
source_schema + source_table + source_col	Must be unique	Asc/Asc/Asc	derived_from_source_source_schema_key	These unique columns are also nullable