ALTER TABLE lab_doctor_customize_view ADD `display_order` INT NULL
ALTER TABLE lab_doctor_customize_view ADD `lab_items_code` INT NOT NULL
ALTER TABLE lab_doctor_customize_view ADD `doctor` VARCHAR(7) NOT NULL
ALTER TABLE er_refer_sender ADD `er_refer_sender_name` VARCHAR(150) NOT NULL
ALTER TABLE er_refer_hosptype ADD `er_refer_hosptype_name` VARCHAR(150) NOT NULL
ALTER TABLE er_nursing_visit_type ADD `visit_name` VARCHAR(150) NOT NULL
CREATE TABLE lab_doctor_customize_view ( `lab_doctor_customize_view_id` INT NOT NULL )
CREATE TABLE er_refer_sender ( `er_refer_sender_id` INT NOT NULL )
CREATE TABLE er_refer_hosptype ( `er_refer_hosptype_id` INT NOT NULL )
CREATE TABLE er_nursing_visit_type ( `visit_type` CHAR(1) NOT NULL )
Checking STRUCTURE phase 1