| tblCommonCodes |
|
primary key:
cc_language +
cc_common_type +
cc_common_value |
|
cc_language Character; Maximum length = 2 |
|
ch_common_desc Character; Max length = 50
|
|
cc_common_type Character; Max length = 2 |
|
cc_common_value Character; Max length = 2 |
| |
|
tblPersonMutations |
|
primary key:
ky_person_mutation_id integer |
|
ky_syndrome_mutation_id integer |
|
ky_person_id integer - a way to link to a person in another
database |
|
dt_start Date and Time - date first effective |
|
dt_end Date and Time - date no longer effective
|
|
ky_vendor_panel_id integer
|
| |