Checking STRUCTURE phase 2
ALTER TABLE physic_member ADD `continue_service` CHAR(1) NULL
ALTER TABLE oapp_perform ADD `order_number` INT NULL
ALTER TABLE oapp_lab ADD `order_number` INT NULL
ALTER TABLE lab_formula_head ADD `doctor` VARCHAR(7) NULL
ALTER TABLE lab_formula_head ADD `lab_formula_name` VARCHAR(100) NOT NULL
ALTER TABLE lab_formula_detail ADD `lab_items_code` INT NOT NULL
ALTER TABLE lab_formula_detail ADD `lab_formula_head_id` INT NOT NULL
ALTER TABLE ipt_icnp ADD `patient_cc_text` text NULL
ALTER TABLE ipt_icnp ADD `an` VARCHAR(9) NOT NULL
ALTER TABLE ipt_icnp ADD `icnp_classification_id` INT NOT NULL
ALTER TABLE ipt_admit_cc ADD `icnp_cc_value` VARCHAR(200) NULL
ALTER TABLE ipt_admit_cc ADD `icnp_cc_id` INT NOT NULL
ALTER TABLE ipt_admit_cc ADD `an` VARCHAR(9) NOT NULL
ALTER TABLE ipd_period ADD `ipd_period_name` VARCHAR(150) NOT NULL
ALTER TABLE icnp_related_factor ADD `icnp_related_factor_name` VARCHAR(250) NOT NULL
ALTER TABLE icnp_phenomena_factor ADD `icnp_activity_phenomena_id` INT NOT NULL
ALTER TABLE icnp_phenomena_factor ADD `icnp_phenomena_factor_value` VARCHAR(200) NULL
ALTER TABLE icnp_phenomena_factor ADD `icnp_related_factor_id` INT NOT NULL
ALTER TABLE icnp_phenomena_assessment ADD `icnp_phenomena_assessment_value` VARCHAR(250) NULL
ALTER TABLE icnp_phenomena_assessment ADD `icnp_assessment_id` INT NOT NULL
ALTER TABLE icnp_phenomena_assessment ADD `icnp_activity_phenomena_id` INT NOT NULL
ALTER TABLE icnp_phenomena ADD `icnp_phenomena_name` VARCHAR(250) NOT NULL
ALTER TABLE icnp_intervention ADD `icnp_intervention_name` VARCHAR(250) NOT NULL
ALTER TABLE icnp_goal_degree ADD `icnp_goal_degree_name` VARCHAR(200) NOT NULL
ALTER TABLE icnp_evaluation ADD `icnp_evaluation_name` VARCHAR(200) NOT NULL
ALTER TABLE icnp_classification ADD `icnp_classification_name` VARCHAR(200) NOT NULL
ALTER TABLE icnp_cc_group ADD `icnp_cc_group_name` VARCHAR(200) NOT NULL
ALTER TABLE icnp_cc ADD `icnp_cc_group_id` INT NOT NULL
ALTER TABLE icnp_cc ADD `icnp_cc_name` VARCHAR(200) NOT NULL
ALTER TABLE icnp_assessment ADD `icnp_assessment_name` VARCHAR(200) NOT NULL
ALTER TABLE icnp_assessed_status ADD `icnp_assessed_status_name` VARCHAR(200) NOT NULL
ALTER TABLE icnp_assessed_degree ADD `icnp_assessed_degree_name` VARCHAR(200) NOT NULL
ALTER TABLE icnp_activity_phenomena ADD `specific_phenomena_text` text NULL
ALTER TABLE icnp_activity_phenomena ADD `icnp_goal_degree_id` INT NULL
ALTER TABLE icnp_activity_phenomena ADD `icnp_assessed_degree_id` INT NULL
ALTER TABLE icnp_activity_phenomena ADD `icnp_assessed_status_id` INT NULL
ALTER TABLE icnp_activity_phenomena ADD `doctor_code` VARCHAR(7) NULL
ALTER TABLE icnp_activity_phenomena ADD `icnp_assessed_time` TIME NULL
ALTER TABLE icnp_activity_phenomena ADD `icnp_assessed_date` DATE NULL
ALTER TABLE icnp_activity_phenomena ADD `icnp_onset_time` TIME NULL
ALTER TABLE icnp_activity_phenomena ADD `icnp_onset_date` DATE NULL
ALTER TABLE icnp_activity_phenomena ADD `icnp_phenomena_id` INT NOT NULL
ALTER TABLE icnp_activity_phenomena ADD `icnp_activity_id` INT NOT NULL
ALTER TABLE icnp_activity_intervention ADD `icnp_intervention_id` INT NOT NULL
ALTER TABLE icnp_activity_intervention ADD `icnp_activity_intervention_value` VARCHAR(200) NULL
ALTER TABLE icnp_activity_intervention ADD `icnp_activity_id` INT NOT NULL
ALTER TABLE icnp_activity_evaluation ADD `icnp_activity_evaluation_value` VARCHAR(200) NULL
ALTER TABLE icnp_activity_evaluation ADD `icnp_evaluation_id` INT NOT NULL
ALTER TABLE icnp_activity_evaluation ADD `icnp_activity_id` INT NOT NULL
ALTER TABLE icnp_activity ADD `an` VARCHAR(9) NULL
ALTER TABLE icnp_activity ADD `ipd_periond_id` INT NULL
ALTER TABLE icnp_activity ADD `icnp_activity_time` TIME NULL
ALTER TABLE icnp_activity ADD `icnp_activity_date` DATE NULL
ALTER TABLE anlock ADD `lock_datetime` datetime NULL
CREATE TABLE lab_formula_head ( `lab_formula_head_id` INT NOT NULL )
CREATE TABLE lab_formula_detail ( `lab_formula_detail_id` INT NOT NULL )
CREATE TABLE ipt_icnp ( `ipt_icnp_id` INT NOT NULL )
CREATE TABLE ipt_admit_cc ( `ipt_admit_cc_id` INT NOT NULL )
CREATE TABLE ipd_period ( `ipd_period_id` INT NOT NULL )
CREATE TABLE icnp_related_factor ( `icnp_related_factor_id` INT NOT NULL )
CREATE TABLE icnp_phenomena_factor ( `icnp_phenomena_factor_id` INT NOT NULL )
CREATE TABLE icnp_phenomena_assessment ( `icnp_phenomena_assessment_id` INT NOT NULL )
CREATE TABLE icnp_phenomena ( `icnp_phenomena_id` INT NOT NULL )
CREATE TABLE icnp_intervention ( `icnp_intervention_id` INT NOT NULL )
CREATE TABLE icnp_goal_degree ( `icnp_goal_degree_id` INT NOT NULL )
CREATE TABLE icnp_evaluation ( `icnp_evaluation_id` INT NOT NULL )
CREATE TABLE icnp_classification ( `icnp_classification_id` INT NOT NULL )
CREATE TABLE icnp_cc_group ( `icnp_cc_group_id` INT NOT NULL )
CREATE TABLE icnp_cc ( `icnp_cc_id` INT NOT NULL )
CREATE TABLE icnp_assessment ( `icnp_assessment_id` INT NOT NULL )
CREATE TABLE icnp_assessed_status ( `icnp_assessed_status_id` INT NOT NULL )
CREATE TABLE icnp_assessed_degree ( `icnp_assessed_degree_id` INT NOT NULL )
CREATE TABLE icnp_activity_phenomena ( `icnp_activity_phenomena_id` INT NOT NULL )
CREATE TABLE icnp_activity_intervention ( `icnp_activity_intervention_id` INT NOT NULL )
CREATE TABLE icnp_activity_evaluation ( `icnp_activity_evaluation_id` INT NOT NULL )
CREATE TABLE icnp_activity ( `icnp_activity_id` INT NOT NULL )
Checking STRUCTURE phase 1