kl_push_set.sql 17 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129
  1. use `med`;
  2. /*
  3. Navicat MySQL Data Transfer
  4. Source Server : 192.168.2.236
  5. Source Server Version : 50725
  6. Source Host : 192.168.2.236:3306
  7. Source Database : med
  8. Target Server Type : MYSQL
  9. Target Server Version : 50725
  10. File Encoding : 65001
  11. Date: 2020-05-12 09:43:55
  12. */
  13. SET FOREIGN_KEY_CHECKS=0;
  14. -- ----------------------------
  15. -- Table structure for kl_push_set
  16. -- ----------------------------
  17. DROP TABLE IF EXISTS `kl_push_set`;
  18. CREATE TABLE `kl_push_set` (
  19. `id` bigint(20) NOT NULL AUTO_INCREMENT,
  20. `is_deleted` char(1) NOT NULL DEFAULT 'N' COMMENT '是否删除,N:未删除,Y:删除',
  21. `gmt_create` datetime NOT NULL DEFAULT '1970-01-01 12:00:00' COMMENT '记录创建时间',
  22. `gmt_modified` datetime NOT NULL DEFAULT '1970-01-01 12:00:00' COMMENT '记录修改时间,如果时间是1970年则表示纪录未修改',
  23. `creator` varchar(20) NOT NULL DEFAULT '0' COMMENT '创建人,0表示无创建人值',
  24. `modifier` varchar(20) NOT NULL DEFAULT '0' COMMENT '修改人,如果为0则表示纪录未修改',
  25. `mode` int(11) NOT NULL DEFAULT '0' COMMENT '推理模式',
  26. `name` varchar(100) DEFAULT NULL COMMENT '配置名称',
  27. `code` varchar(100) DEFAULT NULL COMMENT '配置编码',
  28. `value` varchar(255) DEFAULT NULL,
  29. `remark` varchar(128) DEFAULT NULL COMMENT '备注',
  30. PRIMARY KEY (`id`)
  31. ) ENGINE=InnoDB AUTO_INCREMENT=136 DEFAULT CHARSET=utf8 COMMENT='推理设置';
  32. -- ----------------------------
  33. -- Records of kl_push_set
  34. -- ----------------------------
  35. INSERT INTO `kl_push_set` VALUES ('1', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '病情提示', 'illness_show', '1', '是否显示(1是,0否)');
  36. INSERT INTO `kl_push_set` VALUES ('2', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '病情提示', 'illness_no', '1', '显示顺序');
  37. INSERT INTO `kl_push_set` VALUES ('3', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '常见症状', 'comsympto_show', '1', '是否显示(1是,0否)');
  38. INSERT INTO `kl_push_set` VALUES ('4', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '常见症状', 'comsympto_no', '2', '显示顺序');
  39. INSERT INTO `kl_push_set` VALUES ('7', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', '症状推送', 'symptoms_show', '1', '是否显示(1是,0否)');
  40. INSERT INTO `kl_push_set` VALUES ('8', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', '症状推送', 'symptoms_no', '2', '显示顺序');
  41. INSERT INTO `kl_push_set` VALUES ('11', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '3', '症状推送', 'symptoms_no', '2', '显示顺序');
  42. INSERT INTO `kl_push_set` VALUES ('12', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '3', '症状推送', 'symptoms_show', '1', '是否显示(1是,0否)');
  43. INSERT INTO `kl_push_set` VALUES ('27', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '4', '症状推送', 'symptoms_no', '2', '显示顺序');
  44. INSERT INTO `kl_push_set` VALUES ('28', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '4', '检验检查推送', 'Inspush_show', '1', '是否显示(1是,0否)');
  45. INSERT INTO `kl_push_set` VALUES ('29', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '4', '症状推送', 'symptoms_show', '1', '是否显示(1是,0否)');
  46. INSERT INTO `kl_push_set` VALUES ('30', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '4', '病情提示', 'illness_show', '1', '是否显示(1是,0否)');
  47. INSERT INTO `kl_push_set` VALUES ('31', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '5', '诊断推送', 'diapush_show', '1', '是否显示(1是,0否)');
  48. INSERT INTO `kl_push_set` VALUES ('32', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '4', '诊断推送', 'diapush_no', '3', '显示顺序');
  49. INSERT INTO `kl_push_set` VALUES ('33', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '4', '检验检查推送', 'Inspush_no', '4', '显示顺序');
  50. INSERT INTO `kl_push_set` VALUES ('34', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '4', '病情提示', 'illness_no', '1', '显示顺序');
  51. INSERT INTO `kl_push_set` VALUES ('35', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '4', '病历书写规范提示', 'specification_show', '1', '是否显示(1是,0否)');
  52. INSERT INTO `kl_push_set` VALUES ('36', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '4', '病历书写规范提示', 'specification_no', '5', '显示顺序');
  53. INSERT INTO `kl_push_set` VALUES ('37', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '5', '病情提示', 'illness_show', '1', '是否显示(1是,0否)');
  54. INSERT INTO `kl_push_set` VALUES ('38', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '5', '症状推送', 'symptoms_show', '1', '是否显示(1是,0否)');
  55. INSERT INTO `kl_push_set` VALUES ('39', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '5', '症状推送', 'symptoms_no', '2', '显示顺序');
  56. INSERT INTO `kl_push_set` VALUES ('40', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '5', '诊断推送', 'diapush_show', '1', '是否显示(1是,0否)');
  57. INSERT INTO `kl_push_set` VALUES ('41', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '5', '诊断推送', 'diapush_no', '3', '显示顺序');
  58. INSERT INTO `kl_push_set` VALUES ('42', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '5', '检验检查推送', 'Inspush_show', '1', '是否显示(1是,0否)');
  59. INSERT INTO `kl_push_set` VALUES ('43', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '5', '检验检查推送', 'Inspush_no', '4', '显示顺序');
  60. INSERT INTO `kl_push_set` VALUES ('44', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '5', '病情提示', 'illness_no', '1', '显示顺序');
  61. INSERT INTO `kl_push_set` VALUES ('45', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '5', '病历书写规范提示', 'specification_show', '1', '是否显示(1是,0否)');
  62. INSERT INTO `kl_push_set` VALUES ('46', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '5', '病历书写规范提示', 'specification_no', '5', '显示顺序');
  63. INSERT INTO `kl_push_set` VALUES ('47', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '6', '检验检查推送', 'Inspush_no', '4', '显示顺序');
  64. INSERT INTO `kl_push_set` VALUES ('48', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '6', '病历书写规范提示', 'specification_show', '1', '是否显示(1是,0否)');
  65. INSERT INTO `kl_push_set` VALUES ('49', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '6', '病历书写规范提示', 'specification_no', '5', '显示顺序');
  66. INSERT INTO `kl_push_set` VALUES ('50', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '6', '病情提示', 'illness_show', '1', '是否显示(1是,0否)');
  67. INSERT INTO `kl_push_set` VALUES ('51', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '6', '其他史推送', 'otherpush_show', '1', '是否显示(1是,0否)');
  68. INSERT INTO `kl_push_set` VALUES ('52', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '6', '其他史推送', 'otherpush_no', '2', '显示顺序');
  69. INSERT INTO `kl_push_set` VALUES ('53', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '6', '诊断推送', 'diapush_show', '1', '是否显示(1是,0否)');
  70. INSERT INTO `kl_push_set` VALUES ('54', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '6', '诊断推送', 'diapush_no', '3', '显示顺序');
  71. INSERT INTO `kl_push_set` VALUES ('55', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '6', '检验检查推送', 'Inspush_show', '1', '是否显示(1是,0否)');
  72. INSERT INTO `kl_push_set` VALUES ('56', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '6', '病情提示', 'illness_no', '1', '显示顺序');
  73. INSERT INTO `kl_push_set` VALUES ('57', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '7', '诊断推送', 'diapush_show', '1', '是否显示(1是,0否)');
  74. INSERT INTO `kl_push_set` VALUES ('58', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '7', '诊断推送', 'diapush_no', '4', '显示顺序');
  75. INSERT INTO `kl_push_set` VALUES ('59', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '7', '体格检查推送', 'physical_show', '1', '是否显示(1是,0否)');
  76. INSERT INTO `kl_push_set` VALUES ('60', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '7', '体格检查推送', 'physical_no', '2', '显示顺序');
  77. INSERT INTO `kl_push_set` VALUES ('61', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '7', '病情提示', 'illness_show', '1', '是否显示(1是,0否)');
  78. INSERT INTO `kl_push_set` VALUES ('62', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '7', '病情提示', 'illness_no', '1', '显示顺序');
  79. INSERT INTO `kl_push_set` VALUES ('63', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '7', '病历书写规范提示', 'specification_show', '1', '是否显示(1是,0否)');
  80. INSERT INTO `kl_push_set` VALUES ('64', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '7', '病历书写规范提示', 'specification_no', '6', '显示顺序');
  81. INSERT INTO `kl_push_set` VALUES ('65', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '7', '检验检查推送', 'Inspush_show', '1', '是否显示(1是,0否)');
  82. INSERT INTO `kl_push_set` VALUES ('66', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '7', '检验检查推送', 'Inspush_no', '5', '显示顺序');
  83. INSERT INTO `kl_push_set` VALUES ('67', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '7', '评估量表推送', 'evaluation_show', '1', '是否显示(1是,0否)');
  84. INSERT INTO `kl_push_set` VALUES ('68', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '7', '评估量表推送', 'evaluation_no', '3', '显示顺序');
  85. INSERT INTO `kl_push_set` VALUES ('69', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '8', '病情提示', 'illness_show', '1', '是否显示(1是,0否)');
  86. INSERT INTO `kl_push_set` VALUES ('70', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '8', '病情提示', 'illness_no', '1', '显示顺序');
  87. INSERT INTO `kl_push_set` VALUES ('71', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '8', '诊断推送', 'diapush_show', '1', '是否显示(1是,0否)');
  88. INSERT INTO `kl_push_set` VALUES ('72', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '8', '诊断推送', 'diapush_no', '2', '显示顺序');
  89. INSERT INTO `kl_push_set` VALUES ('73', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '8', '检验检查推送', 'Inspush_show', '1', '是否显示(1是,0否)');
  90. INSERT INTO `kl_push_set` VALUES ('74', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '8', '检验检查推送', 'Inspush_no', '3', '显示顺序');
  91. INSERT INTO `kl_push_set` VALUES ('75', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '8', '病历书写规范提示', 'specification_show', '1', '是否显示(1是,0否)');
  92. INSERT INTO `kl_push_set` VALUES ('76', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '8', '病历书写规范提示', 'specification_no', '4', '显示顺序');
  93. INSERT INTO `kl_push_set` VALUES ('77', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '8', '相似病例推送', 'similarcases_show', '1', '是否显示(1是,0否)');
  94. INSERT INTO `kl_push_set` VALUES ('78', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '8', '相似病例推送', 'similarcases_no', '5', '显示顺序');
  95. INSERT INTO `kl_push_set` VALUES ('79', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '10', '病情提示', 'illness_show', '1', '是否显示(1是,0否)');
  96. INSERT INTO `kl_push_set` VALUES ('80', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '10', '病情提示', 'illness_no', '1', '显示顺序');
  97. INSERT INTO `kl_push_set` VALUES ('81', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '10', '诊断推送', 'diapush_show', '1', '是否显示(1是,0否)');
  98. INSERT INTO `kl_push_set` VALUES ('82', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '10', '诊断推送', 'diapush_no', '2', '显示顺序');
  99. INSERT INTO `kl_push_set` VALUES ('83', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '10', '检验检查推送', 'Inspush_show', '1', '是否显示(1是,0否)');
  100. INSERT INTO `kl_push_set` VALUES ('84', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '10', '检验检查推送', 'Inspush_no', '3', '显示顺序');
  101. INSERT INTO `kl_push_set` VALUES ('85', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '10', '病历书写规范提示', 'specification_show', '1', '是否显示(1是,0否)');
  102. INSERT INTO `kl_push_set` VALUES ('86', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '10', '病历书写规范提示', 'specification_no', '4', '显示顺序');
  103. INSERT INTO `kl_push_set` VALUES ('87', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '10', '相似病例推送', 'similarcases_show', '1', '是否显示(1是,0否)');
  104. INSERT INTO `kl_push_set` VALUES ('88', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '10', '相似病例推送', 'similarcases_no', '5', '显示顺序');
  105. INSERT INTO `kl_push_set` VALUES ('89', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '11', '病情提示', 'illness_show', '1', '是否显示(1是,0否)');
  106. INSERT INTO `kl_push_set` VALUES ('90', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '11', '病情提示', 'illness_no', '1', '显示顺序');
  107. INSERT INTO `kl_push_set` VALUES ('91', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '11', '诊断推送', 'diapush_show', '1', '是否显示(1是,0否)');
  108. INSERT INTO `kl_push_set` VALUES ('92', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '11', '诊断推送', 'diapush_no', '2', '显示顺序');
  109. INSERT INTO `kl_push_set` VALUES ('93', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '11', '检验检查推送', 'Inspush_show', '1', '是否显示(1是,0否)');
  110. INSERT INTO `kl_push_set` VALUES ('94', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '11', '检验检查推送', 'Inspush_no', '3', '显示顺序');
  111. INSERT INTO `kl_push_set` VALUES ('95', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '11', '病历书写规范提示', 'specification_show', '1', '是否显示(1是,0否)');
  112. INSERT INTO `kl_push_set` VALUES ('96', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '11', '病历书写规范提示', 'specification_no', '4', '显示顺序');
  113. INSERT INTO `kl_push_set` VALUES ('97', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '11', '相似病例推送', 'similarcases_show', '1', '是否显示(1是,0否)');
  114. INSERT INTO `kl_push_set` VALUES ('98', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '11', '相似病例推送', 'similarcases_no', '5', '显示顺序');
  115. INSERT INTO `kl_push_set` VALUES ('126', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '9', '病情提示', 'illness_show', '1', '是否显示(1是,0否)');
  116. INSERT INTO `kl_push_set` VALUES ('127', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '9', '病情提示', 'illness_no', '1', '显示顺序');
  117. INSERT INTO `kl_push_set` VALUES ('129', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '9', '诊断推送', 'diapush_show', '1', '是否显示(1是,0否)');
  118. INSERT INTO `kl_push_set` VALUES ('130', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '9', '诊断推送', 'diapush_no', '2', '显示顺序');
  119. INSERT INTO `kl_push_set` VALUES ('131', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '9', '检验检查推送', 'Inspush_show', '1', '是否显示(1是,0否)');
  120. INSERT INTO `kl_push_set` VALUES ('132', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '9', '检验检查推送', 'Inspush_no', '3', '显示顺序');
  121. INSERT INTO `kl_push_set` VALUES ('133', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '9', '病历书写规范提示', 'specification_show', '1', '是否显示(1是,0否)');
  122. INSERT INTO `kl_push_set` VALUES ('134', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '9', '病历书写规范提示', 'specification_no', '4', '显示顺序');
  123. INSERT INTO `kl_push_set` VALUES ('135', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '9', '相似病例推送', 'similarcases_show', '1', '是否显示(1是,0否)');