phenotype_cvterm

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
phenotype_cvterm_id serial 10 nextval('phenotype_cvterm_phenotype_cvterm_id_seq'::regclass)
phenotype_id int4 10 null
phenotype.phenotype_id phenotype_cvterm_phenotype_id_fkey C
cvterm_id int4 10 null
cvterm.cvterm_id phenotype_cvterm_cvterm_id_fkey C
rank int4 10 0

Indexes

Constraint Name Type Sort Column(s)
phenotype_cvterm_pkey Primary key Asc phenotype_cvterm_id
phenotype_cvterm_c1 Must be unique Asc/Asc/Asc phenotype_id + cvterm_id + rank
phenotype_cvterm_idx1 Performance Asc phenotype_id
phenotype_cvterm_idx2 Performance Asc cvterm_id

Relationships