individual_locus - cxgn_breedbase.phenome

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

individual_locus_id

serial

10

√

nextval('phenome.individual_locus_individual_locus_id_seq'::regclass)

individual_id

int8

19

null

individual.individual_id

individual_locus_individual_id_fkey

R

locus_id

int8

19

null

locus.locus_id

individual_locus_locus_id_fkey

R

sp_person_id

int8

19

√

null

sp_person.sp_person_id

individual_locus_sp_person_id_fkey

R

create_date

timestamptz

35,6

√

now()

modified_date

timestamptz

35,6

√

null

obsolete

bool

1

√

false

Showing 1 to 7 of 7 entries

Indexes

Search:

Constraint Name	Type	Sort	Column(s)
individual_locus_pkey	Primary key	Asc	individual_locus_id
individual_locus_ukey	Must be unique	Asc/Asc	individual_id + locus_id

Showing 1 to 2 of 2 entries

Relationships

Close relationships within degrees of separation

One
Two degrees