ALTER TABLE referin ADD `staff` VARCHAR(50) NULL
ALTER TABLE refer_type ADD `refer_type_name` VARCHAR(200) NOT NULL
ALTER TABLE ipt_chart_location_log ADD `an` VARCHAR(9) NOT NULL
ALTER TABLE ipt_chart_location_log ADD `hospital_location_id` INT NOT NULL
ALTER TABLE ipt_chart_location_log ADD `log_datetime` datetime NULL
ALTER TABLE ipt_chart_location_log ADD `staff` VARCHAR(50) NOT NULL
ALTER TABLE ipt_chart_location ADD `hospital_location_id` INT NOT NULL
CREATE TABLE refer_type ( `refer_type` INT NOT NULL )
CREATE TABLE ipt_chart_location_log ( `ipt_cll_id` INT NOT NULL )
CREATE TABLE ipt_chart_location ( `an` VARCHAR(9) NOT NULL )