ALTER TABLE psychia_visit ADD `hn` VARCHAR(9) NULL
ALTER TABLE psychia_member_type ADD `psychia_member_type_id` INT NOT NULL
ALTER TABLE operation_cancel_type ADD `operation_cancel_type_name` VARCHAR(150) NOT NULL
ALTER TABLE operation_cancel ADD `operation_cancel_note` text NULL
ALTER TABLE operation_cancel ADD `operation_cancel_type_id` INT NOT NULL
ALTER TABLE lab_room ADD `lab_room_name` VARCHAR(150) NOT NULL
ALTER TABLE lab_items_report_right ADD `loginname` VARCHAR(50) NOT NULL
ALTER TABLE lab_items_report_right ADD `lab_items_code` INT NOT NULL
ALTER TABLE lab_form_room ADD `lab_room_id` INT NOT NULL
ALTER TABLE lab_form_room ADD `form_name` VARCHAR(250) NOT NULL
ALTER TABLE income_report2 ADD `cscd_group` CHAR(1) NULL
ALTER TABLE eye_examination ADD `doctor` VARCHAR(7) NULL
ALTER TABLE eye_examination ADD `fundi_left` VARCHAR(150) NULL
ALTER TABLE eye_examination ADD `fundi_right` VARCHAR(150) NULL
ALTER TABLE eye_examination ADD `mirror_cupping_le2` VARCHAR(150) NULL
ALTER TABLE eye_examination ADD `mirror_cupping_le1` VARCHAR(150) NULL
ALTER TABLE eye_examination ADD `mirror_cupping_re2` VARCHAR(150) NULL
ALTER TABLE eye_examination ADD `mirror_cupping_re1` VARCHAR(150) NULL
ALTER TABLE eye_examination ADD `mirror_pigmentation_le` VARCHAR(150) NULL
ALTER TABLE eye_examination ADD `mirror_pigmentation_re` VARCHAR(150) NULL
ALTER TABLE eye_examination ADD `mirror_insertion_le` VARCHAR(150) NULL
ALTER TABLE eye_examination ADD `mirror_insertion_re` VARCHAR(150) NULL
ALTER TABLE eye_examination ADD `mirror_shape_re` VARCHAR(150) NULL
ALTER TABLE eye_examination ADD `mirror_shape_le` VARCHAR(150) NULL
ALTER TABLE eye_examination ADD `mirror_angle_le` VARCHAR(150) NULL
ALTER TABLE eye_examination ADD `mirror_angle_re` VARCHAR(150) NULL
ALTER TABLE eye_examination ADD `refraction_pd2` VARCHAR(150) NULL
ALTER TABLE eye_examination ADD `refraction_pd1` VARCHAR(150) NULL
ALTER TABLE eye_examination ADD `refraction_add` VARCHAR(150) NULL
ALTER TABLE eye_examination ADD `subj_os_axis` VARCHAR(150) NULL
ALTER TABLE eye_examination ADD `subj_os_cyl` VARCHAR(150) NULL
ALTER TABLE eye_examination ADD `subj_os_sphere` VARCHAR(150) NULL
ALTER TABLE eye_examination ADD `subj_od_axis` VARCHAR(150) NULL
ALTER TABLE eye_examination ADD `subj_od_cyl` VARCHAR(150) NULL
ALTER TABLE eye_examination ADD `subj_od_sphere` VARCHAR(150) NULL
ALTER TABLE eye_examination ADD `obj_os_axis` VARCHAR(150) NULL
ALTER TABLE eye_examination ADD `obj_os_cyl` VARCHAR(150) NULL
ALTER TABLE eye_examination ADD `obj_os_sphere` VARCHAR(150) NULL
ALTER TABLE eye_examination ADD `obj_od_axis` VARCHAR(150) NULL
ALTER TABLE eye_examination ADD `obj_od_cyl` VARCHAR(150) NULL
ALTER TABLE eye_examination ADD `obj_od_sphere` VARCHAR(150) NULL
ALTER TABLE eye_examination ADD `lens_le` VARCHAR(150) NULL
ALTER TABLE eye_examination ADD `lens_re` VARCHAR(150) NULL
ALTER TABLE eye_examination ADD `ac_le` VARCHAR(150) NULL
ALTER TABLE eye_examination ADD `ac_re` VARCHAR(150) NULL
ALTER TABLE eye_examination ADD `cornea_le` VARCHAR(150) NULL
ALTER TABLE eye_examination ADD `cornea_re` VARCHAR(150) NULL
ALTER TABLE eye_examination ADD `conjunctiva_re` VARCHAR(150) NULL
ALTER TABLE eye_examination ADD `conjunctiva_le` VARCHAR(150) NULL
ALTER TABLE eye_examination ADD `eyelid_le` VARCHAR(150) NULL
ALTER TABLE eye_examination ADD `eyelid_re` VARCHAR(150) NULL
ALTER TABLE eye_examination ADD `pntension2` VARCHAR(150) NULL
ALTER TABLE eye_examination ADD `pntension1` VARCHAR(150) NULL
ALTER TABLE eye_examination ADD `apptension2` VARCHAR(150) NULL
ALTER TABLE eye_examination ADD `apptension1` VARCHAR(150) NULL
ALTER TABLE eye_examination ADD `vacccph2` VARCHAR(150) NULL
ALTER TABLE eye_examination ADD `vacccph1` VARCHAR(150) NULL
ALTER TABLE eye_examination ADD `vacc2` VARCHAR(150) NULL
ALTER TABLE eye_examination ADD `vacc1` VARCHAR(150) NULL
ALTER TABLE eye_examination ADD `vacph2` VARCHAR(150) NULL
ALTER TABLE eye_examination ADD `vacph1` VARCHAR(150) NULL
ALTER TABLE eye_examination ADD `va2` VARCHAR(150) NULL
ALTER TABLE eye_examination ADD `va1` VARCHAR(150) NULL
ALTER TABLE eye_examination ADD `examination_time` TIME NULL
ALTER TABLE eye_examination ADD `examination_date` DATE NULL
ALTER TABLE eye_examination ADD `vn` VARCHAR(13) NOT NULL
CREATE TABLE operation_cancel_type ( `operation_cancel_type_id` INT NOT NULL )
CREATE TABLE operation_cancel ( `operation_id` INT NOT NULL )
CREATE TABLE lab_room ( `lab_room_id` INT NOT NULL )
CREATE TABLE lab_items_report_right ( `lab_items_report_right_id` INT NOT NULL )
CREATE TABLE lab_form_room ( `lab_form_room_id` INT NOT NULL )
CREATE TABLE eye_examination ( `eye_examination_id` INT NOT NULL )