Startsida Utforska Hjälp
Registrera dig Logga in
java
/
diagbotcloud
2
0
Fork 0
Filer Ärenden 0 Pull-förfrågningar 0 Wiki
Träd: c92934a16b
Grenar Taggar
diagbotcloud
/
docs
/
006.20190304慢病基于icss增量脚本
/
init_icss_NCD.sql

init_icss_NCD.sql 26 KB
Historik Rå

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278 
  1. use `sys-icss`;
    2. 

  2. 

  3. DROP TABLE IF EXISTS `icss_vital_order`;
    4. 

  4. DROP TABLE IF EXISTS `icss_lis_unique`;
    5. 

  5. -- 周铁钢
    6. 

  6. -- ----------------------------
    7. 

  7. -- Table structure for icss_dictionary_info
    8. 

  8. -- ----------------------------
    9. 

  9. DROP TABLE IF EXISTS `icss_dictionary_info`;
    10. 

  10. CREATE TABLE `icss_dictionary_info` (
    11. 

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

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

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

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

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

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

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

  18.   `name` varchar(100) NOT NULL DEFAULT '' COMMENT '内容',
    19. 

  19.   `val` varchar(255) NOT NULL DEFAULT '' COMMENT '值',
    20. 

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

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

  22.   `remark` varchar(300) DEFAULT NULL COMMENT '备注',
    23. 

  23.   PRIMARY KEY (`id`)
    24. 

  24. ) ENGINE=InnoDB AUTO_INCREMENT=56 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='icss字典表';
    25. 

  25. 

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

  27. -- Records of icss_dictionary_info
    28. 

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

  29. INSERT INTO `icss_dictionary_info` VALUES ('1', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '主诉现病史', '1', '1', '10', '标签归属');
    30. 

  30. INSERT INTO `icss_dictionary_info` VALUES ('2', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '其他史', '3', '1', '20', '标签归属');
    31. 

  31. INSERT INTO `icss_dictionary_info` VALUES ('3', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '查体', '4', '1', '30', '标签归属');
    32. 

  32. INSERT INTO `icss_dictionary_info` VALUES ('4', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '化验', '5', '1', '40', '标签归属');
    33. 

  33. INSERT INTO `icss_dictionary_info` VALUES ('5', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '辅检', '6', '1', '50', '标签归属');
    34. 

  34. INSERT INTO `icss_dictionary_info` VALUES ('6', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '诊断', '7', '1', '60', '标签归属');
    35. 

  35. INSERT INTO `icss_dictionary_info` VALUES ('7', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '药品', '8', '1', '70', '标签归属');
    36. 

  36. INSERT INTO `icss_dictionary_info` VALUES ('8', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '药品分类', '9', '1', '80', '标签归属');
    37. 

  37. INSERT INTO `icss_dictionary_info` VALUES ('9', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', '多列多选标签（杂音/初为）', '2', '1', '10', '组合标签-填写单类型');
    38. 

  38. INSERT INTO `icss_dictionary_info` VALUES ('10', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', '多项统一横铺标签（血压）', '3', '1', '20', '组合标签-填写单类型');
    39. 

  39. INSERT INTO `icss_dictionary_info` VALUES ('11', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', '症状详细（症状尾巴）', '4', '1', '30', '组合标签-填写单类型');
    40. 

  40. INSERT INTO `icss_dictionary_info` VALUES ('12', 'Y', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', '单选含自由填写项', '5', '1', '40', '组合标签-填写单类型');
    41. 

  41. INSERT INTO `icss_dictionary_info` VALUES ('13', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', '组合项标签（既往史）', '6', '1', '50', '组合标签-填写单类型');
    42. 

  42. INSERT INTO `icss_dictionary_info` VALUES ('14', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', '化验组合', '7', '1', '60', '组合标签-填写单类型');
    43. 

  43. INSERT INTO `icss_dictionary_info` VALUES ('15', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', '空标签', '9', '1', '70', '组合标签-填写单类型');
    44. 

  44. INSERT INTO `icss_dictionary_info` VALUES ('16', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '2', '症状推送类型（添加症状）', '11', '1', '80', '组合标签-填写单类型');
    45. 

  45. INSERT INTO `icss_dictionary_info` VALUES ('26', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '4', '主诉', '1', '1', '10', '模板类型归属');
    46. 

  46. INSERT INTO `icss_dictionary_info` VALUES ('27', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '4', '现病史', '2', '1', '20', '模板类型归属');
    47. 

  47. INSERT INTO `icss_dictionary_info` VALUES ('28', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '4', '其他史', '3', '1', '30', '模板类型归属');
    48. 

  48. INSERT INTO `icss_dictionary_info` VALUES ('29', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '4', '查体', '4', '1', '40', '模板类型归属');
    49. 

  49. INSERT INTO `icss_dictionary_info` VALUES ('30', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '4', '化验', '5', '1', '50', '模板类型归属');
    50. 

  50. INSERT INTO `icss_dictionary_info` VALUES ('31', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '4', '辅检', '6', '1', '60', '模板类型归属');
    51. 

  51. INSERT INTO `icss_dictionary_info` VALUES ('33', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '5', '从左到右，从上到下', '1', '1', '10', '成文顺序');
    52. 

  52. INSERT INTO `icss_dictionary_info` VALUES ('34', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '5', '按点击顺序成文', '0', '1', '20', '成文顺序');
    53. 

  53. INSERT INTO `icss_dictionary_info` VALUES ('35', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '6', '默认值', '0', '1', '10', '单标签组件类型');
    54. 

  54. INSERT INTO `icss_dictionary_info` VALUES ('36', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '6', '单选', '1', '1', '20', '单标签组件类型');
    55. 

  55. INSERT INTO `icss_dictionary_info` VALUES ('37', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '6', '多选', '2', '1', '30', '单标签组件类型');
    56. 

  56. INSERT INTO `icss_dictionary_info` VALUES ('38', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '6', '数字键盘带单位', '5', '1', '40', '单标签组件类型');
    57. 

  57. INSERT INTO `icss_dictionary_info` VALUES ('39', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '6', '输入框', '6', '1', '50', '单标签组件类型');
    58. 

  58. INSERT INTO `icss_dictionary_info` VALUES ('40', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '6', '数字键盘', '7', '1', '60', '单标签组件类型');
    59. 

  59. INSERT INTO `icss_dictionary_info` VALUES ('41', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '6', '联合推送', '99', '1', '80', '单标签组件类型');
    60. 

  60. INSERT INTO `icss_dictionary_info` VALUES ('42', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '6', '单选含自由填写项', '11', '1', '70', '单标签组件类型');
    61. 

  61. INSERT INTO `icss_dictionary_info` VALUES ('43', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '量表', '21', '1', '90', '标签归属');
    62. 

  62. INSERT INTO `icss_dictionary_info` VALUES ('44', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '核心指标', '22', '1', '100', '标签归属');
    63. 

  63. INSERT INTO `icss_dictionary_info` VALUES ('45', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '4', '诊断', '7', '1', '70', '模板类型归属');
    64. 

  64. INSERT INTO `icss_dictionary_info` VALUES ('46', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '7', '普通病', '0', '1', '10', '诊断类型');
    65. 

  65. INSERT INTO `icss_dictionary_info` VALUES ('47', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '7', '慢病', '1', '1', '20', '诊断类型');
    66. 

  66. INSERT INTO `icss_dictionary_info` VALUES ('48', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '7', '急诊', '2', '1', '30', '诊断类型');
    67. 

  67. INSERT INTO `icss_dictionary_info` VALUES ('49', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '8', '文本模块', '0', '1', '10', '量表结构类型');
    68. 

  68. INSERT INTO `icss_dictionary_info` VALUES ('50', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '8', '推送模块', '1', '1', '20', '量表结构类型');
    69. 

  69. INSERT INTO `icss_dictionary_info` VALUES ('51', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '4', '现病史空模板', '22', '1', '80', '模板类型归属');
    70. 

  70. INSERT INTO `icss_dictionary_info` VALUES ('52', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '4', '现病史空模板子模板', '322', '1', '90', '模板类型归属');
    71. 

  71. INSERT INTO `icss_dictionary_info` VALUES ('53', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '4', '主诉子模板', '31', '1', '100', '模板类型归属');
    72. 

  72. INSERT INTO `icss_dictionary_info` VALUES ('54', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '4', '现病史子模板', '32', '1', '110', '模板类型归属');
    73. 

  73. INSERT INTO `icss_dictionary_info` VALUES ('55', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '1', '不良反应', '10', '1', '110', '标签归属');
    74. 

  74. 

  75. 

  76. -- 导入默认的诊断类型
    77. 

  77. -- ----------------------------
    78. 

  78. -- Table structure for icss_dis_scale
    79. 

  79. -- ----------------------------
    80. 

  80. DROP TABLE IF EXISTS `icss_dis_scale`;
    81. 

  81. CREATE TABLE `icss_dis_scale` (
    82. 

  82.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    83. 

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

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

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

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

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

  88.   `dis_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '诊断标签id',
    89. 

  89.   `scale_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '量表标签id',
    90. 

  90.   `order_no` smallint(6) NOT NULL DEFAULT '0' COMMENT '排序号',
    91. 

  91.   `remark` varchar(500) DEFAULT NULL COMMENT '备注',
    92. 

  92.   PRIMARY KEY (`id`)
    93. 

  93. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='诊断量表映射表';
    94. 

  94. 

  95. -- ----------------------------
    96. 

  96. -- Table structure for icss_dis_type
    97. 

  97. -- ----------------------------
    98. 

  98. DROP TABLE IF EXISTS `icss_dis_type`;
    99. 

  99. CREATE TABLE `icss_dis_type` (
    100. 

  100.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    101. 

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

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

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

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

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

  106.   `dis_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '诊断标签id',
    107. 

  107.   `parent_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '父级诊断id',
    108. 

  108.   `type` tinyint(4) NOT NULL DEFAULT '1' COMMENT '1：慢病，2：急诊',
    109. 

  109.   `remark` varchar(500) DEFAULT NULL COMMENT '备注',
    110. 

  110.   PRIMARY KEY (`id`)
    111. 

  111. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='诊断类型表';
    112. 

  112. 

  113. 

  114. insert into icss_dis_type(`dis_id`, `type`)
    115. 

  115. SELECT id,0 FROM `icss_question_info` where type = 7 and is_deleted = 'N';
    116. 

  116. 

  117. -- 将糖尿病设置为慢病
    118. 

  118. update icss_dis_type set type = 1 where dis_id = (
    119. 

  119. 	select id from icss_question_info where tag_name = '糖尿病' and is_deleted = 'N' and type = 7
    120. 

  120. );
    121. 

  121. 

  122. 

  123. 

  124. -- ----------------------------
    125. 

  125. -- Table structure for icss_scale_content
    126. 

  126. -- ----------------------------
    127. 

  127. DROP TABLE IF EXISTS `icss_scale_content`;
    128. 

  128. CREATE TABLE `icss_scale_content` (
    129. 

  129.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    130. 

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

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

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

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

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

  135.   `scale_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '量表标签id',
    136. 

  136.   `content` text COMMENT '内容',
    137. 

  137.   `type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0:文本，1：大数据接口填充',
    138. 

  138.   `order_no` smallint(6) NOT NULL DEFAULT '0' COMMENT '排序号',
    139. 

  139.   `remark` varchar(500) DEFAULT NULL COMMENT '备注',
    140. 

  140.   PRIMARY KEY (`id`)
    141. 

  141. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='量表内容表';
    142. 

  142. 

  143. 

  144. -- 王峰
    145. 

  145. -- ----------------------------
    146. 

  146. -- Table structure for icss_evaluation_module_mapping
    147. 

  147. -- ----------------------------
    148. 

  148. DROP TABLE IF EXISTS `icss_evaluation_module_mapping`;
    149. 

  149. CREATE TABLE `icss_evaluation_module_mapping` (
    150. 

  150.   `id` bigint(20) NOT NULL AUTO_INCREMENT,
    151. 

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

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

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

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

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

  156.   `region_name` varchar(200) DEFAULT NULL COMMENT '区域名',
    157. 

  157.   `region_type` varchar(200) DEFAULT NULL COMMENT '区域类型（0默认自定义，1大数据，2内部数据）',
    158. 

  158.   `order_no` int(11) DEFAULT NULL COMMENT '区域顺序',
    159. 

  159.   `disease_id` bigint(20) DEFAULT NULL COMMENT '疾病id',
    160. 

  160.   `remark` varchar(300) DEFAULT NULL,
    161. 

  161.   PRIMARY KEY (`id`)
    162. 

  162. ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COMMENT='管理与评估模板表';
    163. 

  163. 

  164. -- ----------------------------
    165. 

  165. -- Records of icss_evaluation_module_mapping
    166. 

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

  167. INSERT INTO `icss_evaluation_module_mapping` VALUES ('1', 'N', '1970-01-02 12:00:00', '1970-01-01 12:00:00', '1', '1', '疗效评估', '1', '1', '21773', null);
    168. 

  168. INSERT INTO `icss_evaluation_module_mapping` VALUES ('2', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '1', '1', '血糖控制情况', '10', '2', '21773', null);
    169. 

  169. INSERT INTO `icss_evaluation_module_mapping` VALUES ('3', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '1', '整体评估', '0', '3', '21773', null);
    170. 

  170. INSERT INTO `icss_evaluation_module_mapping` VALUES ('4', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '1', '糖尿病分级管理', '1', '4', '21773', null);
    171. 

  171. INSERT INTO `icss_evaluation_module_mapping` VALUES ('5', 'N', '1970-01-02 12:00:00', '1970-01-01 12:00:00', '0', '1', '疗效评估820', '1', '1', '105', null);
    172. 

  172. INSERT INTO `icss_evaluation_module_mapping` VALUES ('6', 'N', '1970-01-03 12:00:00', '1970-01-01 12:00:00', '0', '11', '疗效评估520', '1', '1', '98', null);
    173. 

  173. INSERT INTO `icss_evaluation_module_mapping` VALUES ('7', 'N', '1970-01-04 12:00:00', '1970-01-01 12:00:00', '0', '1', '疗效评估297', '1', '1', '297', null);
    174. 

  174. INSERT INTO `icss_evaluation_module_mapping` VALUES ('8', 'N', '1970-01-08 12:00:00', '1970-01-01 12:00:00', '0', '1', '疗效评估800', '1', '1', '20718', null);
    175. 

  175. 

  176. -- ----------------------------
    177. 

  177. -- Table structure for icss_index_data
    178. 

  178. -- ----------------------------
    179. 

  179. DROP TABLE IF EXISTS `icss_index_data`;
    180. 

  180. CREATE TABLE `icss_index_data` (
    181. 

  181.   `id` bigint(20) NOT NULL AUTO_INCREMENT,
    182. 

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

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

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

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

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

  187.   `index_unique` varchar(200) DEFAULT NULL COMMENT '指标公表名',
    188. 

  188.   `index_value` varchar(200) DEFAULT NULL COMMENT '指标值',
    189. 

  189.   `index_unit` varchar(200) DEFAULT NULL COMMENT '指标单位',
    190. 

  190.   `is_abnormal` int(11) DEFAULT NULL COMMENT '是否异常',
    191. 

  191.   `creat_time` datetime DEFAULT NULL COMMENT '化验时间',
    192. 

  192.   `patient_id` bigint(20) DEFAULT NULL COMMENT '患者id',
    193. 

  193.   `inquiry_code` varchar(50) DEFAULT NULL COMMENT '就诊号',
    194. 

  194.   `remark` varchar(300) DEFAULT NULL,
    195. 

  195.   PRIMARY KEY (`id`)
    196. 

  196. ) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8 COMMENT='指标数据表';
    197. 

  197. 

  198. -- ----------------------------
    199. 

  199. -- Records of icss_index_data
    200. 

  200. -- ----------------------------
    201. 

  201. INSERT INTO `icss_index_data` VALUES ('1', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '空腹血糖', '10', 'mo/L', '1', '2019-03-11 20:00:05', '1001', '2973', null);
    202. 

  202. INSERT INTO `icss_index_data` VALUES ('2', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '空腹血糖', '20', 'mo/L', '1', '2019-03-05 20:01:15', '1001', '2979', null);
    203. 

  203. INSERT INTO `icss_index_data` VALUES ('3', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '餐后2小时血糖', '6', 'mo/L', '0', '2019-03-11 20:02:02', '1001', '2973', null);
    204. 

  204. INSERT INTO `icss_index_data` VALUES ('4', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '餐后2小时血糖', '4', 'mo/L', '1', '2019-03-05 20:17:32', '1001', '5454', null);
    205. 

  205. INSERT INTO `icss_index_data` VALUES ('5', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '餐后2小时血糖', '8', 'mo/L', '1', '2019-03-01 20:17:36', '1001', '456764546798', null);
    206. 

  206. INSERT INTO `icss_index_data` VALUES ('6', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '餐后2小时血糖', '9', 'mo/L', '1', '2019-03-11 20:17:39', '1001', '4565463', null);
    207. 

  207. INSERT INTO `icss_index_data` VALUES ('7', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '餐后2小时血糖', '5', 'mo/L', '1', '2019-03-07 20:17:56', '1001', '436456456', null);
    208. 

  208. INSERT INTO `icss_index_data` VALUES ('8', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '随机血糖', '1', 'mo/L', '1', '2019-02-06 20:17:41', '1001', '457896', null);
    209. 

  209. INSERT INTO `icss_index_data` VALUES ('9', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '随机血糖', '2', 'mo/L', '1', '2019-03-12 20:17:46', '1001', '364', null);
    210. 

  210. INSERT INTO `icss_index_data` VALUES ('10', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '随机血糖', '3', 'mo/L', '1', '2019-02-14 20:17:49', '1001', '45645', null);
    211. 

  211. INSERT INTO `icss_index_data` VALUES ('11', 'Y', '2019-03-12 15:22:42', '2019-03-12 15:58:43', '1', '0', '空腹血糖', '18', 'mmol/L', '1', '2019-03-12 15:21:01', '1001', '297', null);
    212. 

  212. INSERT INTO `icss_index_data` VALUES ('12', 'Y', '2019-03-12 15:24:02', '2019-03-12 15:58:43', '1', '0', '空腹血糖', '18', 'mmol/L', '1', '2019-03-12 15:21:01', '1001', '297', null);
    213. 

  213. INSERT INTO `icss_index_data` VALUES ('13', 'Y', '2019-03-12 15:24:02', '2019-03-12 15:58:43', '1', '0', '随机血糖', '18', 'mmol/L', '1', '2019-03-12 15:21:01', '1001', '297', null);
    214. 

  214. INSERT INTO `icss_index_data` VALUES ('14', 'Y', '2019-03-12 15:24:02', '2019-03-12 15:58:43', '1', '0', '随机血糖', '18', 'mmol/L', '1', '2019-03-12 15:21:01', '1001', '297', null);
    215. 

  215. INSERT INTO `icss_index_data` VALUES ('15', 'Y', '2019-03-12 15:58:43', '2019-03-12 15:59:16', '1', '0', '空腹血糖', '18', 'mmol/L', '1', '2019-03-12 15:21:01', '1001', '297', null);
    216. 

  216. INSERT INTO `icss_index_data` VALUES ('16', 'Y', '2019-03-12 15:58:43', '2019-03-12 15:59:16', '1', '0', '随机血糖', '18', 'mmol/L', '1', '2019-03-12 15:21:01', '1001', '297', null);
    217. 

  217. INSERT INTO `icss_index_data` VALUES ('17', 'Y', '2019-03-12 15:58:43', '2019-03-12 15:59:16', '1', '0', '随机血糖', '18', 'mmol/L', '1', '2019-03-12 15:21:01', '1001', '297', null);
    218. 

  218. INSERT INTO `icss_index_data` VALUES ('18', 'Y', '2019-03-12 15:59:16', '2019-04-10 11:23:17', '1', '0', '空腹血糖', '18', 'mmol/L', '1', '2019-03-12 15:21:01', '1001', '297', null);
    219. 

  219. INSERT INTO `icss_index_data` VALUES ('19', 'Y', '2019-03-12 15:59:16', '2019-04-10 11:23:17', '1', '0', '随机血糖', '18', 'mmol/L', '1', '2019-03-12 15:21:01', '1001', '297', null);
    220. 

  220. INSERT INTO `icss_index_data` VALUES ('20', 'Y', '2019-03-12 15:59:16', '2019-04-10 11:23:17', '1', '0', '随机血糖', '18', 'mmol/L', '1', '2019-03-12 15:21:01', '1001', '297', null);
    221. 

  221. INSERT INTO `icss_index_data` VALUES ('21', 'N', '2019-03-12 16:00:04', '1970-01-01 12:00:00', '1', '0', '空腹血糖', '18', 'mmol/L', '1', '2019-03-12 15:21:01', '1002', '297', null);
    222. 

  222. INSERT INTO `icss_index_data` VALUES ('22', 'N', '2019-03-12 16:00:04', '1970-01-01 12:00:00', '1', '0', '随机血糖', '18', 'mmol/L', '1', '2019-03-12 15:21:01', '1002', '297', null);
    223. 

  223. INSERT INTO `icss_index_data` VALUES ('23', 'N', '2019-03-12 16:00:04', '1970-01-01 12:00:00', '1', '0', '随机血糖', '18', 'mmol/L', '1', '2019-03-12 15:21:01', '1002', '297', null);
    224. 

  224. INSERT INTO `icss_index_data` VALUES ('24', 'Y', '2019-03-12 16:48:57', '2019-03-12 16:55:21', '1', '0', '空腹血糖', '18', 'mmol/L', '1', '2019-03-12 15:21:01', '1001', '5297', null);
    225. 

  225. INSERT INTO `icss_index_data` VALUES ('25', 'Y', '2019-03-12 16:48:57', '2019-03-12 16:55:21', '1', '0', '随机血糖', '18', 'mmol/L', '1', '2019-03-12 15:21:01', '1001', '5297', null);
    226. 

  226. INSERT INTO `icss_index_data` VALUES ('26', 'Y', '2019-03-12 16:48:57', '2019-03-12 16:55:21', '1', '0', '随机血糖', '18', 'mmol/L', '1', '2019-03-12 15:21:01', '1001', '5297', null);
    227. 

  227. INSERT INTO `icss_index_data` VALUES ('27', 'N', '2019-03-12 16:55:21', '1970-01-01 12:00:00', '1', '0', '空腹血糖', '18', 'mmol/L', '1', '2019-03-12 15:21:01', '1001', '5297', null);
    228. 

  228. INSERT INTO `icss_index_data` VALUES ('28', 'N', '2019-03-12 16:55:21', '1970-01-01 12:00:00', '1', '0', '随机血糖', '18', 'mmol/L', '1', '2019-03-12 15:21:01', '1001', '5297', null);
    229. 

  229. INSERT INTO `icss_index_data` VALUES ('29', 'N', '2019-03-12 16:55:21', '1970-01-01 12:00:00', '1', '0', '随机血糖', '18', 'mmol/L', '1', '2019-03-12 15:21:01', '1001', '5297', null);
    230. 

  230. INSERT INTO `icss_index_data` VALUES ('30', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '糖化血红蛋白', '19', 'mmol/L', '1', '2019-03-03 20:16:48', '1001', '5297', null);
    231. 

  231. INSERT INTO `icss_index_data` VALUES ('31', 'Y', '2019-04-10 11:23:17', '2019-04-10 11:40:47', '1', '0', '空腹血糖', '520', 'string', '1', '2019-05-01 12:00:00', '1001', '297', null);
    232. 

  232. INSERT INTO `icss_index_data` VALUES ('32', 'N', '2019-04-10 11:40:58', '1970-01-01 12:00:00', '1', '0', '空腹血糖', '520', 'string', '1', '2019-05-01 12:00:00', '1001', '297', null);
    233. 

  233. 

  234. -- ----------------------------
    235. 

  235. -- Table structure for icss_index_config
    236. 

  236. -- ----------------------------
    237. 

  237. DROP TABLE IF EXISTS `icss_index_config`;
    238. 

  238. CREATE TABLE `icss_index_config` (
    239. 

  239.   `id` bigint(20) NOT NULL AUTO_INCREMENT,
    240. 

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

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

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

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

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

  245.   `index_unique` varchar(200) DEFAULT NULL COMMENT '指标公表名',
    246. 

  246.   `disease_id` bigint(20) DEFAULT NULL COMMENT '疾病id',
    247. 

  247.   `index_desc` int(11) DEFAULT NULL COMMENT '指标描述',
    248. 

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

  249.   `remark` varchar(300) DEFAULT NULL COMMENT '备注',
    250. 

  250.   PRIMARY KEY (`id`)
    251. 

  251. ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='指标配置';
    252. 

  252. 

  253. -- ----------------------------
    254. 

  254. -- Records of icss_index_config
    255. 

  255. -- ----------------------------
    256. 

  256. INSERT INTO `icss_index_config` VALUES ('1', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '空腹血糖', '21773', '1', '1', null);
    257. 

  257. INSERT INTO `icss_index_config` VALUES ('2', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '餐后2小时血糖', '21773', '1', '2', null);
    258. 

  258. INSERT INTO `icss_index_config` VALUES ('3', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '随机血糖', '21773', '1', '3', null);
    259. 

  259. INSERT INTO `icss_index_config` VALUES ('4', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '糖化血红蛋白', '21773', '2', '1', null);
    260. 

  260. INSERT INTO `icss_index_config` VALUES ('5', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '血压', '105', '1', '1', null);
    261. 

  261. 

  262. -- 王宇
    263. 

  263. -- 模板信息字段修改
    264. 

  264. alter table icss_module_info change  column disease module_type bigint(20) COMMENT '(0.通用 1.根据科室划分 2.慢病)';
    265. 

  265. alter table icss_module_info add  column relation_id bigint(20) NOT NULL DEFAULT '0' COMMENT '关联id';
    266. 

  266. ALTER TABLE `icss_module_info` MODIFY COLUMN `type`  varchar(20) NOT NULL DEFAULT 0 COMMENT '类型(1.主诉 2.现病史 3.其他史 4.查体 5.化验 6.辅检 7.诊断 8.医嘱 22.现病史空模板 31.主诉子模板 32.现病史子模板 322.现病史空模板子模板)' AFTER `name`;
    267. 

  267. alter table icss_module_info modify column name VARCHAR(120);
    268. 

  268. -- 修改普通模板的值
    269. 

  269. UPDATE `icss_module_info` SET `module_type`='0',`relation_id`='0' WHERE (`id`='1');
    270. 

  270. UPDATE `icss_module_info` SET `module_type`='0',`relation_id`='0' WHERE (`id`='2');
    271. 

  271. UPDATE `icss_module_info` SET `type` = '32',`module_type`='0',`relation_id`='0' WHERE (`id`='3');
    272. 

  272. UPDATE `icss_module_info` SET `module_type`='0',`relation_id`='0' WHERE (`id`='4');
    273. 

  273. UPDATE `icss_module_info` SET `type` = '22',`module_type`='0',`relation_id`='0' WHERE (`id`='5');
    274. 

  274. UPDATE `icss_module_info` SET `type` = '31',`module_type`='0',`relation_id`='0' WHERE (`id`='6');
    275. 

  275. 

  276. -- 赵佩诗
    277. 

  277. -- 提示信息显示位置修改
    278. 

  278. ALTER TABLE icss_introduce_detail MODIFY COLUMN `position` VARCHAR (11) DEFAULT '2' COMMENT '显示位置（多选）：1-推送展示，2-更多展示，3-一般治疗展示，4-手术治疗展示，5-药品说明书，6-不良反应';
    279.