registry

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
registry_id serial 10 √ nextval('phenome.registry_registry_id_seq'::regclass)
locus_registry.registry_id locus_registry_registry_id_fkey R
symbol varchar 32 null
name varchar 255 null
description text 2147483647 null
origin varchar 32 √ null
sp_person_id int4 10 null
sp_person.sp_person_id registry_sp_person_id_fkey R
updated_by int4 10 √ null
sp_person.sp_person_id registry_updated_by_fkey R
create_date timestamptz 35,6 √ now()
modified_date timestamptz 35,6 √ null
status varchar 32 √ null

Indexes

Constraint Name Type Sort Column(s)
registry_pkey Primary key Asc registry_id
symbol_name_key Must be unique Asc/Asc symbol + name

Check Constraints

Constraint Name Constraint
registry_status_check ((((status)::text = 'registered'::text) OR ((status)::text = 'active'::text) OR ((status)::text = 'inactive'::text) OR ((status)::text = 'deleted'::text) OR ((status)::text = 'obsolete'::text)))

Relationships

Close relationships within degrees of separation