germplasm

0 rows


Columns

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

Indexes

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

Check Constraints

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

Relationships

Close relationships within degrees of separation