init_prec.sql 674 B

12345678910
  1. use `sys-prec`;
  2. ALTER TABLE `prec_inquiry_info`
  3. ADD COLUMN `son_hospital_id` bigint(20) NULL DEFAULT 0 COMMENT '子医院id' AFTER `hospital_name`,
  4. ADD COLUMN `son_hospital_code` varchar(16) NULL DEFAULT '' COMMENT '子医院code' AFTER `son_hospital_id`,
  5. ADD COLUMN `son_hospital_name` varchar(32) NULL DEFAULT '' COMMENT '子医院名称' AFTER `son_hospital_code`,
  6. ADD COLUMN `is_quoted` int(1) NULL DEFAULT 0 COMMENT '是否被引用:0-未引用;1-已引用' AFTER `data_json`;
  7. ALTER TABLE `prec_question_info` ADD COLUMN `flag` varchar(20) NOT NULL DEFAULT ''
  8. COMMENT '类型标记(1:时间类型,2:诱因类型,3:伴随类型)' AFTER `spec_flag`;