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 |
|
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 |