phendesc

0 rows


Description

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

Columns

Column Type Size Nulls Auto Default Children Parents Comments
phendesc_id serial 10 √ nextval('phendesc_phendesc_id_seq'::regclass)
genotype_id int4 10 null
genotype.genotype_id phendesc_genotype_id_fkey C
environment_id int4 10 null
environment.environment_id phendesc_environment_id_fkey C
description text 2147483647 null
type_id int4 10 null
cvterm.cvterm_id phendesc_type_id_fkey C
pub_id int4 10 null
pub.pub_id phendesc_pub_id_fkey C

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

Close relationships within degrees of separation