locus_registry

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
locus_registry_id serial 10 √ nextval('phenome.locus_registry_locus_registry_id_seq'::regclass)
locus_id int4 10 √ null
locus.locus_id locus_registry_locus_id_fkey R
registry_id int4 10 √ null
registry.registry_id locus_registry_registry_id_fkey R
sp_person_id int4 10 null
sp_person.sp_person_id locus_registry_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)
locus_registry_pkey Primary key Asc locus_registry_id
locus_registry_id_key Must be unique Asc/Asc locus_id + registry_id

Relationships

Close relationships within degrees of separation