Schema Version: 1.3

phendesc


Description

A summary of a set of phenotypic statements for any one gcontext made in any one publication.

Columns

Column Type Size Foreign Key Nullable Default Comments
phendesc_id bigserial 19
nextval('chado.phendesc_phendesc_id_seq'::regclass)
genotype_id int8 19
genotype.genotype_id phendesc_genotype_id_fkey C
null
environment_id int8 19
environment.environment_id phendesc_environment_id_fkey C
null
description text 2147483647
null
type_id int8 19
cvterm.cvterm_id phendesc_type_id_fkey C
null
pub_id int8 19
pub.pub_id phendesc_pub_id_fkey C
null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
phendesc_pkey Primary key Asc phendesc_id
phendesc_c1 Must be unique Asc/Asc/Asc/Asc genotype_id + environment_id + type_id + pub_id
phendesc_idx1 Performance Asc genotype_id
phendesc_idx2 Performance Asc environment_id
phendesc_idx3 Performance Asc pub_id

Relationships