Home Explore Help
Register Sign In
java
/
cdss-core
2
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Tree: b698889242
Branches Tags
cdss-core
/
doc
/
007.20210421推理新增护理
/
med2021_init.sql

med2021_init.sql 15 KB
History Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118 
  1. USE `med_2021`;
    2. 

  2. 

  3. INSERT INTO `med_2021`.`kl_lexicon_relationship` (`id`, `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `name`, `code`, `remark`) VALUES ('11', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '疾病相关护理', '510', '');
    4. 

  4. 

  5. /*
    6. 

  6.  Navicat Premium Data Transfer
    7. 

  7. 

  8.  Source Server         : 192.168.2.236
    9. 

  9.  Source Server Type    : MySQL
    10. 

  10.  Source Server Version : 50731
    11. 

  11.  Source Host           : 192.168.2.236:3306
    12. 

  12.  Source Schema         : med_2021
    13. 

  13. 

  14.  Target Server Type    : MySQL
    15. 

  15.  Target Server Version : 50731
    16. 

  16.  File Encoding         : 65001
    17. 

  17. 

  18.  Date: 27/04/2021 13:48:49
    19. 

  19. */
    20. 

  20. 

  21. SET NAMES utf8mb4;
    22. 

  22. SET FOREIGN_KEY_CHECKS = 0;
    23. 

  23. 

  24. -- ----------------------------
    25. 

  25. -- Table structure for kl_dictionary_info
    26. 

  26. -- ----------------------------
    27. 

  27. DROP TABLE IF EXISTS `kl_dictionary_info`;
    28. 

  28. CREATE TABLE `kl_dictionary_info`  (
    29. 

  29.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    30. 

  30.   `is_deleted` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'N' COMMENT '是否删除,N:未删除，Y:删除',
    31. 

  31.   `gmt_create` datetime(0) NOT NULL DEFAULT '1970-01-01 12:00:00' COMMENT '记录创建时间',
    32. 

  32.   `gmt_modified` datetime(0) NOT NULL DEFAULT '1970-01-01 12:00:00' COMMENT '记录修改时间,如果时间是1970年则表示纪录未修改',
    33. 

  33.   `creator` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '创建人，0表示无创建人值',
    34. 

  34.   `modifier` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '修改人,如果为0则表示纪录未修改',
    35. 

  35.   `group_type` bigint(20) NOT NULL DEFAULT 0 COMMENT '分组（值自定义）',
    36. 

  36.   `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '内容',
    37. 

  37.   `val` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '值',
    38. 

  38.   `return_type` int(11) NOT NULL DEFAULT 1 COMMENT '返回类型（0: 都返回，1：后台维护返回 2：界面返回）',
    39. 

  39.   `order_no` int(11) NOT NULL DEFAULT 0 COMMENT '排序号',
    40. 

  40.   `remark` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
    41. 

  41.   PRIMARY KEY (`id`) USING BTREE
    42. 

  42. ) ENGINE = InnoDB AUTO_INCREMENT = 144 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '字典表' ROW_FORMAT = Dynamic;
    43. 

  43. 

  44. -- ----------------------------
    45. 

  45. -- Records of kl_dictionary_info
    46. 

  46. -- ----------------------------
    47. 

  47. INSERT INTO `kl_dictionary_info` VALUES (1, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 7, '全部', '0', 2, 1, '静态知识检索类型');
    48. 

  48. INSERT INTO `kl_dictionary_info` VALUES (2, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 7, '诊断', '1', 2, 10, '静态知识检索类型');
    49. 

  49. INSERT INTO `kl_dictionary_info` VALUES (3, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 7, '药品', '2', 2, 20, '静态知识检索类型');
    50. 

  50. INSERT INTO `kl_dictionary_info` VALUES (4, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 7, '检验', '3', 2, 30, '静态知识检索类型');
    51. 

  51. INSERT INTO `kl_dictionary_info` VALUES (5, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 7, '检查', '5', 2, 40, '静态知识检索类型');
    52. 

  52. INSERT INTO `kl_dictionary_info` VALUES (6, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 7, '手术和操作', '6', 2, 50, '静态知识检索类型');
    53. 

  53. INSERT INTO `kl_dictionary_info` VALUES (7, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 7, '量表', '8', 2, 80, '静态知识检索类型');
    54. 

  54. INSERT INTO `kl_dictionary_info` VALUES (80, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 13, '诊断', '疾病', 1, 100, '页面显示词性');
    55. 

  55. INSERT INTO `kl_dictionary_info` VALUES (81, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 13, '药品', '药品通用名', 1, 101, '页面显示词性');
    56. 

  56. INSERT INTO `kl_dictionary_info` VALUES (82, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 13, '药品剂型', '药品剂型', 1, 102, '页面显示词性');
    57. 

  57. INSERT INTO `kl_dictionary_info` VALUES (83, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 13, '症状', '症状', 1, 103, '页面显示词性');
    58. 

  58. INSERT INTO `kl_dictionary_info` VALUES (84, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 13, '体格检查项目', '体格检查项目', 1, 104, '页面显示词性');
    59. 

  59. INSERT INTO `kl_dictionary_info` VALUES (85, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 13, '体格检查结果', '体格检查结果', 1, 105, '页面显示词性');
    60. 

  60. INSERT INTO `kl_dictionary_info` VALUES (86, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 13, '手术和操作', '手术和操作', 1, 106, '页面显示词性');
    61. 

  61. INSERT INTO `kl_dictionary_info` VALUES (87, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 13, '检验套餐', '实验室检查套餐', 1, 107, '页面显示词性');
    62. 

  62. INSERT INTO `kl_dictionary_info` VALUES (88, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 13, '检验细项', '实验室检查子项目', 1, 108, '页面显示词性');
    63. 

  63. INSERT INTO `kl_dictionary_info` VALUES (89, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 13, '检查', '辅助检查项目', 1, 109, '页面显示词性');
    64. 

  64. INSERT INTO `kl_dictionary_info` VALUES (90, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 13, '检查子项', '辅助检查子项目', 1, 110, '页面显示词性');
    65. 

  65. INSERT INTO `kl_dictionary_info` VALUES (91, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 13, '辅助检查描述', '辅助检查描述', 1, 111, '页面显示词性');
    66. 

  66. INSERT INTO `kl_dictionary_info` VALUES (92, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 13, '辅助检查结果', '辅助检查结果', 1, 112, '页面显示词性');
    67. 

  67. INSERT INTO `kl_dictionary_info` VALUES (93, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 13, '输血类型', '输血类型', 1, 113, '页面显示词性');
    68. 

  68. INSERT INTO `kl_dictionary_info` VALUES (94, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 13, '麻醉', '麻醉', 1, 114, '页面显示词性');
    69. 

  69. INSERT INTO `kl_dictionary_info` VALUES (95, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 13, '科室', '科室', 1, 115, '页面显示词性');
    70. 

  70. INSERT INTO `kl_dictionary_info` VALUES (96, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 13, '性别', '性别', 1, 116, '页面显示词性');
    71. 

  71. INSERT INTO `kl_dictionary_info` VALUES (97, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 13, '人群', '人群', 1, 117, '页面显示词性');
    72. 

  72. INSERT INTO `kl_dictionary_info` VALUES (98, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 13, '食物', '食物', 1, 118, '页面显示词性');
    73. 

  73. INSERT INTO `kl_dictionary_info` VALUES (99, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 13, '其他过敏原', '其他过敏原', 1, 119, '页面显示词性');
    74. 

  74. INSERT INTO `kl_dictionary_info` VALUES (100, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 13, '医疗器械及物品', '医疗器械及物品', 1, 120, '页面显示词性');
    75. 

  75. INSERT INTO `kl_dictionary_info` VALUES (101, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 13, '给药途径', '给药途径', 1, 121, '页面显示词性');
    76. 

  76. INSERT INTO `kl_dictionary_info` VALUES (102, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 13, '部位', '部位', 1, 122, '页面显示词性');
    77. 

  77. INSERT INTO `kl_dictionary_info` VALUES (103, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 13, '护理', '护理', 1, 123, '页面显示词性');
    78. 

  78. INSERT INTO `kl_dictionary_info` VALUES (104, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 13, '量表', '量表', 1, 124, '页面显示词性');
    79. 

  79. INSERT INTO `kl_dictionary_info` VALUES (105, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 13, '单位', '单位', 1, 125, '页面显示词性');
    80. 

  80. INSERT INTO `kl_dictionary_info` VALUES (106, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 13, 'ICD10疾病类别', 'ICD10疾病类别', 1, 300, '页面显示词性');
    81. 

  81. INSERT INTO `kl_dictionary_info` VALUES (107, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 13, '药品化学物质类别', '药品化学物质类别', 1, 301, '页面显示词性');
    82. 

  82. INSERT INTO `kl_dictionary_info` VALUES (108, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 13, '药品治疗学类别', '药品治疗学类别', 1, 302, '页面显示词性');
    83. 

  83. INSERT INTO `kl_dictionary_info` VALUES (109, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 13, '药品药理学类别', '药品药理学类别', 1, 303, '页面显示词性');
    84. 

  84. INSERT INTO `kl_dictionary_info` VALUES (110, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 13, '药品解剖学类别', '药品解剖学类别', 1, 304, '页面显示词性');
    85. 

  85. INSERT INTO `kl_dictionary_info` VALUES (111, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 13, '症状类别', '症状类别', 1, 305, '页面显示词性');
    86. 

  86. INSERT INTO `kl_dictionary_info` VALUES (112, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 13, '手术和操作类别', '手术和操作类别', 1, 306, '页面显示词性');
    87. 

  87. INSERT INTO `kl_dictionary_info` VALUES (113, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 13, 'ICD10疾病类别根节点', 'ICD10疾病类别根节点', 1, 400, '页面显示词性');
    88. 

  88. INSERT INTO `kl_dictionary_info` VALUES (114, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 13, '科室疾病类别根节点', '科室疾病类别根节点', 1, 401, '页面显示词性');
    89. 

  89. INSERT INTO `kl_dictionary_info` VALUES (115, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 13, '药品化学物质类别根节点', '药品化学物质类别根节点', 1, 402, '页面显示词性');
    90. 

  90. INSERT INTO `kl_dictionary_info` VALUES (116, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 13, '药品治疗学类别根节点', '药品治疗学类别根节点', 1, 403, '页面显示词性');
    91. 

  91. INSERT INTO `kl_dictionary_info` VALUES (117, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 13, '药品药理学类别根节点', '药品药理学类别根节点', 1, 404, '页面显示词性');
    92. 

  92. INSERT INTO `kl_dictionary_info` VALUES (118, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 13, '药品解剖学类别根节点', '药品解剖学类别根节点', 1, 405, '页面显示词性');
    93. 

  93. INSERT INTO `kl_dictionary_info` VALUES (119, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 13, '症状类别根节点', '症状类别根节点', 1, 406, '页面显示词性');
    94. 

  94. INSERT INTO `kl_dictionary_info` VALUES (120, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 13, '手术和操作类别根节点', '手术和操作类别根节点', 1, 407, '页面显示词性');
    95. 

  95. INSERT INTO `kl_dictionary_info` VALUES (121, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 13, '实验室检查类别根节点', '实验室检查类别根节点', 1, 408, '页面显示词性');
    96. 

  96. INSERT INTO `kl_dictionary_info` VALUES (122, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 13, '辅助检查类别根节点', '辅助检查类别根节点', 1, 409, '页面显示词性');
    97. 

  97. INSERT INTO `kl_dictionary_info` VALUES (123, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 13, '年龄', '年龄', 1, 410, '页面显示词性');
    98. 

  98. INSERT INTO `kl_dictionary_info` VALUES (124, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 20, '危急值-实验室检查子项目', '3-108-2', 1, 0, '化验规则维护特殊处理');
    99. 

  99. INSERT INTO `kl_dictionary_info` VALUES (125, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 20, '其他值提醒-实验室检查子项目', '4-108-2', 1, 0, '化验规则维护特殊处理');
    100. 

  100. INSERT INTO `kl_dictionary_info` VALUES (126, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 20, '其他值提醒输血-实验室检查子项目', '5-108-2', 1, 0, '化验规则维护特殊处理');
    101. 

  101. INSERT INTO `kl_dictionary_info` VALUES (127, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 21, '高危-药品通用名', '2-101', 1, 0, '附加信息特殊处理');
    102. 

  102. INSERT INTO `kl_dictionary_info` VALUES (128, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 21, '其他值提醒-辅助检查结果', '4-112', 1, 0, '附加信息特殊处理');
    103. 

  103. INSERT INTO `kl_dictionary_info` VALUES (129, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 21, '其他值提醒输血-实验室检查子项目', '5-108', 1, 0, '附加信息特殊处理');
    104. 

  104. INSERT INTO `kl_dictionary_info` VALUES (130, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 20, '正常项目重复开立-辅助检查项目', '6-109-6', 1, 0, '化验规则维护特殊处理');
    105. 

  105. INSERT INTO `kl_dictionary_info` VALUES (131, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 20, '正常项目重复开立-辅助检查子项目', '6-110-6', 1, 0, '化验规则维护特殊处理');
    106. 

  106. INSERT INTO `kl_dictionary_info` VALUES (132, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 31, '开单外等于术语本身', '1', 1, 0, '基础规则类型');
    107. 

  107. INSERT INTO `kl_dictionary_info` VALUES (133, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 31, '开单外存在比较', '2', 1, 0, '基础规则类型');
    108. 

  108. INSERT INTO `kl_dictionary_info` VALUES (134, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 31, '开单外不等于术语本身', '3', 1, 0, '基础规则类型');
    109. 

  109. INSERT INTO `kl_dictionary_info` VALUES (135, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 31, '过敏原', '4', 1, 0, '基础规则类型');
    110. 

  110. INSERT INTO `kl_dictionary_info` VALUES (136, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 31, '开单项', '5', 1, 0, '基础规则类型');
    111. 

  111. INSERT INTO `kl_dictionary_info` VALUES (137, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 31, '检查结果正则表达式', '6', 1, 0, '基础规则类型');
    112. 

  112. INSERT INTO `kl_dictionary_info` VALUES (138, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 22, '开单合理性-年龄-体格检查项目', '410,104', 1, 0, '开单合理性只有数字没有文本');
    113. 

  113. INSERT INTO `kl_dictionary_info` VALUES (139, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 23, '复杂情况下高风险手术-手术和操作', '2-106', 1, 0, '高危手术存在有无子条件特殊处理');
    114. 

  114. INSERT INTO `kl_dictionary_info` VALUES (140, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 24, '诊断依据存在比较-年龄-体格检查项目', '410,104', 1, 0, '诊断依据存在比较只有数字没有文本');
    115. 

  115. INSERT INTO `kl_dictionary_info` VALUES (141, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 25, '诊断依据存在比较-实验室检查子项目', '108', 1, 0, '诊断依据存在比较只有文本');
    116. 

  116. INSERT INTO `kl_dictionary_info` VALUES (143, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 7, '护理', '9', 2, 90, '静态知识检索类型');
    117. 

  117. 

  118. SET FOREIGN_KEY_CHECKS = 1;
    119.