diagbotcloud/docs/041.20210511知识库扩展/user_init.sql

use `med_2021`;

ALTER TABLE `kl_disease` add COLUMN `en_name` varchar(255) not null DEFAULT '' COMMENT '英文名称' AFTER `icd10_code`;
ALTER TABLE `kl_disease` add COLUMN `en_name_simple` varchar(255) not null DEFAULT '' COMMENT '英文简称' AFTER `icd10_code`;
ALTER TABLE `kl_disease` add COLUMN `name_simple` varchar(255) not null DEFAULT '' COMMENT '简称' AFTER `icd10_code`;
ALTER TABLE `kl_disease` add COLUMN `is_heredity` varchar(5) not null DEFAULT '' COMMENT '是否遗传' AFTER `icd10_code`;
ALTER TABLE `kl_disease` add COLUMN `is_common_dis` varchar(5) not null DEFAULT '' COMMENT '是否常见病' AFTER `icd10_code`;
ALTER TABLE `kl_disease` add COLUMN `ch_western` varchar(5) not null DEFAULT '' COMMENT '中西医疾病' AFTER `icd10_code`;
ALTER TABLE `kl_disease` add COLUMN `dis_type` varchar(1024) not null DEFAULT '' COMMENT '疾病分型' AFTER `icd10_code`;
ALTER TABLE `kl_disease` add COLUMN `pathogeny` varchar(1024) not null DEFAULT '' COMMENT '病因' AFTER `icd10_code`;
ALTER TABLE `kl_disease` add COLUMN `complication` varchar(1024) not null DEFAULT '' COMMENT '并发症' AFTER `icd10_code`;
ALTER TABLE `kl_disease` add COLUMN `is_infect` varchar(5) not null DEFAULT '' COMMENT '是否传染' AFTER `icd10_code`;
ALTER TABLE `kl_disease` add COLUMN `incidence` double(11,5) DEFAULT NULL COMMENT '发病率' AFTER `icd10_code`;
ALTER TABLE `kl_disease` add COLUMN `vul_crowd` varchar(255) not null DEFAULT '' COMMENT '好发人群' AFTER `icd10_code`;
ALTER TABLE `kl_disease` add COLUMN `vul_area` varchar(255) not null DEFAULT '' COMMENT '好发地区' AFTER `icd10_code`;
ALTER TABLE `kl_disease` add COLUMN `clinic_type` varchar(1024) not null DEFAULT '' COMMENT '临床分类' AFTER `icd10_code`;
ALTER TABLE `kl_disease` add COLUMN `pernicious` varchar(255) not null DEFAULT '' COMMENT '危害性' AFTER `icd10_code`;
ALTER TABLE `kl_disease` add COLUMN `healing` varchar(255) not null DEFAULT '' COMMENT '治愈性' AFTER `icd10_code`;
ALTER TABLE `kl_disease` add COLUMN `hazard` varchar(1024) not null DEFAULT '' COMMENT '危险因素' AFTER `icd10_code`;
ALTER TABLE `kl_disease` add COLUMN `food_prohibition` varchar(1024) not null DEFAULT '' COMMENT '饮食禁忌' AFTER `icd10_code`;
ALTER TABLE `kl_disease` add COLUMN `inducement` varchar(255) not null DEFAULT '' COMMENT '诱因' AFTER `icd10_code`;
ALTER TABLE `kl_disease` add COLUMN `course` varchar(255) not null DEFAULT '' COMMENT '病程' AFTER `icd10_code`;