germplasm - cxgn_breedbase.phenome

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

germplasm_id

serial

10

√

nextval('phenome.germplasm_germplasm_id_seq'::regclass)

germplasm_type

varchar

10

√

null

individual_id

int8

19

null

individual.individual_id

germplasm_individual_id_fkey

R

description

text

2147483647

√

null

dbxref_id

int8

19

√

null

dbxref.dbxref_id

germplasm_dbxref_id_fkey

R

sp_person_id

int8

19

√

null

sp_person.sp_person_id

germplasm_sp_person_id_fkey

R

create_date

timestamptz

35,6

√

now()

modified_date

timestamptz

35,6

√

null

obsolete

bool

1

√

false

Showing 1 to 9 of 9 entries

Indexes

Search:

Constraint Name	Type	Sort	Column(s)
germplasm_pkey	Primary key	Asc	germplasm_id

Showing 1 to 1 of 1 entries

Check Constraints

Search:

Constraint Name	Constraint
chk_germplasm_germplasm_type	((((germplasm_type)::text = 'seed'::text) OR ((germplasm_type)::text = 'vegetative'::text)))

Showing 1 to 1 of 1 entries

Relationships

Close relationships within degrees of separation

One
Two degrees