Schema Version: 1.3 Module: chado

synonym


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 Foreign Key Nullable Default Comments
synonym_id bigserial 19
nextval('sequence.synonym_synonym_id_seq'::regclass)
name varchar 255
null

The synonym itself. Should be human-readable machine-searchable ascii text.

type_id int8 19
cvterm.cvterm_id synonym_type_id_fkey C
null

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.

Table contained -1 rows

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