Schema Version: 1.3

cvtermsynonym


Description

A cvterm actually represents a distinct class or concept. A concept can be refered to by different phrases or names. In addition to the primary name (cvterm.name) there can be a number of alternative aliases or synonyms. For example, "T cell" as a synonym for "T lymphocyte".

Columns

Column Type Size Foreign Key Nullable Default Comments
cvtermsynonym_id bigserial 19
nextval('chado.cvtermsynonym_cvtermsynonym_id_seq'::regclass)
cvterm_id int8 19
cvterm.cvterm_id cvtermsynonym_cvterm_id_fkey C
null
synonym varchar 1024
null
type_id int8 19
cvterm.cvterm_id cvtermsynonym_type_id_fkey C
√ null

A synonym can be exact, narrower, or broader than.

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
cvtermsynonym_pkey Primary key Asc cvtermsynonym_id
cvtermsynonym_c1 Must be unique Asc/Asc cvterm_id + synonym
cvtermsynonym_idx1 Performance Asc cvterm_id

Relationships

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

Show relationships within degrees of separation