HOSxP 3.51.11.19 Version ตรัง
Checking structure phase 2
ALTER TABLE xray_status ADD `xray_status_name` varchar(150) NOT NULL
ALTER TABLE xray_film_staff ADD `staff` varchar(50) NOT NULL
ALTER TABLE xray_film_staff ADD `xn` int NOT NULL
ALTER TABLE universal_form_design ADD `universal_lookup_key_field` varchar(100) NULL
ALTER TABLE universal_form_design ADD `universal_lookup_list_field` varchar(100) NULL
ALTER TABLE universal_form_design ADD `universal_lookup_table` varchar(100) NULL
ALTER TABLE universal_form_design ADD `universal_is_lookup` char(1) NULL
ALTER TABLE schedule ADD `sync_id` int NULL
ALTER TABLE schedule ADD `reminder_resources_data` blob NULL
ALTER TABLE schedule ADD `reminder_minutes_beforestart` int NULL
ALTER TABLE schedule ADD `reminder_date` datetime NULL
ALTER TABLE operation_list ADD `operation_anes_physical_status_id` int NULL
ALTER TABLE operation_anes_physical_status ADD `operation_anes_physical_status_name` varchar(250) NOT NULL
ALTER TABLE operation_anes_oper_list ADD `qty` int NULL
ALTER TABLE operation_anes_oper_list ADD `opi_guid` varchar(38) NULL
ALTER TABLE operation_anes_oper_list ADD `price` double(15,3) NULL
ALTER TABLE operation_anes_oper_list ADD `operation_anes_oper_end_datetime` datetime NULL
ALTER TABLE operation_anes_oper_list ADD `operation_anes_oper_begin_datetime` datetime NULL
ALTER TABLE operation_anes_oper_list ADD `doctor` varchar(9) NULL
ALTER TABLE operation_anes_oper_list ADD `operation_anes_oper_id` int NOT NULL
ALTER TABLE operation_anes_oper_list ADD `operation_id` int NOT NULL
ALTER TABLE operation_anes_oper ADD `price` double(15,3) NULL
ALTER TABLE operation_anes_oper ADD `icode` varchar(7) NULL
ALTER TABLE operation_anes_oper ADD `operation_anes_oper_name` varchar(150) NOT NULL
ALTER TABLE opduser ADD `xray_staff` char(1) NULL
ALTER TABLE ipt_treatment_list ADD `treatment_end_time` time NULL
ALTER TABLE ipt_pregnancy ADD `dead_child_count` int NULL
ALTER TABLE death ADD `newborn_death_cause_id` int NULL
CREATE TABLE xray_status ( `xray_status_id` int NOT NULL )
CREATE TABLE xray_film_staff ( `xray_film_staff_id` int NOT NULL )
CREATE TABLE operation_anes_physical_status ( `operation_anes_physical_status_id` int NOT NULL )
CREATE TABLE operation_anes_oper_list ( `operation_anes_oper_list_id` int NOT NULL )
CREATE TABLE operation_anes_oper ( `operation_anes_oper_id` int NOT NULL )