| | |
|---|
| | | |
|---|
| | | # 查看最大的连接数 |
|---|
| | | 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; |
|---|
