synonym

0 rows


Description

A synonym for a feature. One feature can have multiple synonyms, and the same synonym can apply to multiple features

Columns

Column Type Size Nulls Auto Default Children Parents Comments
synonym_id serial 10 √ nextval('synonym_synonym_id_seq'::regclass)
feature_synonym.synonym_id feature_synonym_synonym_id_fkey C
name varchar 255 null

The synonym itself. Should be human-readable machine-searchable ascii text
type_id int4 10 null
cvterm.cvterm_id synonym_type_id_fkey C

types would be symbol and fullname for now
synonym_sgml varchar 255 null

The fully specified synonym, with any non-ascii characters encoded in SGML

Indexes

Constraint Name Type Sort Column(s)
synonym_pkey Primary key Asc synonym_id
synonym_c1 Must be unique Asc/Asc name + type_id
synonym_idx1 Performance Asc type_id
synonym_idx2 Performance

Relationships

Close relationships within degrees of separation