|
cc_vendor_type Character; Maximum length = 2 |
|
ch_vendor_name Character; Max length = 80
|
|
cc_vendor_URL Character; Max length = 80 (see note 8) |
|
dt_start Date and Time - date first effective |
|
dt_end Date and Time - date no longer effective
|
| |
|
tblVendorPanels |
|
primary key:
ky_vendor_panel_id integer |
|
ch_panel_desc Character; Max length = 60 |
|
dt_start Date and Time - date first effective |
|
dt_end Date and Time - date no longer effective
|
|
ky_vendor_id integer
|
| |
|
tblPanelGenes |
|
primary key:
ky_panel_gene_id integer |
| ch_gene_desc Character; Max
length = 20 |
|
ky_vendor_panel_id integer |
| |
| Notes: |
| 8. It seems simplest to get vendor
telephone, contact and address from the website |
| |