Table cxgn.phenome.individual_locus

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

individual_locus_id

serial

√

nextval('individual_locus_individual_locus_id_seq'::regclass)

individual_id

int8

individual.individual_id

individual_locus_individual_id_fkey

locus_id

int8

locus.locus_id

individual_locus_locus_id_fkey

sp_person_id

int8

√

null

create_date

timestamptz

35,6

√

now()

modified_date

timestamptz

35,6

√

null

obsolete

bool

√

false

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

Indexes:

Column(s)	Type	Sort	Constraint Name
individual_locus_id	Primary key	Asc	individual_locus_pkey
individual_id + locus_id	Must be unique	Asc/Asc	individual_locus_ukey