ALTER TABLE special_prop_type ADD `special_prop_type_name` VARCHAR(150) NOT NULL
ALTER TABLE religion MODIFY COLUMN `nhso_code` VARCHAR(10)
ALTER TABLE person_labor_type ADD `nhso_code` VARCHAR(10) NULL
ALTER TABLE patient_special_prop ADD `entry_datetime` datetime NULL
ALTER TABLE patient_special_prop ADD `note` VARCHAR(250) NULL
ALTER TABLE patient_special_prop ADD `staff` VARCHAR(25) NULL
ALTER TABLE patient_special_prop ADD `special_prop_type_id` INT NULL
ALTER TABLE patient_special_prop ADD `hn` VARCHAR(9) NOT NULL
ALTER TABLE operation_detail ADD `extension_code` VARCHAR(15) NULL
ALTER TABLE operation_detail ADD `electric_touch` CHAR(1) NULL
ALTER TABLE operation_detail ADD `extenstion_code` VARCHAR(10) NULL
ALTER TABLE operation_anes_problem ADD `problem_time` TIME NULL
ALTER TABLE operation_anes_problem ADD `problem_date` DATE NULL
ALTER TABLE operation_anes_problem ADD `staff` VARCHAR(25) NULL
ALTER TABLE operation_anes ADD `doctor3` VARCHAR(9) NULL
ALTER TABLE operation_anes MODIFY COLUMN `doctor2` VARCHAR(9)
ALTER TABLE operation_anes MODIFY COLUMN `doctor` VARCHAR(9)
ALTER TABLE labor ADD `placenta_bpd` DOUBLE(15,3) NULL
ALTER TABLE labor ADD `placenta_bps` DOUBLE(15,3) NULL
ALTER TABLE doctor_position_std ADD `doctor_position_std_name` VARCHAR(150) NOT NULL
CREATE TABLE special_prop_type ( `special_prop_type_id` INT NOT NULL )
CREATE TABLE patient_special_prop ( `patient_special_prop_id` INT NOT NULL )
CREATE TABLE doctor_position_std ( `doctor_position_std_id` INT NOT NULL )
Checking STRUCTURE phase 1