Schema Version: 1.3

phenstatement


Description

Phenotypes are things like "larval lethal". Phenstatements are things like "dpp-1 is recessive larval lethal". So essentially phenstatement is a linking table expressing the relationship between genotype, environment, and phenotype.

Columns

Column Type Size Foreign Key Nullable Default Comments
phenstatement_id bigserial 19
nextval('chado.phenstatement_phenstatement_id_seq'::regclass)
genotype_id int8 19
genotype.genotype_id phenstatement_genotype_id_fkey C
null
environment_id int8 19
environment.environment_id phenstatement_environment_id_fkey C
null
phenotype_id int8 19
phenotype.phenotype_id phenstatement_phenotype_id_fkey C
null
type_id int8 19
cvterm.cvterm_id phenstatement_type_id_fkey C
null
pub_id int8 19
pub.pub_id phenstatement_pub_id_fkey C
null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
phenstatement_pkey Primary key Asc phenstatement_id
phenstatement_c1 Must be unique Asc/Asc/Asc/Asc/Asc genotype_id + phenotype_id + environment_id + type_id + pub_id
phenstatement_idx1 Performance Asc genotype_id
phenstatement_idx2 Performance Asc phenotype_id

Relationships

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

Show relationships within degrees of separation