ALTER TABLE pharmacology_group ADD `outline` VARCHAR(15) NULL
ALTER TABLE operation_agent ADD `total_price` DOUBLE(15,3) NULL
ALTER TABLE opd_queue ADD `queue_date` DATE NULL
ALTER TABLE oapp_template_detail ADD `oapp_note` VARCHAR(150) NULL
ALTER TABLE oapp_template_detail ADD `oapp_date_number` INT NULL
ALTER TABLE oapp_template_detail ADD `oapp_template_id` INT NULL
ALTER TABLE oapp_template ADD `oapp_template_name` VARCHAR(200) NOT NULL
ALTER TABLE lab_perform_status ADD `abort_price` CHAR(1) NULL
ALTER TABLE lab_perform_status ADD `lab_perform_status_name` VARCHAR(150) NOT NULL
ALTER TABLE ipt_admit_stat ADD `admit_hour` INT NULL
ALTER TABLE drugusage ADD `divide_amount` INT NULL
ALTER TABLE drugusage MODIFY COLUMN `dosageform` VARCHAR(250)
ALTER TABLE drug_counseling_list ADD `counseling_pttype` INT NULL
ALTER TABLE drug_counseling_list ADD `department` CHAR(3) NULL
ALTER TABLE drug_counseling_group_check ADD `drug_counseling_check_name` VARCHAR(200) NULL
ALTER TABLE drug_counseling_group_check ADD `drug_counseling_group_id` INT NOT NULL
ALTER TABLE drug_counseling_group ADD `drug_counseling_group_name` VARCHAR(200) NOT NULL
ALTER TABLE counseling_pttype ADD `counseling_pttype_name` VARCHAR(150) NOT NULL
ALTER TABLE blood_pay_service ADD `blood_request_id` INT NOT NULL
ALTER TABLE blood_pay_service ADD `opi_guid` VARCHAR(38) NULL
ALTER TABLE blood_pay_service ADD `service_price` DOUBLE(15,3) NULL
ALTER TABLE blood_pay_service ADD `icode` VARCHAR(7) NOT NULL
ALTER TABLE blood_pay_detail ADD `opi_guid` VARCHAR(38) NULL
ALTER TABLE blood_pay_detail ADD `service_price` DOUBLE(15,3) NULL
ALTER TABLE blood_pay_detail ADD `blood_detail_type_id` INT NULL
ALTER TABLE blood_pay_detail ADD `approve_staff` VARCHAR(15) NULL
ALTER TABLE blood_pay_detail ADD `staff` VARCHAR(15) NULL
ALTER TABLE blood_detail_type ADD `icode` CHAR(7) NULL
ALTER TABLE blood_detail_type ADD `blood_detail_type_name` VARCHAR(150) NOT NULL
CREATE TABLE oapp_template_detail ( `oapp_template_detail_id` INT NOT NULL )
CREATE TABLE oapp_template ( `oapp_template_id` INT NOT NULL )
CREATE TABLE lab_perform_status ( `lab_perform_status_id` INT NOT NULL )
CREATE TABLE drug_counseling_group_check ( `drug_counseling_group_check_id` INT NOT NULL )
CREATE TABLE drug_counseling_group ( `drug_counseling_group_id` INT NOT NULL )
CREATE TABLE counseling_pttype ( `counseling_pttype` INT NOT NULL )
CREATE TABLE blood_pay_service ( `blood_pay_service_id` INT NOT NULL )
CREATE TABLE blood_detail_type ( `blood_detail_type_id` INT NOT NULL )