allele - cxgn_breedbase.phenome

Columns

Related columns Constraint Comments

Search:

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

Showing 1 to 10 of 15 entries

Indexes

Search:

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

Showing 1 to 1 of 1 entries

Check Constraints

Search:

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)))

Showing 1 to 1 of 1 entries

Relationships

Close relationships within degrees of separation

One
Two degrees