locus_unigene - cxgn_breedbase.phenome

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

locus_unigene_id

serial

10

√

nextval('phenome.locus_unigene_locus_unigene_id_seq'::regclass)

locus_id

int4

10

null

locus.locus_id

locus_unigene_locus_id_fkey

R

unigene_id

int4

10

null

unigene.unigene_id

locus_unigene_unigene_id_fkey

R

obsolete

bool

1

√

false

sp_person_id

int4

10

√

null

sp_person.sp_person_id

locus_unigene_sp_person_id_fkey

R

create_date

timestamptz

35,6

√

now()

modified_date

timestamptz

35,6

√

null

Showing 1 to 7 of 7 entries

Indexes

Search:

Constraint Name	Type	Sort	Column(s)
locus_unigene_pkey	Primary key	Asc	locus_unigene_id
locus_unigene_key	Must be unique	Asc/Asc	locus_id + unigene_id

Showing 1 to 2 of 2 entries

Relationships

Close relationships within degrees of separation

One
Two degrees