allele_history

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
allele_history_id serial 10 √ nextval('phenome.allele_history_allele_history_id_seq'::regclass)
allele_id int4 10 null
allele.allele_id allele_history_allele_id_fkey C
locus_id int4 10 null
locus.locus_id allele_history_locus_id_fkey C
allele_symbol varchar 32 √ null
allele_name varchar 32 √ null
mode_of_inheritance varchar 18 √ null
allele_phenotype text 2147483647 √ null
sp_person_id int4 10 √ null
sp_person.sp_person_id allele_history_sp_person_id_fkey R
updated_by int4 10 √ null
sp_person.sp_person_id allele_history_updated_by_fkey R
obsolete bool 1 √ false
create_date timestamptz 35,6 √ now()
sequence text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
allele_history_pkey Primary key Asc allele_history_id

Check Constraints

Constraint Name Constraint
allele_history_mode_of_inheritance_check ((((mode_of_inheritance)::text = 'dominant'::text) OR ((mode_of_inheritance)::text = 'partially dominant'::text) OR ((mode_of_inheritance)::text = 'recessive'::text) OR ((mode_of_inheritance)::text = ''::text)))

Relationships

Close relationships within degrees of separation