Home Explore Help
Register Sign In
java
/
cdss-core
2
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Tree: be355a2b4c
Branches Tags
cdss-core
/
doc
/
003.20201217标准术语维护脚本
/
cdss-core_init.sql

cdss-core_init.sql 47 KB
History Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378 
  1. use `sys-user`;
    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 : 50731
    9. 

  9.  Source Host           : 192.168.2.236:3306
    10. 

  10.  Source Schema         : sys-user
    11. 

  11. 

  12.  Target Server Type    : MySQL
    13. 

  13.  Target Server Version : 50731
    14. 

  14.  File Encoding         : 65001
    15. 

  15. 

  16.  Date: 17/12/2020 11:52:26
    17. 

  17. */
    18. 

  18. 

  19. SET NAMES utf8mb4;
    20. 

  20. SET FOREIGN_KEY_CHECKS = 0;
    21. 

  21. 

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

  23. -- Table structure for sys_menu
    24. 

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

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

  26. CREATE TABLE `sys_menu`  (
    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.   `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '菜单名称',
    34. 

  34.   `parent_id` bigint(20) NOT NULL DEFAULT -1 COMMENT '-1：表示顶级,其他值表示上级菜单的id',
    35. 

  35.   `code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '编码，与前端对应',
    36. 

  36.   `order_no` int(11) NOT NULL DEFAULT 0 COMMENT '排序，从小到大',
    37. 

  37.   `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '备注',
    38. 

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

  39. ) ENGINE = InnoDB AUTO_INCREMENT = 90 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '系统菜单' ROW_FORMAT = Dynamic;
    40. 

  40. 

  41. -- ----------------------------
    42. 

  42. -- Records of sys_menu
    43. 

  43. -- ----------------------------
    44. 

  44. INSERT INTO `sys_menu` VALUES (1, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '控制台', -1, 'YH-KZT', 1, '用户-控制台');
    45. 

  45. INSERT INTO `sys_menu` VALUES (2, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '更多服务', -1, 'YH-GDFW', 2, '用户-更多服务');
    46. 

  46. INSERT INTO `sys_menu` VALUES (3, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '机构中心', -1, 'YH-JGZX', 3, '用户-机构中心');
    47. 

  47. INSERT INTO `sys_menu` VALUES (4, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '账号信息', 3, 'YH-JGZX-ZHXX', 1, '用户-机构中心-账号信息');
    48. 

  48. INSERT INTO `sys_menu` VALUES (5, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '已开通产品', 3, 'YH-JGZX-YKTCP', 2, '用户-机构中心-已开通产品');
    49. 

  49. INSERT INTO `sys_menu` VALUES (6, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '安全设置', 3, 'YH-JGZX-AQSZ', 5, '用户-机构中心-安全设置');
    50. 

  50. INSERT INTO `sys_menu` VALUES (9, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '管理服务端', 3, 'YH-JGZX-GLFFD', 3, '用户-机构中心-管理服务端');
    51. 

  51. INSERT INTO `sys_menu` VALUES (10, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '客户中心', -1, 'LT-KHZX', 2, '朗通-客户中心');
    52. 

  52. INSERT INTO `sys_menu` VALUES (11, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '机构信息', 10, 'LT-KHZX-JGXX', 2, '朗通-客户中心-机构信息');
    53. 

  53. INSERT INTO `sys_menu` VALUES (12, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '控制台', -1, 'LT-KZT', 1, '朗通-控制台');
    54. 

  54. INSERT INTO `sys_menu` VALUES (14, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '已生成令牌', 3, 'YH-JGZX-YSCLP', 4, '用户-机构中心-已生成令牌');
    55. 

  55. INSERT INTO `sys_menu` VALUES (15, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '注册用户', 10, 'LT-KHZX-ZCYH', 1, '朗通-客户中心-注册用户');
    56. 

  56. INSERT INTO `sys_menu` VALUES (16, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '审核超管信息', 10, 'LT-KHZX-CGXX', 3, '朗通-客户中心-超管信息');
    57. 

  57. INSERT INTO `sys_menu` VALUES (17, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '订单系统', -1, 'LT-DDXT', 3, '朗通-订单系统');
    58. 

  58. INSERT INTO `sys_menu` VALUES (18, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '产品申请列表', 17, 'LT-DDXT-CPXSQLB', 1, '朗通-订单系统-产品申请列表');
    59. 

  59. INSERT INTO `sys_menu` VALUES (19, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '产品线管理', -1, 'LT-CPXGL', 4, '朗通-产品线管理');
    60. 

  60. INSERT INTO `sys_menu` VALUES (20, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '个人中心', -1, 'LT-GRZX', 99, '朗通-个人中心');
    61. 

  61. INSERT INTO `sys_menu` VALUES (21, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '已认证超管信息', 10, 'LT-YRZCGXX', 0, '朗通-客户中心-已认证超管信息');
    62. 

  62. INSERT INTO `sys_menu` VALUES (22, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '产品续费列表', 17, 'LT-CPXFLB', 2, '朗通-订单系统-产品续费列表');
    63. 

  63. INSERT INTO `sys_menu` VALUES (23, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 'ICSS数据维护', -1, 'LT-YXSJWH', 5, '朗通-ICSS数据维护');
    64. 

  64. INSERT INTO `sys_menu` VALUES (24, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '标签组维护', 23, 'LT-YXSJWH-BQZWH', 10, '朗通-ICSS数据维护-标签组维护');
    65. 

  65. INSERT INTO `sys_menu` VALUES (25, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '独立类型标签维护', 23, 'LT-YXSJWH-DLLXBQWH', 20, '朗通-ICSS数据维护-独立类型标签维护');
    66. 

  66. INSERT INTO `sys_menu` VALUES (27, 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '别名维护', 23, 'LT-YXSJWH-BMWH', 25, '朗通-ICSS数据维护-别名维护');
    67. 

  67. INSERT INTO `sys_menu` VALUES (28, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '模版维护', 23, 'LT-YXSJWH-MBWH', 30, '朗通-ICSS数据维护-模版维护');
    68. 

  68. INSERT INTO `sys_menu` VALUES (30, 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 'icss科室维护', 23, 'LT-YXSJWH-KSWH', 40, '朗通-ICSS数据维护-icss科室维护');
    69. 

  69. INSERT INTO `sys_menu` VALUES (31, 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '常见选项维护', 23, 'LT-YXSJWH-CJXXWH', 45, '朗通-ICSS数据维护-常见选项维护');
    70. 

  70. INSERT INTO `sys_menu` VALUES (33, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '免责声明维护', 38, 'LT-YXSJKWH-MZSMWH', 90, '朗通-医学术语库维护-免责声明维护');
    71. 

  71. INSERT INTO `sys_menu` VALUES (34, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '版本信息维护', 60, 'LT-GBBXXWH-BBXXWH', 60, '朗通-各版本信息维护-版本信息维护');
    72. 

  72. INSERT INTO `sys_menu` VALUES (35, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '查体模板维护', 23, 'LT-YXSJWH-CTMBWH', 40, '朗通-ICSS数据维护-查体模板维护');
    73. 

  73. INSERT INTO `sys_menu` VALUES (37, 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '提示信息维护', 23, 'LT-YXSJWH-TSXXWH', 50, '朗通-ICSS数据维护-提示信息维护');
    74. 

  74. INSERT INTO `sys_menu` VALUES (38, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '医学术语库维护', -1, 'LT-YXSYKWH', 6, '朗通-医学术语库维护');
    75. 

  75. INSERT INTO `sys_menu` VALUES (39, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '医学术语命名维护', 38, 'LT-YXSYKWH-YXSYMMWH', 10, '朗通-医学术语库维护-医学术语命名维护');
    76. 

  76. INSERT INTO `sys_menu` VALUES (40, 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '术语医学属性维护', 38, 'LT-YXSYKWH-SYYXSXWH', 2, '朗通-医学术语库维护-术语医学属性维护');
    77. 

  77. INSERT INTO `sys_menu` VALUES (41, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '医学术语关系维护', 38, 'LT-YXSYKWH-YXSYGXWH', 20, '朗通-医学术语库维护-医学术语关系维护');
    78. 

  78. INSERT INTO `sys_menu` VALUES (42, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '医学术语静态知识维护', 38, 'LT-YXSYKWH-YXSYJTZSWH', 50, '朗通-医学术语库维护-医学术语静态知识维护');
    79. 

  79. INSERT INTO `sys_menu` VALUES (43, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '化验大小项与公表项对应维护', 38, 'LT-YXSJWH-HYDXXYGBXDY', 85, '朗通-医学术语库维护-化验大小项与公表项对应维护');
    80. 

  80. INSERT INTO `sys_menu` VALUES (44, 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '慢病管理与评估维护', 23, 'LT-YXSJWH-MBGLYPG', 75, '朗通-ICSS数据维护-慢病管理与评估维护');
    81. 

  81. INSERT INTO `sys_menu` VALUES (45, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '慢病指标值关联维护', 38, 'LT-YXSYKWH-MBZBZGLWH', 70, '朗通-医学术语库维护-慢病指标值关联维护');
    82. 

  82. INSERT INTO `sys_menu` VALUES (48, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '量表结构维护', 38, 'LT-YXSYKWH-LBJGWH', 60, '朗通-医学术语库维护-量表结构维护');
    83. 

  83. INSERT INTO `sys_menu` VALUES (49, 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '医学术语类型维护', 38, 'LT-YXSYKWH-YXSYLXWH', 5, '朗通-医学术语库维护-医学术语类型维护');
    84. 

  84. INSERT INTO `sys_menu` VALUES (50, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '化验子项维护', 38, 'LT-YXSYKWH-HYZXWH', 80, '朗通-医学术语库维护-化验子项维护');
    85. 

  85. INSERT INTO `sys_menu` VALUES (51, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '医学术语关联维护', 38, 'LT-YXSYKWH-YXSYGLWH', 30, '朗通-医学术语库维护-医学术语关联维护');
    86. 

  86. INSERT INTO `sys_menu` VALUES (52, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '分诊人体图数据维护', 38, 'LT-YXSYKWH-YXSYDCGLWH', 40, '朗通-医学术语库维护-医学术语多层关联维护');
    87. 

  87. INSERT INTO `sys_menu` VALUES (53, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '预问诊数据维护', -1, 'LT-YWZSJWH', 8, '朗通-预问诊数据维护');
    88. 

  88. INSERT INTO `sys_menu` VALUES (54, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '独立填写单维护', 53, 'LT-YWZSJWH-DLTXDWH', 1, '朗通-预问诊数据维护-独立填写单维护');
    89. 

  89. INSERT INTO `sys_menu` VALUES (55, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '组合填写单维护', 53, 'LT-YWZSJWH-ZHTXDWH', 2, '朗通-预问诊数据维护-组合填写单维护');
    90. 

  90. INSERT INTO `sys_menu` VALUES (56, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '模版维护', 53, 'LT-YWZSJWH-MBWH', 3, '朗通-预问诊数据维护-模版维护');
    91. 

  91. INSERT INTO `sys_menu` VALUES (57, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '诊断依据维护', -1, 'LT-ZDYJWH', 10, '朗通-诊断依据维护');
    92. 

  92. INSERT INTO `sys_menu` VALUES (58, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '诊断依据数据维护', 57, 'LT-ZDYJWH-ZDYJSJWH', 10, '朗通-诊断依据维护-诊断依据数据维护');
    93. 

  93. INSERT INTO `sys_menu` VALUES (59, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '问题词数据维护', 57, 'LT-ZDYJWH-WTCSJWH', 20, '朗通-诊断依据维护-问题词数据维护');
    94. 

  94. INSERT INTO `sys_menu` VALUES (60, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '各版本信息维护', -1, 'LT-GBBXXWH', 11, '朗通-各版本信息维护');
    95. 

  95. INSERT INTO `sys_menu` VALUES (61, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '数据统计', -1, 'LT-SJTJ', 12, '朗通-数据统计');
    96. 

  96. INSERT INTO `sys_menu` VALUES (62, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '医学数据统计', 61, 'LT-SJTJ-YXSJTJ', 1, '朗通-数据统计-医学数据统计');
    97. 

  97. INSERT INTO `sys_menu` VALUES (63, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '辅检子项维护', 38, 'LT-YXSYKWH-FJZXWH', 86, '朗通-医学术语库维护-辅检子项维护');
    98. 

  98. INSERT INTO `sys_menu` VALUES (64, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '辅检层级关联维护', 38, 'LT-YXSYKWH-FJCJGLWH', 87, '朗通-医学术语库维护-辅检层级关联维护');
    99. 

  99. INSERT INTO `sys_menu` VALUES (65, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '安全管理', -1, 'LT-AQGL', 13, '朗通-安全管理');
    100. 

  100. INSERT INTO `sys_menu` VALUES (66, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 'license维护', 65, 'LT-AQGL-LICENSEWH', 1, '朗通-安全管理-license维护');
    101. 

  101. INSERT INTO `sys_menu` VALUES (67, 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '病历管理', -1, 'LT-BLGL', 14, '朗通-病历管理');
    102. 

  102. INSERT INTO `sys_menu` VALUES (68, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '规则维护', 38, 'LT-YXSYKWH-GZWH', 91, '朗通-医学术语库维护-规则维护');
    103. 

  103. INSERT INTO `sys_menu` VALUES (69, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '规则应用维护', 38, 'LT-YXSYKWH-GZYYWH', 92, '朗通-医学术语库维护-规则应用维护');
    104. 

  104. INSERT INTO `sys_menu` VALUES (70, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '病例入录', -1, 'LT-BLZK-BLRl', 15, '朗通-病例入录');
    105. 

  105. INSERT INTO `sys_menu` VALUES (71, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '质控条目', 72, 'LT-ZKYMSJWH-ZKTM', 1, '朗通-质控页面数据维护-质控条目');
    106. 

  106. INSERT INTO `sys_menu` VALUES (72, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '质控页面数据维护', -1, 'LT-ZKYMSJWH', 17, '朗通-质控页面数据维护');
    107. 

  107. INSERT INTO `sys_menu` VALUES (73, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '字段映射维护', 72, 'LT-ZKYMSJWH-ZDYSWH', 5, '朗通-质控页面数据维护-字段映射维护');
    108. 

  108. INSERT INTO `sys_menu` VALUES (74, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '组合字段维护', 72, 'LT-ZKYMSJWH-ZHDYWH', 10, '朗通-质控页面数据维护-组合字段维护');
    109. 

  109. INSERT INTO `sys_menu` VALUES (75, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '模板维护', 72, 'LT-ZKYMSJWH-MBWH', 15, '朗通-质控页面数据维护-模板维护');
    110. 

  110. INSERT INTO `sys_menu` VALUES (76, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '质控类型维护', 72, 'LT-ZKYMSJWH-ZKLXWH', 20, '朗通-质控页面数据维护-质控类型维护');
    111. 

  111. INSERT INTO `sys_menu` VALUES (77, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '条目关联质控类型', 72, 'LT-ZKYMSJWH-TMGLZKLX', 25, '朗通-质控页面数据维护-条目关联质控类型');
    112. 

  112. INSERT INTO `sys_menu` VALUES (78, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '标准病历', 72, 'LT-ZKYMSJWH-BZBL', 50, '朗通-质控页面数据维护-标准病历');
    113. 

  113. INSERT INTO `sys_menu` VALUES (79, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '自动化测试统计', 72, 'LT-ZKYMSJWH-ZDHCSTJ', 55, '朗通-质控页面数据维护-自动化测试统计');
    114. 

  114. INSERT INTO `sys_menu` VALUES (80, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '任务列表', 72, 'LT-ZKYMSJWH-RWLB', 56, '朗通-质控页面数据维护-任务列表');
    115. 

  115. INSERT INTO `sys_menu` VALUES (81, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 'CDSS数据维护', -1, 'LT-CDSSSJWH', 100, '朗通-CDSS数据维护');
    116. 

  116. INSERT INTO `sys_menu` VALUES (82, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '静态术语知识维护', 81, 'LT-CDSSSJWH-JTSYZSWH', 10, '朗通-CDSS数据维护-静态术语知识维护');
    117. 

  117. INSERT INTO `sys_menu` VALUES (83, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '医学术语关联维护', 81, 'LT-CDSSSJWH-YXSYGLWH', 20, '朗通-CDSS数据维护-医学术语关联维护');
    118. 

  118. INSERT INTO `sys_menu` VALUES (84, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '医院管理', 81, 'LT-CDSSSJWH-YYGL', 30, '朗通-CDSS数据维护-医院管理');
    119. 

  119. INSERT INTO `sys_menu` VALUES (85, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '医院用户管理', 81, 'LT-CDSSSJWH-YYYHGL', 40, '朗通-CDSS数据维护-医院用户管理');
    120. 

  120. INSERT INTO `sys_menu` VALUES (86, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '电子病历方案配置', 81, 'LT-CDSSSJWH-DZBLFAPZ', 50, '朗通-CDSS数据维护-电子病历方案配置');
    121. 

  121. INSERT INTO `sys_menu` VALUES (87, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '版本维护', 81, 'LT-CDSSSJWH-BBWH', 60, '朗通-CDSS数据维护-版本维护');
    122. 

  122. INSERT INTO `sys_menu` VALUES (88, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '免责声明维护', 81, 'LT-CDSSSJWH-MZSMWH', 70, '朗通-CDSS数据维护-免责声明维护');
    123. 

  123. INSERT INTO `sys_menu` VALUES (89, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '知识图谱标准术语维护', 81, 'LT-CDSSSJWH-ZSTPBZSYWH', 0, '朗通-CDSS数据维护-知识图谱标准术语维护');
    124. 

  124. 

  125. SET FOREIGN_KEY_CHECKS = 1;
    126. 

  126. 

  127. /*
    128. 

  128.  Navicat Premium Data Transfer
    129. 

  129. 

  130.  Source Server         : 192.168.2.236
    131. 

  131.  Source Server Type    : MySQL
    132. 

  132.  Source Server Version : 50731
    133. 

  133.  Source Host           : 192.168.2.236:3306
    134. 

  134.  Source Schema         : sys-user
    135. 

  135. 

  136.  Target Server Type    : MySQL
    137. 

  137.  Target Server Version : 50731
    138. 

  138.  File Encoding         : 65001
    139. 

  139. 

  140.  Date: 17/12/2020 11:52:38
    141. 

  141. */
    142. 

  142. 

  143. SET NAMES utf8mb4;
    144. 

  144. SET FOREIGN_KEY_CHECKS = 0;
    145. 

  145. 

  146. -- ----------------------------
    147. 

  147. -- Table structure for sys_role_menu
    148. 

  148. -- ----------------------------
    149. 

  149. DROP TABLE IF EXISTS `sys_role_menu`;
    150. 

  150. CREATE TABLE `sys_role_menu`  (
    151. 

  151.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    152. 

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

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

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

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

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

  157.   `role_id` bigint(20) NOT NULL DEFAULT 0 COMMENT '角色id',
    158. 

  158.   `menu_id` bigint(20) NOT NULL DEFAULT 0 COMMENT '菜单id',
    159. 

  159.   `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
    160. 

  160.   PRIMARY KEY (`id`) USING BTREE
    161. 

  161. ) ENGINE = InnoDB AUTO_INCREMENT = 98 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色和菜单的映射表' ROW_FORMAT = Dynamic;
    162. 

  162. 

  163. -- ----------------------------
    164. 

  164. -- Records of sys_role_menu
    165. 

  165. -- ----------------------------
    166. 

  166. INSERT INTO `sys_role_menu` VALUES (1, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 1, 1, '用户-控制台');
    167. 

  167. INSERT INTO `sys_role_menu` VALUES (2, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 1, 2, '用户-更多服务');
    168. 

  168. INSERT INTO `sys_role_menu` VALUES (3, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 1, 3, '用户-机构中心');
    169. 

  169. INSERT INTO `sys_role_menu` VALUES (4, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 1, 4, '用户-机构中心-账号信息');
    170. 

  170. INSERT INTO `sys_role_menu` VALUES (5, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 1, 5, '用户-机构中心-已开通产品');
    171. 

  171. INSERT INTO `sys_role_menu` VALUES (6, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 1, 6, '用户-机构中心-安全设置');
    172. 

  172. INSERT INTO `sys_role_menu` VALUES (7, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 1, 9, '用户-机构中心-管理服务端');
    173. 

  173. INSERT INTO `sys_role_menu` VALUES (8, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 1, 14, '用户-机构中心-已生成令牌');
    174. 

  174. INSERT INTO `sys_role_menu` VALUES (9, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 2, 10, '朗通-客户中心');
    175. 

  175. INSERT INTO `sys_role_menu` VALUES (10, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 2, 11, '朗通-客户中心-机构信息');
    176. 

  176. INSERT INTO `sys_role_menu` VALUES (11, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 2, 12, '朗通-控制台');
    177. 

  177. INSERT INTO `sys_role_menu` VALUES (12, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 2, 15, '朗通-客户中心-注册用户');
    178. 

  178. INSERT INTO `sys_role_menu` VALUES (13, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 2, 16, '朗通-客户中心-审核超管信息');
    179. 

  179. INSERT INTO `sys_role_menu` VALUES (14, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 2, 17, '朗通-订单系统');
    180. 

  180. INSERT INTO `sys_role_menu` VALUES (15, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 2, 18, '朗通-订单系统-产品线申请列表');
    181. 

  181. INSERT INTO `sys_role_menu` VALUES (16, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 2, 19, '朗通-产品线管理');
    182. 

  182. INSERT INTO `sys_role_menu` VALUES (17, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 2, 20, '朗通-个人中心');
    183. 

  183. INSERT INTO `sys_role_menu` VALUES (21, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 2, 21, '朗通-客户中心-已认证超管信息');
    184. 

  184. INSERT INTO `sys_role_menu` VALUES (22, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 2, 22, '朗通-订单系统-产品续费列表');
    185. 

  185. INSERT INTO `sys_role_menu` VALUES (23, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 3, 23, '朗通-ICSS数据维护');
    186. 

  186. INSERT INTO `sys_role_menu` VALUES (24, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 3, 24, '朗通-ICSS数据维护-标签组维护');
    187. 

  187. INSERT INTO `sys_role_menu` VALUES (25, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 3, 25, '朗通-ICSS数据维护-独立类型标签维护');
    188. 

  188. INSERT INTO `sys_role_menu` VALUES (27, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 3, 27, '朗通-ICSS数据维护-别名维护');
    189. 

  189. INSERT INTO `sys_role_menu` VALUES (28, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 3, 28, '朗通-ICSS数据维护-模版维护');
    190. 

  190. INSERT INTO `sys_role_menu` VALUES (29, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 3, 29, '朗通-ICSS数据维护-查体模版维护');
    191. 

  191. INSERT INTO `sys_role_menu` VALUES (30, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 3, 30, '朗通-ICSS数据维护-icss科室维护');
    192. 

  192. INSERT INTO `sys_role_menu` VALUES (31, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 3, 31, '朗通-ICSS数据维护-常见选项维护');
    193. 

  193. INSERT INTO `sys_role_menu` VALUES (32, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 3, 32, '朗通-ICSS数据维护-提示信息维护');
    194. 

  194. INSERT INTO `sys_role_menu` VALUES (33, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 3, 33, '朗通-ICSS数据维护-免责声明维护');
    195. 

  195. INSERT INTO `sys_role_menu` VALUES (34, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 7, 34, '朗通-各版本信息维护-版本信息维护');
    196. 

  196. INSERT INTO `sys_role_menu` VALUES (35, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 3, 35, '朗通-ICSS数据维护-查体模板维护');
    197. 

  197. INSERT INTO `sys_role_menu` VALUES (38, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 4, 38, '朗通-医学术语库维护');
    198. 

  198. INSERT INTO `sys_role_menu` VALUES (39, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 4, 39, '朗通-医学术语库维护-医学术语命名维护');
    199. 

  199. INSERT INTO `sys_role_menu` VALUES (40, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 4, 40, '朗通-医学术语库维护-术语医学属性维护');
    200. 

  200. INSERT INTO `sys_role_menu` VALUES (41, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 4, 41, '朗通-医学术语库维护-医学术语关系维护');
    201. 

  201. INSERT INTO `sys_role_menu` VALUES (42, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 4, 42, '朗通-医学术语库维护-医学术语静态知识维护');
    202. 

  202. INSERT INTO `sys_role_menu` VALUES (43, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 4, 43, '朗通-医学术语库维护-化验大小项与公表项对应维护');
    203. 

  203. INSERT INTO `sys_role_menu` VALUES (45, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 4, 44, '朗通-ICSS数据维护-慢病管理与评估维护');
    204. 

  204. INSERT INTO `sys_role_menu` VALUES (46, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 4, 45, '朗通-ICSS数据维护-慢病指标值关联维护');
    205. 

  205. INSERT INTO `sys_role_menu` VALUES (49, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 3, 48, '朗通-医学术语库维护-量表结构维护');
    206. 

  206. INSERT INTO `sys_role_menu` VALUES (50, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 4, 49, '朗通-医学术语库维护-医学术语类型维护');
    207. 

  207. INSERT INTO `sys_role_menu` VALUES (51, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 4, 51, '朗通-医学术语库维护-医学术语关联维护');
    208. 

  208. INSERT INTO `sys_role_menu` VALUES (52, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 4, 52, '朗通-医学术语库维护-医学术语多层关联维护');
    209. 

  209. INSERT INTO `sys_role_menu` VALUES (53, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 4, 50, '朗通-医学术语库维护-化验子项维护');
    210. 

  210. INSERT INTO `sys_role_menu` VALUES (54, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 5, 53, '朗通-预问诊数据维护');
    211. 

  211. INSERT INTO `sys_role_menu` VALUES (55, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 5, 54, '朗通-预问诊数据维护-独立填写单维护');
    212. 

  212. INSERT INTO `sys_role_menu` VALUES (56, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 5, 55, '朗通-预问诊数据维护-组合填写单维护');
    213. 

  213. INSERT INTO `sys_role_menu` VALUES (57, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 5, 56, '朗通-预问诊数据维护-模版维护');
    214. 

  214. INSERT INTO `sys_role_menu` VALUES (58, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 6, 57, '朗通-诊断依据维护');
    215. 

  215. INSERT INTO `sys_role_menu` VALUES (59, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 6, 58, '朗通-诊断依据维护-诊断依据数据维护');
    216. 

  216. INSERT INTO `sys_role_menu` VALUES (60, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 6, 59, '朗通-诊断依据维护-问题词数据维护');
    217. 

  217. INSERT INTO `sys_role_menu` VALUES (61, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 7, 60, '朗通-各版本信息维护-版本信息维护');
    218. 

  218. INSERT INTO `sys_role_menu` VALUES (62, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 8, 10, '朗通-客户中心');
    219. 

  219. INSERT INTO `sys_role_menu` VALUES (63, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 8, 15, '朗通-客户中心-注册用户');
    220. 

  220. INSERT INTO `sys_role_menu` VALUES (64, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 9, 61, '朗通-数据统计');
    221. 

  221. INSERT INTO `sys_role_menu` VALUES (65, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 9, 62, '朗通-数据统计-医学数据统计');
    222. 

  222. INSERT INTO `sys_role_menu` VALUES (66, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 4, 63, '朗通-医学术语库维护-辅检子项维护');
    223. 

  223. INSERT INTO `sys_role_menu` VALUES (67, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 4, 64, '朗通-医学术语库维护-辅检层级关联维护');
    224. 

  224. INSERT INTO `sys_role_menu` VALUES (68, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 10, 65, '朗通-安全管理');
    225. 

  225. INSERT INTO `sys_role_menu` VALUES (69, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 10, 66, '朗通-安全管理-license维护');
    226. 

  226. INSERT INTO `sys_role_menu` VALUES (70, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 11, 67, '朗通-病历管理');
    227. 

  227. INSERT INTO `sys_role_menu` VALUES (71, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 12, 42, '朗通-医学术语库维护-医学术语静态知识维护');
    228. 

  228. INSERT INTO `sys_role_menu` VALUES (72, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 12, 68, '朗通-医学术语库维护-规则维护');
    229. 

  229. INSERT INTO `sys_role_menu` VALUES (73, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 12, 69, '朗通-医学术语库维护-规则应用维护');
    230. 

  230. INSERT INTO `sys_role_menu` VALUES (74, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 12, 38, '朗通-医学术语库维护');
    231. 

  231. INSERT INTO `sys_role_menu` VALUES (77, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 13, 70, '朗通-病历入录');
    232. 

  232. INSERT INTO `sys_role_menu` VALUES (79, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 15, 71, '朗通-质控页面数据维护-质控条目');
    233. 

  233. INSERT INTO `sys_role_menu` VALUES (80, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 15, 72, '朗通-质控页面数据维护');
    234. 

  234. INSERT INTO `sys_role_menu` VALUES (81, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 15, 73, '朗通-质控页面数据维护-字段映射维护');
    235. 

  235. INSERT INTO `sys_role_menu` VALUES (82, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 15, 74, '朗通-质控页面数据维护-组合字段维护');
    236. 

  236. INSERT INTO `sys_role_menu` VALUES (83, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 15, 75, '朗通-质控页面数据维护-模板维护');
    237. 

  237. INSERT INTO `sys_role_menu` VALUES (84, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 15, 76, '朗通-质控页面数据维护-质控类型维护');
    238. 

  238. INSERT INTO `sys_role_menu` VALUES (85, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 15, 77, '朗通-质控页面数据维护-条目关联质控类型');
    239. 

  239. INSERT INTO `sys_role_menu` VALUES (86, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 15, 78, '朗通-质控页面数据维护-标准病历');
    240. 

  240. INSERT INTO `sys_role_menu` VALUES (87, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 15, 79, '朗通-质控页面数据维护-自动化测试统计');
    241. 

  241. INSERT INTO `sys_role_menu` VALUES (88, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 15, 80, '朗通-质控页面数据维护-任务列表');
    242. 

  242. INSERT INTO `sys_role_menu` VALUES (89, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 16, 81, '朗通-CDSS数据维护');
    243. 

  243. INSERT INTO `sys_role_menu` VALUES (90, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 16, 82, '朗通-CDSS数据维护-静态术语知识维护');
    244. 

  244. INSERT INTO `sys_role_menu` VALUES (91, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 16, 83, '朗通-CDSS数据维护-医学术语关联维护');
    245. 

  245. INSERT INTO `sys_role_menu` VALUES (92, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 16, 84, '朗通-CDSS数据维护-医院管理');
    246. 

  246. INSERT INTO `sys_role_menu` VALUES (93, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 16, 85, '朗通-CDSS数据维护-医院用户管理');
    247. 

  247. INSERT INTO `sys_role_menu` VALUES (94, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 16, 86, '朗通-CDSS数据维护-电子病历方案配置');
    248. 

  248. INSERT INTO `sys_role_menu` VALUES (95, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 16, 87, '朗通-CDSS数据维护-版本维护');
    249. 

  249. INSERT INTO `sys_role_menu` VALUES (96, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 16, 88, '朗通-CDSS数据维护-免责声明维护');
    250. 

  250. INSERT INTO `sys_role_menu` VALUES (97, 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 16, 89, '朗通-CDSS数据维护-知识图谱标准术语维护');
    251. 

  251. 

  252. SET FOREIGN_KEY_CHECKS = 1;
    253. 

  253. 

  254. 

  255. use `cdss`;
    256. 

  256. 

  257. /*
    258. 

  258.  Navicat Premium Data Transfer
    259. 

  259. 

  260.  Source Server         : 192.168.2.236
    261. 

  261.  Source Server Type    : MySQL
    262. 

  262.  Source Server Version : 50731
    263. 

  263.  Source Host           : 192.168.2.236:3306
    264. 

  264.  Source Schema         : cdss
    265. 

  265. 

  266.  Target Server Type    : MySQL
    267. 

  267.  Target Server Version : 50731
    268. 

  268.  File Encoding         : 65001
    269. 

  269. 

  270.  Date: 17/12/2020 15:47:27
    271. 

  271. */
    272. 

  272. 

  273. SET NAMES utf8mb4;
    274. 

  274. SET FOREIGN_KEY_CHECKS = 0;
    275. 

  275. 

  276. -- ----------------------------
    277. 

  277. -- Table structure for sys_dictionary_info
    278. 

  278. -- ----------------------------
    279. 

  279. DROP TABLE IF EXISTS `sys_dictionary_info`;
    280. 

  280. CREATE TABLE `sys_dictionary_info`  (
    281. 

  281.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    282. 

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

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

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

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

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

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

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

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

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

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

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

  293.   PRIMARY KEY (`id`) USING BTREE
    294. 

  294. ) ENGINE = InnoDB AUTO_INCREMENT = 80 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'CDSS字典表' ROW_FORMAT = Dynamic;
    295. 

  295. 

  296. -- ----------------------------
    297. 

  297. -- Records of sys_dictionary_info
    298. 

  298. -- ----------------------------
    299. 

  299. 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, '静态知识检索类型');
    300. 

  300. 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, '静态知识检索类型');
    301. 

  301. 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, '静态知识检索类型');
    302. 

  302. 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, '静态知识检索类型');
    303. 

  303. 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, '静态知识检索类型');
    304. 

  304. 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, '静态知识检索类型');
    305. 

  305. 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, '图谱标签与页面显示类型对应关系');
    306. 

  306. 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, '图谱标签与页面显示类型对应关系');
    307. 

  307. 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, '图谱标签与页面显示类型对应关系');
    308. 

  308. 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, '图谱标签与页面显示类型对应关系');
    309. 

  309. 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, '图谱标签与页面显示类型对应关系');
    310. 

  310. 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, '图谱标签与页面显示类型对应关系');
    311. 

  311. 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, '药品剂型');
    312. 

  312. 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, '药品剂型');
    313. 

  313. 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, '药品剂型');
    314. 

  314. 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, '药品剂型');
    315. 

  315. 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, '药品剂型');
    316. 

  316. 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, '药品剂型');
    317. 

  317. 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, '图谱标签与页面显示类型对应关系');
    318. 

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

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

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

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

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

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

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

  325. 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, '图谱标签与页面显示类型对应关系');
    326. 

  326. 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, '开单合理项检索类型');
    327. 

  327. 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, '开单合理项检索类型');
    328. 

  328. 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, '开单合理项检索类型');
    329. 

  329. 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, '开单合理项检索类型');
    330. 

  330. 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, '开单合理项检索类型');
    331. 

  331. 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, '开单禁忌条件类型');
    332. 

  332. 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, '开单禁忌条件类型');
    333. 

  333. 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, '开单禁忌条件类型');
    334. 

  334. 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, '开单禁忌条件类型');
    335. 

  335. 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, '开单禁忌条件类型');
    336. 

  336. 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, '开单禁忌条件类型');
    337. 

  337. 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, '开单禁忌条件类型');
    338. 

  338. 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, '开单禁忌条件类型');
    339. 

  339. 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, '开单禁忌条件类型');
    340. 

  340. 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, '开单禁忌条件类型');
    341. 

  341. 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, '开单禁忌条件类型');
    342. 

  342. 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, '开单禁忌条件类型');
    343. 

  343. 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, '开单禁忌条件类型');
    344. 

  344. 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, '开单禁忌条件类型');
    345. 

  345. 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, '开单禁忌条件类型');
    346. 

  346. 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, '开单禁忌条件类型');
    347. 

  347. 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, '图谱标签与页面显示类型对应关系');
    348. 

  348. 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, '图谱标签与页面显示类型对应关系');
    349. 

  349. 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, '图谱标签与页面显示类型对应关系');
    350. 

  350. 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, '图谱标签与页面显示类型对应关系');
    351. 

  351. 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, '图谱标签与页面显示类型对应关系');
    352. 

  352. 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, '图谱标签与页面显示类型对应关系');
    353. 

  353. 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, '图谱标签与页面显示类型对应关系');
    354. 

  354. 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, '图谱标签与页面显示类型对应关系');
    355. 

  355. 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, '图谱标签与页面显示类型对应关系');
    356. 

  356. 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, '图谱标签与页面显示类型对应关系');
    357. 

  357. 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, '图谱标签与页面显示类型对应关系');
    358. 

  358. 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, '图谱标签与页面显示类型对应关系');
    359. 

  359. 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, '图谱标签与页面显示类型对应关系');
    360. 

  360. 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, '图谱标签与页面显示类型对应关系');
    361. 

  361. 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, '图谱标签与页面显示类型对应关系');
    362. 

  362. 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, '图谱标签与页面显示类型对应关系');
    363. 

  363. 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, '图谱标签与页面显示类型对应关系');
    364. 

  364. 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, '图谱标签与页面显示类型对应关系');
    365. 

  365. 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, '图谱标签与页面显示类型对应关系');
    366. 

  366. 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, '图谱标签与页面显示类型对应关系');
    367. 

  367. 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, '图谱标签与页面显示类型对应关系');
    368. 

  368. 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, '图谱标签与页面显示类型对应关系');
    369. 

  369. 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, '图谱标签与页面显示类型对应关系');
    370. 

  370. 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, '图谱标签与页面显示类型对应关系');
    371. 

  371. 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, '图谱标签与页面显示类型对应关系');
    372. 

  372. 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, '图谱标签与页面显示类型对应关系');
    373. 

  373. 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, '图谱标签与页面显示类型对应关系');
    374. 

  374. 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, '图谱标签与页面显示类型对应关系');
    375. 

  375. 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, '图谱标签与页面显示类型对应关系');
    376. 

  376. 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, '图谱标签与页面显示类型对应关系');
    377. 

  377. 

  378. SET FOREIGN_KEY_CHECKS = 1;
    379.