Schema Version: 1.3

phenotype_comparison


Description

Comparison of phenotypes e.g., genotype1/environment1/phenotype1 "non-suppressible" with respect to genotype2/environment2/phenotype2.

Columns

Column Type Size Foreign Key Nullable Default Comments
phenotype_comparison_id bigserial 19
nextval('chado.phenotype_comparison_phenotype_comparison_id_seq'::regclass)
genotype1_id int8 19
genotype.genotype_id phenotype_comparison_genotype1_id_fkey C
null
environment1_id int8 19
environment.environment_id phenotype_comparison_environment1_id_fkey C
null
genotype2_id int8 19
genotype.genotype_id phenotype_comparison_genotype2_id_fkey C
null
environment2_id int8 19
environment.environment_id phenotype_comparison_environment2_id_fkey C
null
phenotype1_id int8 19
phenotype.phenotype_id phenotype_comparison_phenotype1_id_fkey C
null
phenotype2_id int8 19
phenotype.phenotype_id phenotype_comparison_phenotype2_id_fkey C
√ null
pub_id int8 19
pub.pub_id phenotype_comparison_pub_id_fkey C
null
organism_id int8 19
organism.organism_id phenotype_comparison_organism_id_fkey C
null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
phenotype_comparison_pkey Primary key Asc phenotype_comparison_id
phenotype_comparison_c1 Must be unique Asc/Asc/Asc/Asc/Asc/Asc genotype1_id + environment1_id + genotype2_id + environment2_id + phenotype1_id + pub_id
phenotype_comparison_idx1 Performance Asc genotype1_id
phenotype_comparison_idx2 Performance Asc genotype2_id
phenotype_comparison_idx4 Performance Asc pub_id

Relationships

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

Show relationships within degrees of separation