Schema Version: 1.3

phenotype_comparison_cvterm


Columns

Column Type Size Foreign Key Nullable Default Comments
phenotype_comparison_cvterm_id bigserial 19
nextval('chado.phenotype_comparison_cvterm_phenotype_comparison_cvterm_id_seq'::regclass)
phenotype_comparison_id int8 19
phenotype_comparison.phenotype_comparison_id phenotype_comparison_cvterm_phenotype_comparison_id_fkey C
null
cvterm_id int8 19
cvterm.cvterm_id phenotype_comparison_cvterm_cvterm_id_fkey C
null
pub_id int8 19
pub.pub_id phenotype_comparison_cvterm_pub_id_fkey C
null
rank int4 10
0

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
phenotype_comparison_cvterm_pkey Primary key Asc phenotype_comparison_cvterm_id
phenotype_comparison_cvterm_c1 Must be unique Asc/Asc phenotype_comparison_id + cvterm_id
phenotype_comparison_cvterm_idx1 Performance Asc phenotype_comparison_id
phenotype_comparison_cvterm_idx2 Performance Asc cvterm_id

Relationships