Checking STRUCTURE phase 2
ALTER TABLE village_water_type ADD `village_water_type_name` VARCHAR(150) NOT NULL
ALTER TABLE village_water ADD `hos_guid` VARCHAR(38) NULL
ALTER TABLE village_water ADD `village_water_status` CHAR(1) NULL
ALTER TABLE village_water ADD `village_water_type_id` INT NULL
ALTER TABLE village_water ADD `village_water_name` VARCHAR(150) NOT NULL
ALTER TABLE village_water ADD `village_id` INT NOT NULL
ALTER TABLE village_store ADD `sell_alcohol` CHAR(1) NULL
ALTER TABLE village_store ADD `sell_cigar` CHAR(1) NULL
ALTER TABLE village_priest_type ADD `village_priest_type_name` VARCHAR(150) NOT NULL
ALTER TABLE village_priest ADD `village_priest_type_id` INT NULL
ALTER TABLE person_deformed_refer_type ADD `person_deformed_refer_type_name` VARCHAR(150) NOT NULL
ALTER TABLE person_deformed_detail ADD `organ` VARCHAR(200) NULL
ALTER TABLE person_deformed ADD `remark` VARCHAR(150) NULL
ALTER TABLE person_deformed ADD `certificate_date` DATE NULL
ALTER TABLE person_deformed ADD `register_date` DATE NULL
ALTER TABLE person_deformed ADD `person_deformed_refer_type_id` INT NULL
ALTER TABLE house_herb_type ADD `hous_herb_type_name` VARCHAR(150) NOT NULL
ALTER TABLE house_herb ADD `house_herb_plant` CHAR(1) NULL
ALTER TABLE house_herb ADD `update_date` datetime NULL
ALTER TABLE house_herb ADD `house_herb_use` CHAR(1) NULL
ALTER TABLE house_herb ADD `house_herb_type_id` INT NOT NULL
ALTER TABLE house_herb ADD `house_id` INT NOT NULL
ALTER TABLE house_container_type ADD `house_container_type_name` VARCHAR(150) NOT NULL
ALTER TABLE house_container ADD `qty` INT NULL
ALTER TABLE house_container ADD `update_date` datetime NULL
ALTER TABLE house_container ADD `house_container_volume` INT NULL
ALTER TABLE house_container ADD `house_container_type_id` INT NOT NULL
ALTER TABLE house_container ADD `house_id` INT NOT NULL
ALTER TABLE house_animal_type ADD `house_animal_type_name` VARCHAR(150) NOT NULL
ALTER TABLE house_animal ADD `update_date` datetime NULL
ALTER TABLE house_animal ADD `qty` INT NULL
ALTER TABLE house_animal ADD `house_animal_type_id` INT NOT NULL
ALTER TABLE house_animal ADD `house_id` INT NOT NULL
CREATE TABLE village_water_type ( `village_water_type_id` INT NOT NULL )
CREATE TABLE village_water ( `village_water_id` INT NOT NULL )
CREATE TABLE village_priest_type ( `village_priest_type_id` INT NOT NULL )
CREATE TABLE person_deformed_refer_type ( `person_deformed_refer_type_id` INT NOT NULL )
CREATE TABLE house_herb_type ( `house_herb_type_id` INT NOT NULL )
CREATE TABLE house_herb ( `house_herb_id` INT NOT NULL )
CREATE TABLE house_container_type ( `house_container_type_id` INT NOT NULL )
CREATE TABLE house_container ( `house_container_id` INT NOT NULL )
CREATE TABLE house_animal_type ( `house_animal_type_id` INT NOT NULL )
CREATE TABLE house_animal ( `house_animal_id` INT NOT NULL )
Checking STRUCTURE phase 1