diagbotcloud/docs/022.20191118预问诊新对接/init_prec.sql

use `sys-prec`;
ALTER TABLE `prec_inquiry_info`
ADD COLUMN `son_hospital_id`  bigint(20) NULL DEFAULT 0 COMMENT '子医院id' AFTER `hospital_name`,
ADD COLUMN `son_hospital_code`  varchar(16) NULL DEFAULT '' COMMENT '子医院code' AFTER `son_hospital_id`,
ADD COLUMN `son_hospital_name`  varchar(32) NULL DEFAULT '' COMMENT '子医院名称' AFTER `son_hospital_code`,
ADD COLUMN `is_quoted`  int(1) NULL DEFAULT 0 COMMENT '是否被引用：0-未引用；1-已引用' AFTER `data_json`;