ALTER TABLE xray_items ADD `loinc_code` varchar(15) NULL
ALTER TABLE student_year_period ADD `student_year_period_name` varchar(100) NOT NULL
ALTER TABLE loinc_code ADD `loinc_example_unit_name` varchar(100) NULL
ALTER TABLE loinc_code ADD `loinc_system_name` varchar(100) NULL
ALTER TABLE loinc_code ADD `loinc_property_name` varchar(50) NULL
ALTER TABLE loinc_code ADD `loinc_component_name` varchar(200) NULL
ALTER TABLE loinc_code ADD `loinc_class_name` varchar(100) NULL
ALTER TABLE loinc_code ADD `loinc_short_name` varchar(250) NULL
ALTER TABLE loinc_code ADD `loinc_long_common_name` varchar(250) NOT NULL
ALTER TABLE lab_items ADD `loinc_code` varchar(15) NULL
ALTER TABLE infant_setting ADD `infant_setting_hospcode_dopa` varchar(5) NULL
ALTER TABLE infant_setting ADD `infant_head_person_name` varchar(150) NULL
ALTER TABLE infant_setting ADD `infant_head_person_cid` varchar(13) NULL
ALTER TABLE infant_setting ADD `infant_registrar_name` varchar(150) NULL
ALTER TABLE infant_setting ADD `infant_authorize_cid` varchar(13) NULL
CREATE TABLE student_year_period ( `student_year_period_id` int NOT NULL )
CREATE TABLE loinc_code ( `loinc_code` varchar(20) NOT NULL )
alter ignore table student_year_period add unique index ix_student_year_period_name (student_year_period_name)
create index ix_loinc_long_common_name on loinc_code (loinc_long_common_name)
create index ix_loinc_class_name on loinc_code (loinc_class_name)
create index ix_loinc_code on lab_items (loinc_code)
alter ignore table health_med_operation_item_organ add unique index ix_unique (health_med_operation_item_organ_id,health_med_operation_item_id,health_med_operation_type_id)
alter ignore table datadictionary add unique index ix_fieldname_tablename_unique (fieldname,tablename)
Index not found : student_year_period.student_year_period_name (student_year_period_name)
Index not found : provis_proced.ix_provis_unique (export_month,pid,seq,proced)
Index not found : provis_diag.ix_provis_unique (export_month,pid,seq,diagcode)
Index not found : loinc_code.ix_loinc_long_common_name (loinc_long_common_name)
Index not found : loinc_code.ix_loinc_class_name (loinc_class_name)
Index not found : lab_items.ix_loinc_code (loinc_code)
Index not found : health_med_operation_item_organ.ix_unique (health_med_operation_item_organ_id,health_med_operation_item_id,health_med_operation_type_id)
Index not found : datadictionary.ix_fieldname_tablename_unique (fieldname,tablename)
หัวข้อ: 3.54.6.6 มาแล้ว !!! (อ่าน 22018 ครั้ง)