Schema Version: 1.3 Module: chado

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('genetic.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

The following entity relationship (ER) diagram shows the relationships involving the phendesc table.

These relationships often cross chado module boundries, in which case the table name will be prefixed with the module it is in. When querying these tables do not include the module name, as all chado tables are contained within the same schema.

Show relationships within degrees of separation