0616-1

zhaowenxuan

2025-06-16 47ff4d8018d550a23ca81a964c226ec173326942

 ltkj-admin/src/main/resources/sql/index.sql

@@ -17,3 +17,28 @@

# 查看最大的连接数
SHOW VARIABLES LIKE 'max_connections';

CREATE TABLE tj_report_special_project (
                                           id BIGINT PRIMARY KEY NOT NULL,
                                           pro_id BIGINT NOT NULL UNIQUE,
                                           template_key TINYINT(2) NOT NULL COMMENT '模板判断编号 根据编号走不同的生成模板类型',
                                           params TEXT NULL COMMENT '需要额外传递的参数'
) COMMENT '报告特殊项目';


-- 凌云数据
INSERT INTO tj_report_special_project VALUES(1623853479200546816,1862852701533012001,1,'{"dy":"4.0","xy":"4.0","title":"阳性参考值：","dystr":"DOB值：         ≥      ${dy}                HP-阳性","xystr":"                <      ${xy}                  正常","en":"DOB"}');


-- 县医院数据
INSERT INTO tj_report_special_project VALUES(1623853479200546817,1870371396991955967,1,'{"dy":"100","xy":"100","title":"参考值(DPM)：","dystr":"DPM值：         ≥      ${dy}                阳性","xystr":"                <      ${xy}                  阴性","en":"DPM"}');


SELECT * FROM tj_report_special_project;

-- 用户公告关联表
CREATE TABLE sys_notice_user (
                                 id BIGINT PRIMARY KEY NOT NULL,
                                 notice_id BIGINT NOT NULL,
                                 user_id BIGINT NOT NULL
);