Checking structure phase 2
ALTER TABLE workplacetype ADD `hos_guid` varchar(38) NULL
ALTER TABLE workplacetype ADD `workplacetype_name` varchar(500) NULL
ALTER TABLE workdescription ADD `work_name` char(100) NULL
ALTER TABLE surveil_member ADD `dw_amp_approve_date` date NULL
ALTER TABLE surveil_member ADD `dw_amp_approve_staff` varchar(20) NULL
ALTER TABLE surveil_member ADD `dw_amp_approve` char(1) NULL
ALTER TABLE patient_cancer_pelvis ADD `last_update` datetime NULL
ALTER TABLE patient_cancer_pelvis ADD `doctor_start` varchar(10) NULL
ALTER TABLE patient_cancer_lung ADD `last_update` datetime NULL
ALTER TABLE patient_cancer_lung ADD `doctor_start` varchar(10) NULL
ALTER TABLE patient_cancer_head ADD `last_update` datetime NULL
ALTER TABLE patient_cancer_head ADD `doctor_start` varchar(10) NULL
ALTER TABLE patient_cancer_faceneck ADD `fs_back_type` varchar(2) NULL
ALTER TABLE patient_cancer_faceneck ADD `off_cord_back_type` varchar(2) NULL
ALTER TABLE patient_cancer_cervix ADD `last_update` datetime NULL
ALTER TABLE patient_cancer_cervix ADD `doctor_start` varchar(10) NULL
ALTER TABLE patient_cancer_breast ADD `last_update` datetime NULL
ALTER TABLE patient_cancer_breast ADD `doctor_start` varchar(10) NULL
ALTER TABLE patient_cancer_bone_met ADD `last_update` datetime NULL
ALTER TABLE patient_cancer_bone_met ADD `doctor_start` varchar(10) NULL
ALTER TABLE patient_cancer_abdomen ADD `last_update` datetime NULL
ALTER TABLE patient_cancer_abdomen ADD `doctor_start` varchar(10) NULL
ALTER TABLE patient_cancer_3dcrt ADD `last_update` datetime NULL
ALTER TABLE patient_cancer_3dcrt ADD `doctor_start` varchar(10) NULL
ALTER TABLE nameenoc_form_image ADD `hos_guid` varchar(38) NULL
ALTER TABLE nameenoc_form_image ADD `picture_data` longblob NULL
ALTER TABLE nameenoc_form_image ADD `picture_no` int NULL
ALTER TABLE nameenoc ADD `icd10` char(10) NULL
ALTER TABLE nameenoc ADD `hos_guid` varchar(38) NULL
ALTER TABLE nameenoc ADD `disease_detail` longtext NULL
ALTER TABLE nameenoc ADD `ename` varchar(150) NULL
ALTER TABLE nameenoc ADD `code506_2` char(10) NULL
ALTER TABLE nameenoc ADD `codeenoc` char(10) NULL
ALTER TABLE nameenoc ADD `name` varchar(250) NULL
ALTER TABLE illcause ADD `hos_guid` varchar(38) NULL
ALTER TABLE illcause ADD `illcause_name` char(100) NULL
ALTER TABLE enoc_process_status ADD `enoc_process_status_name` varchar(150) NOT NULL
ALTER TABLE enoc_member_log ADD `data_sync` char(1) NULL
ALTER TABLE enoc_member_log ADD `op_type` varchar(10) NULL
ALTER TABLE enoc_member_log ADD `enoc_guid` varchar(38) NOT NULL
ALTER TABLE enoc_member_dw ADD `last_update` datetime NULL
ALTER TABLE enoc_member_dw ADD `pat_death` char(1) NULL
ALTER TABLE enoc_member_dw ADD `tel` varchar(13) NULL
ALTER TABLE enoc_member_dw ADD `pat_tmbpart` varchar(2) NULL
ALTER TABLE enoc_member_dw ADD `pat_amppart` varchar(2) NULL
ALTER TABLE enoc_member_dw ADD `pat_chwpart` varchar(2) NULL
ALTER TABLE enoc_member_dw ADD `pat_road` varchar(50) NULL
ALTER TABLE enoc_member_dw ADD `pat_moo` varchar(5) NULL
ALTER TABLE enoc_member_dw ADD `pat_addr` varchar(50) NULL
ALTER TABLE enoc_member_dw ADD `house_long` varchar(50) NULL
ALTER TABLE enoc_member_dw ADD `house_lat` varchar(50) NULL
ALTER TABLE enoc_member_dw ADD `workplacetype_text` blob NULL
ALTER TABLE enoc_member_dw ADD `workplacetype` char(10) NULL
ALTER TABLE enoc_member_dw ADD `workplacename` varchar(500) NULL
ALTER TABLE enoc_member_dw ADD `cause_place` varchar(500) NULL
ALTER TABLE enoc_member_dw ADD `workdescription` blob NULL
ALTER TABLE enoc_member_dw ADD `workdescriptioncode` char(10) NULL
ALTER TABLE enoc_member_dw ADD `illcause_text` blob NULL
ALTER TABLE enoc_member_dw ADD `illcause` char(10) NULL
ALTER TABLE enoc_member_dw ADD `epi_group_code` int NULL
ALTER TABLE enoc_member_dw ADD `intime` char(1) NULL
ALTER TABLE enoc_member_dw ADD `cid` char(13) NULL
ALTER TABLE enoc_member_dw ADD `data_sync` char(1) NULL
ALTER TABLE enoc_member_dw ADD `enoc_guid` varchar(38) NULL
ALTER TABLE enoc_member_dw ADD `hospcode` char(5) NULL
ALTER TABLE enoc_member_dw ADD `report_date` date NULL
ALTER TABLE enoc_member_dw ADD `hserv` varchar(10) NULL
ALTER TABLE enoc_member_dw ADD `office` tinytext NULL
ALTER TABLE enoc_member_dw ADD `department` char(3) NULL
ALTER TABLE enoc_member_dw ADD `send_epidem` char(1) NULL
ALTER TABLE enoc_member_dw ADD `ptstat` char(1) NULL
ALTER TABLE enoc_member_dw ADD `begin_date` date NULL
ALTER TABLE enoc_member_dw ADD `vstdate` date NULL
ALTER TABLE enoc_member_dw ADD `staff` varchar(25) NULL
ALTER TABLE enoc_member_dw ADD `pdx` varchar(9) NULL
ALTER TABLE enoc_member_dw ADD `death_date` date NULL
ALTER TABLE enoc_member_dw ADD `ovstost` char(2) NULL
ALTER TABLE enoc_member_dw ADD `tmbpart` char(2) NULL
ALTER TABLE enoc_member_dw ADD `amppart` char(2) NULL
ALTER TABLE enoc_member_dw ADD `chwpart` char(2) NULL
ALTER TABLE enoc_member_dw ADD `moo` char(2) NULL
ALTER TABLE enoc_member_dw ADD `road` varchar(50) NULL
ALTER TABLE enoc_member_dw ADD `addr` varchar(50) NULL
ALTER TABLE enoc_member_dw ADD `codeenoc` varchar(10) NULL
ALTER TABLE enoc_member_dw ADD `vn` varchar(13) NULL
ALTER TABLE enoc_member_dw ADD `hn` varchar(9) NOT NULL
ALTER TABLE enoc_member ADD `last_update` datetime NULL
ALTER TABLE enoc_member ADD `pat_death` char(1) NULL
ALTER TABLE enoc_member ADD `tel` varchar(13) NULL
ALTER TABLE enoc_member ADD `pat_tmbpart` varchar(2) NULL
ALTER TABLE enoc_member ADD `pat_amppart` varchar(2) NULL
ALTER TABLE enoc_member ADD `pat_chwpart` varchar(2) NULL
ALTER TABLE enoc_member ADD `pat_road` varchar(50) NULL
ALTER TABLE enoc_member ADD `pat_moo` varchar(5) NULL
ALTER TABLE enoc_member ADD `pat_addr` varchar(50) NULL
ALTER TABLE enoc_member ADD `house_long` varchar(50) NULL
ALTER TABLE enoc_member ADD `house_lat` varchar(50) NULL
ALTER TABLE enoc_member ADD `workplacetype_text` blob NULL
ALTER TABLE enoc_member ADD `workplacetype` char(10) NULL
ALTER TABLE enoc_member ADD `workplacename` varchar(500) NULL
ALTER TABLE enoc_member ADD `cause_place` varchar(500) NULL
ALTER TABLE enoc_member ADD `workdescription` blob NULL
ALTER TABLE enoc_member ADD `workdescriptioncode` char(10) NULL
ALTER TABLE enoc_member ADD `illcause_text` blob NULL
ALTER TABLE enoc_member ADD `illcause` char(10) NULL
ALTER TABLE enoc_member ADD `epi_group_code` int NULL
ALTER TABLE enoc_member ADD `intime` char(1) NULL
ALTER TABLE enoc_member ADD `cid` char(13) NULL
ALTER TABLE enoc_member ADD `data_sync` char(1) NULL
ALTER TABLE enoc_member ADD `enoc_guid` varchar(38) NULL
ALTER TABLE enoc_member ADD `hospcode` char(5) NULL
ALTER TABLE enoc_member ADD `report_date` date NULL
ALTER TABLE enoc_member ADD `hserv` varchar(10) NULL
ALTER TABLE enoc_member ADD `office` tinytext NULL
ALTER TABLE enoc_member ADD `department` char(3) NULL
ALTER TABLE enoc_member ADD `send_epidem` char(1) NULL
ALTER TABLE enoc_member ADD `ptstat` char(1) NULL
ALTER TABLE enoc_member ADD `begin_date` date NULL
ALTER TABLE enoc_member ADD `vstdate` date NULL
ALTER TABLE enoc_member ADD `staff` varchar(25) NULL
ALTER TABLE enoc_member ADD `pdx` varchar(9) NULL
ALTER TABLE enoc_member ADD `death_date` date NULL
ALTER TABLE enoc_member ADD `ovstost` char(2) NULL
ALTER TABLE enoc_member ADD `tmbpart` char(2) NULL
ALTER TABLE enoc_member ADD `amppart` char(2) NULL
ALTER TABLE enoc_member ADD `chwpart` char(2) NULL
ALTER TABLE enoc_member ADD `moo` char(2) NULL
ALTER TABLE enoc_member ADD `road` varchar(50) NULL
ALTER TABLE enoc_member ADD `addr` varchar(50) NULL
ALTER TABLE enoc_member ADD `codeenoc` varchar(10) NULL
ALTER TABLE enoc_member ADD `vn` varchar(13) NULL
ALTER TABLE enoc_member ADD `hn` varchar(9) NULL
CREATE TABLE workplacetype ( `workplacetype_id` char(10) NOT NULL )
CREATE TABLE workdescription ( `work_code` char(3) NOT NULL )
CREATE TABLE nameenoc_form_image ( `code` int NULL )
CREATE TABLE nameenoc ( `code` int NOT NULL )
CREATE TABLE illcause ( `illcause_id` char(10) NOT NULL )
CREATE TABLE enoc_process_status ( `enoc_process_status_id` int NOT NULL )
CREATE TABLE enoc_member_log ( `enoc_member_log_id` int NOT NULL )
CREATE TABLE enoc_member_dw ( `enoc_number` int NOT NULL )
CREATE TABLE enoc_member ( `enoc_number` int NOT NULL )
Checking structure phase 1
555