123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129 |
- use `med`;
- /*
- Navicat MySQL Data Transfer
- Source Server : 192.168.2.236
- Source Server Version : 50725
- Source Host : 192.168.2.236:3306
- Source Database : med
- Target Server Type : MYSQL
- Target Server Version : 50725
- File Encoding : 65001
- Date: 2020-05-12 09:43:55
- */
- SET FOREIGN_KEY_CHECKS=0;
- -- ----------------------------
- -- Table structure for kl_push_set
- -- ----------------------------
- DROP TABLE IF EXISTS `kl_push_set`;
- CREATE TABLE `kl_push_set` (
- `id` bigint(20) NOT NULL AUTO_INCREMENT,
- `is_deleted` char(1) NOT NULL DEFAULT 'N' COMMENT '是否删除,N:未删除,Y:删除',
- `gmt_create` datetime NOT NULL DEFAULT '1970-01-01 12:00:00' COMMENT '记录创建时间',
- `gmt_modified` datetime NOT NULL DEFAULT '1970-01-01 12:00:00' COMMENT '记录修改时间,如果时间是1970年则表示纪录未修改',
- `creator` varchar(20) NOT NULL DEFAULT '0' COMMENT '创建人,0表示无创建人值',
- `modifier` varchar(20) NOT NULL DEFAULT '0' COMMENT '修改人,如果为0则表示纪录未修改',
- `mode` int(11) NOT NULL DEFAULT '0' COMMENT '推理模式',
- `name` varchar(100) DEFAULT NULL COMMENT '配置名称',
- `code` varchar(100) DEFAULT NULL COMMENT '配置编码',
- `value` varchar(255) DEFAULT NULL,
- `remark` varchar(128) DEFAULT NULL COMMENT '备注',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=136 DEFAULT CHARSET=utf8 COMMENT='推理设置';
- -- ----------------------------
- -- Records of kl_push_set
- -- ----------------------------
- 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否)');
- 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', '显示顺序');
- 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否)');
- 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', '显示顺序');
- 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否)');
- 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', '显示顺序');
- 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', '显示顺序');
- 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否)');
- 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', '显示顺序');
- 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否)');
- 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否)');
- 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否)');
- 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否)');
- 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', '显示顺序');
- 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', '显示顺序');
- 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', '显示顺序');
- 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否)');
- 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', '显示顺序');
- 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否)');
- 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否)');
- 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', '显示顺序');
- 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否)');
- 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', '显示顺序');
- 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否)');
- 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', '显示顺序');
- 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', '显示顺序');
- 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否)');
- 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', '显示顺序');
- 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', '显示顺序');
- 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否)');
- 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', '显示顺序');
- 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否)');
- 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否)');
- 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', '显示顺序');
- 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否)');
- 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', '显示顺序');
- 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否)');
- 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', '显示顺序');
- 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否)');
- 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', '显示顺序');
- 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否)');
- 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', '显示顺序');
- 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否)');
- 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', '显示顺序');
- 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否)');
- 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', '显示顺序');
- 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否)');
- 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', '显示顺序');
- 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否)');
- 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', '显示顺序');
- 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否)');
- 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', '显示顺序');
- 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否)');
- 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', '显示顺序');
- 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否)');
- 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', '显示顺序');
- 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否)');
- 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', '显示顺序');
- 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否)');
- 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', '显示顺序');
- 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否)');
- 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', '显示顺序');
- 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否)');
- 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', '显示顺序');
- 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否)');
- 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', '显示顺序');
- 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否)');
- 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', '显示顺序');
- 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否)');
- 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', '显示顺序');
- 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否)');
- 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', '显示顺序');
- 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否)');
- 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', '显示顺序');
- 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否)');
- 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', '显示顺序');
- 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否)');
- 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', '显示顺序');
- 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否)');
- 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', '显示顺序');
- 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否)');
- 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', '显示顺序');
- 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否)');
- 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', '显示顺序');
- 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否)');
- 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', '显示顺序');
- 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否)');
- 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', '显示顺序');
- 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否)');
|