individual_locus

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
individual_locus_id serial 10 √ nextval('phenome.individual_locus_individual_locus_id_seq'::regclass)
individual_id int8 19 null
individual.individual_id individual_locus_individual_id_fkey R
locus_id int8 19 null
locus.locus_id individual_locus_locus_id_fkey R
sp_person_id int8 19 √ null
sp_person.sp_person_id individual_locus_sp_person_id_fkey R
create_date timestamptz 35,6 √ now()
modified_date timestamptz 35,6 √ null
obsolete bool 1 √ false

Indexes

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

Relationships

Close relationships within degrees of separation