首頁 探索 說明
註冊 登入
java
/
cdss-core
2
0
複刻 0
檔案 問題管理 0 合併請求 0 Wiki
目錄樹: 1732402e78
分支列表 標籤列表
cdss-core
/
doc
/
009.20210615量表规则
/
med_20221.sql

med_20221.sql 42 KB
文件歷史 原始文件

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324 
  1. USE `med_2021`;
    2. 

  2. 

  3. SET FOREIGN_KEY_CHECKS=0;
    4. 

  4. 

  5. -- ----------------------------
    6. 

  6. -- Table structure for kl_regulation
    7. 

  7. -- ----------------------------
    8. 

  8. DROP TABLE IF EXISTS `kl_regulation`;
    9. 

  9. CREATE TABLE `kl_regulation` (
    10. 

  10.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    11. 

  11.   `is_deleted` char(1) NOT NULL DEFAULT 'N' COMMENT '是否删除,N:未删除，Y:删除',
    12. 

  12.   `gmt_create` datetime NOT NULL DEFAULT '1970-01-01 12:00:00' COMMENT '记录创建时间',
    13. 

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

  14.   `creator` varchar(20) NOT NULL DEFAULT '0' COMMENT '创建人，0表示无创建人值',
    15. 

  15.   `modifier` varchar(20) NOT NULL DEFAULT '0' COMMENT '修改人,如果为0则表示纪录未修改',
    16. 

  16.   `name` varchar(255) NOT NULL DEFAULT '' COMMENT '规则名称',
    17. 

  17.   `code` int(11) NOT NULL DEFAULT '100001' COMMENT '规则编码',
    18. 

  18.   `type` tinyint(4) NOT NULL DEFAULT '1' COMMENT '规则类型:(1:量表)',
    19. 

  19.   `status` int(1) NOT NULL DEFAULT '1' COMMENT '启用状态（0：禁用，1：启用）',
    20. 

  20.   `remark` varchar(300) NOT NULL DEFAULT '' COMMENT '备注',
    21. 

  21.   PRIMARY KEY (`id`),
    22. 

  22.   UNIQUE KEY `idx_code` (`code`) USING BTREE,
    23. 

  23.   UNIQUE KEY `idx_name` (`name`) USING BTREE
    24. 

  24. ) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=utf8 COMMENT='通用规则表';
    25. 

  25. 

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

  27. -- Records of kl_regulation
    28. 

  28. -- ----------------------------
    29. 

  29. INSERT INTO `kl_regulation` VALUES ('1', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '使用公共车辆-自己完全可以做', '100001', '1', '1', '使用公共车辆-自己完全可以做');
    30. 

  30. INSERT INTO `kl_regulation` VALUES ('2', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '使用公共车辆-有些困难', '100002', '1', '1', '使用公共车辆-有些困难');
    31. 

  31. INSERT INTO `kl_regulation` VALUES ('3', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '使用公共车辆-需要帮助', '100003', '1', '1', '使用公共车辆-需要帮助');
    32. 

  32. INSERT INTO `kl_regulation` VALUES ('4', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '使用公共车辆-根本无法做', '100004', '1', '1', '使用公共车辆-根本无法做');
    33. 

  33. INSERT INTO `kl_regulation` VALUES ('5', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '行走-自己完全可以做', '100005', '1', '1', '行走-自己完全可以做');
    34. 

  34. INSERT INTO `kl_regulation` VALUES ('6', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '行走-有些困难', '100006', '1', '1', '行走-有些困难');
    35. 

  35. INSERT INTO `kl_regulation` VALUES ('7', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '行走-需要帮助', '100007', '1', '1', '行走-需要帮助');
    36. 

  36. INSERT INTO `kl_regulation` VALUES ('8', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '行走-根本无法做', '100008', '1', '1', '行走-根本无法做');
    37. 

  37. INSERT INTO `kl_regulation` VALUES ('9', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '做饭菜-自己完全可以做', '100009', '1', '1', '做饭菜-自己完全可以做');
    38. 

  38. INSERT INTO `kl_regulation` VALUES ('10', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '做饭菜-有些困难', '100010', '1', '1', '做饭菜-有些困难');
    39. 

  39. INSERT INTO `kl_regulation` VALUES ('11', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '做饭菜-需要帮助', '100011', '1', '1', '做饭菜-需要帮助');
    40. 

  40. INSERT INTO `kl_regulation` VALUES ('12', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '做饭菜-根本无法做', '100012', '1', '1', '做饭菜-根本无法做');
    41. 

  41. INSERT INTO `kl_regulation` VALUES ('13', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '做家务-自己完全可以做', '100013', '1', '1', '做家务-自己完全可以做');
    42. 

  42. INSERT INTO `kl_regulation` VALUES ('14', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '做家务-有些困难', '100014', '1', '1', '做家务-有些困难');
    43. 

  43. INSERT INTO `kl_regulation` VALUES ('15', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '做家务-需要帮助', '100015', '1', '1', '做家务-需要帮助');
    44. 

  44. INSERT INTO `kl_regulation` VALUES ('16', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '做家务-根本无法做', '100016', '1', '1', '做家务-根本无法做');
    45. 

  45. INSERT INTO `kl_regulation` VALUES ('17', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '吃药-自己完全可以做', '100017', '1', '1', '吃药-自己完全可以做');
    46. 

  46. INSERT INTO `kl_regulation` VALUES ('18', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '吃药-有些困难', '100018', '1', '1', '吃药-有些困难');
    47. 

  47. INSERT INTO `kl_regulation` VALUES ('19', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '吃药-需要帮助', '100019', '1', '1', '吃药-需要帮助');
    48. 

  48. INSERT INTO `kl_regulation` VALUES ('20', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '吃药-根本无法做', '100020', '1', '1', '吃药-根本无法做');
    49. 

  49. INSERT INTO `kl_regulation` VALUES ('21', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '吃饭-自己完全可以做', '100021', '1', '1', '吃饭-自己完全可以做');
    50. 

  50. INSERT INTO `kl_regulation` VALUES ('22', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '吃饭-有些困难', '100022', '1', '1', '吃饭-有些困难');
    51. 

  51. INSERT INTO `kl_regulation` VALUES ('23', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '吃饭-需要帮助', '100023', '1', '1', '吃饭-需要帮助');
    52. 

  52. INSERT INTO `kl_regulation` VALUES ('24', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '吃饭-根本无法做', '100024', '1', '1', '吃饭-根本无法做');
    53. 

  53. INSERT INTO `kl_regulation` VALUES ('25', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '梳头、刷牙-自己完全可以做', '100025', '1', '1', '梳头、刷牙-自己完全可以做');
    54. 

  54. INSERT INTO `kl_regulation` VALUES ('26', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '梳头、刷牙-有些困难', '100026', '1', '1', '梳头、刷牙-有些困难');
    55. 

  55. INSERT INTO `kl_regulation` VALUES ('27', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '梳头、刷牙-需要帮助', '100027', '1', '1', '梳头、刷牙-需要帮助');
    56. 

  56. INSERT INTO `kl_regulation` VALUES ('28', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '梳头、刷牙-根本无法做', '100028', '1', '1', '梳头、刷牙-根本无法做');
    57. 

  57. INSERT INTO `kl_regulation` VALUES ('29', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '洗衣-自己完全可以做', '100029', '1', '1', '洗衣-自己完全可以做');
    58. 

  58. INSERT INTO `kl_regulation` VALUES ('30', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '洗衣-有些困难', '100030', '1', '1', '洗衣-有些困难');
    59. 

  59. INSERT INTO `kl_regulation` VALUES ('31', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '洗衣-需要帮助', '100031', '1', '1', '洗衣-需要帮助');
    60. 

  60. INSERT INTO `kl_regulation` VALUES ('32', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '洗衣-根本无法做', '100032', '1', '1', '洗衣-根本无法做');
    61. 

  61. INSERT INTO `kl_regulation` VALUES ('33', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '洗澡-自己完全可以做', '100033', '1', '1', '洗澡-自己完全可以做');
    62. 

  62. INSERT INTO `kl_regulation` VALUES ('34', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '洗澡-有些困难', '100034', '1', '1', '洗澡-有些困难');
    63. 

  63. INSERT INTO `kl_regulation` VALUES ('35', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '洗澡-需要帮助', '100035', '1', '1', '洗澡-需要帮助');
    64. 

  64. INSERT INTO `kl_regulation` VALUES ('36', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '洗澡-根本无法做', '100036', '1', '1', '洗澡-根本无法做');
    65. 

  65. INSERT INTO `kl_regulation` VALUES ('37', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '购物-自己完全可以做', '100037', '1', '1', '购物-自己完全可以做');
    66. 

  66. INSERT INTO `kl_regulation` VALUES ('38', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '购物-有些困难', '100038', '1', '1', '购物-有些困难');
    67. 

  67. INSERT INTO `kl_regulation` VALUES ('39', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '购物-需要帮助', '100039', '1', '1', '购物-需要帮助');
    68. 

  68. INSERT INTO `kl_regulation` VALUES ('40', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '购物-根本无法做', '100040', '1', '1', '购物-根本无法做');
    69. 

  69. INSERT INTO `kl_regulation` VALUES ('41', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '定时上厕所-自己完全可以做', '100041', '1', '1', '定时上厕所-自己完全可以做');
    70. 

  70. INSERT INTO `kl_regulation` VALUES ('42', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '定时上厕所-有些困难', '100042', '1', '1', '定时上厕所-有些困难');
    71. 

  71. INSERT INTO `kl_regulation` VALUES ('43', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '定时上厕所-需要帮助', '100043', '1', '1', '定时上厕所-需要帮助');
    72. 

  72. INSERT INTO `kl_regulation` VALUES ('44', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '定时上厕所-根本无法做', '100044', '1', '1', '定时上厕所-根本无法做');
    73. 

  73. INSERT INTO `kl_regulation` VALUES ('45', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '打电话-自己完全可以做', '100045', '1', '1', '打电话-自己完全可以做');
    74. 

  74. INSERT INTO `kl_regulation` VALUES ('46', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '打电话-有些困难', '100046', '1', '1', '打电话-有些困难');
    75. 

  75. INSERT INTO `kl_regulation` VALUES ('47', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '打电话-需要帮助', '100047', '1', '1', '打电话-需要帮助');
    76. 

  76. INSERT INTO `kl_regulation` VALUES ('48', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '打电话-根本无法做', '100048', '1', '1', '打电话-根本无法做');
    77. 

  77. INSERT INTO `kl_regulation` VALUES ('49', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '处理自己钱财-自己完全可以做', '100049', '1', '1', '处理自己钱财-自己完全可以做');
    78. 

  78. INSERT INTO `kl_regulation` VALUES ('50', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '处理自己钱财-有些困难', '100050', '1', '1', '处理自己钱财-有些困难');
    79. 

  79. INSERT INTO `kl_regulation` VALUES ('51', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '处理自己钱财-需要帮助', '100051', '1', '1', '处理自己钱财-需要帮助');
    80. 

  80. INSERT INTO `kl_regulation` VALUES ('52', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '处理自己钱财-根本无法做', '100052', '1', '1', '处理自己钱财-根本无法做');
    81. 

  81. 

  82. -- ----------------------------
    83. 

  83. -- Table structure for kl_regulation_base
    84. 

  84. -- ----------------------------
    85. 

  85. DROP TABLE IF EXISTS `kl_regulation_base`;
    86. 

  86. CREATE TABLE `kl_regulation_base` (
    87. 

  87.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    88. 

  88.   `is_deleted` char(1) NOT NULL DEFAULT 'N' COMMENT '是否删除,N:未删除，Y:删除',
    89. 

  89.   `gmt_create` datetime NOT NULL DEFAULT '1970-01-01 12:00:00' COMMENT '记录创建时间',
    90. 

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

  91.   `creator` varchar(20) NOT NULL DEFAULT '0' COMMENT '创建人，0表示无创建人值',
    92. 

  92.   `modifier` varchar(20) NOT NULL DEFAULT '0' COMMENT '修改人,如果为0则表示纪录未修改',
    93. 

  93.   `concept_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '提示概念id',
    94. 

  94.   `description` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '描述',
    95. 

  95.   `type` int(10) NOT NULL DEFAULT '1' COMMENT '基础规则类型(1:等于术语本身;2:存在比较;3:主诉现病史正则;4:既往史正则)',
    96. 

  96.   `min_operator` varchar(15) NOT NULL DEFAULT '' COMMENT '最小域比较符',
    97. 

  97.   `min_value` varchar(50) NOT NULL DEFAULT '' COMMENT '最小域值',
    98. 

  98.   `min_unit` varchar(50) NOT NULL DEFAULT '' COMMENT '最小域单位',
    99. 

  99.   `max_operator` varchar(15) NOT NULL DEFAULT '' COMMENT '最大域比较符',
    100. 

  100.   `max_value` varchar(50) NOT NULL DEFAULT '' COMMENT '最大域值',
    101. 

  101.   `max_unit` varchar(50) NOT NULL DEFAULT '' COMMENT '最大域单位',
    102. 

  102.   `eq_operator` varchar(15) NOT NULL DEFAULT '' COMMENT '等于域比较符',
    103. 

  103.   `eq_value` varchar(255) NOT NULL DEFAULT '' COMMENT '等于域值',
    104. 

  104.   `eq_unit` varchar(50) NOT NULL DEFAULT '' COMMENT '等于域单位',
    105. 

  105.   `status` int(1) NOT NULL DEFAULT '1' COMMENT '启用状态（0：禁用，1：启用）',
    106. 

  106.   PRIMARY KEY (`id`),
    107. 

  107.   KEY `idx_concept_id` (`concept_id`) USING BTREE
    108. 

  108. ) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=utf8 COMMENT='通用规则基础表';
    109. 

  109. 

  110. -- ----------------------------
    111. 

  111. -- Records of kl_regulation_base
    112. 

  112. -- ----------------------------
    113. 

  113. INSERT INTO `kl_regulation_base` VALUES ('1', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '0', '使用公共车辆-自己完全可以做', '3', '', '', '', '', '', '', '', '自行乘坐公共汽车', '', '1');
    114. 

  114. INSERT INTO `kl_regulation_base` VALUES ('2', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '0', '使用公共车辆-有些困难', '3', '', '', '', '', '', '', '', '乘坐公共汽车困难', '', '1');
    115. 

  115. INSERT INTO `kl_regulation_base` VALUES ('3', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '0', '使用公共车辆-需要帮助', '3', '', '', '', '', '', '', '', '乘坐公共汽车需要帮忙', '', '1');
    116. 

  116. INSERT INTO `kl_regulation_base` VALUES ('4', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '0', '使用公共车辆-根本无法做', '3', '', '', '', '', '', '', '', '不能乘坐公共汽车', '', '1');
    117. 

  117. INSERT INTO `kl_regulation_base` VALUES ('5', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '0', '行走-自己完全可以做', '3', '', '', '', '', '', '', '', '自行走路|行走自如', '', '1');
    118. 

  118. INSERT INTO `kl_regulation_base` VALUES ('6', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '0', '行走-有些困难', '3', '', '', '', '', '', '', '', '行走困难', '', '1');
    119. 

  119. INSERT INTO `kl_regulation_base` VALUES ('7', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '0', '行走-需要帮助', '3', '', '', '', '', '', '', '', '行走需要搀扶', '', '1');
    120. 

  120. INSERT INTO `kl_regulation_base` VALUES ('8', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '0', '行走-根本无法做', '3', '', '', '', '', '', '', '', '不能行走', '', '1');
    121. 

  121. INSERT INTO `kl_regulation_base` VALUES ('9', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '0', '做饭菜-自己完全可以做', '3', '', '', '', '', '', '', '', '(?<!不)会做饭菜', '', '1');
    122. 

  122. INSERT INTO `kl_regulation_base` VALUES ('10', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '0', '做饭菜-有些困难', '3', '', '', '', '', '', '', '', '做饭菜困难', '', '1');
    123. 

  123. INSERT INTO `kl_regulation_base` VALUES ('11', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '0', '做饭菜-需要帮助', '3', '', '', '', '', '', '', '', '做饭菜需要帮忙', '', '1');
    124. 

  124. INSERT INTO `kl_regulation_base` VALUES ('12', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '0', '做饭菜-根本无法做', '3', '', '', '', '', '', '', '', '不会做饭菜', '', '1');
    125. 

  125. INSERT INTO `kl_regulation_base` VALUES ('13', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '0', '做家务-自己完全可以做', '3', '', '', '', '', '', '', '', '(?<!不)会做家务', '', '1');
    126. 

  126. INSERT INTO `kl_regulation_base` VALUES ('14', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '0', '做家务-有些困难', '3', '', '', '', '', '', '', '', '做家务困难', '', '1');
    127. 

  127. INSERT INTO `kl_regulation_base` VALUES ('15', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '0', '做家务-需要帮助', '3', '', '', '', '', '', '', '', '做家务需要帮忙', '', '1');
    128. 

  128. INSERT INTO `kl_regulation_base` VALUES ('16', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '0', '做家务-根本无法做', '3', '', '', '', '', '', '', '', '不会做家务', '', '1');
    129. 

  129. INSERT INTO `kl_regulation_base` VALUES ('17', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '0', '吃药-自己完全可以做', '3', '', '', '', '', '', '', '', '自行服药', '', '1');
    130. 

  130. INSERT INTO `kl_regulation_base` VALUES ('18', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '0', '吃药-有些困难', '3', '', '', '', '', '', '', '', '服药困难', '', '1');
    131. 

  131. INSERT INTO `kl_regulation_base` VALUES ('19', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '0', '吃药-需要帮助', '3', '', '', '', '', '', '', '', '吃药需要帮忙', '', '1');
    132. 

  132. INSERT INTO `kl_regulation_base` VALUES ('20', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '0', '吃药-根本无法做', '3', '', '', '', '', '', '', '', '不会吃药', '', '1');
    133. 

  133. INSERT INTO `kl_regulation_base` VALUES ('21', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '0', '吃饭-自己完全可以做', '3', '', '', '', '', '', '', '', '自行吃饭|自行用餐|自主用餐|自主进食', '', '1');
    134. 

  134. INSERT INTO `kl_regulation_base` VALUES ('22', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '0', '吃饭-有些困难', '3', '', '', '', '', '', '', '', '吃饭困难|用餐困难|进食困难', '', '1');
    135. 

  135. INSERT INTO `kl_regulation_base` VALUES ('23', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '0', '吃饭-需要帮助', '3', '', '', '', '', '', '', '', '吃饭需要帮忙|用餐需帮忙|进食需要帮助', '', '1');
    136. 

  136. INSERT INTO `kl_regulation_base` VALUES ('24', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '0', '吃饭-根本无法做', '3', '', '', '', '', '', '', '', '不会吃饭|不能用餐', '', '1');
    137. 

  137. INSERT INTO `kl_regulation_base` VALUES ('25', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '0', '梳头、刷牙-自己完全可以做', '3', '', '', '', '', '', '', '', '自行梳头|自行刷牙', '', '1');
    138. 

  138. INSERT INTO `kl_regulation_base` VALUES ('26', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '0', '梳头、刷牙-有些困难', '3', '', '', '', '', '', '', '', '梳头困难|刷牙困难', '', '1');
    139. 

  139. INSERT INTO `kl_regulation_base` VALUES ('27', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '0', '梳头、刷牙-需要帮助', '3', '', '', '', '', '', '', '', '梳头需要帮忙|刷牙需要帮忙', '', '1');
    140. 

  140. INSERT INTO `kl_regulation_base` VALUES ('28', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '0', '梳头、刷牙-根本无法做', '3', '', '', '', '', '', '', '', '不会梳头|不会刷牙', '', '1');
    141. 

  141. INSERT INTO `kl_regulation_base` VALUES ('29', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '0', '洗衣-自己完全可以做', '3', '', '', '', '', '', '', '', '自己洗衣服', '', '1');
    142. 

  142. INSERT INTO `kl_regulation_base` VALUES ('30', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '0', '洗衣-有些困难', '3', '', '', '', '', '', '', '', '洗衣困难', '', '1');
    143. 

  143. INSERT INTO `kl_regulation_base` VALUES ('31', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '0', '洗衣-需要帮助', '3', '', '', '', '', '', '', '', '洗衣服需要帮忙', '', '1');
    144. 

  144. INSERT INTO `kl_regulation_base` VALUES ('32', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '0', '洗衣-根本无法做', '3', '', '', '', '', '', '', '', '不会洗衣服', '', '1');
    145. 

  145. INSERT INTO `kl_regulation_base` VALUES ('33', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '0', '洗澡-自己完全可以做', '3', '', '', '', '', '', '', '', '自己洗澡', '', '1');
    146. 

  146. INSERT INTO `kl_regulation_base` VALUES ('34', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '0', '洗澡-有些困难', '3', '', '', '', '', '', '', '', '洗澡困难', '', '1');
    147. 

  147. INSERT INTO `kl_regulation_base` VALUES ('35', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '0', '洗澡-需要帮助', '3', '', '', '', '', '', '', '', '洗澡需要帮忙', '', '1');
    148. 

  148. INSERT INTO `kl_regulation_base` VALUES ('36', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '0', '洗澡-根本无法做', '3', '', '', '', '', '', '', '', '不会洗澡', '', '1');
    149. 

  149. INSERT INTO `kl_regulation_base` VALUES ('37', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '0', '购物-自己完全可以做', '3', '', '', '', '', '', '', '', '自己购物|自己买东西', '', '1');
    150. 

  150. INSERT INTO `kl_regulation_base` VALUES ('38', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '0', '购物-有些困难', '3', '', '', '', '', '', '', '', '购物困难', '', '1');
    151. 

  151. INSERT INTO `kl_regulation_base` VALUES ('39', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '0', '购物-需要帮助', '3', '', '', '', '', '', '', '', '购物需要帮忙', '', '1');
    152. 

  152. INSERT INTO `kl_regulation_base` VALUES ('40', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '0', '购物-根本无法做', '3', '', '', '', '', '', '', '', '不会购物', '', '1');
    153. 

  153. INSERT INTO `kl_regulation_base` VALUES ('41', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '0', '定时上厕所-自己完全可以做', '3', '', '', '', '', '', '', '', '自己能上厕所|自行如厕', '', '1');
    154. 

  154. INSERT INTO `kl_regulation_base` VALUES ('42', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '0', '定时上厕所-有些困难', '3', '', '', '', '', '', '', '', '上厕所困难|如厕困难', '', '1');
    155. 

  155. INSERT INTO `kl_regulation_base` VALUES ('43', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '0', '定时上厕所-需要帮助', '3', '', '', '', '', '', '', '', '上厕所需要帮忙|上厕所需要搀扶|如厕需要帮忙', '', '1');
    156. 

  156. INSERT INTO `kl_regulation_base` VALUES ('44', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '0', '定时上厕所-根本无法做', '3', '', '', '', '', '', '', '', '不会上厕所|自己不能上厕所|不能如厕', '', '1');
    157. 

  157. INSERT INTO `kl_regulation_base` VALUES ('45', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '0', '打电话-自己完全可以做', '3', '', '', '', '', '', '', '', '(?<!不)能正常打电话', '', '1');
    158. 

  158. INSERT INTO `kl_regulation_base` VALUES ('46', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '0', '打电话-有些困难', '3', '', '', '', '', '', '', '', '打电话困难', '', '1');
    159. 

  159. INSERT INTO `kl_regulation_base` VALUES ('47', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '0', '打电话-需要帮助', '3', '', '', '', '', '', '', '', '打电话需要帮忙', '', '1');
    160. 

  160. INSERT INTO `kl_regulation_base` VALUES ('48', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '0', '打电话-根本无法做', '3', '', '', '', '', '', '', '', '不会打电话', '', '1');
    161. 

  161. INSERT INTO `kl_regulation_base` VALUES ('49', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '0', '处理自己钱财-自己完全可以做', '3', '', '', '', '', '', '', '', '钱币能分清', '', '1');
    162. 

  162. INSERT INTO `kl_regulation_base` VALUES ('50', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '0', '处理自己钱财-有些困难', '3', '', '', '', '', '', '', '', '分清钱币困难', '', '1');
    163. 

  163. INSERT INTO `kl_regulation_base` VALUES ('51', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '0', '处理自己钱财-需要帮助', '3', '', '', '', '', '', '', '', '分清钱币需要帮助', '', '1');
    164. 

  164. INSERT INTO `kl_regulation_base` VALUES ('52', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '0', '处理自己钱财-根本无法做', '3', '', '', '', '', '', '', '', '不认识钱币', '', '1');
    165. 

  165. 

  166. -- ----------------------------
    167. 

  167. -- Table structure for kl_regulation_condition
    168. 

  168. -- ----------------------------
    169. 

  169. DROP TABLE IF EXISTS `kl_regulation_condition`;
    170. 

  170. CREATE TABLE `kl_regulation_condition` (
    171. 

  171.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    172. 

  172.   `is_deleted` char(1) NOT NULL DEFAULT 'N' COMMENT '是否删除,N:未删除，Y:删除',
    173. 

  173.   `gmt_create` datetime NOT NULL DEFAULT '1970-01-01 12:00:00' COMMENT '记录创建时间',
    174. 

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

  175.   `creator` varchar(20) NOT NULL DEFAULT '0' COMMENT '创建人，0表示无创建人值',
    176. 

  176.   `modifier` varchar(20) NOT NULL DEFAULT '0' COMMENT '修改人,如果为0则表示纪录未修改',
    177. 

  177.   `regulation_id` bigint(20) NOT NULL COMMENT '通用规则表主表id',
    178. 

  178.   `condition_type` int(11) NOT NULL DEFAULT '0' COMMENT '条件类型(1:基础条件；2:组合条件)',
    179. 

  179.   `condition_group` int(11) NOT NULL DEFAULT '0' COMMENT '规则组别（1XX_condition_type为2:组合条件有效）',
    180. 

  180.   `fit_no` int(11) NOT NULL DEFAULT '1' COMMENT '符合数量（condition_type为2:组合条件有效）',
    181. 

  181.   `base_group` int(11) NOT NULL DEFAULT '0' COMMENT '基础规则组别（1X_condition_type为1:基础条件；2:组合条件）',
    182. 

  182.   `regulation_base_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '基础规则id（condition_type为1:基础条件有效）',
    183. 

  183.   PRIMARY KEY (`id`),
    184. 

  184.   KEY `idx_regulation_id` (`regulation_id`) USING BTREE,
    185. 

  185.   KEY `idx_regulation_base_id` (`regulation_base_id`) USING BTREE
    186. 

  186. ) ENGINE=InnoDB AUTO_INCREMENT=105 DEFAULT CHARSET=utf8 COMMENT='通用规则条件表';
    187. 

  187. 

  188. -- ----------------------------
    189. 

  189. -- Records of kl_regulation_condition
    190. 

  190. -- ----------------------------
    191. 

  191. INSERT INTO `kl_regulation_condition` VALUES ('1', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '1', '0', '0', '10', '1');
    192. 

  192. INSERT INTO `kl_regulation_condition` VALUES ('2', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', '1', '0', '0', '10', '2');
    193. 

  193. INSERT INTO `kl_regulation_condition` VALUES ('3', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '3', '1', '0', '0', '10', '3');
    194. 

  194. INSERT INTO `kl_regulation_condition` VALUES ('4', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '4', '1', '0', '0', '10', '4');
    195. 

  195. INSERT INTO `kl_regulation_condition` VALUES ('5', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '5', '1', '0', '0', '10', '5');
    196. 

  196. INSERT INTO `kl_regulation_condition` VALUES ('6', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '6', '1', '0', '0', '10', '6');
    197. 

  197. INSERT INTO `kl_regulation_condition` VALUES ('7', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '7', '1', '0', '0', '10', '7');
    198. 

  198. INSERT INTO `kl_regulation_condition` VALUES ('8', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '8', '1', '0', '0', '10', '8');
    199. 

  199. INSERT INTO `kl_regulation_condition` VALUES ('9', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '9', '1', '0', '0', '10', '9');
    200. 

  200. INSERT INTO `kl_regulation_condition` VALUES ('10', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '10', '1', '0', '0', '10', '10');
    201. 

  201. INSERT INTO `kl_regulation_condition` VALUES ('11', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '11', '1', '0', '0', '10', '11');
    202. 

  202. INSERT INTO `kl_regulation_condition` VALUES ('12', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '12', '1', '0', '0', '10', '12');
    203. 

  203. INSERT INTO `kl_regulation_condition` VALUES ('13', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '13', '1', '0', '0', '10', '13');
    204. 

  204. INSERT INTO `kl_regulation_condition` VALUES ('14', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '14', '1', '0', '0', '10', '14');
    205. 

  205. INSERT INTO `kl_regulation_condition` VALUES ('15', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '15', '1', '0', '0', '10', '15');
    206. 

  206. INSERT INTO `kl_regulation_condition` VALUES ('16', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '16', '1', '0', '0', '10', '16');
    207. 

  207. INSERT INTO `kl_regulation_condition` VALUES ('17', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '17', '1', '0', '0', '10', '17');
    208. 

  208. INSERT INTO `kl_regulation_condition` VALUES ('18', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '18', '1', '0', '0', '10', '18');
    209. 

  209. INSERT INTO `kl_regulation_condition` VALUES ('19', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '19', '1', '0', '0', '10', '19');
    210. 

  210. INSERT INTO `kl_regulation_condition` VALUES ('20', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '20', '1', '0', '0', '10', '20');
    211. 

  211. INSERT INTO `kl_regulation_condition` VALUES ('21', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '21', '1', '0', '0', '10', '21');
    212. 

  212. INSERT INTO `kl_regulation_condition` VALUES ('22', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '22', '1', '0', '0', '10', '22');
    213. 

  213. INSERT INTO `kl_regulation_condition` VALUES ('23', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '23', '1', '0', '0', '10', '23');
    214. 

  214. INSERT INTO `kl_regulation_condition` VALUES ('24', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '24', '1', '0', '0', '10', '24');
    215. 

  215. INSERT INTO `kl_regulation_condition` VALUES ('25', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '25', '1', '0', '0', '10', '25');
    216. 

  216. INSERT INTO `kl_regulation_condition` VALUES ('26', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '26', '1', '0', '0', '10', '26');
    217. 

  217. INSERT INTO `kl_regulation_condition` VALUES ('27', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '27', '1', '0', '0', '10', '27');
    218. 

  218. INSERT INTO `kl_regulation_condition` VALUES ('28', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '28', '1', '0', '0', '10', '28');
    219. 

  219. INSERT INTO `kl_regulation_condition` VALUES ('29', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '29', '1', '0', '0', '10', '29');
    220. 

  220. INSERT INTO `kl_regulation_condition` VALUES ('30', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '30', '1', '0', '0', '10', '30');
    221. 

  221. INSERT INTO `kl_regulation_condition` VALUES ('31', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '31', '1', '0', '0', '10', '31');
    222. 

  222. INSERT INTO `kl_regulation_condition` VALUES ('32', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '32', '1', '0', '0', '10', '32');
    223. 

  223. INSERT INTO `kl_regulation_condition` VALUES ('33', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '33', '1', '0', '0', '10', '33');
    224. 

  224. INSERT INTO `kl_regulation_condition` VALUES ('34', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '34', '1', '0', '0', '10', '34');
    225. 

  225. INSERT INTO `kl_regulation_condition` VALUES ('35', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '35', '1', '0', '0', '10', '35');
    226. 

  226. INSERT INTO `kl_regulation_condition` VALUES ('36', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '36', '1', '0', '0', '10', '36');
    227. 

  227. INSERT INTO `kl_regulation_condition` VALUES ('37', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '37', '1', '0', '0', '10', '37');
    228. 

  228. INSERT INTO `kl_regulation_condition` VALUES ('38', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '38', '1', '0', '0', '10', '38');
    229. 

  229. INSERT INTO `kl_regulation_condition` VALUES ('39', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '39', '1', '0', '0', '10', '39');
    230. 

  230. INSERT INTO `kl_regulation_condition` VALUES ('40', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '40', '1', '0', '0', '10', '40');
    231. 

  231. INSERT INTO `kl_regulation_condition` VALUES ('41', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '41', '1', '0', '0', '10', '41');
    232. 

  232. INSERT INTO `kl_regulation_condition` VALUES ('42', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '42', '1', '0', '0', '10', '42');
    233. 

  233. INSERT INTO `kl_regulation_condition` VALUES ('43', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '43', '1', '0', '0', '10', '43');
    234. 

  234. INSERT INTO `kl_regulation_condition` VALUES ('44', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '44', '1', '0', '0', '10', '44');
    235. 

  235. INSERT INTO `kl_regulation_condition` VALUES ('45', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '45', '1', '0', '0', '10', '45');
    236. 

  236. INSERT INTO `kl_regulation_condition` VALUES ('46', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '46', '1', '0', '0', '10', '46');
    237. 

  237. INSERT INTO `kl_regulation_condition` VALUES ('47', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '47', '1', '0', '0', '10', '47');
    238. 

  238. INSERT INTO `kl_regulation_condition` VALUES ('48', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '48', '1', '0', '0', '10', '48');
    239. 

  239. INSERT INTO `kl_regulation_condition` VALUES ('49', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '49', '1', '0', '0', '10', '49');
    240. 

  240. INSERT INTO `kl_regulation_condition` VALUES ('50', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '50', '1', '0', '0', '10', '50');
    241. 

  241. INSERT INTO `kl_regulation_condition` VALUES ('51', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '51', '1', '0', '0', '10', '51');
    242. 

  242. INSERT INTO `kl_regulation_condition` VALUES ('52', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '52', '1', '0', '0', '10', '52');
    243. 

  243. INSERT INTO `kl_regulation_condition` VALUES ('53', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '2', '100', '1', '10', '0');
    244. 

  244. INSERT INTO `kl_regulation_condition` VALUES ('54', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', '2', '100', '1', '10', '0');
    245. 

  245. INSERT INTO `kl_regulation_condition` VALUES ('55', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '3', '2', '100', '1', '10', '0');
    246. 

  246. INSERT INTO `kl_regulation_condition` VALUES ('56', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '4', '2', '100', '1', '10', '0');
    247. 

  247. INSERT INTO `kl_regulation_condition` VALUES ('57', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '5', '2', '100', '1', '10', '0');
    248. 

  248. INSERT INTO `kl_regulation_condition` VALUES ('58', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '6', '2', '100', '1', '10', '0');
    249. 

  249. INSERT INTO `kl_regulation_condition` VALUES ('59', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '7', '2', '100', '1', '10', '0');
    250. 

  250. INSERT INTO `kl_regulation_condition` VALUES ('60', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '8', '2', '100', '1', '10', '0');
    251. 

  251. INSERT INTO `kl_regulation_condition` VALUES ('61', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '9', '2', '100', '1', '10', '0');
    252. 

  252. INSERT INTO `kl_regulation_condition` VALUES ('62', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '10', '2', '100', '1', '10', '0');
    253. 

  253. INSERT INTO `kl_regulation_condition` VALUES ('63', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '11', '2', '100', '1', '10', '0');
    254. 

  254. INSERT INTO `kl_regulation_condition` VALUES ('64', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '12', '2', '100', '1', '10', '0');
    255. 

  255. INSERT INTO `kl_regulation_condition` VALUES ('65', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '13', '2', '100', '1', '10', '0');
    256. 

  256. INSERT INTO `kl_regulation_condition` VALUES ('66', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '14', '2', '100', '1', '10', '0');
    257. 

  257. INSERT INTO `kl_regulation_condition` VALUES ('67', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '15', '2', '100', '1', '10', '0');
    258. 

  258. INSERT INTO `kl_regulation_condition` VALUES ('68', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '16', '2', '100', '1', '10', '0');
    259. 

  259. INSERT INTO `kl_regulation_condition` VALUES ('69', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '17', '2', '100', '1', '10', '0');
    260. 

  260. INSERT INTO `kl_regulation_condition` VALUES ('70', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '18', '2', '100', '1', '10', '0');
    261. 

  261. INSERT INTO `kl_regulation_condition` VALUES ('71', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '19', '2', '100', '1', '10', '0');
    262. 

  262. INSERT INTO `kl_regulation_condition` VALUES ('72', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '20', '2', '100', '1', '10', '0');
    263. 

  263. INSERT INTO `kl_regulation_condition` VALUES ('73', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '21', '2', '100', '1', '10', '0');
    264. 

  264. INSERT INTO `kl_regulation_condition` VALUES ('74', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '22', '2', '100', '1', '10', '0');
    265. 

  265. INSERT INTO `kl_regulation_condition` VALUES ('75', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '23', '2', '100', '1', '10', '0');
    266. 

  266. INSERT INTO `kl_regulation_condition` VALUES ('76', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '24', '2', '100', '1', '10', '0');
    267. 

  267. INSERT INTO `kl_regulation_condition` VALUES ('77', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '25', '2', '100', '1', '10', '0');
    268. 

  268. INSERT INTO `kl_regulation_condition` VALUES ('78', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '26', '2', '100', '1', '10', '0');
    269. 

  269. INSERT INTO `kl_regulation_condition` VALUES ('79', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '27', '2', '100', '1', '10', '0');
    270. 

  270. INSERT INTO `kl_regulation_condition` VALUES ('80', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '28', '2', '100', '1', '10', '0');
    271. 

  271. INSERT INTO `kl_regulation_condition` VALUES ('81', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '29', '2', '100', '1', '10', '0');
    272. 

  272. INSERT INTO `kl_regulation_condition` VALUES ('82', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '30', '2', '100', '1', '10', '0');
    273. 

  273. INSERT INTO `kl_regulation_condition` VALUES ('83', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '31', '2', '100', '1', '10', '0');
    274. 

  274. INSERT INTO `kl_regulation_condition` VALUES ('84', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '32', '2', '100', '1', '10', '0');
    275. 

  275. INSERT INTO `kl_regulation_condition` VALUES ('85', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '33', '2', '100', '1', '10', '0');
    276. 

  276. INSERT INTO `kl_regulation_condition` VALUES ('86', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '34', '2', '100', '1', '10', '0');
    277. 

  277. INSERT INTO `kl_regulation_condition` VALUES ('87', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '35', '2', '100', '1', '10', '0');
    278. 

  278. INSERT INTO `kl_regulation_condition` VALUES ('88', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '36', '2', '100', '1', '10', '0');
    279. 

  279. INSERT INTO `kl_regulation_condition` VALUES ('89', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '37', '2', '100', '1', '10', '0');
    280. 

  280. INSERT INTO `kl_regulation_condition` VALUES ('90', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '38', '2', '100', '1', '10', '0');
    281. 

  281. INSERT INTO `kl_regulation_condition` VALUES ('91', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '39', '2', '100', '1', '10', '0');
    282. 

  282. INSERT INTO `kl_regulation_condition` VALUES ('92', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '40', '2', '100', '1', '10', '0');
    283. 

  283. INSERT INTO `kl_regulation_condition` VALUES ('93', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '41', '2', '100', '1', '10', '0');
    284. 

  284. INSERT INTO `kl_regulation_condition` VALUES ('94', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '42', '2', '100', '1', '10', '0');
    285. 

  285. INSERT INTO `kl_regulation_condition` VALUES ('95', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '43', '2', '100', '1', '10', '0');
    286. 

  286. INSERT INTO `kl_regulation_condition` VALUES ('96', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '44', '2', '100', '1', '10', '0');
    287. 

  287. INSERT INTO `kl_regulation_condition` VALUES ('97', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '45', '2', '100', '1', '10', '0');
    288. 

  288. INSERT INTO `kl_regulation_condition` VALUES ('98', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '46', '2', '100', '1', '10', '0');
    289. 

  289. INSERT INTO `kl_regulation_condition` VALUES ('99', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '47', '2', '100', '1', '10', '0');
    290. 

  290. INSERT INTO `kl_regulation_condition` VALUES ('100', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '48', '2', '100', '1', '10', '0');
    291. 

  291. INSERT INTO `kl_regulation_condition` VALUES ('101', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '49', '2', '100', '1', '10', '0');
    292. 

  292. INSERT INTO `kl_regulation_condition` VALUES ('102', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '50', '2', '100', '1', '10', '0');
    293. 

  293. INSERT INTO `kl_regulation_condition` VALUES ('103', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '51', '2', '100', '1', '10', '0');
    294. 

  294. INSERT INTO `kl_regulation_condition` VALUES ('104', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '52', '2', '100', '1', '10', '0');
    295. 

  295. 

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

  297. -- Table structure for kl_concept_scale
    298. 

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

  299. DROP TABLE IF EXISTS `kl_concept_scale`;
    300. 

  300. CREATE TABLE `kl_concept_scale` (
    301. 

  301.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    302. 

  302.   `is_deleted` char(1) NOT NULL DEFAULT 'N' COMMENT '是否删除,N:未删除，Y:删除',
    303. 

  303.   `gmt_create` datetime NOT NULL DEFAULT '1970-01-01 12:00:00' COMMENT '记录创建时间',
    304. 

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

  305.   `creator` varchar(20) NOT NULL DEFAULT '0' COMMENT '创建人，0表示无创建人值',
    306. 

  306.   `modifier` varchar(20) NOT NULL DEFAULT '0' COMMENT '修改人,如果为0则表示纪录未修改',
    307. 

  307.   `concept_id` bigint(20) DEFAULT NULL COMMENT '术语概念id',
    308. 

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

  309.   `content` mediumtext COMMENT '内容',
    310. 

  310.   `rule_code` varchar(255) DEFAULT NULL COMMENT '编码',
    311. 

  311.   `score` decimal(6,1) DEFAULT '0.0' COMMENT '扣分',
    312. 

  312.   `factor` decimal(6,1) DEFAULT '0.0' COMMENT '系数',
    313. 

  313.   `constant` decimal(6,1) DEFAULT '0.0' COMMENT '常数',
    314. 

  314.   `text_type` int(11) DEFAULT NULL COMMENT '11问题选项;12文本;13得分结果（隐藏）21问题，31答案',
    315. 

  315.   `result_type` int(11) NOT NULL DEFAULT '0' COMMENT '结果类型（1算分;2显示选择结果）',
    316. 

  316.   `select_type` int(11) NOT NULL DEFAULT '0' COMMENT '选择类型(21单选22多选)',
    317. 

  317.   `order_no` int(11) DEFAULT NULL COMMENT '显示顺序',
    318. 

  318.   `status` int(2) DEFAULT '1' COMMENT '1：显示，0：不显示，2隐藏',
    319. 

  319.   `group_num` int(11) DEFAULT '-1' COMMENT '组别互斥（同组互斥）',
    320. 

  320.   `result` varchar(255) DEFAULT NULL COMMENT '结果',
    321. 

  321.   `push_info` text COMMENT '推送信息',
    322. 

  322.   `remark` varchar(255) DEFAULT NULL,
    323. 

  323.   PRIMARY KEY (`id`)
    324. 

  324. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='量表明细表';
    325.