locus_alias

1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
locus_alias_id serial 10 √ nextval('phenome.locus_alias_locus_alias_id_seq'::regclass)
alias text 2147483647 null
locus_id int4 10 null
locus.locus_id locus_alias_locus_id_fkey R
preferred bool 1 √ false
obsolete bool 1 √ false
sp_person_id int4 10 √ null
sp_person.sp_person_id locus_alias_sp_person_id_fkey R
create_date timestamptz 35,6 √ now()
modified_date timestamptz 35,6 √ null

Indexes

Constraint Name Type Sort Column(s)
locus_alias_pkey Primary key Asc locus_alias_id

Relationships

Close relationships within degrees of separation