mrqc-sys/doc/002.20200426第二版/qc_init.sql

use `qc`;

ALTER TABLE `med_behospital_info` MODIFY COLUMN `doctor_id` varchar(16) DEFAULT NULL COMMENT '医生ID' AFTER `diagnose`;

ALTER TABLE sys_user_hospital ADD  COLUMN `dept_id` varchar(16) NOT NULL COMMENT '科室ID' AFTER `hospital_id`;
ALTER TABLE sys_user_hospital ADD  COLUMN `doctor_id` varchar(16) DEFAULT NULL COMMENT '医生ID' AFTER `dept_id`;