ALTER TABLE person_elder_club_type ADD `person_elder_club_type_name` varchar(250) NOT NULL
ALTER TABLE person_elder_club_member ADD `active_elder_member` char(1) NULL
ALTER TABLE person_elder_club_member ADD `discharge_date` date NULL
ALTER TABLE person_elder_club_member ADD `discharge` char(1) NULL
ALTER TABLE person_elder_club_member ADD `register_date` date NULL
ALTER TABLE person_elder_club_member ADD `person_elder_club_id` int NOT NULL
ALTER TABLE person_elder_club_member ADD `person_id` int NOT NULL
ALTER TABLE person_elder_club ADD `contact_phone` varchar(250) NULL
ALTER TABLE person_elder_club ADD `contact_address` varchar(250) NULL
ALTER TABLE person_elder_club ADD `director_person_id` int NULL
ALTER TABLE person_elder_club ADD `person_elder_club_type_id` int NOT NULL
ALTER TABLE person_elder_club ADD `village_id` int NOT NULL
ALTER TABLE person_elder_club ADD `person_elder_club_name` varchar(250) NOT NULL
ALTER TABLE person_elder_activity_type ADD `person_elder_activity_type_name` varchar(250) NOT NULL
ALTER TABLE person_elder_activity ADD `person_elder_club_member_id` int NOT NULL
ALTER TABLE person_elder_activity ADD `person_elder_activity_type_id` int NOT NULL
ALTER TABLE person_elder_activity ADD `activity_date` date NULL
ALTER TABLE opitemrece_summary ADD `opitemrece_did` varchar(24) NULL
ALTER TABLE diagtype ADD `hos_guid` varchar(38) NULL
ALTER TABLE dbpeople ADD `Chk` int NULL
ALTER TABLE dbpeople ADD `G4W` int NULL
ALTER TABLE dbpeople ADD `G3W` int NULL
ALTER TABLE dbpeople ADD `G2W` int NULL
ALTER TABLE dbpeople ADD `G1W` int NULL
ALTER TABLE dbpeople ADD `G4M` int NULL
ALTER TABLE dbpeople ADD `G3M` int NULL
ALTER TABLE dbpeople ADD `G2M` int NULL
ALTER TABLE dbpeople ADD `G1M` int NULL
ALTER TABLE dbpeople ADD `idhospital` varchar(5) NULL
ALTER TABLE dbpeople ADD `DBYear` varchar(4) NULL
ALTER TABLE dboccupation ADD `Doccupation` varchar(50) NULL
ALTER TABLE dbnation ADD `Dnation` varchar(50) NULL
ALTER TABLE dbinscl ADD `MAININSC` varchar(5) NULL
ALTER TABLE dbinscl ADD `INSCL_DATEEXP` varchar(80) NULL
ALTER TABLE dbinscl ADD `INSCL_NAME` varchar(100) NULL
ALTER TABLE dbicd10chronic ADD `IDCode_DBCode` int NULL
ALTER TABLE dbicd10chronic ADD `ICD_Name_Eng` varchar(255) NULL
ALTER TABLE dbicd10chronic ADD `ICD_Name_Thai` varchar(255) NULL
ALTER TABLE dbhospital ADD `MARK` varchar(50) NULL
ALTER TABLE dbhospital ADD `ZONE` varchar(2) NULL
ALTER TABLE dbhospital ADD `ADDRS` varchar(255) NULL
ALTER TABLE dbhospital ADD `IDMOO` varchar(2) NULL
ALTER TABLE dbhospital ADD `IDDIST` varchar(6) NULL
ALTER TABLE dbhospital ADD `IDAMP` varchar(4) NULL
ALTER TABLE dbhospital ADD `IDPROVINCEL` varchar(2) NULL
ALTER TABLE dbhospital ADD `type` varchar(50) NULL
ALTER TABLE dbhospital ADD `Dhospital` varchar(100) NULL
ALTER TABLE dbdxtype ADD `D_DXTYPE` varchar(50) NULL
ALTER TABLE dbdrug ADD `DR_USAGE` varchar(50) NULL
ALTER TABLE dbdrug ADD `DR_UNIT` varchar(50) NULL
ALTER TABLE dbdrug ADD `DR_PACK` int NULL
ALTER TABLE dbdrug ADD `DR_NAME` varchar(100) NULL
ALTER TABLE dbcode ADD `ICD` varchar(100) NULL
ALTER TABLE dbcode ADD `En_code` varchar(100) NULL
ALTER TABLE dbcode ADD `Th_code` varchar(100) NULL
ALTER TABLE dbcode ADD `Dcode` int NULL
ALTER TABLE dbcode ADD `ChronicL` int NULL
ALTER TABLE dbchronicpatient ADD `hn` char(14) NULL
ALTER TABLE dbchronicpatient ADD `idcard` char(13) NULL
ALTER TABLE dbchronic_occupation ADD `Chronic_Code` varchar(2) NULL
ALTER TABLE dbchronic_occupation ADD `hos_guid` varchar(38) NULL
ALTER TABLE dbchronic_occupation ADD `code506` varchar(10) NULL
ALTER TABLE dbchronic_occupation ADD `nhso_code` char(3) NULL
ALTER TABLE dbchronic_occupation ADD `occupation` char(3) NOT NULL
ALTER TABLE dbchronic_nationality ADD `Chronic_code` varchar(1) NULL
ALTER TABLE dbchronic_nationality ADD `hos_guid` varchar(38) NULL
ALTER TABLE dbchronic_nationality ADD `nhso_code` varchar(3) NULL
ALTER TABLE dbchronic_nationality ADD `nationality` char(3) NOT NULL
ALTER TABLE dbchronic ADD `En_chronic` varchar(50) NULL
ALTER TABLE dbchronic ADD `Th_chronic` varchar(50) NULL
ALTER TABLE dbchronic ADD `Dchronic` varchar(10) NULL
ALTER TABLE dbcasue ADD `DBcasue` varchar(60) NULL
ALTER TABLE dbaddress ADD `Note` varchar(50) NULL
ALTER TABLE dbaddress ADD `district` varchar(50) NULL
ALTER TABLE dbaddress ADD `iddistrict` varchar(6) NULL
ALTER TABLE dbaddress ADD `T_amp` varchar(20) NULL
ALTER TABLE dbaddress ADD `amphur` varchar(50) NULL
ALTER TABLE dbaddress ADD `idamphur` varchar(4) NULL
ALTER TABLE dbaddress ADD `province` varchar(50) NULL
ALTER TABLE dbaddress ADD `idprovince` varchar(2) NULL
ALTER TABLE cancer_treatment ADD `cancer_treatment_name` varchar(150) NOT NULL
ALTER TABLE cancer_stage2 ADD `cancer_stage2_name` varchar(150) NOT NULL
ALTER TABLE cancer_stage1 ADD `cancer_stage1_name` varchar(150) NOT NULL
ALTER TABLE cancer_sex ADD `cancer_sex_name` varchar(150) NOT NULL
ALTER TABLE cancer_report_treatment ADD `cancer_treatment_id` int NULL
ALTER TABLE cancer_report_treatment ADD `cancer_department_type_id` int NULL
ALTER TABLE cancer_report_treatment ADD `treatment_desc` varchar(250) NULL
ALTER TABLE cancer_report_treatment ADD `doctor_name` varchar(150) NULL
ALTER TABLE cancer_report_treatment ADD `doctor_license_no` varchar(25) NULL
ALTER TABLE cancer_report_treatment ADD `icd9cm` varchar(9) NULL
ALTER TABLE cancer_report_treatment ADD `admit_no` varchar(9) NULL
ALTER TABLE cancer_report_treatment ADD `treatment_hospcode` char(5) NULL
ALTER TABLE cancer_report_treatment ADD `treatment_date` date NULL
ALTER TABLE cancer_report_treatment ADD `cancer_pttype_id` int NULL
ALTER TABLE cancer_report_treatment ADD `cancer_report_id` int NULL
ALTER TABLE cancer_report ADD `person_persist_addr_code` char(6) NULL
ALTER TABLE cancer_report ADD `person_regist_addr_code` char(6) NULL
ALTER TABLE cancer_report ADD `cancer_report_date` date NULL
ALTER TABLE cancer_report ADD `person_refer_to_desc` varchar(12) NULL
ALTER TABLE cancer_report ADD `person_refer_to_hn` varchar(12) NULL
ALTER TABLE cancer_report ADD `person_refer_to_date` date NULL
ALTER TABLE cancer_report ADD `person_refer_to_hospcode` char(5) NULL
ALTER TABLE cancer_report ADD `person_refer_in_hospcode` char(5) NULL
ALTER TABLE cancer_report ADD `person_refer_in_hn` varchar(12) NULL
ALTER TABLE cancer_report ADD `person_refer_in_date` date NULL
ALTER TABLE cancer_report ADD `person_refer_in_desc` varchar(250) NULL
ALTER TABLE cancer_report ADD `cancer_death_cause_desc` varchar(250) NULL
ALTER TABLE cancer_report ADD `cancer_death_cause_id` int NULL
ALTER TABLE cancer_report ADD `person_death_date` date NULL
ALTER TABLE cancer_report ADD `cancer_person_live_status_id` int NULL
ALTER TABLE cancer_report ADD `person_last_contact_date` date NULL
ALTER TABLE cancer_report ADD `cancer_metastasis_id` int NULL
ALTER TABLE cancer_report ADD `cancer_extend_id` int NULL
ALTER TABLE cancer_report ADD `cancer_stage2_id` int NULL
ALTER TABLE cancer_report ADD `cancer_stage1_id` int NULL
ALTER TABLE cancer_report ADD `cancer_tnm_desc` varchar(250) NULL
ALTER TABLE cancer_report ADD `cancer_grade_id` int NULL
ALTER TABLE cancer_report ADD `cancer_behaviour_id` int NULL
ALTER TABLE cancer_report ADD `cancer_lab_result_desc` varchar(250) NULL
ALTER TABLE cancer_report ADD `cancer_lab_result` varchar(50) NULL
ALTER TABLE cancer_report ADD `cancer_laterality_id` int NULL
ALTER TABLE cancer_report ADD `cancer_location_desc` varchar(250) NULL
ALTER TABLE cancer_report ADD `cancer_location` varchar(15) NULL
ALTER TABLE cancer_report ADD `cancer_biopsy_date` date NULL
ALTER TABLE cancer_report ADD `cancer_lab_number` varchar(25) NULL
ALTER TABLE cancer_report ADD `cancer_lab_name` varchar(50) NULL
ALTER TABLE cancer_report ADD `cancer_diagnosis_type_id` int NULL
ALTER TABLE cancer_report ADD `person_age_year` int NULL
ALTER TABLE cancer_report ADD `cancer_diag_date` date NULL
ALTER TABLE cancer_report ADD `hospital_hn` varchar(12) NULL
ALTER TABLE cancer_report ADD `hospital_code` char(5) NULL
ALTER TABLE cancer_report ADD `hospital_name` varchar(50) NULL
ALTER TABLE cancer_report ADD `person_persist_code` varchar(20) NULL
ALTER TABLE cancer_report ADD `person_persist_po_code` varchar(5) NULL
ALTER TABLE cancer_report ADD `person_persist_phone` varchar(25) NULL
ALTER TABLE cancer_report ADD `person_persist_tmbpart` char(2) NULL
ALTER TABLE cancer_report ADD `person_persist_amppart` char(2) NULL
ALTER TABLE cancer_report ADD `person_persist_chwpart` char(2) NULL
ALTER TABLE cancer_report ADD `person_persist_road` varchar(50) NULL
ALTER TABLE cancer_report ADD `person_persist_moo` varchar(10) NULL
ALTER TABLE cancer_report ADD `person_persist_addr` varchar(50) NULL
ALTER TABLE cancer_report ADD `person_regist_code` varchar(20) NULL
ALTER TABLE cancer_report ADD `person_regist_po_code` varchar(5) NULL
ALTER TABLE cancer_report ADD `person_regist_phone` varchar(25) NULL
ALTER TABLE cancer_report ADD `person_regist_tmbpart` char(2) NULL
ALTER TABLE cancer_report ADD `person_regist_amppart` char(2) NULL
ALTER TABLE cancer_report ADD `person_regist_chwpart` char(2) NULL
ALTER TABLE cancer_report ADD `person_regist_road` varchar(50) NULL
ALTER TABLE cancer_report ADD `person_regist_moo` varchar(10) NULL
ALTER TABLE cancer_report ADD `person_regist_addr` varchar(50) NULL
ALTER TABLE cancer_report ADD `cancer_religion_id` int NULL
ALTER TABLE cancer_report ADD `cancer_citizenship_id` int NULL
ALTER TABLE cancer_report ADD `cancer_nationality_id` int NULL
ALTER TABLE cancer_report ADD `cancer_marital_status_id` int NULL
ALTER TABLE cancer_report ADD `cancer_sex_id` int NULL
ALTER TABLE cancer_report ADD `person_birthdate` date NULL
ALTER TABLE cancer_report ADD `person_passport_no` varchar(25) NULL
ALTER TABLE cancer_report ADD `perosn_cid` varchar(13) NULL
ALTER TABLE cancer_report ADD `person_lname` varchar(50) NULL
ALTER TABLE cancer_report ADD `person_fname` varchar(50) NULL
ALTER TABLE cancer_report ADD `person_pname` varchar(50) NULL
ALTER TABLE cancer_religion ADD `cancer_religion_name` varchar(150) NOT NULL
ALTER TABLE cancer_pttype ADD `cancer_pttype_name` varchar(150) NOT NULL
ALTER TABLE cancer_person_live_status ADD `cancer_person_live_status_name` varchar(150) NOT NULL
ALTER TABLE cancer_nationality ADD `cancer_nationality_name` varchar(150) NOT NULL
ALTER TABLE cancer_metastasis ADD `cancer_metastasis_name` varchar(150) NOT NULL
ALTER TABLE cancer_marital_status ADD `cancer_marital_status_name` varchar(150) NOT NULL
ALTER TABLE cancer_laterality ADD `cancer_laterality_name` varchar(150) NOT NULL
ALTER TABLE cancer_grade ADD `cancer_grade_name` varchar(150) NOT NULL
ALTER TABLE cancer_extend ADD `cancer_extend_name` varchar(150) NOT NULL
ALTER TABLE cancer_diagnosis_type ADD `cancer_diagnosis_type_name` varchar(150) NOT NULL
ALTER TABLE cancer_department_type ADD `cancer_department_type_name` varchar(150) NOT NULL
ALTER TABLE cancer_death_cause ADD `cancer_death_cause_name` varchar(150) NOT NULL
ALTER TABLE cancer_citizenship ADD `cancer_citizenship_name` varchar(150) NOT NULL
ALTER TABLE cancer_behaviour ADD `cancer_behaviour_name` varchar(150) NOT NULL
CREATE TABLE person_elder_club_type ( `person_elder_club_type_id` int NOT NULL )
CREATE TABLE person_elder_club_member ( `person_elder_club_member_id` int NOT NULL )
CREATE TABLE person_elder_club ( `person_elder_club_id` int NOT NULL )
CREATE TABLE person_elder_activity_type ( `person_elder_activity_type_id` int NOT NULL )
CREATE TABLE person_elder_activity ( `person_elder_activity_id` int NOT NULL )
CREATE TABLE dbpeople ( `IDPP` int NULL )
CREATE TABLE dboccupation ( `idoccupation` int NULL )
CREATE TABLE dbnation ( `idnation` int NULL )
CREATE TABLE dbinscl ( `INSCL` varchar(3) NULL )
CREATE TABLE dbicd10chronic ( `ICD_10` varchar(255) NOT NULL )
CREATE TABLE dbhospital ( `idhospital` varchar(5) NULL )
CREATE TABLE dbdxtype ( `ID_DXTYPE` varchar(2) NULL )
CREATE TABLE dbdrug ( `DR_DID` varchar(24) NULL )
CREATE TABLE dbcode ( `idcode` int NOT NULL )
CREATE TABLE dbchronicpatient ( `idkey` bigint NOT NULL )
CREATE TABLE dbchronic_occupation ( `name` varchar(50) NULL )
CREATE TABLE dbchronic_nationality ( `name` varchar(50) NULL )
CREATE TABLE dbchronic ( `idchronic` int NULL )
CREATE TABLE dbcasue ( `idCasue` int NULL )
CREATE TABLE dbbranch ( `branch` varchar(100) NULL )
CREATE TABLE dbaddress ( `idaddress` int NULL )
CREATE TABLE cancer_treatment ( `cancer_treatment_id` int NOT NULL )
CREATE TABLE cancer_stage2 ( `cancer_stage2_id` int NOT NULL )
CREATE TABLE cancer_stage1 ( `cancer_stage1_id` int NOT NULL )
CREATE TABLE cancer_sex ( `cancer_sex_id` int NOT NULL )
CREATE TABLE cancer_report_treatment ( `cancer_report_treatment_id` int NOT NULL )
CREATE TABLE cancer_report ( `cancer_report_id` int NOT NULL )
CREATE TABLE cancer_religion ( `cancer_religion_id` int NOT NULL )
CREATE TABLE cancer_pttype ( `cancer_pttype_id` int NOT NULL )
CREATE TABLE cancer_person_live_status ( `cancer_person_live_status_id` int NOT NULL )
CREATE TABLE cancer_nationality ( `cancer_nationality_id` int NOT NULL )
CREATE TABLE cancer_metastasis ( `cancer_metastasis_id` int NOT NULL )
CREATE TABLE cancer_marital_status ( `cancer_marital_status_id` int NOT NULL )
CREATE TABLE cancer_laterality ( `cancer_laterality_id` int NOT NULL )
CREATE TABLE cancer_grade ( `cancer_grade_id` int NOT NULL )
CREATE TABLE cancer_extend ( `cancer_extend_id` int NOT NULL )
CREATE TABLE cancer_diagnosis_type ( `cancer_diagnosis_type_id` int NOT NULL )
CREATE TABLE cancer_department_type ( `cancer_department_type_id` int NOT NULL )
CREATE TABLE cancer_death_cause ( `cancer_death_cause_id` int NOT NULL )
CREATE TABLE cancer_citizenship ( `cancer_citizenship_id` int NOT NULL )
CREATE TABLE cancer_behaviour ( `cancer_behaviour_id` int NOT NULL )
Checking structure phase 1