ALTER TABLE xray_rent ADD `home_rent` CHAR(1) NULL
ALTER TABLE visit_time_type ADD `name` VARCHAR(100) NULL
ALTER TABLE replicate_lock ADD `computer_name` VARCHAR(100) NULL
ALTER TABLE referout ADD `dest_hospital_department` VARCHAR(250) NULL
ALTER TABLE operation_screen_in ADD `chronic_disease` VARCHAR(200) NULL
ALTER TABLE operation_recovery_room ADD `complication` text NULL
ALTER TABLE operation_recovery_room ADD `recovery_dch_id` INT NULL
ALTER TABLE operation_recovery_dch ADD `dch_name` VARCHAR(100) NULL
ALTER TABLE operation_list ADD `anes_complete` CHAR(1) NULL
ALTER TABLE operation_intra_complication ADD `complication_type_id` INT NULL
ALTER TABLE operation_complication_type ADD `complication_type_name` VARCHAR(100) NULL
ALTER TABLE operation_anes_problem ADD `airway_solution_id` INT NULL
ALTER TABLE operation_anes_problem ADD `airway_problem_id` INT NOT NULL
ALTER TABLE operation_anes_problem ADD `operation_id` INT NOT NULL
ALTER TABLE operation_anes_invent ADD `sp_use` VARCHAR(9) NULL
ALTER TABLE operation_agent ADD `price` DOUBLE(15,3) NULL
ALTER TABLE lab_items ADD `items_is_outlab` CHAR(1) NULL
ALTER TABLE drug_interaction ADD `check_old_prescription` CHAR(1) NULL
ALTER TABLE doctor_position_list ADD `position_id` INT NOT NULL
ALTER TABLE doctor_position_list ADD `doctor` VARCHAR(7) NOT NULL
CREATE TABLE visit_time_type ( `visit_time_type_id` INT NOT NULL )
CREATE TABLE referout_hosp_department ( `name` VARCHAR(250) NOT NULL )
CREATE TABLE operation_recovery_dch ( `recovery_dch_id` INT NOT NULL )
CREATE TABLE operation_complication_type ( `complication_type_id` INT NOT NULL )
CREATE TABLE operation_anes_problem ( `operation_anes_problem_id` INT NOT NULL )
CREATE TABLE doctor_position_list ( `doctor_position_list_id` INT NOT NULL )