ホーム エクスプローラ ヘルプ
登録 サインイン
java
/
cdss-core
2
0
Fork 0
ファイル 課題 0 プルリクエスト 0 Wiki
ツリー: a2e978d1c8
ブランチ タグ
cdss-core
/
doc
/
027.20220301医学计算公式
/
cdss_init.sql

cdss_init.sql 29 KB
履歴 Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193 
  1. USE `cdss`;
    2. 

  2. 

  3. /*
    4. 

  4.  Navicat Premium Data Transfer
    5. 

  5. 

  6.  Source Server         : 192.168.2.236
    7. 

  7.  Source Server Type    : MySQL
    8. 

  8.  Source Server Version : 50736
    9. 

  9.  Source Host           : 192.168.2.236:3306
    10. 

  10.  Source Schema         : cdss
    11. 

  11. 

  12.  Target Server Type    : MySQL
    13. 

  13.  Target Server Version : 50736
    14. 

  14.  File Encoding         : 65001
    15. 

  15. 

  16.  Date: 09/03/2022 14:09:02
    17. 

  17. */
    18. 

  18. 

  19. SET NAMES utf8mb4;
    20. 

  20. SET FOREIGN_KEY_CHECKS = 0;
    21. 

  21. 

  22. -- ----------------------------
    23. 

  23. -- Table structure for sys_dictionary_info
    24. 

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

  25. DROP TABLE IF EXISTS `sys_dictionary_info`;
    26. 

  26. CREATE TABLE `sys_dictionary_info`  (
    27. 

  27.                                         `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    28. 

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

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

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

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

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

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

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

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

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

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

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

  39.                                         PRIMARY KEY (`id`) USING BTREE
    40. 

  40. ) ENGINE = InnoDB AUTO_INCREMENT = 149 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'CDSS字典表' ROW_FORMAT = Dynamic;
    41. 

  41. 

  42. -- ----------------------------
    43. 

  43. -- Records of sys_dictionary_info
    44. 

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

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

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

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

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

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

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

  51. INSERT INTO `sys_dictionary_info` VALUES (7, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 8, '诊断', '医保疾病名称', 0, 1, '图谱标签与页面显示类型对应关系');
    52. 

  52. INSERT INTO `sys_dictionary_info` VALUES (8, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 8, '药品', '药品通用名称', 0, 6, '图谱标签与页面显示类型对应关系');
    53. 

  53. INSERT INTO `sys_dictionary_info` VALUES (9, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 8, '检验套餐', '实验室检查套餐名', 0, 2, '图谱标签与页面显示类型对应关系');
    54. 

  54. INSERT INTO `sys_dictionary_info` VALUES (10, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 8, '检验细项', '实验室检查名称', 0, 3, '图谱标签与页面显示类型对应关系');
    55. 

  55. INSERT INTO `sys_dictionary_info` VALUES (11, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 8, '检查', '辅助检查名称', 0, 4, '图谱标签与页面显示类型对应关系');
    56. 

  56. INSERT INTO `sys_dictionary_info` VALUES (12, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 8, '手术和操作', '医保手术和操作名称', 0, 7, '图谱标签与页面显示类型对应关系');
    57. 

  57. INSERT INTO `sys_dictionary_info` VALUES (13, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 9, '', '0', 0, 1, '药品剂型');
    58. 

  58. INSERT INTO `sys_dictionary_info` VALUES (14, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 9, '注射剂', '1', 0, 10, '药品剂型');
    59. 

  59. INSERT INTO `sys_dictionary_info` VALUES (15, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 9, '片剂', '2', 0, 20, '药品剂型');
    60. 

  60. INSERT INTO `sys_dictionary_info` VALUES (16, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 9, '缓释剂', '3', 0, 30, '药品剂型');
    61. 

  61. INSERT INTO `sys_dictionary_info` VALUES (17, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 9, '胶囊剂', '4', 0, 40, '药品剂型');
    62. 

  62. INSERT INTO `sys_dictionary_info` VALUES (18, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 9, '滴丸剂', '5', 0, 50, '药品剂型');
    63. 

  63. INSERT INTO `sys_dictionary_info` VALUES (19, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 8, '检查子项', '辅助检查子项目名称', 0, 5, '图谱标签与页面显示类型对应关系');
    64. 

  64. INSERT INTO `sys_dictionary_info` VALUES (21, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 10, '诊断', '1', 1, 1, '静态知识类型');
    65. 

  65. INSERT INTO `sys_dictionary_info` VALUES (22, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 10, '药品', '2', 1, 2, '静态知识类型');
    66. 

  66. INSERT INTO `sys_dictionary_info` VALUES (23, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 10, '检验套餐', '3', 1, 3, '静态知识类型');
    67. 

  67. INSERT INTO `sys_dictionary_info` VALUES (24, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 10, '检验细项', '4', 1, 4, '静态知识类型');
    68. 

  68. INSERT INTO `sys_dictionary_info` VALUES (25, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 10, '检查', '5', 1, 5, '静态知识类型');
    69. 

  69. INSERT INTO `sys_dictionary_info` VALUES (26, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 10, '检查子项', '6', 1, 6, '静态知识类型');
    70. 

  70. INSERT INTO `sys_dictionary_info` VALUES (27, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 10, '手术和操作', '7', 1, 7, '静态知识类型');
    71. 

  71. INSERT INTO `sys_dictionary_info` VALUES (28, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 8, '药品类别', '药品类别', 0, 20, '图谱标签与页面显示类型对应关系');
    72. 

  72. INSERT INTO `sys_dictionary_info` VALUES (29, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 11, '检验套餐', '1', 0, 1, '开单合理项检索类型');
    73. 

  73. INSERT INTO `sys_dictionary_info` VALUES (30, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 11, '检查', '2', 0, 2, '开单合理项检索类型');
    74. 

  74. INSERT INTO `sys_dictionary_info` VALUES (31, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 11, '检查子项', '3', 0, 3, '开单合理项检索类型');
    75. 

  75. INSERT INTO `sys_dictionary_info` VALUES (32, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 11, '手术和操作', '4', 0, 4, '开单合理项检索类型');
    76. 

  76. INSERT INTO `sys_dictionary_info` VALUES (33, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 11, '药品注册名称', '5', 0, 5, '开单合理项检索类型');
    77. 

  77. INSERT INTO `sys_dictionary_info` VALUES (34, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 12, '性别', '1', 0, 0, '开单禁忌条件类型');
    78. 

  78. INSERT INTO `sys_dictionary_info` VALUES (35, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 12, '实验室检查', '2', 0, 0, '开单禁忌条件类型');
    79. 

  79. INSERT INTO `sys_dictionary_info` VALUES (36, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 12, '临床表现', '3', 0, 0, '开单禁忌条件类型');
    80. 

  80. INSERT INTO `sys_dictionary_info` VALUES (37, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 12, '辅助检查名称描述', '4', 0, 0, '开单禁忌条件类型');
    81. 

  81. INSERT INTO `sys_dictionary_info` VALUES (38, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 12, '疾病', '5', 0, 0, '开单禁忌条件类型');
    82. 

  82. INSERT INTO `sys_dictionary_info` VALUES (39, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 12, '服用药品', '6', 0, 0, '开单禁忌条件类型');
    83. 

  83. INSERT INTO `sys_dictionary_info` VALUES (40, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 12, '药物过敏原', '7', 0, 0, '开单禁忌条件类型');
    84. 

  84. INSERT INTO `sys_dictionary_info` VALUES (41, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 12, '食物过敏原', '8', 0, 0, '开单禁忌条件类型');
    85. 

  85. INSERT INTO `sys_dictionary_info` VALUES (42, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 12, '手术', '9', 0, 0, '开单禁忌条件类型');
    86. 

  86. INSERT INTO `sys_dictionary_info` VALUES (43, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 12, '禁忌人群', '10', 0, 0, '开单禁忌条件类型');
    87. 

  87. INSERT INTO `sys_dictionary_info` VALUES (44, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 12, '过敏原', '11', 0, 0, '开单禁忌条件类型');
    88. 

  88. INSERT INTO `sys_dictionary_info` VALUES (45, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 12, '体征', '12', 0, 0, '开单禁忌条件类型');
    89. 

  89. INSERT INTO `sys_dictionary_info` VALUES (46, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 12, '禁忌医疗器械及物品', '13', 0, 0, '开单禁忌条件类型');
    90. 

  90. INSERT INTO `sys_dictionary_info` VALUES (47, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 12, '年龄', '14', 0, 0, '开单禁忌条件类型');
    91. 

  91. INSERT INTO `sys_dictionary_info` VALUES (48, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 12, '给药途径', '15', 0, 0, '开单禁忌条件类型');
    92. 

  92. INSERT INTO `sys_dictionary_info` VALUES (49, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 12, '开单项互斥', '16', 0, 0, '开单禁忌条件类型');
    93. 

  93. INSERT INTO `sys_dictionary_info` VALUES (50, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 8, '疾病（开单合理性）', '疾病', 0, 8, '图谱标签与页面显示类型对应关系');
    94. 

  94. INSERT INTO `sys_dictionary_info` VALUES (51, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 8, '实验室检查细项（开单合理性）', '实验室检查', 0, 9, '图谱标签与页面显示类型对应关系');
    95. 

  95. INSERT INTO `sys_dictionary_info` VALUES (52, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 8, '化验细项及结果（推理）', '化验细项及结果', 0, 10, '图谱标签与页面显示类型对应关系');
    96. 

  96. INSERT INTO `sys_dictionary_info` VALUES (53, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 8, '实验室检查危急值', '实验室检查危急值', 0, 11, '图谱标签与页面显示类型对应关系');
    97. 

  97. INSERT INTO `sys_dictionary_info` VALUES (54, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 8, '化验提醒指标', '化验提醒指标', 0, 12, '图谱标签与页面显示类型对应关系');
    98. 

  98. INSERT INTO `sys_dictionary_info` VALUES (55, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 8, '化验套餐名称（推理）', '化验套餐名称', 0, 13, '图谱标签与页面显示类型对应关系');
    99. 

  99. INSERT INTO `sys_dictionary_info` VALUES (56, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 8, '辅助检查危急值', '辅助检查危急值', 0, 14, '图谱标签与页面显示类型对应关系');
    100. 

  100. INSERT INTO `sys_dictionary_info` VALUES (57, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 8, '辅助检查结果（开单合理性）', '辅助检查名称描述', 0, 15, '图谱标签与页面显示类型对应关系');
    101. 

  101. INSERT INTO `sys_dictionary_info` VALUES (58, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 8, '辅助检查结果（诊断依据）', '辅助检查名称结果', 0, 16, '图谱标签与页面显示类型对应关系');
    102. 

  102. INSERT INTO `sys_dictionary_info` VALUES (59, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 8, '辅检提醒指标', '辅检提醒指标', 0, 17, '图谱标签与页面显示类型对应关系');
    103. 

  103. INSERT INTO `sys_dictionary_info` VALUES (60, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 8, '药品代码通用名', '药品代码通用名', 0, 18, '图谱标签与页面显示类型对应关系');
    104. 

  104. INSERT INTO `sys_dictionary_info` VALUES (61, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 8, '药品注册名称', '药品注册名称', 0, 19, '图谱标签与页面显示类型对应关系');
    105. 

  105. INSERT INTO `sys_dictionary_info` VALUES (62, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 8, '药品治疗学类别', '药品治疗学类别', 0, 21, '图谱标签与页面显示类型对应关系');
    106. 

  106. INSERT INTO `sys_dictionary_info` VALUES (63, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 8, '药品药理学类别', '药品药理学类别', 0, 22, '图谱标签与页面显示类型对应关系');
    107. 

  107. INSERT INTO `sys_dictionary_info` VALUES (64, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 8, '药品解剖学类别', '药品解剖学类别', 0, 23, '图谱标签与页面显示类型对应关系');
    108. 

  108. INSERT INTO `sys_dictionary_info` VALUES (65, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 8, '药品化学物质类别', '药品化学物质类别', 0, 24, '图谱标签与页面显示类型对应关系');
    109. 

  109. INSERT INTO `sys_dictionary_info` VALUES (66, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 8, '服用药品（开单合理性）', '服用药品', 0, 25, '图谱标签与页面显示类型对应关系');
    110. 

  110. INSERT INTO `sys_dictionary_info` VALUES (67, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 8, '禁忌医疗器械及物品', '禁忌医疗器械及物品', 0, 26, '图谱标签与页面显示类型对应关系');
    111. 

  111. INSERT INTO `sys_dictionary_info` VALUES (68, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 8, '性别', '性别', 0, 27, '图谱标签与页面显示类型对应关系');
    112. 

  112. INSERT INTO `sys_dictionary_info` VALUES (69, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 8, '体征', '体征', 0, 28, '图谱标签与页面显示类型对应关系');
    113. 

  113. INSERT INTO `sys_dictionary_info` VALUES (70, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 8, '症状', '症状', 0, 29, '图谱标签与页面显示类型对应关系');
    114. 

  114. INSERT INTO `sys_dictionary_info` VALUES (71, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 8, '临床表现', '临床表现', 0, 30, '图谱标签与页面显示类型对应关系');
    115. 

  115. INSERT INTO `sys_dictionary_info` VALUES (72, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 8, '科室', '科室', 0, 31, '图谱标签与页面显示类型对应关系');
    116. 

  116. INSERT INTO `sys_dictionary_info` VALUES (73, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 8, '开单项互斥', '开单项互斥', 0, 32, '图谱标签与页面显示类型对应关系');
    117. 

  117. INSERT INTO `sys_dictionary_info` VALUES (74, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 8, '禁忌人群', '禁忌人群', 0, 33, '图谱标签与页面显示类型对应关系');
    118. 

  118. INSERT INTO `sys_dictionary_info` VALUES (75, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 8, '建议输血提醒', '建议输血提醒', 0, 34, '图谱标签与页面显示类型对应关系');
    119. 

  119. INSERT INTO `sys_dictionary_info` VALUES (76, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 8, '药物过敏原', '药物过敏原', 0, 35, '图谱标签与页面显示类型对应关系');
    120. 

  120. INSERT INTO `sys_dictionary_info` VALUES (77, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 8, '其他过敏原', '过敏原', 0, 36, '图谱标签与页面显示类型对应关系');
    121. 

  121. INSERT INTO `sys_dictionary_info` VALUES (78, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 8, '食物过敏原', '食物过敏原', 0, 37, '图谱标签与页面显示类型对应关系');
    122. 

  122. INSERT INTO `sys_dictionary_info` VALUES (79, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 8, '输血提醒指标', '输血提醒指标', 0, 38, '图谱标签与页面显示类型对应关系');
    123. 

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  167. INSERT INTO `sys_dictionary_info` VALUES (124, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 7, '量表/医学计算公式', '8', 2, 80, '静态知识检索类型');
    168. 

  168. INSERT INTO `sys_dictionary_info` VALUES (125, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 10, '量表', '8', 1, 8, '静态知识类型');
    169. 

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

  170. INSERT INTO `sys_dictionary_info` VALUES (127, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 10, '护理', '9', 1, 9, '静态知识类型');
    171. 

  171. INSERT INTO `sys_dictionary_info` VALUES (128, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 50, '否', '0', 1, 1, '是否选项');
    172. 

  172. INSERT INTO `sys_dictionary_info` VALUES (129, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 50, '是', '1', 1, 2, '是否选项');
    173. 

  173. INSERT INTO `sys_dictionary_info` VALUES (130, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 7, '政策法规', '10', 2, 100, '静态知识检索类型');
    174. 

  174. INSERT INTO `sys_dictionary_info` VALUES (131, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 10, '政策法规', '10', 1, 10, '静态知识类型');
    175. 

  175. INSERT INTO `sys_dictionary_info` VALUES (132, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 13, '政策法规', '政策法规', 1, 411, '页面显示词性');
    176. 

  176. INSERT INTO `sys_dictionary_info` VALUES (133, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 60, '默认方案', 'plan_default', 1, 0, '电子方案配置');
    177. 

  177. INSERT INTO `sys_dictionary_info` VALUES (134, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 60, '输入位置-基本信息', 'info', 1, 0, '电子方案配置');
    178. 

  178. INSERT INTO `sys_dictionary_info` VALUES (135, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 60, '输入位置-主诉', 'chief', 1, 0, '电子方案配置');
    179. 

  179. INSERT INTO `sys_dictionary_info` VALUES (136, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 60, '输入位置-现病史', 'symptom', 1, 0, '电子方案配置');
    180. 

  180. INSERT INTO `sys_dictionary_info` VALUES (137, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 60, '输入位置-其他史', 'other', 1, 0, '电子方案配置');
    181. 

  181. INSERT INTO `sys_dictionary_info` VALUES (138, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 60, '输入位置-体格检查', 'vital', 1, 0, '电子方案配置');
    182. 

  182. INSERT INTO `sys_dictionary_info` VALUES (139, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 60, '输入位置-化验', 'lis', 1, 0, '电子方案配置');
    183. 

  183. INSERT INTO `sys_dictionary_info` VALUES (140, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 60, '输入位置-辅检', 'pacs', 1, 0, '电子方案配置');
    184. 

  184. INSERT INTO `sys_dictionary_info` VALUES (141, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 60, '输入位置-诊断', 'diag', 1, 0, '电子方案配置');
    185. 

  185. INSERT INTO `sys_dictionary_info` VALUES (142, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 60, '输入位置-医嘱', 'doc_advice', 1, 0, '电子方案配置');
    186. 

  186. INSERT INTO `sys_dictionary_info` VALUES (143, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 60, '非空且非输入状态', 'patientia', 1, 0, '电子方案配置');
    187. 

  187. INSERT INTO `sys_dictionary_info` VALUES (144, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 60, '病历推送', 'medical_record', 1, 0, '电子方案配置');
    188. 

  188. INSERT INTO `sys_dictionary_info` VALUES (145, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 60, '医嘱推送', 'medical_advice', 1, 0, '电子方案配置');
    189. 

  189. INSERT INTO `sys_dictionary_info` VALUES (146, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 60, '开单合理性', 'order_rational', 1, 0, '电子方案配置');
    190. 

  190. INSERT INTO `sys_dictionary_info` VALUES (147, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 60, '检查报告多测量值', 'reference_pacs', 1, 0, '电子方案配置');
    191. 

  191. INSERT INTO `sys_dictionary_info` VALUES (148, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 60, '检验报告多测量值', 'reference_lis', 1, 0, NULL);
    192. 

  192. 

  193. SET FOREIGN_KEY_CHECKS = 1;
    194.