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

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

These relationships often cross chado module boundries, in which case the table name will be prefixed with the module it is in. When querying these tables do not include the module name, as all chado tables are contained within the same schema.

Show relationships within degrees of separation