cvtermsynonym

2784 rows


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 Nulls Auto Default Children Parents Comments
cvtermsynonym_id serial 10 √ nextval('cvtermsynonym_cvtermsynonym_id_seq'::regclass)
cvterm_id int4 10 null
cvterm.cvterm_id cvtermsynonym_cvterm_id_fkey C
synonym varchar 1024 null
type_id int4 10 √ null
cvterm.cvterm_id cvtermsynonym_type_id_fkey C

A synonym can be exact, narrow or borader than

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

Close relationships within degrees of separation