Schema Version: 1.3

organism_cvterm


Description

organism to cvterm associations. Examples: taxonomic name

Columns

Column Type Size Foreign Key Nullable Default Comments
organism_cvterm_id bigserial 19
nextval('chado.organism_cvterm_organism_cvterm_id_seq'::regclass)
organism_id int8 19
organism.organism_id organism_cvterm_organism_id_fkey C
null
cvterm_id int8 19
cvterm.cvterm_id organism_cvterm_cvterm_id_fkey C
null
rank int4 10
0

Property-Value ordering. Any organism_cvterm can have multiple values for any particular property type - these are ordered in a list using rank, counting from zero. For properties that are single-valued rather than multi-valued, the default 0 value should be used
pub_id int8 19
pub.pub_id organism_cvterm_pub_id_fkey C
null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
organism_cvterm_pkey Primary key Asc organism_cvterm_id
organism_cvterm_c1 Must be unique Asc/Asc/Asc organism_id + cvterm_id + pub_id
organism_cvterm_idx1 Performance Asc organism_id
organism_cvterm_idx2 Performance Asc cvterm_id

Relationships

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

Show relationships within degrees of separation