ALTER TABLE person_wbc ADD `last_update` datetime NULL
ALTER TABLE person_wbc ADD `baby_service3_date` DATE NULL
ALTER TABLE person_labour_type ADD `person_labour_type_name` VARCHAR(150) NOT NULL
ALTER TABLE person_labour_place ADD `person_labour_place_name` VARCHAR(100) NOT NULL
ALTER TABLE person_labour_doctor_type ADD `person_labour_doctor_type_name` VARCHAR(150) NOT NULL
ALTER TABLE person_labour ADD `labour_status` CHAR(1) NULL
ALTER TABLE person_labour ADD `has_vitk` CHAR(1) NULL
ALTER TABLE person_labour ADD `has_asphyxia` CHAR(1) NULL
ALTER TABLE person_labour ADD `birth_weight` INT NULL
ALTER TABLE person_labour ADD `person_labour_doctor_type_id` INT NULL
ALTER TABLE person_labour ADD `person_labour_type_id` INT NULL
ALTER TABLE person_labour ADD `labour_hospcode` CHAR(5) NULL
ALTER TABLE person_labour ADD `person_labour_place_id` INT NULL
ALTER TABLE person_labour ADD `gravida` INT NULL
ALTER TABLE person_chronic ADD `last_update` datetime NULL
ALTER TABLE person_chronic ADD `clinic_member_status_id` INT NULL
ALTER TABLE person_chronic ADD `regdate` DATE NULL
ALTER TABLE person_anc_service ADD `service_result` CHAR(1) NULL
ALTER TABLE person_anc_service ADD `ga` INT NULL
ALTER TABLE person_anc ADD `labor_icd10` VARCHAR(7) NULL
ALTER TABLE person_anc ADD `labour_hospcode` CHAR(5) NULL
ALTER TABLE person_anc ADD `labour_type_id` INT NULL
ALTER TABLE person_anc ADD `post_labor_service3_date` DATE NULL
ALTER TABLE person_anc ADD `lmp` DATE NULL
ALTER TABLE person ADD `sps_person_id` INT NULL
ALTER TABLE person ADD `pttype_no` VARCHAR(50) NULL
ALTER TABLE person ADD `mother_person_id` INT NULL
ALTER TABLE person ADD `father_person_id` INT NULL
ALTER TABLE person ADD `pttype_hospsub` CHAR(5) NULL
ALTER TABLE person ADD `pttype_hospmain` CHAR(5) NULL
ALTER TABLE person ADD `pttype_expire_date` DATE NULL
ALTER TABLE person ADD `pttype_begin_date` DATE NULL
ALTER TABLE person ADD `pttype` CHAR(2) NULL
ALTER TABLE pcu_drugitems ADD `icode` VARCHAR(7) NULL
ALTER TABLE pcu_drugitems ADD `drug_name` VARCHAR(200) NOT NULL
ALTER TABLE ovst_seq ADD `seq_id` INT NOT NULL
ALTER TABLE opd_screen_value ADD `screen_value` VARCHAR(250) NOT NULL
ALTER TABLE opd_screen_value ADD `screen_name` VARCHAR(100) NOT NULL
ALTER TABLE opd_screen_value ADD `vn` VARCHAR(13) NOT NULL
ALTER TABLE occupation ADD `code506` VARCHAR(10) NULL
ALTER TABLE oapp_activity ADD `oapp_activity_name` VARCHAR(150) NOT NULL
ALTER TABLE house_survey_item ADD `export_code` VARCHAR(10) NULL
ALTER TABLE house ADD `last_update` DATE NULL
ALTER TABLE house ADD `family_count` INT NULL
ALTER TABLE doctor_time_type ADD `name` VARCHAR(250) NULL
ALTER TABLE clinic ADD `oapp_activity_id` INT NULL
ALTER TABLE clinic ADD `pcu_code` INT NULL
CREATE TABLE person_labour_type ( `person_labour_type_id` INT NOT NULL )
CREATE TABLE person_labour_place ( `person_labor_place_id` INT NOT NULL )
CREATE TABLE person_labour_doctor_type ( `person_labour_doctor_type_id` INT NOT NULL )
CREATE TABLE person_labour ( `person_id` INT NOT NULL )
CREATE TABLE pcu_drugitems ( `did` VARCHAR(20) NOT NULL )
CREATE TABLE ovst_seq ( `vn` VARCHAR(13) NOT NULL )
CREATE TABLE opd_screen_value ( `opd_screen_value_id` INT NOT NULL )
CREATE TABLE oapp_activity ( `oapp_activity_id` INT NOT NULL )
CREATE TABLE icd10_sss_check ( `icd10` VARCHAR(9) NOT NULL )
CREATE TABLE doctor_time_type ( `doctor_time_type_id` INT NOT NULL )