Checking STRUCTURE phase 2
ALTER TABLE tempreport ADD `name22` VARCHAR(100) NULL
ALTER TABLE tempreport ADD `name21` VARCHAR(100) NULL
ALTER TABLE stock_user_warehouse ADD `stock_warehouse_id` INT NOT NULL
ALTER TABLE stock_user_warehouse ADD `stock_user_id` INT NOT NULL
ALTER TABLE stock_user_department ADD `stock_department_id` INT NOT NULL
ALTER TABLE stock_user_department ADD `stock_user_id` INT NOT NULL
ALTER TABLE person_ncd_waist_type ADD `person_ncd_waist_type_name` VARCHAR(150) NOT NULL
ALTER TABLE person_ncd_summary_code ADD `person_ncd_summary_name` VARCHAR(150) NOT NULL
ALTER TABLE person_ncd_summary ADD `person_ncd_summary_code` VARCHAR(10) NULL
ALTER TABLE person_ncd_summary ADD `person_ncd_id` INT NOT NULL
ALTER TABLE person_ncd_screen ADD `person_ncd_waist_type_id` INT NULL
ALTER TABLE person_ncd_screen ADD `person_ncd_cigar_type_id` INT NULL
ALTER TABLE person_ncd_screen ADD `person_ncd_heart_type_id` INT NULL
ALTER TABLE person_ncd_screen ADD `person_ncd_fbs_type_id` INT NULL
ALTER TABLE person_ncd_screen ADD `fbs` INT NULL
ALTER TABLE person_ncd_screen ADD `person_ncd_pregnancy_dm_type_id` INT NULL
ALTER TABLE person_ncd_screen ADD `person_ncd_high_lipid_type_id` INT NULL
ALTER TABLE person_ncd_screen ADD `person_ncd_bp_type_id` INT NULL
ALTER TABLE person_ncd_screen ADD `bpd` DOUBLE(15,3) NULL
ALTER TABLE person_ncd_screen ADD `bps` DOUBLE(15,3) NULL
ALTER TABLE person_ncd_screen ADD `waist` DOUBLE(15,3) NULL
ALTER TABLE person_ncd_screen ADD `height` DOUBLE(15,3) NULL
ALTER TABLE person_ncd_screen ADD `bw` DOUBLE(15,3) NULL
ALTER TABLE person_ncd_screen ADD `person_ncd_heredity_type_id` INT NULL
ALTER TABLE person_ncd_screen ADD `person_ncd_screen_date` DATE NULL
ALTER TABLE person_ncd_screen ADD `person_ncd_id` INT NOT NULL
ALTER TABLE person_ncd_pregnancy_dm_type ADD `person_ncd_pregnancy_dm_type_name` VARCHAR(150) NOT NULL
ALTER TABLE person_ncd_paralysis_type ADD `person_ncd_paralysis_type_name` VARCHAR(150) NOT NULL
ALTER TABLE person_ncd_high_lipid_type ADD `person_ncd_high_lipid_type_name` VARCHAR(150) NOT NULL
ALTER TABLE person_ncd_heredity_type ADD `person_ncd_heredity_type_name` VARCHAR(150) NOT NULL
ALTER TABLE person_ncd_heart_type ADD `person_ncd_heart_type_name` VARCHAR(150) NOT NULL
ALTER TABLE person_ncd_fbs_type ADD `person_ncd_fbs_type_name` VARCHAR(150) NOT NULL
ALTER TABLE person_ncd_cigar_type ADD `person_ncd_cigar_type_name` VARCHAR(150) NOT NULL
ALTER TABLE person_ncd_bp_type ADD `person_ncd_bp_type_name` VARCHAR(150) NOT NULL
ALTER TABLE person_ncd ADD `person_ncd_summary_code` VARCHAR(10) NULL
ALTER TABLE person_ncd ADD `person_ncd_paralysis_type_id` INT NULL
ALTER TABLE person_ncd ADD `discharge_date` DATE NULL
ALTER TABLE person_ncd ADD `discharge` CHAR(1) NULL
ALTER TABLE person_ncd ADD `register_date` DATE NULL
ALTER TABLE person_ncd ADD `person_id` INT NOT NULL
ALTER TABLE operation_item_type ADD `operation_item_type_name` VARCHAR(150) NOT NULL
CREATE TABLE stock_user_warehouse ( `stock_user_warehouse_id` INT NOT NULL )
CREATE TABLE stock_user_department ( `stock_user_department_id` INT NOT NULL )
CREATE TABLE person_ncd_waist_type ( `person_ncd_waist_type_id` INT NOT NULL )
CREATE TABLE person_ncd_summary_code ( `person_ncd_summary_code` CHAR(1) NOT NULL )
CREATE TABLE person_ncd_summary ( `person_ncd_summary_id` INT NOT NULL )
CREATE TABLE person_ncd_screen ( `person_ncd_screen_id` INT NOT NULL )
CREATE TABLE person_ncd_pregnancy_dm_type ( `person_ncd_pregnancy_dm_type_id` INT NOT NULL )
CREATE TABLE person_ncd_paralysis_type ( `person_ncd_paralysis_type_id` INT NOT NULL )
CREATE TABLE person_ncd_high_lipid_type ( `person_ncd_high_lipid_type_id` INT NOT NULL )
CREATE TABLE person_ncd_heredity_type ( `person_ncd_heredity_type_id` INT NOT NULL )
CREATE TABLE person_ncd_heart_type ( `person_ncd_heart_type_id` INT NOT NULL )
CREATE TABLE person_ncd_fbs_type ( `person_ncd_fbs_type_id` INT NOT NULL )
CREATE TABLE person_ncd_cigar_type ( `person_ncd_cigar_type_id` INT NOT NULL )
CREATE TABLE person_ncd_bp_type ( `person_ncd_bp_type_id` INT NOT NULL )
CREATE TABLE person_ncd ( `person_ncd_id` INT NOT NULL )
CREATE TABLE operation_item_type ( `operation_item_type_id` INT NOT NULL )
Checking STRUCTURE phase 1