HOSxP 3.51.10.29
Checking structure phase 2
ALTER TABLE vaccine_combination ADD `vaccine_combine_code` varchar(20) NOT NULL
ALTER TABLE vaccine_combination ADD `vaccine_code` varchar(20) NOT NULL
ALTER TABLE stock_subdraw_type ADD `stock_subdraw_type_name` varchar(150) NOT NULL
ALTER TABLE stock_subdraw ADD `stock_subdraw_type_id` int NULL
ALTER TABLE stock_opitemrece ADD `ipt_order_no` int NULL
ALTER TABLE referout_status ADD `referout_status_name` varchar(150) NOT NULL
ALTER TABLE pregnancy_abort_type ADD `pregnancy_abort_type_name` varchar(150) NOT NULL
ALTER TABLE person_anc ADD `post_labor_service_percent` double(15,3) NULL
ALTER TABLE person_anc ADD `pre_labor_service_percent` double(15,3) NULL
ALTER TABLE operation_schedule_resource ADD `resource_image_index` int NULL
ALTER TABLE operation_schedule_resource ADD `resource_color` int NULL
ALTER TABLE operation_schedule_resource ADD `resource_name` varchar(250) NULL
ALTER TABLE operation_schedule ADD `sync_id` int NULL
ALTER TABLE operation_schedule ADD `staff_modified` varchar(25) NULL
ALTER TABLE operation_schedule ADD `last_modified` datetime NULL
ALTER TABLE operation_schedule ADD `staff` varchar(25) NULL
ALTER TABLE operation_schedule ADD `operation_name` varchar(250) NULL
ALTER TABLE operation_schedule ADD `hn` varchar(9) NULL
ALTER TABLE operation_schedule ADD `patient_name` varchar(150) NULL
ALTER TABLE operation_schedule ADD `actual_finish` int NULL
ALTER TABLE operation_schedule ADD `actual_start` int NULL
ALTER TABLE operation_schedule ADD `event_type` int NULL
ALTER TABLE operation_schedule ADD `reminder_resources_data` blob NULL
ALTER TABLE operation_schedule ADD `reminder_minutes_beforestart` int NULL
ALTER TABLE operation_schedule ADD `reminder_date` datetime NULL
ALTER TABLE operation_schedule ADD `task_status` int NULL
ALTER TABLE operation_schedule ADD `task_links` blob NULL
ALTER TABLE operation_schedule ADD `task_index` int NULL
ALTER TABLE operation_schedule ADD `task_complete` int NULL
ALTER TABLE operation_schedule ADD `doctor_code` varchar(7) NULL
ALTER TABLE operation_schedule ADD `label_color` int NULL
ALTER TABLE operation_schedule ADD `state` int NULL
ALTER TABLE operation_schedule ADD `message` longtext NULL
ALTER TABLE operation_schedule ADD `location` varchar(250) NULL
ALTER TABLE operation_schedule ADD `resource_id` int NULL
ALTER TABLE operation_schedule ADD `recurrence_info` blob NULL
ALTER TABLE operation_schedule ADD `recurrence_index` int NULL
ALTER TABLE operation_schedule ADD `caption` varchar(250) NULL
ALTER TABLE operation_schedule ADD `options` int NULL
ALTER TABLE operation_schedule ADD `finish_date` datetime NULL
ALTER TABLE operation_schedule ADD `start_date` datetime NULL
ALTER TABLE operation_schedule ADD `parentid` int NULL
ALTER TABLE operation_holidays ADD `holidays_data` longblob NULL
ALTER TABLE newborn_death_cuase ADD `name` varchar(150) NOT NULL
ALTER TABLE medplan_ipd_wait ADD `transfer` char(1) NULL
ALTER TABLE medplan_ipd_wait ADD `vn` varchar(13) NULL
ALTER TABLE ipt_pregnancy ADD `pregnancy_abort_type_id` int NULL
ALTER TABLE ipt_pregnancy ADD `twin_child_count` int NULL
ALTER TABLE ipt_newborn ADD `newborn_death_cause_id` int NULL
ALTER TABLE druginteraction_skip ADD `drugname2` varchar(250) NOT NULL
ALTER TABLE druginteraction_skip ADD `drugname1` varchar(250) NOT NULL
ALTER TABLE druginteraction_skip ADD `doctor` varchar(7) NULL
CREATE TABLE vaccine_combination ( `vaccine_combination_id` int NOT NULL )
CREATE TABLE stock_subdraw_type ( `stock_subdraw_type_id` int NOT NULL )
CREATE TABLE referout_status ( `referout_status_id` int NOT NULL )
CREATE TABLE pregnancy_abort_type ( `pregnancy_abort_type_id` int NOT NULL )
CREATE TABLE operation_schedule_resource ( `resource_id` int NOT NULL )
CREATE TABLE operation_schedule ( `id` int NOT NULL )
CREATE TABLE operation_holidays ( `operation_holidays_id` int NOT NULL )
CREATE TABLE newborn_death_cuase ( `newborn_death_cause_id` int NOT NULL )
CREATE TABLE druginteraction_skip ( `druginteraction_skip_id` int NOT NULL )
Checking structure phase 1
หัวข้อ: HOSxP 3.51.10.29 (อ่าน 4012 ครั้ง)