Column | Type | Size | Foreign Key | Nullable | Default | Comments | ||
---|---|---|---|---|---|---|---|---|
phenotype_comparison_id | bigserial | 19 |
|
nextval('genetic.phenotype_comparison_phenotype_comparison_id_seq'::regclass) | ||||
genotype1_id | int8 | 19 |
|
null | ||||
environment1_id | int8 | 19 |
|
null | ||||
genotype2_id | int8 | 19 |
|
null | ||||
environment2_id | int8 | 19 |
|
null | ||||
phenotype1_id | int8 | 19 |
|
null | ||||
phenotype2_id | int8 | 19 |
|
√ | null | |||
pub_id | int8 | 19 |
|
null | ||||
organism_id | int8 | 19 |
|
null |
Showing 1 to 9 of 9 entries
Table contained -1 rows
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 |
Showing 1 to 5 of 5 entries
The following entity relationship (ER) diagram shows the relationships involving the phenotype_comparison 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.