| tblGeneSynonyms |
|
primary key:
ky_gene_synonym_id integer |
|
cc_synonym_source Character; Maximum length = 2 (database that
has the synonym)
|
|
see note 1 |
|
ch_gene_name Character; Maximum length = 20 (see note 2) |
|
ch_synonym_name Character; Maximum length = 20 |
| |
|
tblSyndromeSynonyms |
|
primary key:
ky_syndrome_synonym_id integer |
|
cc_synonym_source Character; Maximum length = 2
|
|
ch_syndrome_name Character; Maximum length = 80
|
| cc_synonym_name_language Character;
Maximum length = 2 |
| ky_syndrome_id integer |
| |
| Notes: |
| 1. column names with a prefix
of cc indicate a corresponding entry in the common code |
| table.
This allows display of a field to vary with the user's
language
|
| 2. For the most part, a length of 12
characters suffices for gene names. An opportunity |
|
for a standard. Note that some thought might be given to
representation in other |
|
alphabets such as Cyrillic, Greek, Hebrew and the vast family
of Brahmic scripts as well |
|
as logographic scripts such as Chinese, Japanese and Korean. |
| |