allele

1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
allele_id serial 10 nextval('phenome.allele_allele_id_seq'::regclass)
allele_alias.allele_id allele_alias_allele_id_fkey R
allele_dbxref.allele_id allele_dbxref_allele_id_fkey R
allele_history.allele_id allele_history_allele_id_fkey C
individual_allele.allele_id individual_allele_allele_id_fkey R
stock_allele.allele_id stock_allele_allele_id_fkey C
locus_id int4 10 null
locus.locus_id allele_locus_id_fkey R
allele_symbol varchar 32 null
allele_name varchar 255 null
mode_of_inheritance varchar 18 null
allele_synonym _varchar 255 null
allele_phenotype text 2147483647 null
allele_notes text 2147483647 null
obsolete bool 1 false
sp_person_id int4 10 null
sp_person.sp_person_id allele_sp_person_id_fkey R
create_date timestamptz 35,6 now()
modified_date timestamptz 35,6 null
updated_by int4 10 null
sp_person.sp_person_id allele_updated_by_fkey R
is_default bool 1 true
sequence text 2147483647 null

Indexes

Constraint Name Type Sort Column(s)
allele_pkey Primary key Asc allele_id

Check Constraints

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

Relationships