Table cxgn.phenome.locus_registry

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

locus_registry_id

serial

√

nextval('locus_registry_locus_registry_id_seq'::regclass)

locus_id

int4

√

null

locus.locus_id

locus_registry_locus_id_fkey

registry_id

int4

√

null

registry.registry_id

locus_registry_registry_id_fkey

sp_person_id

int4

create_date

timestamptz

35,6

√

now()

modified_date

timestamptz

35,6

√

null

obsolete

bool

√

false

Table contained 3 rows at Wed May 20 01:35 EDT 2009

Indexes:

Column(s)	Type	Sort	Constraint Name	Anomalies
locus_registry_id	Primary key	Asc	locus_registry_pkey
locus_id + registry_id	Must be unique	Asc/Asc	locus_registry_id_key	These unique columns are also nullable