wlyy2.0/common/common-entity/src/db/2024.sql

ALTER table wlyy_outpatient add COLUMN `plan_id` varchar(50) DEFAULT NULL COMMENT '康复执行计划关联id';
ALTER table wlyy_outpatient add COLUMN `plan_doctor` varchar(50) DEFAULT NULL COMMENT '康复执行计划负责人id';

--中山医院那套有就不加了 ALTER table base_suggestion add COLUMN `suggest_user_idcard` varchar(50) DEFAULT NULL COMMENT '投诉人身份证';
-- ALTER table base_suggestion add COLUMN `user_idcard_front` varchar(255) DEFAULT NULL COMMENT '投诉人身份证正面url';
-- ALTER table base_suggestion add COLUMN `user_idcard_bak` varchar(255) DEFAULT NULL COMMENT '投诉人身份证反面url';
-- ALTER table base_suggestion add COLUMN `vitist_type` varchar(50) DEFAULT NULL COMMENT '就诊类型 1门诊 2住院';
-- ALTER table base_suggestion add COLUMN `vitist_time` varchar(50) DEFAULT NULL COMMENT '就诊时间';
-- ALTER table base_suggestion add COLUMN `vitist_dept_code` varchar(50) DEFAULT NULL COMMENT '就诊科室编码';
-- ALTER table base_suggestion add COLUMN `vitist_detp_name` varchar(50) DEFAULT NULL COMMENT '就诊科室名称';
-- ALTER table base_suggestion add COLUMN `admission_no` varchar(50) DEFAULT NULL COMMENT '住院号';

ALTER table base_menu_dict add COLUMN `article_type` varchar(2) DEFAULT NULL COMMENT '文章类型 公告、广告、文章、帮助中心 article_menu_type';

INSERT INTO `base`.`wlyy_hospital_sys_dict` (`id`, `saas_id`, `dict_name`, `dict_code`, `dict_value`, `py_code`, `sort`, `hospital`, `create_time`, `create_user`, `create_user_name`, `update_time`, `update_user`, `update_user_name`, `img_url`, `model_name`) VALUES ('article_menu_type1', NULL, 'article_menu_type', '1', '公告', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '文章类型 公告、广告、文章、帮助中心');
INSERT INTO `base`.`wlyy_hospital_sys_dict` (`id`, `saas_id`, `dict_name`, `dict_code`, `dict_value`, `py_code`, `sort`, `hospital`, `create_time`, `create_user`, `create_user_name`, `update_time`, `update_user`, `update_user_name`, `img_url`, `model_name`) VALUES ('article_menu_type2', NULL, 'article_menu_type', '2', '广告', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '文章类型 公告、广告、文章、帮助中心');
INSERT INTO `base`.`wlyy_hospital_sys_dict` (`id`, `saas_id`, `dict_name`, `dict_code`, `dict_value`, `py_code`, `sort`, `hospital`, `create_time`, `create_user`, `create_user_name`, `update_time`, `update_user`, `update_user_name`, `img_url`, `model_name`) VALUES ('article_menu_type3', NULL, 'article_menu_type', '3', '文章', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '文章类型 公告、广告、文章、帮助中心');
INSERT INTO `base`.`wlyy_hospital_sys_dict` (`id`, `saas_id`, `dict_name`, `dict_code`, `dict_value`, `py_code`, `sort`, `hospital`, `create_time`, `create_user`, `create_user_name`, `update_time`, `update_user`, `update_user_name`, `img_url`, `model_name`) VALUES ('article_menu_type4', NULL, 'article_menu_type', '4', '帮助中心', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '文章类型 公告、广告、文章、帮助中心');


ALTER table wlyy_devices add COLUMN `qrcode` varchar(255) DEFAULT NULL COMMENT '二维码地址';
INSERT INTO `base`.`wlyy_hospital_sys_dict` (`id`, `saas_id`, `dict_name`, `dict_code`, `dict_value`, `py_code`, `sort`, `hospital`, `create_time`, `create_user`, `create_user_name`, `update_time`, `update_user`, `update_user_name`, `img_url`, `model_name`) VALUES ('devicePriUrl', NULL, 'devicePriUrl', 'devicePriUrl', 'https://hlw.xmdsyy.cn/hlw/ims-wx/#/healthRecords/deviceBind?SN=', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '设备二维码前缀');

ALTER table base_knowledge_question add COLUMN `scene_code` varchar(50) DEFAULT NULL COMMENT '使用场景编码 逗号间隔';
ALTER table base_knowledge_question add COLUMN `scene_name` varchar(200) DEFAULT NULL COMMENT '使用场景名称 逗号间隔';
INSERT INTO `base`.`wlyy_hospital_sys_dict` (`id`, `saas_id`, `dict_name`, `dict_code`, `dict_value`, `py_code`, `sort`, `hospital`, `create_time`, `create_user`, `create_user_name`, `update_time`, `update_user`, `update_user_name`, `img_url`, `model_name`) VALUES ('knowledge_question_scene1', NULL, 'knowledge_question_scene', '1', '在线导诊', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '使用场景');
INSERT INTO `base`.`wlyy_hospital_sys_dict` (`id`, `saas_id`, `dict_name`, `dict_code`, `dict_value`, `py_code`, `sort`, `hospital`, `create_time`, `create_user`, `create_user_name`, `update_time`, `update_user`, `update_user_name`, `img_url`, `model_name`) VALUES ('knowledge_question_scene2', NULL, 'knowledge_question_scene', '2', '专属服务导诊', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '使用场景');
INSERT INTO `base`.`wlyy_hospital_sys_dict` (`id`, `saas_id`, `dict_name`, `dict_code`, `dict_value`, `py_code`, `sort`, `hospital`, `create_time`, `create_user`, `create_user_name`, `update_time`, `update_user`, `update_user_name`, `img_url`, `model_name`) VALUES ('knowledge_question_scene3', NULL, 'knowledge_question_scene', '3', '在线候诊室', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '使用场景');
INSERT INTO `base`.`wlyy_hospital_sys_dict` (`id`, `saas_id`, `dict_name`, `dict_code`, `dict_value`, `py_code`, `sort`, `hospital`, `create_time`, `create_user`, `create_user_name`, `update_time`, `update_user`, `update_user_name`, `img_url`, `model_name`) VALUES ('knowledge_question_scene4', NULL, 'knowledge_question_scene', '4', '在线诊室', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '使用场景');


ALTER table wlyy_patient_family_member add COLUMN `medicare` varchar(50) DEFAULT NULL COMMENT '社保卡';

INSERT INTO `base`.`oauth_wlyy_config` (`id`, `app_id`, `app_secret`, `token_url`, `url`, `remark`) VALUES
    ('getDoctorList', '019bd04d-3cb2-433f-a530-03f0cdb083e5', '08cc3ec2-736b-4732-a8f0-f99eb6f9d311', 'https://www.xmtyw.cn/wlyytest/gc/accesstoken', 'https://www.xmtyw.cn/wlyytest/wlyygc/tongan/hospital/getDoctorList', '厦门I健康获取社区医生列表');

INSERT INTO `base`.`wx_wechat` (`id`, `name`, `token`, `encoding_aes_key`, `enc_type`, `status`, `type`, `app_id`, `app_secret`, `app_origin_id`, `base_url`, `user_name`, `password`, `public_type`, `create_user`, `create_user_name`, `create_time`, `update_user`, `update_user_name`, `update_time`, `remark`, `mch_id`, `cerfiticate`, `app_key`, `syn_path`, `applets`, `applets_secret`) VALUES ('xm_ihealth_wx', '厦门I健康', NULL, NULL, '1', '1', NULL, 'wx79a7f451c8c30308', 'fc96ec810e5078c0ca0f96a8fca4da95', 'gh#_a09552a72c9b', NULL, NULL, NULL, NULL, NULL, NULL, '2022-03-29 10:15:02', NULL, NULL, '1970-01-02 00:00:00', NULL, NULL, NULL, NULL, 'https://www.xmtyw.cn/wlyy/iHealth/userInfo', NULL, NULL);






-------------------------------------------------------------------------------------------------------------------------

-- 20240220 新增
ALTER TABLE `base`.`wlyy_outpatient`
ADD COLUMN `is_positive` varchar(255) NULL COMMENT '是否新冠阳性 1是0否' AFTER `plan_doctor`,
ADD COLUMN `inquiry_sign` varchar(255) NULL COMMENT '问诊标识1发热咨询0普通门诊' AFTER `is_positive`,
ADD COLUMN `visit_type` varchar(255) NULL COMMENT '就诊类型：1首诊2复诊' AFTER `inquiry_sign`,
ADD COLUMN `virus_flag` varchar(255) NULL COMMENT '新冠病毒：1阴性、2阳性、0无' AFTER `visit_type`,
ADD COLUMN `is_disease` varchar(255) NULL COMMENT '特殊病种1是0否' AFTER `virus_flag`;

-- 2024-02-26
ALTER TABLE `base`.`wlyy_knowledge_category`
    ADD COLUMN `is_check` tinyint(1) NULL COMMENT '是否开启审核1开启 0关闭， 默认开启' ;




INSERT INTO `base`.`wlyy_hospital_sys_dict` (`id`, `saas_id`, `dict_name`, `dict_code`, `dict_value`, `py_code`, `sort`, `hospital`, `create_time`, `create_user`, `create_user_name`, `update_time`, `update_user`, `update_user_name`, `img_url`, `model_name`) VALUES ('patient_lable_custom1', NULL, 'patient_lable_custom', '1', '儿童', NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '居民标签自定义');
INSERT INTO `base`.`wlyy_hospital_sys_dict` (`id`, `saas_id`, `dict_name`, `dict_code`, `dict_value`, `py_code`, `sort`, `hospital`, `create_time`, `create_user`, `create_user_name`, `update_time`, `update_user`, `update_user_name`, `img_url`, `model_name`) VALUES ('patient_lable_custom2', NULL, 'patient_lable_custom', '2', '孕妇女', NULL, '2', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '居民标签自定义');
INSERT INTO `base`.`wlyy_hospital_sys_dict` (`id`, `saas_id`, `dict_name`, `dict_code`, `dict_value`, `py_code`, `sort`, `hospital`, `create_time`, `create_user`, `create_user_name`, `update_time`, `update_user`, `update_user_name`, `img_url`, `model_name`) VALUES ('patient_lable_custom3', NULL, 'patient_lable_custom', '3', '65岁以上', NULL, '3', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '居民标签自定义');
INSERT INTO `base`.`wlyy_hospital_sys_dict` (`id`, `saas_id`, `dict_name`, `dict_code`, `dict_value`, `py_code`, `sort`, `hospital`, `create_time`, `create_user`, `create_user_name`, `update_time`, `update_user`, `update_user_name`, `img_url`, `model_name`) VALUES ('patient_lable_health1', NULL, 'patient_lable_health', '1', '健康人群', NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '健康情况标签');
INSERT INTO `base`.`wlyy_hospital_sys_dict` (`id`, `saas_id`, `dict_name`, `dict_code`, `dict_value`, `py_code`, `sort`, `hospital`, `create_time`, `create_user`, `create_user_name`, `update_time`, `update_user`, `update_user_name`, `img_url`, `model_name`) VALUES ('patient_lable_health2', NULL, 'patient_lable_health', '2', '高危人群', NULL, '2', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '健康情况标签');
INSERT INTO `base`.`wlyy_hospital_sys_dict` (`id`, `saas_id`, `dict_name`, `dict_code`, `dict_value`, `py_code`, `sort`, `hospital`, `create_time`, `create_user`, `create_user_name`, `update_time`, `update_user`, `update_user_name`, `img_url`, `model_name`) VALUES ('patient_lable_health3', NULL, 'patient_lable_health', '3', '患病人群', NULL, '3', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '健康情况标签');
INSERT INTO `base`.`wlyy_hospital_sys_dict` (`id`, `saas_id`, `dict_name`, `dict_code`, `dict_value`, `py_code`, `sort`, `hospital`, `create_time`, `create_user`, `create_user_name`, `update_time`, `update_user`, `update_user_name`, `img_url`, `model_name`) VALUES ('patient_lable_health4', NULL, 'patient_lable_health', '4', '恢复期人群', NULL, '4', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '健康情况标签');
INSERT INTO `base`.`wlyy_hospital_sys_dict` (`id`, `saas_id`, `dict_name`, `dict_code`, `dict_value`, `py_code`, `sort`, `hospital`, `create_time`, `create_user`, `create_user_name`, `update_time`, `update_user`, `update_user_name`, `img_url`, `model_name`) VALUES ('patient_lable_disease_type1', NULL, 'patient_lable_disease_type', '1', '高血压', NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '居民标签_疾病类型');
INSERT INTO `base`.`wlyy_hospital_sys_dict` (`id`, `saas_id`, `dict_name`, `dict_code`, `dict_value`, `py_code`, `sort`, `hospital`, `create_time`, `create_user`, `create_user_name`, `update_time`, `update_user`, `update_user_name`, `img_url`, `model_name`) VALUES ('patient_lable_disease_type2', NULL, 'patient_lable_disease_type', '2', '糖尿病', NULL, '2', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '居民标签_疾病类型');
INSERT INTO `base`.`wlyy_hospital_sys_dict` (`id`, `saas_id`, `dict_name`, `dict_code`, `dict_value`, `py_code`, `sort`, `hospital`, `create_time`, `create_user`, `create_user_name`, `update_time`, `update_user`, `update_user_name`, `img_url`, `model_name`) VALUES ('patient_lable_disease_type3', NULL, 'patient_lable_disease_type', '3', '慢性支气管炎', NULL, '3', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '居民标签_疾病类型');
INSERT INTO `base`.`wlyy_hospital_sys_dict` (`id`, `saas_id`, `dict_name`, `dict_code`, `dict_value`, `py_code`, `sort`, `hospital`, `create_time`, `create_user`, `create_user_name`, `update_time`, `update_user`, `update_user_name`, `img_url`, `model_name`) VALUES ('patient_lable_disease_type4', NULL, 'patient_lable_disease_type', '4', '脑梗塞', NULL, '4', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '居民标签_疾病类型');
INSERT INTO `base`.`wlyy_hospital_sys_dict` (`id`, `saas_id`, `dict_name`, `dict_code`, `dict_value`, `py_code`, `sort`, `hospital`, `create_time`, `create_user`, `create_user_name`, `update_time`, `update_user`, `update_user_name`, `img_url`, `model_name`) VALUES ('patient_lable_disease_type5', NULL, 'patient_lable_disease_type', '5', '冠心病', NULL, '5', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '居民标签_疾病类型');
INSERT INTO `base`.`wlyy_hospital_sys_dict` (`id`, `saas_id`, `dict_name`, `dict_code`, `dict_value`, `py_code`, `sort`, `hospital`, `create_time`, `create_user`, `create_user_name`, `update_time`, `update_user`, `update_user_name`, `img_url`, `model_name`) VALUES ('patient_lable_disease_type6', NULL, 'patient_lable_disease_type', '6', '呼吸系统疾病', NULL, '6', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '居民标签_疾病类型');
INSERT INTO `base`.`wlyy_hospital_sys_dict` (`id`, `saas_id`, `dict_name`, `dict_code`, `dict_value`, `py_code`, `sort`, `hospital`, `create_time`, `create_user`, `create_user_name`, `update_time`, `update_user`, `update_user_name`, `img_url`, `model_name`) VALUES ('patient_lable_disease_type7', NULL, 'patient_lable_disease_type', '7', '骨性关节疾病', NULL, '7', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '居民标签_疾病类型');
INSERT INTO `base`.`wlyy_hospital_sys_dict` (`id`, `saas_id`, `dict_name`, `dict_code`, `dict_value`, `py_code`, `sort`, `hospital`, `create_time`, `create_user`, `create_user_name`, `update_time`, `update_user`, `update_user_name`, `img_url`, `model_name`) VALUES ('patient_lable_disease_type8', NULL, 'patient_lable_disease_type', '8', '结核病', NULL, '8', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '居民标签_疾病类型');
INSERT INTO `base`.`wlyy_hospital_sys_dict` (`id`, `saas_id`, `dict_name`, `dict_code`, `dict_value`, `py_code`, `sort`, `hospital`, `create_time`, `create_user`, `create_user_name`, `update_time`, `update_user`, `update_user_name`, `img_url`, `model_name`) VALUES ('patient_lable_disease_type9', NULL, 'patient_lable_disease_type', '9', '残疾', NULL, '9', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '居民标签_疾病类型');
INSERT INTO `base`.`wlyy_hospital_sys_dict` (`id`, `saas_id`, `dict_name`, `dict_code`, `dict_value`, `py_code`, `sort`, `hospital`, `create_time`, `create_user`, `create_user_name`, `update_time`, `update_user`, `update_user_name`, `img_url`, `model_name`) VALUES ('patient_lable_disease_type10', NULL, 'patient_lable_disease_type', '10', '重性精神疾病', NULL, '10', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '居民标签_疾病类型');
INSERT INTO `base`.`wlyy_hospital_sys_dict` (`id`, `saas_id`, `dict_name`, `dict_code`, `dict_value`, `py_code`, `sort`, `hospital`, `create_time`, `create_user`, `create_user_name`, `update_time`, `update_user`, `update_user_name`, `img_url`, `model_name`) VALUES ('patient_lable_disease_type11', NULL, 'patient_lable_disease_type', '11', '其他疾病', NULL, '11', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '居民标签_疾病类型');

CREATE TABLE `wlyy_patient_label_log` (
     `id` int NOT NULL AUTO_INCREMENT,,
     `patient` varchar(50) DEFAULT NULL,
     `doctor` varchar(50) DEFAULT NULL,
     `doctor_name` varchar(50) DEFAULT NULL,
     `label_code` varchar(50) DEFAULT NULL,
     `label_name` varchar(50) DEFAULT NULL,
     `label_type` varchar(50) DEFAULT NULL,
     `job_title` varchar(50) DEFAULT NULL,
     `create_time` datetime DEFAULT NULL,
     PRIMARY KEY (`id`),
     KEY `index` (`patient`,`doctor`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;


-------- 慢病管理------
CREATE TABLE `wlyy_doctor_switch` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `doctor` varchar(50) DEFAULT NULL COMMENT '关联医生',
  `alert_patient_switch` varchar(2) DEFAULT '0' COMMENT '0不自动跟踪居民，1自动跟踪预警居民',
  `dispatch_order_switch` varchar(2) DEFAULT '0' COMMENT '0关闭分派订单功能，1开启分派订单功能',
  `create_time` timestamp NULL DEFAULT NULL,
  `update_time` timestamp NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=870 DEFAULT CHARSET=utf8;

CREATE TABLE `wlyy_doctor_scheme_blood_sugger` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '数据库主键，与业务主键无关',
  `name` varchar(20) DEFAULT NULL COMMENT '方案名称',
  `code` varchar(50) NOT NULL COMMENT '业务主键UUID',
  `doctorcode` varchar(50) DEFAULT NULL COMMENT '医生CODE',
  `dayofweek` tinyint(4) NOT NULL COMMENT '1到7递增，1为星期日，7为星期六',
  `before_breakfast` tinyint(4) DEFAULT '0' COMMENT '早餐前：0为否，1为是',
  `before_breakfast_time` time DEFAULT NULL COMMENT '早餐前测量时间',
  `after_breakfast` tinyint(4) DEFAULT '0' COMMENT '早餐后：0为否，1为是',
  `after_breakfast_time` time DEFAULT NULL COMMENT '早餐后测量时间',
  `before_lunch` tinyint(4) DEFAULT '0' COMMENT '午餐前：0为否，1为是',
  `before_lunch_time` time DEFAULT NULL COMMENT '午餐前测量时间',
  `after_lunch` tinyint(4) DEFAULT '0' COMMENT '午餐后：0为否，1为是',
  `after_lunch_time` time DEFAULT NULL COMMENT '午餐后测量时间',
  `before_dinner` tinyint(4) DEFAULT '0' COMMENT '晚餐前：0为否，1为是',
  `before_dinner_time` time DEFAULT NULL COMMENT '晚餐前测量时间',
  `after_dinner` tinyint(4) DEFAULT '0' COMMENT '晚餐后：0为否，1为是',
  `after_dinner_time` time DEFAULT NULL COMMENT '晚餐后测量时间',
  `before_sleep` tinyint(4) DEFAULT '0' COMMENT '睡前：0为否，1为是',
  `before_sleep_time` time DEFAULT NULL COMMENT '睡前测量时间',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `alert_tag` tinyint(4) DEFAULT '0' COMMENT '是否提醒居民：0为否，1为是',
  `content` varchar(30) DEFAULT NULL COMMENT '方案说明',
  `del` tinyint(4) DEFAULT '0' COMMENT '0为正常，1为被删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=113 DEFAULT CHARSET=utf8mb4 COMMENT='医生-血糖监测方案表';


INSERT INTO `base`.`oauth_wlyy_config`(`id`, `app_id`, `app_secret`, `token_url`, `url`, `remark`)
VALUES ('getChronicDiseaseData', '019bd04d-3cb2-433f-a530-03f0cdb083e5', '08cc3ec2-736b-4732-a8f0-f99eb6f9d311', 'https://ehr.yihu.com/wlyy/gc/accesstoken', 'https://ehr.yihu.com/wlyy/wlyygc/tongan/hospital/getChronicDiseaseData', '获取同安签约慢病数据');

CREATE TABLE `base_patient_doctor_relation` (
  `id` int NOT NULL AUTO_INCREMENT,
  `patient_id` varchar(100) DEFAULT NULL COMMENT '患者id',
  `doctor_id` varchar(100) DEFAULT NULL COMMENT '医生id',
  `source_type` varchar(10) DEFAULT NULL COMMENT '来源类型，1线上就诊 ， 2i健康签约',
  `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;


CREATE TABLE `wlyy_track_patient` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `patient_code` varchar(50) DEFAULT NULL COMMENT '关联居民code，医生的重点关注对象',
  `patient_name` varchar(50) DEFAULT NULL COMMENT '患者姓名',
  `doctor_code` varchar(50) DEFAULT NULL COMMENT '所属医生',
  `doctor_name` varchar(50) DEFAULT NULL COMMENT '所属医生名',
  `team_code` int(11) DEFAULT NULL COMMENT '居民签约团队',
  `idcard` varchar(50) DEFAULT NULL COMMENT '身份证号',
  `ssc` varchar(50) DEFAULT NULL COMMENT '社保卡号',
  `del` varchar(1) DEFAULT NULL COMMENT '1正常，0删除',
  `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uk_patient_doctor` (`patient_code`,`doctor_code`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1946 DEFAULT CHARSET=utf8mb4;

CREATE TABLE `wlyy_doctor_health_standard` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '业务无关主键',
  `doctor` varchar(50) NOT NULL COMMENT '患者标识',
  `type` int(11) NOT NULL COMMENT '健康指标类型：1血糖，2血压，3体重，4腰围',
  `min_value_1` double DEFAULT NULL COMMENT '最低安全值(血糖餐前收缩压体重腰围)',
  `max_value_1` double DEFAULT NULL COMMENT '最高安全值(血糖餐前收缩压体重腰围)',
  `min_value_2` double DEFAULT NULL COMMENT '最低安全值(血糖餐后舒张压)',
  `max_value_2` double DEFAULT NULL COMMENT '最高安全值(血糖餐后舒张压)',
  `czrq` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '设置时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `idx_wlyy_doctor_health_standard_1` (`doctor`,`type`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=359 DEFAULT CHARSET=utf8mb4 COMMENT='医生健康指标预警值方案';


CREATE TABLE `wlyy_doctor_scheme_blood_pressure` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id主键，与业务主键CODE无关',
  `name` varchar(20) DEFAULT NULL COMMENT '方案名称',
  `code` varchar(50) DEFAULT NULL COMMENT '业务主键CODE，UUID',
  `doctorcode` varchar(50) DEFAULT NULL COMMENT '医生CODE',
  `dayofweek` tinyint(4) NOT NULL COMMENT '1至7递增，1为星期日，7位星期六',
  `early_morning` tinyint(4) DEFAULT '0' COMMENT '清晨：0为否，1为是',
  `early_morning_time` time DEFAULT NULL COMMENT '清晨测量时间',
  `morning` tinyint(4) DEFAULT '0' COMMENT '上午：0为否，1为是',
  `morning_time` time DEFAULT NULL COMMENT '上午测量时间',
  `noon` tinyint(4) DEFAULT '0' COMMENT '中午：0为否，1为是',
  `noon_time` time DEFAULT NULL COMMENT '中午测量时间',
  `after_noon` tinyint(4) DEFAULT '0' COMMENT '下午：0为否，1为是',
  `after_noon_time` time DEFAULT NULL COMMENT '下午测量时间',
  `night` tinyint(4) DEFAULT '0' COMMENT '晚上：0为否，1为是',
  `night_time` time DEFAULT NULL COMMENT '晚上测量时间',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `alert_tag` tinyint(4) DEFAULT NULL COMMENT '是否提醒居民：0为否，1为是',
  `content` varchar(20) DEFAULT NULL COMMENT '方案说明',
  `del` tinyint(4) DEFAULT '0' COMMENT '0为正常，1为被删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=78 DEFAULT CHARSET=utf8mb4 COMMENT='医生-血压监测方案';


CREATE TABLE `wlyy_patient_scheme_list` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id主键，与业务逻辑无关',
  `code` varchar(50) NOT NULL COMMENT '业务逻辑主键UUID',
  `patientcode` varchar(50) NOT NULL COMMENT '患者CODE',
  `schemecode` varchar(50) NOT NULL COMMENT '监测方案CODE',
  `type` tinyint(4) NOT NULL COMMENT '方案类型：1为血糖,2为血压',
  `doctorcode` varchar(50) DEFAULT NULL COMMENT '医生CODE',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COMMENT='患者-监测方案关联关系表';

INSERT INTO `base`.`oauth_wlyy_config` (`id`, `app_id`, `app_secret`, `token_url`, `url`, `remark`) VALUES ('commonGet', '019bd04d-3cb2-433f-a530-03f0cdb083e5', '08cc3ec2-736b-4732-a8f0-f99eb6f9d311', 'https://www.xmtyw.cn/wlyytest/gc/accesstoken', 'https://www.xmtyw.cn/wlyytest/wlyygc/tongan/hospital/', '通用接口');
INSERT INTO `base`.`oauth_wlyy_config` (`id`, `app_id`, `app_secret`, `token_url`, `url`, `remark`) VALUES ('uploadImg', '019bd04d-3cb2-433f-a530-03f0cdb083e5', '08cc3ec2-736b-4732-a8f0-f99eb6f9d311', 'https://www.xmtyw.cn/wlyytest/gc/accesstoken', 'https://www.xmtyw.cn/wlyytest/wlyygc/upload/file', '图片上传');

CREATE TABLE `wlyy_sign` (
   `id` int NOT NULL AUTO_INCREMENT,
   `idcard` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '身份证',
   `admin_team_id` int DEFAULT NULL COMMENT '签约团队',
   `name` varchar(50) DEFAULT NULL COMMENT '姓名',
   `address` varchar(50) DEFAULT NULL COMMENT '地址',
   `hospital_name` varchar(50) DEFAULT NULL COMMENT '签约社区',
   `doctor_name` varchar(50) DEFAULT NULL COMMENT '全科医生',
   `health_doctor_name` varchar(50) DEFAULT NULL COMMENT '健管师',
   `begin` varchar(10) DEFAULT NULL COMMENT '签约开始时间',
   `end` varchar(10) DEFAULT NULL COMMENT '签约结束时间',
   `sign_year` varchar(1) DEFAULT NULL COMMENT '签约年限',
   `status` varchar(4) DEFAULT NULL COMMENT '状态',
   `sign_source` varchar(1) DEFAULT NULL COMMENT '签约类型',
   `disease_condition` varchar(5) DEFAULT NULL COMMENT '病情',
   `sys_time` varchar(30) DEFAULT NULL COMMENT '同步时间',
   `create_time` datetime DEFAULT NULL COMMENT '创建时间',
   PRIMARY KEY (`id`),
   KEY `index2` (`admin_team_id`),
   KEY `index3` (`sys_time`),
   KEY `index4` (`hospital_name`,`doctor_name`,`health_doctor_name`),
   KEY `index1` (`patient`,`idcard`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;



CREATE TABLE `wlyy_patient_aim_blood_pressure` (
      `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id主键，与业务逻辑无关',
      `code` varchar(50) NOT NULL COMMENT '业务主键UUID',
      `patientcode` varchar(50) DEFAULT NULL COMMENT '患者CODE',
      `sbp` varchar(10) DEFAULT NULL COMMENT '血压收缩压',
      `dbp` varchar(10) DEFAULT NULL COMMENT '血压舒张压',
      `sbp_min` varchar(10) DEFAULT NULL COMMENT '血压收缩压低限',
      `dbp_min` varchar(10) DEFAULT NULL COMMENT '血压舒张压低限',
      `unit` varchar(10) DEFAULT NULL COMMENT '单位',
      `create_time` datetime DEFAULT NULL COMMENT '创建时间',
      PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COMMENT='患者-血压目标';

CREATE TABLE `wlyy_patient_aim_blood_sugger` (
   `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id主键，与业务主键无关',
   `code` varchar(50) NOT NULL COMMENT '业务主键UUID',
   `patientcode` varchar(50) DEFAULT NULL COMMENT '患者CODE',
   `fbg` varchar(10) DEFAULT NULL COMMENT 'FBG(fasting blood-glucose)空腹血糖',
   `hpg` varchar(10) DEFAULT NULL COMMENT '餐后两小时血糖(2h Plasma Glucose,2Hpg)',
   `fbg_min` varchar(10) DEFAULT NULL COMMENT '空腹血糖低限',
   `hpg_min` varchar(255) DEFAULT NULL COMMENT '餐后血糖低限',
   `unit` varchar(10) DEFAULT NULL COMMENT '血糖单位',
   `create_time` datetime DEFAULT NULL COMMENT '创建时间',
   PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='患者-血糖目标';


INSERT INTO `wlyy_hospital_sys_dict` (`id`, `saas_id`, `dict_name`, `dict_code`, `dict_value`, `py_code`, `sort`, `hospital`, `create_time`,
  `create_user`, `create_user_name`, `update_time`, `update_user`, `update_user_name`, `img_url`, `model_name`) VALUES
('ijk_sign_source1', NULL, 'ijk_sign_source', '1', '线下', NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '签约类型');
INSERT INTO `wlyy_hospital_sys_dict` (`id`, `saas_id`, `dict_name`, `dict_code`, `dict_value`, `py_code`, `sort`, `hospital`, `create_time`,
                                      `create_user`, `create_user_name`, `update_time`, `update_user`, `update_user_name`, `img_url`, `model_name`) VALUES
  ('ijk_sign_source2', NULL, 'ijk_sign_source', '2', '线上', NULL, '2', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '签约类型');


INSERT INTO `wlyy_hospital_sys_dict` (`id`, `saas_id`, `dict_name`, `dict_code`, `dict_value`, `py_code`, `sort`, `hospital`, `create_time`,
                                      `create_user`, `create_user_name`, `update_time`, `update_user`, `update_user_name`, `img_url`, `model_name`) VALUES
    ('ijk_sign_status1', NULL, 'ijk_sign_status', '-1', '患者已取消', NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '签约状态');
INSERT INTO `wlyy_hospital_sys_dict` (`id`, `saas_id`, `dict_name`, `dict_code`, `dict_value`, `py_code`, `sort`, `hospital`, `create_time`,
                                      `create_user`, `create_user_name`, `update_time`, `update_user`, `update_user_name`, `img_url`, `model_name`) VALUES
    ('ijk_sign_status2', NULL, 'ijk_sign_status', '-2', '已拒绝', NULL, '2', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '签约状态');
INSERT INTO `wlyy_hospital_sys_dict` (`id`, `saas_id`, `dict_name`, `dict_code`, `dict_value`, `py_code`, `sort`, `hospital`, `create_time`,
                                      `create_user`, `create_user_name`, `update_time`, `update_user`, `update_user_name`, `img_url`, `model_name`) VALUES
    ('ijk_sign_status3', NULL, 'ijk_sign_status', '-3', '已解约', NULL, '3', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '签约状态');
INSERT INTO `wlyy_hospital_sys_dict` (`id`, `saas_id`, `dict_name`, `dict_code`, `dict_value`, `py_code`, `sort`, `hospital`, `create_time`,
                                      `create_user`, `create_user_name`, `update_time`, `update_user`, `update_user_name`, `img_url`, `model_name`) VALUES
    ('ijk_sign_status4', NULL, 'ijk_sign_status', '-4', '已到期', NULL, '4', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '签约状态');
INSERT INTO `wlyy_hospital_sys_dict` (`id`, `saas_id`, `dict_name`, `dict_code`, `dict_value`, `py_code`, `sort`, `hospital`, `create_time`,
                                      `create_user`, `create_user_name`, `update_time`, `update_user`, `update_user_name`, `img_url`, `model_name`) VALUES
    ('ijk_sign_status5', NULL, 'ijk_sign_status', '0', '待签约', NULL, '5', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '签约状态');
INSERT INTO `wlyy_hospital_sys_dict` (`id`, `saas_id`, `dict_name`, `dict_code`, `dict_value`, `py_code`, `sort`, `hospital`, `create_time`,
                                      `create_user`, `create_user_name`, `update_time`, `update_user`, `update_user_name`, `img_url`, `model_name`) VALUES
    ('ijk_sign_status6', NULL, 'ijk_sign_status', '1', '已签约', NULL, '6', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '签约状态');
INSERT INTO `wlyy_hospital_sys_dict` (`id`, `saas_id`, `dict_name`, `dict_code`, `dict_value`, `py_code`, `sort`, `hospital`, `create_time`,
                                      `create_user`, `create_user_name`, `update_time`, `update_user`, `update_user_name`, `img_url`, `model_name`) VALUES
    ('ijk_sign_status7', NULL, 'ijk_sign_status', '2', '患者申请取消签约', NULL, '7', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '签约状态');
INSERT INTO `wlyy_hospital_sys_dict` (`id`, `saas_id`, `dict_name`, `dict_code`, `dict_value`, `py_code`, `sort`, `hospital`, `create_time`,
                                      `create_user`, `create_user_name`, `update_time`, `update_user`, `update_user_name`, `img_url`, `model_name`) VALUES
    ('ijk_sign_status8', NULL, 'ijk_sign_status', '3', '医生申请取消签约', NULL, '8', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '签约状态');