locus_history - cxgn_breedbase.phenome

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

locus_history_id

serial

10

√

nextval('phenome.locus_history_locus_history_id_seq'::regclass)

locus_id

int4

10

null

locus.locus_id

locus_history_locus_id_fkey

C

locus_name

varchar

255

√

null

locus_symbol

varchar

32

√

null

original_symbol

varchar

32

√

null

gene_activity

text

2147483647

√

null

locus_description

text

2147483647

√

null

locus_notes

text

2147483647

√

null

linkage_group

varchar

16

√

null

lg_arm

varchar

16

√

null

Showing 1 to 10 of 14 entries

Indexes

Search:

Constraint Name	Type	Sort	Column(s)
locus_history_pkey	Primary key	Asc	locus_history_id

Showing 1 to 1 of 1 entries

Check Constraints

Search:

Constraint Name	Constraint
locus_history_lg_arm_check	((((lg_arm)::text = 'short'::text) OR ((lg_arm)::text = 'long'::text) OR ((lg_arm)::text = ''::text)))

Showing 1 to 1 of 1 entries

Relationships

Close relationships within degrees of separation

One
Two degrees