Domů Procházet Nápověda
Registrovat se Přihlásit se
dashoo
/
lims_college
2
0
Rozštěpit 0
Soubory Úkoly 0 Pull Requesty 0 Wiki
Strom: b0453b002e
Větve Značky
lims_college
/
doc
/
部署相关
/
l_lims.sql

l_lims.sql 176 KB
Historie Surový

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596 
  1. /*
    2. 

  2.  Navicat Premium Data Transfer
    3. 

  3. 

  4.  Source Server         : l_lims
    5. 

  5.  Source Server Type    : MySQL
    6. 

  6.  Source Server Version : 80016
    7. 

  7.  Source Host           : rm-8vbk16zx2rbfu6jt6uo.mysql.zhangbei.rds.aliyuncs.com:3306
    8. 

  8.  Source Schema         : l_lims
    9. 

  9. 

  10.  Target Server Type    : MySQL
    11. 

  11.  Target Server Version : 80016
    12. 

  12.  File Encoding         : 65001
    13. 

  13. 

  14.  Date: 29/12/2020 17:53:35
    15. 

  15. */
    16. 

  16. 

  17. SET NAMES utf8mb4;
    18. 

  18. SET FOREIGN_KEY_CHECKS = 0;
    19. 

  19. 

  20. -- ----------------------------
    21. 

  21. -- Table structure for bank_sampletype
    22. 

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

  23. DROP TABLE IF EXISTS `bank_sampletype`;
    24. 

  24. CREATE TABLE `bank_sampletype`  (
    25. 

  25.   `Id` int(11) NOT NULL AUTO_INCREMENT,
    26. 

  26.   `AccCode` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '账户编码',
    27. 

  27.   `MainId` int(11) NULL DEFAULT NULL COMMENT '模板ID',
    28. 

  28.   `MainName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模板Name',
    29. 

  29.   `Code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '编码 账户内不可重复（用户录入）',
    30. 

  30.   `Name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称 账户内不可重复（用户录入）',
    31. 

  31.   `DefaultCapacity` float NULL DEFAULT NULL COMMENT '默认容量',
    32. 

  32.   `Unit` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '单位',
    33. 

  33.   `ValidityHours` int(11) NULL DEFAULT NULL COMMENT '有效期 单位 小时',
    34. 

  34.   `WaningHours` int(11) NULL DEFAULT NULL COMMENT '提前预警 单位 小时  备用',
    35. 

  35.   `SubpackageNum` int(11) NULL DEFAULT NULL COMMENT '分装份数',
    36. 

  36.   `SubpackageCapacity` float NULL DEFAULT NULL COMMENT '分装容量',
    37. 

  37.   `SortCode` int(11) NULL DEFAULT NULL COMMENT '序号                  ----备用',
    38. 

  38.   `Photo` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '样本图片',
    39. 

  39.   `PhotoType` int(11) NULL DEFAULT NULL COMMENT '样本图片',
    40. 

  40.   `SeriesNumber` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '序列号             ---备用',
    41. 

  41.   `StypeItemIds` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '样本扩展字段IDs',
    42. 

  42.   `CreateOn` datetime(0) NOT NULL,
    43. 

  43.   `CreateUserId` int(11) NULL DEFAULT NULL,
    44. 

  44.   `CreateBy` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    45. 

  45.   `ModifiedOn` datetime(0) NULL DEFAULT NULL,
    46. 

  46.   `ModifiedUserId` int(11) NULL DEFAULT NULL,
    47. 

  47.   `FatherSample` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '父级样本',
    48. 

  48.   `ModifiedBy` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    49. 

  49.   `Remark` tinytext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注',
    50. 

  50.   `IsExpiresAlarm` int(11) NULL DEFAULT NULL COMMENT '0：报警；1不报警',
    51. 

  51.   `Type` int(11) NULL DEFAULT 0 COMMENT '样本类型分类：0 供体材料；1 细胞；',
    52. 

  52.   `CellTypeId` int(11) NULL DEFAULT NULL COMMENT '细胞类型Id（供体组织或者样本细胞经过操作产生的下一代细胞的类型）',
    53. 

  53.   `CellType` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '细胞类型（供体组织或者样本细胞经过操作产生的下一代细胞的类型）',
    54. 

  54.   `Del_state` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '是否删除 1删除 0 未删除',
    55. 

  55.   PRIMARY KEY (`Id`) USING BTREE
    56. 

  56. ) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '样本类型' ROW_FORMAT = DYNAMIC;
    57. 

  57. 

  58. -- ----------------------------
    59. 

  59. -- Records of bank_sampletype
    60. 

  60. -- ----------------------------
    61. 

  61. INSERT INTO `bank_sampletype` VALUES (1, '', 0, NULL, 'TP', '胎盘', 20, 'cm', -100, 0, 1, 0, 0, '/static/img/sampletypeimg/plasma.png', 0, '', '', '2020-07-11 09:09:10', 1, '系统管理员', '2020-07-11 09:09:10', 1, NULL, '系统管理员', '无', 0, 0, 6, '细胞', NULL);
    62. 

  62. INSERT INTO `bank_sampletype` VALUES (2, '', 0, NULL, 'YC', '牙齿', 20, 'cm', -100, 0, 1, 0, 0, '/static/img/sampletypeimg/yaopian.png', 0, '', '', '2020-07-11 09:09:10', 1, '系统管理员', '2020-12-18 13:31:10', 1, '', 'Dashoo', '无', 0, 0, 6, '细胞', NULL);
    63. 

  63. INSERT INTO `bank_sampletype` VALUES (3, '', 0, NULL, 'ZF', '脂肪', 20, 'cm', -100, 0, 1, 0, 0, '/static/img/sampletypeimg/huangse.png', 0, '', '', '2020-07-11 09:09:10', 1, '系统管理员', '2020-12-18 13:31:20', 1, '', 'Dashoo', '无', 0, 0, 6, '细胞', NULL);
    64. 

  64. INSERT INTO `bank_sampletype` VALUES (4, '', 0, NULL, 'PB', '外周血', 20, 'cm', -100, 0, 1, 0, 0, '/static/img/sampletypeimg/hongxibao.png', 0, '', '', '2020-07-11 09:09:10', 1, '系统管理员', '2020-12-18 13:31:28', 1, '', 'Dashoo', '无', 0, 0, 6, '细胞', NULL);
    65. 

  65. INSERT INTO `bank_sampletype` VALUES (5, '', 0, NULL, 'QD', '脐带', 20, 'cm', -100, 0, 1, 0, 0, '/static/img/sampletypeimg/plasma.png', 0, '', '', '2020-07-11 09:09:10', 1, '系统管理员', '2020-07-11 09:09:10', 1, NULL, '系统管理员', '无', 0, 0, 6, '细胞', NULL);
    66. 

  66. INSERT INTO `bank_sampletype` VALUES (6, '', 0, '', 'XB', '细胞', 20, 'mL', -100, 0, 1, 0, 0, '/static/img/sampletypeimg/RNA.png', 0, '', '', '2020-08-21 14:52:03', 1, '系统管理员', '2020-08-21 14:53:20', 1, '', '系统管理员', '无', 0, 0, 6, '细胞', NULL);
    67. 

  67. 

  68. -- ----------------------------
    69. 

  69. -- Table structure for base_itemdetails
    70. 

  70. -- ----------------------------
    71. 

  71. DROP TABLE IF EXISTS `base_itemdetails`;
    72. 

  72. CREATE TABLE `base_itemdetails`  (
    73. 

  73.   `Id` int(10) NOT NULL AUTO_INCREMENT,
    74. 

  74.   `AccCode` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    75. 

  75.   `ParentId` int(10) NULL DEFAULT NULL,
    76. 

  76.   `ItemCode` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    77. 

  77.   `ItemName` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    78. 

  78.   `ItemValue` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    79. 

  79.   `Enabled` int(10) NOT NULL DEFAULT 1,
    80. 

  80.   `AllowEdit` int(10) NOT NULL DEFAULT 1,
    81. 

  81.   `AllowDelete` int(10) NOT NULL DEFAULT 1,
    82. 

  82.   `SortCode` int(10) NULL DEFAULT NULL,
    83. 

  83.   `Description` varchar(800) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    84. 

  84.   `IsPublic` int(10) NOT NULL DEFAULT 1,
    85. 

  85.   `DeletionStateCode` int(10) NOT NULL DEFAULT 0,
    86. 

  86.   `CreateOn` datetime(0) NULL DEFAULT NULL,
    87. 

  87.   `CreateUserId` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    88. 

  88.   `CreateBy` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    89. 

  89.   `ModifiedOn` datetime(0) NULL DEFAULT NULL,
    90. 

  90.   `ModifiedUserId` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    91. 

  91.   `ModifiedBy` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    92. 

  92.   PRIMARY KEY (`Id`) USING BTREE
    93. 

  93. ) ENGINE = InnoDB AUTO_INCREMENT = 1034 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    94. 

  94. 

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

  96. -- Records of base_itemdetails
    97. 

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

  98. INSERT INTO `base_itemdetails` VALUES (168, '', 203, NULL, '红管', '红管', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, '2019-08-06 19:02:03', NULL, NULL);
    99. 

  99. INSERT INTO `base_itemdetails` VALUES (169, '', 203, NULL, '紫管', '紫管', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    100. 

  100. INSERT INTO `base_itemdetails` VALUES (171, '', 204, NULL, '细胞检测', '细胞检测', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, '2019-08-26 17:34:42', NULL, NULL);
    101. 

  101. INSERT INTO `base_itemdetails` VALUES (172, '', 204, NULL, 'iPSCs', 'iPSCs细胞制备', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, '2018-02-28 17:00:51', NULL, NULL);
    102. 

  102. INSERT INTO `base_itemdetails` VALUES (173, '', 206, NULL, '顺丰', '顺丰快递', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    103. 

  103. INSERT INTO `base_itemdetails` VALUES (174, '', 206, NULL, '中通', '中通快递', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    104. 

  104. INSERT INTO `base_itemdetails` VALUES (175, '', 206, NULL, '邮政', '邮政快递', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    105. 

  105. INSERT INTO `base_itemdetails` VALUES (176, '', 208, NULL, 'Ipc项目', 'Ipc项目', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    106. 

  106. INSERT INTO `base_itemdetails` VALUES (177, '', 208, NULL, 'Ipc项目2', 'Ipc项目2', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, '2019-09-11 09:48:07', NULL, NULL);
    107. 

  107. INSERT INTO `base_itemdetails` VALUES (178, '', 209, NULL, '感冒', '感冒', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    108. 

  108. INSERT INTO `base_itemdetails` VALUES (179, '', 209, NULL, '发烧', '发烧', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    109. 

  109. INSERT INTO `base_itemdetails` VALUES (180, '', 209, NULL, '头疼', '头疼', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    110. 

  110. INSERT INTO `base_itemdetails` VALUES (181, '', 210, NULL, '第一类医疗设备', '第一类医疗设备', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    111. 

  111. INSERT INTO `base_itemdetails` VALUES (183, '', 210, NULL, '离心机', '离心机', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, '2018-03-22 09:50:34', NULL, NULL);
    112. 

  112. INSERT INTO `base_itemdetails` VALUES (184, '', 211, NULL, '个', '个', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    113. 

  113. INSERT INTO `base_itemdetails` VALUES (185, '', 211, NULL, '瓶', '瓶', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    114. 

  114. INSERT INTO `base_itemdetails` VALUES (186, '', 211, NULL, '箱', '箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    115. 

  115. INSERT INTO `base_itemdetails` VALUES (187, '', 211, NULL, '袋', '袋', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    116. 

  116. INSERT INTO `base_itemdetails` VALUES (188, '', 211, NULL, '支', '支', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    117. 

  117. INSERT INTO `base_itemdetails` VALUES (189, '', 211, NULL, '盒', '盒', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    118. 

  118. INSERT INTO `base_itemdetails` VALUES (190, '', 213, NULL, '赛默飞世尔', 'Thermo', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, '2018-03-21 17:32:33', NULL, NULL);
    119. 

  119. INSERT INTO `base_itemdetails` VALUES (191, '', 213, NULL, '罗氏', 'Roche', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, '2018-03-21 17:31:45', NULL, NULL);
    120. 

  120. INSERT INTO `base_itemdetails` VALUES (192, '', 213, NULL, 'BD', 'BD', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    121. 

  121. INSERT INTO `base_itemdetails` VALUES (193, '', 213, NULL, 'Life', 'Life', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    122. 

  122. INSERT INTO `base_itemdetails` VALUES (194, '', 213, NULL, 'Gibco', 'Gibco', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    123. 

  123. INSERT INTO `base_itemdetails` VALUES (200, 'sQLQ4', 206, NULL, '顺丰', '顺丰', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    124. 

  124. INSERT INTO `base_itemdetails` VALUES (201, 'sQLQ4', 206, NULL, '邮政', '邮政', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    125. 

  125. INSERT INTO `base_itemdetails` VALUES (202, 'sQLQ4', 208, NULL, 'iPSCs制备', 'iPSCs制备a\'a', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, '2018-06-10 09:46:59', NULL, NULL);
    126. 

  126. INSERT INTO `base_itemdetails` VALUES (203, 'sQLQ4', 204, NULL, 'iPSCs细胞制备', 'iPSCs细胞制备', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    127. 

  127. INSERT INTO `base_itemdetails` VALUES (204, 'sQLQ4', 199, NULL, 'ml', 'ml', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    128. 

  128. INSERT INTO `base_itemdetails` VALUES (205, 'sQLQ4', 199, NULL, 'g', 'g', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    129. 

  129. INSERT INTO `base_itemdetails` VALUES (206, 'sQLQ4', 210, NULL, '离心机', '离心机', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    130. 

  130. INSERT INTO `base_itemdetails` VALUES (207, 'sQLQ4', 209, NULL, '心脏病', '心脏病', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    131. 

  131. INSERT INTO `base_itemdetails` VALUES (208, 'sQLQ4', 209, NULL, '冠心病', '冠心病', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    132. 

  132. INSERT INTO `base_itemdetails` VALUES (209, 'sQLQ4', 211, NULL, '个', '个', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    133. 

  133. INSERT INTO `base_itemdetails` VALUES (210, 'sQLQ4', 211, NULL, '盒', '盒', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    134. 

  134. INSERT INTO `base_itemdetails` VALUES (211, 'sQLQ4', 211, NULL, '箱', '箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    135. 

  135. INSERT INTO `base_itemdetails` VALUES (212, 'sQLQ4', 212, NULL, 'Thermo', 'Thermo', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, '2018-05-03 14:23:59', NULL, NULL);
    136. 

  136. INSERT INTO `base_itemdetails` VALUES (213, 'sQLQ4', 213, NULL, '品牌1', '品牌1', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    137. 

  137. INSERT INTO `base_itemdetails` VALUES (216, 'sQLQ4', 215, NULL, '国有企业', '国有企业', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    138. 

  138. INSERT INTO `base_itemdetails` VALUES (217, 'sQLQ4', 216, NULL, '样本异常', '样本异常', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    139. 

  139. INSERT INTO `base_itemdetails` VALUES (218, 's4JrT', 204, NULL, 'iPSCs制备', 'iPSCs制备', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    140. 

  140. INSERT INTO `base_itemdetails` VALUES (219, 's4JrT', 206, NULL, '顺丰', '顺丰', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    141. 

  141. INSERT INTO `base_itemdetails` VALUES (220, 's4JrT', 206, NULL, '邮政', '邮政', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    142. 

  142. INSERT INTO `base_itemdetails` VALUES (221, 's4JrT', 208, NULL, 'iPSCs项目', 'iPSCs项目', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    143. 

  143. INSERT INTO `base_itemdetails` VALUES (225, 's4JrT', 209, NULL, '乙肝', '乙肝', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    144. 

  144. INSERT INTO `base_itemdetails` VALUES (226, 's4JrT', 209, NULL, '高血压', '高血压', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    145. 

  145. INSERT INTO `base_itemdetails` VALUES (228, 's4JrT', 211, NULL, '个', '个', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    146. 

  146. INSERT INTO `base_itemdetails` VALUES (229, 's4JrT', 211, NULL, '支', '支', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    147. 

  147. INSERT INTO `base_itemdetails` VALUES (230, 's4JrT', 211, NULL, '盒', '盒', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    148. 

  148. INSERT INTO `base_itemdetails` VALUES (231, 's4JrT', 211, NULL, '箱', '箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    149. 

  149. INSERT INTO `base_itemdetails` VALUES (233, 's4JrT', 213, NULL, '品牌A', '品牌A', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    150. 

  150. INSERT INTO `base_itemdetails` VALUES (236, 's4JrT', 215, NULL, '国有企业', '国有企业', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    151. 

  151. INSERT INTO `base_itemdetails` VALUES (237, 's4JrT', 215, NULL, '合资企业', '合资企业', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    152. 

  152. INSERT INTO `base_itemdetails` VALUES (238, 's4JrT', 216, NULL, '样本异常', '样本异常', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    153. 

  153. INSERT INTO `base_itemdetails` VALUES (239, 's4JrT', 199, NULL, '10^6', '10^6', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    154. 

  154. INSERT INTO `base_itemdetails` VALUES (241, 's4JrT', 210, NULL, '洁净工作台', '洁净工作台', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    155. 

  155. INSERT INTO `base_itemdetails` VALUES (242, 's4JrT', 210, NULL, '生物安全柜', '生物安全柜', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    156. 

  156. INSERT INTO `base_itemdetails` VALUES (243, 's4JrT', 210, NULL, '倒置荧光显微镜', '倒置荧光显微镜', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    157. 

  157. INSERT INTO `base_itemdetails` VALUES (244, 's4JrT', 210, NULL, '4℃医用冰箱', '4℃医用冰箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    158. 

  158. INSERT INTO `base_itemdetails` VALUES (245, 's4JrT', 210, NULL, '负20℃医用冰箱', '负20℃医用冰箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    159. 

  159. INSERT INTO `base_itemdetails` VALUES (246, 's4JrT', 210, NULL, '负80℃超低温冰箱', '负80℃超低温冰箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    160. 

  160. INSERT INTO `base_itemdetails` VALUES (247, 's4JrT', 210, NULL, '液氮罐', '液氮罐', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    161. 

  161. INSERT INTO `base_itemdetails` VALUES (248, 's4JrT', 210, NULL, '灭菌柜', '灭菌柜', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    162. 

  162. INSERT INTO `base_itemdetails` VALUES (249, 's4JrT', 210, NULL, '三分类血液分析仪', '三分类血液分析仪', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    163. 

  163. INSERT INTO `base_itemdetails` VALUES (250, 's4JrT', 210, NULL, '自动细胞计数仪', '自动细胞计数仪', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    164. 

  164. INSERT INTO `base_itemdetails` VALUES (251, 's4JrT', 210, NULL, '微生物培养仪', '微生物培养仪', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    165. 

  165. INSERT INTO `base_itemdetails` VALUES (252, 's4JrT', 210, NULL, '流式细胞仪', '流式细胞仪', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    166. 

  166. INSERT INTO `base_itemdetails` VALUES (253, 's4JrT', 210, NULL, '光学显微镜', '光学显微镜', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    167. 

  167. INSERT INTO `base_itemdetails` VALUES (258, 'sQLQ4', 212, NULL, 'Meck', 'Meck', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    168. 

  168. INSERT INTO `base_itemdetails` VALUES (259, 'sQLQ4', 212, NULL, 'Corning', 'Corning', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    169. 

  169. INSERT INTO `base_itemdetails` VALUES (260, 'sQLQ4', 212, NULL, 'R&D', 'R&D', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    170. 

  170. INSERT INTO `base_itemdetails` VALUES (261, 'sQLQ4', 212, NULL, 'BD', 'BD', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    171. 

  171. INSERT INTO `base_itemdetails` VALUES (262, 'sQLQ4', 213, NULL, 'Gibco', 'Gibco', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    172. 

  172. INSERT INTO `base_itemdetails` VALUES (263, 'sQLQ4', 213, NULL, 'Invitrogen', 'Invitrogen', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    173. 

  173. INSERT INTO `base_itemdetails` VALUES (264, 'sQLQ4', 213, NULL, 'Hyclone', 'Hyclone', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    174. 

  174. INSERT INTO `base_itemdetails` VALUES (265, 'sQLQ4', 213, NULL, 'Nunc', 'Nunc', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    175. 

  175. INSERT INTO `base_itemdetails` VALUES (266, 's4JrT', 212, NULL, '厂商B', '物料B', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    176. 

  176. INSERT INTO `base_itemdetails` VALUES (267, 's4JrT', 218, NULL, '实验异常', '实验结果异常，存在异常数据', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    177. 

  177. INSERT INTO `base_itemdetails` VALUES (268, 's4JrT', 218, NULL, '实验正常', '实验结果正常，无异常现象', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    178. 

  178. INSERT INTO `base_itemdetails` VALUES (269, 's4JrT', 219, NULL, '审核通过', '数据、操作正常，无异常数据，审核通过', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    179. 

  179. INSERT INTO `base_itemdetails` VALUES (270, 's4JrT', 219, NULL, '审核不通过', '数据、操作存在异常，审核不通过', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    180. 

  180. INSERT INTO `base_itemdetails` VALUES (271, 'sD8gC', 199, NULL, '毫克', 'mg', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    181. 

  181. INSERT INTO `base_itemdetails` VALUES (272, 'sD8gC', 199, NULL, '克', 'g', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    182. 

  182. INSERT INTO `base_itemdetails` VALUES (273, 'sD8gC', 199, NULL, '毫升', 'ml', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    183. 

  183. INSERT INTO `base_itemdetails` VALUES (274, 'sD8gC', 204, NULL, 'iPSCs制备', 'iPSCs制备', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    184. 

  184. INSERT INTO `base_itemdetails` VALUES (275, 'sD8gC', 204, NULL, 'SCNT移植', 'SCNT移植', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    185. 

  185. INSERT INTO `base_itemdetails` VALUES (276, 'sD8gC', 204, NULL, 'CRSIPR', 'CRSIPR', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    186. 

  186. INSERT INTO `base_itemdetails` VALUES (277, 'sD8gC', 204, NULL, '综合类', '综合类', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, '2018-12-25 17:37:57', NULL, NULL);
    187. 

  187. INSERT INTO `base_itemdetails` VALUES (278, 'sD8gC', 206, NULL, '邮政', '邮政', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, '2018-05-16 17:41:19', NULL, NULL);
    188. 

  188. INSERT INTO `base_itemdetails` VALUES (279, 'sD8gC', 206, NULL, '顺丰', '顺丰', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, '2018-05-16 17:41:14', NULL, NULL);
    189. 

  189. INSERT INTO `base_itemdetails` VALUES (280, 'sD8gC', 206, NULL, '中通', '中通', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, '2018-05-16 17:41:10', NULL, NULL);
    190. 

  190. INSERT INTO `base_itemdetails` VALUES (281, 'sD8gC', 206, NULL, '申通', '申通', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, '2018-05-16 17:41:05', NULL, NULL);
    191. 

  191. INSERT INTO `base_itemdetails` VALUES (282, 'sD8gC', 208, NULL, 'iPSCs项目', 'iPSCs项目', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    192. 

  192. INSERT INTO `base_itemdetails` VALUES (283, 'sD8gC', 208, NULL, 'CIK', 'CIK', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    193. 

  193. INSERT INTO `base_itemdetails` VALUES (284, 'sD8gC', 208, NULL, 'CRSIPR', 'CRSIPR', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    194. 

  194. INSERT INTO `base_itemdetails` VALUES (285, 'sD8gC', 208, NULL, 'SCNT', 'SCNT', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    195. 

  195. INSERT INTO `base_itemdetails` VALUES (286, 'sD8gC', 209, NULL, '高血压', '高血压', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    196. 

  196. INSERT INTO `base_itemdetails` VALUES (287, 'sD8gC', 209, NULL, '乙肝', '乙肝', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    197. 

  197. INSERT INTO `base_itemdetails` VALUES (290, 'sD8gC', 210, NULL, '流式细胞仪', '流式细胞仪', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, '2018-05-16 17:42:57', NULL, NULL);
    198. 

  198. INSERT INTO `base_itemdetails` VALUES (291, 'sD8gC', 210, NULL, '微生物培养仪', '微生物培养仪', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, '2018-05-16 17:42:53', NULL, NULL);
    199. 

  199. INSERT INTO `base_itemdetails` VALUES (292, 'sD8gC', 210, NULL, '自动细胞计数仪', '自动细胞计数仪', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, '2018-05-16 17:42:49', NULL, NULL);
    200. 

  200. INSERT INTO `base_itemdetails` VALUES (293, 'sD8gC', 210, NULL, '三分类血液分析仪', '三分类血液分析仪', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, '2018-05-16 17:42:45', NULL, NULL);
    201. 

  201. INSERT INTO `base_itemdetails` VALUES (294, 'sD8gC', 210, NULL, '离心机', '离心机', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, '2018-05-16 17:42:41', NULL, NULL);
    202. 

  202. INSERT INTO `base_itemdetails` VALUES (295, 'sD8gC', 210, NULL, '灭菌柜', '灭菌柜', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, '2018-05-16 17:42:37', NULL, NULL);
    203. 

  203. INSERT INTO `base_itemdetails` VALUES (296, 'sD8gC', 210, NULL, '液氮罐', '液氮罐', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, '2018-05-16 17:42:32', NULL, NULL);
    204. 

  204. INSERT INTO `base_itemdetails` VALUES (297, 'sD8gC', 210, NULL, '负80℃超低温冰箱', '负80℃超低温冰箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, '2018-05-16 17:42:27', NULL, NULL);
    205. 

  205. INSERT INTO `base_itemdetails` VALUES (298, 'sD8gC', 210, NULL, '负20℃医用冰箱', '负20℃医用冰箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, '2018-05-16 17:42:22', NULL, NULL);
    206. 

  206. INSERT INTO `base_itemdetails` VALUES (299, 'sD8gC', 210, NULL, '4℃医用冰箱', '4℃医用冰箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, '2018-05-16 17:42:18', NULL, NULL);
    207. 

  207. INSERT INTO `base_itemdetails` VALUES (300, 'sD8gC', 210, NULL, '生物安全柜', '生物安全柜', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, '2018-05-16 17:42:14', NULL, NULL);
    208. 

  208. INSERT INTO `base_itemdetails` VALUES (301, 'sD8gC', 210, NULL, 'CO2培养箱', 'CO2培养箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, '2018-05-16 17:42:08', NULL, NULL);
    209. 

  209. INSERT INTO `base_itemdetails` VALUES (302, 'sD8gC', 210, NULL, '光学显微镜', '光学显微镜', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, '2018-05-16 17:42:03', NULL, NULL);
    210. 

  210. INSERT INTO `base_itemdetails` VALUES (303, 'sD8gC', 210, NULL, '倒置荧光显微镜', '倒置荧光显微镜', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, '2018-05-16 17:41:59', NULL, NULL);
    211. 

  211. INSERT INTO `base_itemdetails` VALUES (304, 'sD8gC', 210, NULL, '洁净工作台', '洁净工作台', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, '2018-05-16 17:41:39', NULL, NULL);
    212. 

  212. INSERT INTO `base_itemdetails` VALUES (305, 'sD8gC', 211, NULL, '个', '个', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, '2018-05-16 18:03:50', NULL, NULL);
    213. 

  213. INSERT INTO `base_itemdetails` VALUES (306, 'sD8gC', 211, NULL, '支', '支', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, '2018-05-16 18:03:47', NULL, NULL);
    214. 

  214. INSERT INTO `base_itemdetails` VALUES (307, 'sD8gC', 211, NULL, '袋', '袋', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, '2018-05-16 18:03:43', NULL, NULL);
    215. 

  215. INSERT INTO `base_itemdetails` VALUES (308, 'sD8gC', 211, NULL, '盒', '盒', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, '2018-05-16 18:03:39', NULL, NULL);
    216. 

  216. INSERT INTO `base_itemdetails` VALUES (309, 'sD8gC', 211, NULL, '箱', '箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, '2018-05-16 18:03:36', NULL, NULL);
    217. 

  217. INSERT INTO `base_itemdetails` VALUES (310, 'sD8gC', 212, NULL, '合宙通信', '合宙通信', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, '2018-06-12 15:03:51', NULL, NULL);
    218. 

  218. INSERT INTO `base_itemdetails` VALUES (311, 'sD8gC', 212, NULL, '大数', '大数', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, '2018-06-21 17:20:09', NULL, NULL);
    219. 

  219. INSERT INTO `base_itemdetails` VALUES (312, 'sD8gC', 212, NULL, '厂商C', '厂商C', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, '2018-05-16 17:43:15', NULL, NULL);
    220. 

  220. INSERT INTO `base_itemdetails` VALUES (313, 'sD8gC', 213, NULL, '普天', '普天', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, '2018-05-16 17:43:49', NULL, NULL);
    221. 

  221. INSERT INTO `base_itemdetails` VALUES (315, 'sD8gC', 213, NULL, 'Thermo Nunc', 'Thermo Nunc', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, '2018-05-16 17:43:45', NULL, NULL);
    222. 

  222. INSERT INTO `base_itemdetails` VALUES (316, 'sD8gC', 213, NULL, '中国移动', '中国移动', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, '2018-06-12 15:06:21', NULL, NULL);
    223. 

  223. INSERT INTO `base_itemdetails` VALUES (322, 'sD8gC', 215, NULL, '国有企业', '国有企业', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, '2018-05-16 17:44:34', NULL, NULL);
    224. 

  224. INSERT INTO `base_itemdetails` VALUES (323, 'sD8gC', 215, NULL, '私营企业', '私营企业', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, '2018-05-16 17:44:31', NULL, NULL);
    225. 

  225. INSERT INTO `base_itemdetails` VALUES (324, 'sD8gC', 215, NULL, '合资企业', '合资企业', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, '2018-05-16 17:44:27', NULL, NULL);
    226. 

  226. INSERT INTO `base_itemdetails` VALUES (325, 'sD8gC', 216, NULL, '温度过高，样本失效', '温度过高，样本失效', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, '2018-05-16 17:46:35', NULL, NULL);
    227. 

  227. INSERT INTO `base_itemdetails` VALUES (326, 'sD8gC', 218, NULL, '实验正常', '实验结果正常，无异常现象', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    228. 

  228. INSERT INTO `base_itemdetails` VALUES (327, 'sD8gC', 218, NULL, '实验异常', '实验结果异常，存在异常数据', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    229. 

  229. INSERT INTO `base_itemdetails` VALUES (328, 'sD8gC', 219, NULL, '审核不通过', '数据、操作存在异常，审核不通过', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    230. 

  230. INSERT INTO `base_itemdetails` VALUES (329, 'sD8gC', 219, NULL, '审核通过', '数据、操作正常，无异常数据，审核通过', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    231. 

  231. INSERT INTO `base_itemdetails` VALUES (330, 'sD8gC', 216, NULL, '运输时间过长，样本失效', '运输时间过长，样本失效', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    232. 

  232. INSERT INTO `base_itemdetails` VALUES (331, 'sD8gC', 211, NULL, '瓶', '瓶', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    233. 

  233. INSERT INTO `base_itemdetails` VALUES (334, 'sQLQ4', 215, NULL, '医院', '医院', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, '2018-05-29 10:55:00', NULL, NULL);
    234. 

  234. INSERT INTO `base_itemdetails` VALUES (335, 'sQLQ4', 215, NULL, '高校', '高校课题组', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    235. 

  235. INSERT INTO `base_itemdetails` VALUES (336, 'sQLQ4', 215, NULL, '有限责任公司', '有限责任公司', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    236. 

  236. INSERT INTO `base_itemdetails` VALUES (337, 'sQLQ4', 215, NULL, '股份有限公司', '股份有限公司', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    237. 

  237. INSERT INTO `base_itemdetails` VALUES (338, 'sQLQ4', 215, NULL, '其他', '其他', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    238. 

  238. INSERT INTO `base_itemdetails` VALUES (339, 'sQLQ4', 215, NULL, '科研单位', '科研单位', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    239. 

  239. INSERT INTO `base_itemdetails` VALUES (340, 'sQLQ4', 208, NULL, 'iPSCs-心肌分化', 'iPSCs-心肌分化', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    240. 

  240. INSERT INTO `base_itemdetails` VALUES (341, 'sQLQ4', 208, NULL, 'iPSCs-神经分化', 'iPSCs-神经分化', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    241. 

  241. INSERT INTO `base_itemdetails` VALUES (342, 'sD8gC', 211, NULL, '张', '张', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    242. 

  242. INSERT INTO `base_itemdetails` VALUES (343, 'sUUKC', 215, NULL, '001', '001', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    243. 

  243. INSERT INTO `base_itemdetails` VALUES (344, 'sUUKC', 204, NULL, '业务01', '01', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    244. 

  244. INSERT INTO `base_itemdetails` VALUES (345, 'sUUKC', 199, NULL, 'ML', 'ML', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    245. 

  245. INSERT INTO `base_itemdetails` VALUES (346, 'sUUKC', 209, NULL, '疾病类型01', '01', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    246. 

  246. INSERT INTO `base_itemdetails` VALUES (347, 'sUUKC', 213, NULL, '22', '22', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    247. 

  247. INSERT INTO `base_itemdetails` VALUES (349, 'sD8gC', 213, NULL, '大数', '大数', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    248. 

  248. INSERT INTO `base_itemdetails` VALUES (350, 'sD8gC', 211, NULL, '台', '台', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    249. 

  249. INSERT INTO `base_itemdetails` VALUES (351, 'sUUKC', 208, NULL, '抗凝血', '1', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    250. 

  250. INSERT INTO `base_itemdetails` VALUES (352, 'sUUKC', 211, NULL, '支', '1', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    251. 

  251. INSERT INTO `base_itemdetails` VALUES (354, 'sAGCH', 199, NULL, '毫升', 'mL', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    252. 

  252. INSERT INTO `base_itemdetails` VALUES (355, 'sAGCH', 204, NULL, '脐血保存', '脐血保存', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    253. 

  253. INSERT INTO `base_itemdetails` VALUES (356, 'sAGCH', 215, NULL, '医院', '医院', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    254. 

  254. INSERT INTO `base_itemdetails` VALUES (357, 'sYzpG', 199, NULL, 'g', 'g', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    255. 

  255. INSERT INTO `base_itemdetails` VALUES (358, 'sYzpG', 199, NULL, 'mL', 'mL', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    256. 

  256. INSERT INTO `base_itemdetails` VALUES (359, 'sYzpG', 204, NULL, 'iPSCs细胞制备', 'iPSCs细胞制备', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    257. 

  257. INSERT INTO `base_itemdetails` VALUES (360, 'sYzpG', 206, NULL, '顺丰', '顺丰', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    258. 

  258. INSERT INTO `base_itemdetails` VALUES (361, 'sYzpG', 208, NULL, 'iPSCs-心肌分化', 'iPSCs-心肌分化', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    259. 

  259. INSERT INTO `base_itemdetails` VALUES (362, 'sYzpG', 209, NULL, '冠心病', '冠心病', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    260. 

  260. INSERT INTO `base_itemdetails` VALUES (363, 'sYzpG', 209, NULL, '心脏病', '心脏病', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    261. 

  261. INSERT INTO `base_itemdetails` VALUES (365, 'sYzpG', 211, NULL, '箱', '箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    262. 

  262. INSERT INTO `base_itemdetails` VALUES (366, 'sYzpG', 211, NULL, '盒', '盒', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    263. 

  263. INSERT INTO `base_itemdetails` VALUES (367, 'sYzpG', 211, NULL, '个', '个', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    264. 

  264. INSERT INTO `base_itemdetails` VALUES (368, 'sYzpG', 212, NULL, 'BD', 'BD', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    265. 

  265. INSERT INTO `base_itemdetails` VALUES (369, 'sYzpG', 212, NULL, 'R&D', 'R&D', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    266. 

  266. INSERT INTO `base_itemdetails` VALUES (370, 'sYzpG', 212, NULL, 'Thermo', 'Thermo', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    267. 

  267. INSERT INTO `base_itemdetails` VALUES (371, 'sYzpG', 212, NULL, 'Corning', 'Corning', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    268. 

  268. INSERT INTO `base_itemdetails` VALUES (372, 'sYzpG', 213, NULL, 'Gibco', 'Gibco', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    269. 

  269. INSERT INTO `base_itemdetails` VALUES (373, 'sYzpG', 213, NULL, 'Invitrogen', 'Invitrogen', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    270. 

  270. INSERT INTO `base_itemdetails` VALUES (374, 'sYzpG', 213, NULL, 'Hyclone', 'Hyclone', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    271. 

  271. INSERT INTO `base_itemdetails` VALUES (380, 'sYzpG', 216, NULL, '样本异常', '样本异常', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    272. 

  272. INSERT INTO `base_itemdetails` VALUES (381, 'sYzpG', 215, NULL, '科研单位', '科研单位', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    273. 

  273. INSERT INTO `base_itemdetails` VALUES (382, 'sYzpG', 215, NULL, '医院', '医院', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    274. 

  274. INSERT INTO `base_itemdetails` VALUES (383, 'sYzpG', 215, NULL, '高校', '高校', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    275. 

  275. INSERT INTO `base_itemdetails` VALUES (384, 'sYzpG', 215, NULL, '私营企业', '私营企业', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    276. 

  276. INSERT INTO `base_itemdetails` VALUES (385, 'sYzpG', 218, NULL, '实验正常', '实验结果正常，无异常现象', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    277. 

  277. INSERT INTO `base_itemdetails` VALUES (386, 'sYzpG', 218, NULL, '实验异常', '实验结果异常，存在异常数据', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    278. 

  278. INSERT INTO `base_itemdetails` VALUES (387, 'sYzpG', 219, NULL, '审核不通过', '数据、操作存在异常，审核不通过', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    279. 

  279. INSERT INTO `base_itemdetails` VALUES (388, 'sYzpG', 219, NULL, '审核通过', '数据、操作正常，无异常数据，审核通过', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    280. 

  280. INSERT INTO `base_itemdetails` VALUES (389, 'sYzpG', 213, NULL, 'Nunc', 'Nunc', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    281. 

  281. INSERT INTO `base_itemdetails` VALUES (390, 's4JrT', 212, NULL, 'Thermo', 'Thermo', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    282. 

  282. INSERT INTO `base_itemdetails` VALUES (391, 's4JrT', 212, NULL, 'Meck', 'Meck', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    283. 

  283. INSERT INTO `base_itemdetails` VALUES (392, 's4JrT', 212, NULL, 'Corning', 'Corning', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    284. 

  284. INSERT INTO `base_itemdetails` VALUES (393, 's4JrT', 213, NULL, 'Nunc', 'Nunc', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    285. 

  285. INSERT INTO `base_itemdetails` VALUES (394, 's4JrT', 213, NULL, 'Hyclone', 'Hyclone', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    286. 

  286. INSERT INTO `base_itemdetails` VALUES (395, 's4JrT', 213, NULL, 'Invitrogen', 'Invitrogen', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    287. 

  287. INSERT INTO `base_itemdetails` VALUES (396, 's4JrT', 213, NULL, 'Gibco', 'Gibco', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    288. 

  288. INSERT INTO `base_itemdetails` VALUES (397, 'sAGCH', 206, NULL, '顺丰', '顺丰', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    289. 

  289. INSERT INTO `base_itemdetails` VALUES (398, 'sAGCH', 212, NULL, 'Thermo', 'Thermo', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    290. 

  290. INSERT INTO `base_itemdetails` VALUES (399, 'sAGCH', 212, NULL, 'Meck', 'Meck', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    291. 

  291. INSERT INTO `base_itemdetails` VALUES (400, 'sAGCH', 211, NULL, '箱', '箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    292. 

  292. INSERT INTO `base_itemdetails` VALUES (401, 'sAGCH', 211, NULL, '盒', '盒', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    293. 

  293. INSERT INTO `base_itemdetails` VALUES (402, 'sAGCH', 211, NULL, '个', '个', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    294. 

  294. INSERT INTO `base_itemdetails` VALUES (403, 'sAGCH', 211, NULL, '袋', '袋', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    295. 

  295. INSERT INTO `base_itemdetails` VALUES (404, 'sAGCH', 211, NULL, '支', '支', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    296. 

  296. INSERT INTO `base_itemdetails` VALUES (405, 'sAGCH', 213, NULL, 'Nunc', 'Nunc', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    297. 

  297. INSERT INTO `base_itemdetails` VALUES (406, 'sAGCH', 213, NULL, 'Invitrogen', 'Invitrogen', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    298. 

  298. INSERT INTO `base_itemdetails` VALUES (407, 'sAGCH', 213, NULL, 'Hyclone', 'Hyclone', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    299. 

  299. INSERT INTO `base_itemdetails` VALUES (408, 'sAGCH', 213, NULL, 'Gibco', 'Gibco', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    300. 

  300. INSERT INTO `base_itemdetails` VALUES (409, 'sAGCH', 210, NULL, '离心机', '离心机', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    301. 

  301. INSERT INTO `base_itemdetails` VALUES (410, 'sAGCH', 208, NULL, '脐带', '脐带', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    302. 

  302. INSERT INTO `base_itemdetails` VALUES (411, 'sAGCH', 209, NULL, '高血压', '高血压', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    303. 

  303. INSERT INTO `base_itemdetails` VALUES (412, 'sAGCH', 209, NULL, '乙肝', '乙肝', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    304. 

  304. INSERT INTO `base_itemdetails` VALUES (413, 'sAGCH', 219, NULL, '审核不通过', '数据、操作存在异常，审核不通过', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    305. 

  305. INSERT INTO `base_itemdetails` VALUES (414, 'sAGCH', 219, NULL, '审核通过', '数据、操作正常，无异常数据，审核通过', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    306. 

  306. INSERT INTO `base_itemdetails` VALUES (415, 'sAGCH', 218, NULL, '实验正常', '实验结果正常，无异常现象', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    307. 

  307. INSERT INTO `base_itemdetails` VALUES (416, 'sAGCH', 218, NULL, '实验异常', '实验结果异常，存在异常数据', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    308. 

  308. INSERT INTO `base_itemdetails` VALUES (417, 'sAGCH', 216, NULL, '样本异常', '样本异常', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    309. 

  309. INSERT INTO `base_itemdetails` VALUES (418, '', 204, NULL, '细胞制备', '细胞制备', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    310. 

  310. INSERT INTO `base_itemdetails` VALUES (419, '', 206, NULL, '顺丰', '顺丰', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    311. 

  311. INSERT INTO `base_itemdetails` VALUES (420, '', 208, NULL, '细胞制备', '细胞制备', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    312. 

  312. INSERT INTO `base_itemdetails` VALUES (421, '', 199, NULL, '毫升', 'mL', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    313. 

  313. INSERT INTO `base_itemdetails` VALUES (422, '', 199, NULL, '毫克', 'mg', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    314. 

  314. INSERT INTO `base_itemdetails` VALUES (423, '', 209, NULL, '乙肝', '乙肝', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    315. 

  315. INSERT INTO `base_itemdetails` VALUES (424, '', 209, NULL, '高血压', '高血压', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    316. 

  316. INSERT INTO `base_itemdetails` VALUES (426, '', 211, NULL, '支', '支', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    317. 

  317. INSERT INTO `base_itemdetails` VALUES (427, '', 211, NULL, '袋', '袋', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    318. 

  318. INSERT INTO `base_itemdetails` VALUES (428, '', 211, NULL, '个', '个', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    319. 

  319. INSERT INTO `base_itemdetails` VALUES (429, '', 211, NULL, '盒', '盒', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    320. 

  320. INSERT INTO `base_itemdetails` VALUES (430, '', 211, NULL, '箱', '箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    321. 

  321. INSERT INTO `base_itemdetails` VALUES (431, '', 212, NULL, 'Meck', 'Meck', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    322. 

  322. INSERT INTO `base_itemdetails` VALUES (432, '', 212, NULL, 'Thermo', 'Thermo', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    323. 

  323. INSERT INTO `base_itemdetails` VALUES (433, '', 213, NULL, 'Gibco', 'Gibco', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    324. 

  324. INSERT INTO `base_itemdetails` VALUES (434, '', 213, NULL, 'Hyclone', 'Hyclone', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    325. 

  325. INSERT INTO `base_itemdetails` VALUES (435, '', 213, NULL, 'Invitrogen', 'Invitrogen', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    326. 

  326. INSERT INTO `base_itemdetails` VALUES (436, '', 213, NULL, 'Nunc', 'Nunc', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    327. 

  327. INSERT INTO `base_itemdetails` VALUES (438, '', 216, NULL, '样本异常', '样本异常', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    328. 

  328. INSERT INTO `base_itemdetails` VALUES (439, '', 218, NULL, '实验异常', ' 实验结果异常，存在异常数据', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    329. 

  329. INSERT INTO `base_itemdetails` VALUES (440, '', 218, NULL, '实验正常', '实验结果正常，无异常现象', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    330. 

  330. INSERT INTO `base_itemdetails` VALUES (441, '', 219, NULL, '审核通过', '数据、操作正常，无异常数据，审核通过', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    331. 

  331. INSERT INTO `base_itemdetails` VALUES (442, '', 219, NULL, '审核不通过', '数据、操作存在异常，审核不通过', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    332. 

  332. INSERT INTO `base_itemdetails` VALUES (444, 'ssVtu', 210, NULL, '生物安全柜', '生物安全柜', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    333. 

  333. INSERT INTO `base_itemdetails` VALUES (445, 'ssVtu', 210, NULL, '细胞计数仪', '细胞计数仪', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    334. 

  334. INSERT INTO `base_itemdetails` VALUES (446, 'ssVtu', 210, NULL, '培养箱', '培养箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    335. 

  335. INSERT INTO `base_itemdetails` VALUES (447, 'ssVtu', 210, NULL, '冰箱', '冰箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    336. 

  336. INSERT INTO `base_itemdetails` VALUES (448, 'ssVtu', 210, NULL, '液氮罐', '液氮罐', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    337. 

  337. INSERT INTO `base_itemdetails` VALUES (449, 'ssVtu', 210, NULL, '显微镜', '显微镜', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    338. 

  338. INSERT INTO `base_itemdetails` VALUES (450, 'ssVtu', 210, NULL, '烘箱', '烘箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    339. 

  339. INSERT INTO `base_itemdetails` VALUES (451, 'ssVtu', 210, NULL, '灭菌锅', '灭菌锅', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    340. 

  340. INSERT INTO `base_itemdetails` VALUES (452, 'ssVtu', 210, NULL, '移液器', '移液器', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    341. 

  341. INSERT INTO `base_itemdetails` VALUES (453, 'ssVtu', 210, NULL, '电脑', '电脑', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    342. 

  342. INSERT INTO `base_itemdetails` VALUES (454, 'ssVtu', 210, NULL, '打印机', '打印机', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    343. 

  343. INSERT INTO `base_itemdetails` VALUES (455, 'ssVtu', 209, NULL, '阿尔兹海默症', 'AD', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, '2018-09-14 16:37:19', NULL, NULL);
    344. 

  344. INSERT INTO `base_itemdetails` VALUES (456, 'ssVtu', 209, NULL, '帕金森综合征', 'PD', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    345. 

  345. INSERT INTO `base_itemdetails` VALUES (457, 'ssVtu', 209, NULL, '抑郁症', '抑郁症', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    346. 

  346. INSERT INTO `base_itemdetails` VALUES (458, 'ssVtu', 209, NULL, '癫痫', '癫痫', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    347. 

  347. INSERT INTO `base_itemdetails` VALUES (459, 'ssVtu', 209, NULL, '心脏衰竭', '心脏衰竭', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    348. 

  348. INSERT INTO `base_itemdetails` VALUES (460, 'ssVtu', 209, NULL, '视网膜色素变性', '视网膜色素变性', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    349. 

  349. INSERT INTO `base_itemdetails` VALUES (461, 'ssVtu', 218, NULL, '正常', '正常', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    350. 

  350. INSERT INTO `base_itemdetails` VALUES (462, 'ssVtu', 218, NULL, '异常', '异常', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    351. 

  351. INSERT INTO `base_itemdetails` VALUES (463, 'ssVtu', 211, NULL, '箱', '箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    352. 

  352. INSERT INTO `base_itemdetails` VALUES (464, 'ssVtu', 211, NULL, '盒', '盒', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    353. 

  353. INSERT INTO `base_itemdetails` VALUES (465, 'ssVtu', 211, NULL, '袋', '袋', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    354. 

  354. INSERT INTO `base_itemdetails` VALUES (466, 'ssVtu', 211, NULL, '瓶', '瓶', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    355. 

  355. INSERT INTO `base_itemdetails` VALUES (467, 'ssVtu', 211, NULL, '支', '支', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    356. 

  356. INSERT INTO `base_itemdetails` VALUES (468, 'ssVtu', 211, NULL, 'g', 'g', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    357. 

  357. INSERT INTO `base_itemdetails` VALUES (469, 'ssVtu', 211, NULL, 'mg', 'mg', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    358. 

  358. INSERT INTO `base_itemdetails` VALUES (470, 'ssVtu', 211, NULL, 'ug', 'ug', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    359. 

  359. INSERT INTO `base_itemdetails` VALUES (471, 'ssVtu', 211, NULL, 'L', 'L', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    360. 

  360. INSERT INTO `base_itemdetails` VALUES (472, 'ssVtu', 211, NULL, 'mL', 'mL', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    361. 

  361. INSERT INTO `base_itemdetails` VALUES (473, 'ssVtu', 211, NULL, 'uL', 'uL', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    362. 

  362. INSERT INTO `base_itemdetails` VALUES (474, 'ssVtu', 211, NULL, '个', '个', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    363. 

  363. INSERT INTO `base_itemdetails` VALUES (475, 'ssVtu', 213, NULL, 'Nunc', 'Nunc', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    364. 

  364. INSERT INTO `base_itemdetails` VALUES (476, 'ssVtu', 213, NULL, 'Life', 'Life', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    365. 

  365. INSERT INTO `base_itemdetails` VALUES (477, 'ssVtu', 213, NULL, 'ABI', 'ABI', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    366. 

  366. INSERT INTO `base_itemdetails` VALUES (478, 'ssVtu', 213, NULL, 'RD', 'RD', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    367. 

  367. INSERT INTO `base_itemdetails` VALUES (479, 'ssVtu', 213, NULL, 'BD', 'BD', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    368. 

  368. INSERT INTO `base_itemdetails` VALUES (480, 'ssVtu', 213, NULL, '生工', '生工', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    369. 

  369. INSERT INTO `base_itemdetails` VALUES (481, 'ssVtu', 213, NULL, 'Sigma-Aldrich', 'Sigma-Aldrich', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    370. 

  370. INSERT INTO `base_itemdetails` VALUES (482, 'ssVtu', 213, NULL, 'Thermo', 'Thermo', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    371. 

  371. INSERT INTO `base_itemdetails` VALUES (483, 'ssVtu', 213, NULL, '其他', '其他', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    372. 

  372. INSERT INTO `base_itemdetails` VALUES (484, 'ssVtu', 209, NULL, '健康', '健康', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    373. 

  373. INSERT INTO `base_itemdetails` VALUES (485, 'ssVtu', 199, NULL, 'mL', 'mL', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    374. 

  374. INSERT INTO `base_itemdetails` VALUES (486, 'ssVtu', 199, NULL, 'g', 'g', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    375. 

  375. INSERT INTO `base_itemdetails` VALUES (487, 'ssVtu', 199, NULL, '10^6', '10^6', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    376. 

  376. INSERT INTO `base_itemdetails` VALUES (492, 'ssVtu', 219, NULL, '审核通过', '审核通过', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    377. 

  377. INSERT INTO `base_itemdetails` VALUES (493, 'ssVtu', 212, NULL, 'Thermo', 'Thermo', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    378. 

  378. INSERT INTO `base_itemdetails` VALUES (494, 'ssVtu', 212, NULL, 'Sigma-Aldrich', 'Sigma-Aldrich', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    379. 

  379. INSERT INTO `base_itemdetails` VALUES (495, 'ssVtu', 212, NULL, 'RD', 'RD', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    380. 

  380. INSERT INTO `base_itemdetails` VALUES (496, 'ssVtu', 212, NULL, 'BD', 'BD', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    381. 

  381. INSERT INTO `base_itemdetails` VALUES (497, 'ssVtu', 212, NULL, '生工', '生工', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    382. 

  382. INSERT INTO `base_itemdetails` VALUES (498, 'ssVtu', 212, NULL, '国药', '国药', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    383. 

  383. INSERT INTO `base_itemdetails` VALUES (499, 'ssVtu', 212, NULL, '其他', '其他', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    384. 

  384. INSERT INTO `base_itemdetails` VALUES (500, 'ssVtu', 204, NULL, 'iPSCs制备', 'iPSCs制备', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    385. 

  385. INSERT INTO `base_itemdetails` VALUES (501, 'ssVtu', 204, NULL, '神经干细胞分化', '神经干细胞分化', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    386. 

  386. INSERT INTO `base_itemdetails` VALUES (502, 'ssVtu', 204, NULL, '心肌细胞分化', '心肌细胞分化', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    387. 

  387. INSERT INTO `base_itemdetails` VALUES (503, 'ssVtu', 204, NULL, '肝脏细胞分化', '肝脏细胞分化', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    388. 

  388. INSERT INTO `base_itemdetails` VALUES (504, 'ssVtu', 208, NULL, 'iPSCs细胞系制备', 'iPSCs细胞系制备', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    389. 

  389. INSERT INTO `base_itemdetails` VALUES (506, 'ssVtu', 215, NULL, '企业', '企业', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    390. 

  390. INSERT INTO `base_itemdetails` VALUES (507, 'ssVtu', 215, NULL, '医院', '医院', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    391. 

  391. INSERT INTO `base_itemdetails` VALUES (508, 'ssVtu', 215, NULL, '科研机构', '科研机构', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    392. 

  392. INSERT INTO `base_itemdetails` VALUES (509, 'ssVtu', 215, NULL, '学校', '学校', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    393. 

  393. INSERT INTO `base_itemdetails` VALUES (510, 'ssVtu', 206, NULL, '顺丰快递', '顺丰快递', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    394. 

  394. INSERT INTO `base_itemdetails` VALUES (511, 'ssVtu', 206, NULL, '圆通快递', '圆通快递', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    395. 

  395. INSERT INTO `base_itemdetails` VALUES (512, 'ssVtu', 206, NULL, '中通快递', '中通快递', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    396. 

  396. INSERT INTO `base_itemdetails` VALUES (513, 'ssVtu', 206, NULL, 'EMS', 'EMS', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    397. 

  397. INSERT INTO `base_itemdetails` VALUES (514, 'ssVtu', 206, NULL, '申通快递', '申通快递', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    398. 

  398. INSERT INTO `base_itemdetails` VALUES (515, 'ssVtu', 206, NULL, '冷链公司-上海百奥泉', '冷链公司-上海百奥泉', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    399. 

  399. INSERT INTO `base_itemdetails` VALUES (516, 'ssVtu', 206, NULL, '韵达快递', '韵达快递', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    400. 

  400. INSERT INTO `base_itemdetails` VALUES (517, 'ssVtu', 206, NULL, '其他', '其他', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    401. 

  401. INSERT INTO `base_itemdetails` VALUES (518, 'ssVtu', 199, NULL, '支', '支', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    402. 

  402. INSERT INTO `base_itemdetails` VALUES (519, 'ssVtu', 210, NULL, '洗衣机', '洗衣机', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    403. 

  403. INSERT INTO `base_itemdetails` VALUES (520, 'ssVtu', 210, NULL, '水浴锅', '水浴锅', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    404. 

  404. INSERT INTO `base_itemdetails` VALUES (521, 'ssVtu', 210, NULL, '微波炉', '微波炉', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    405. 

  405. INSERT INTO `base_itemdetails` VALUES (522, 'ssVtu', 210, NULL, '真空泵', '真空泵', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, '2018-11-13 11:39:58', NULL, NULL);
    406. 

  406. INSERT INTO `base_itemdetails` VALUES (523, 'ssVtu', 210, NULL, 'PH计', 'PH计', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    407. 

  407. INSERT INTO `base_itemdetails` VALUES (524, 'ssVtu', 210, NULL, '纯净水仪', '纯净水仪', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    408. 

  408. INSERT INTO `base_itemdetails` VALUES (525, 'ssVtu', 210, NULL, '电子天平', '电子天平', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    409. 

  409. INSERT INTO `base_itemdetails` VALUES (526, 'ssVtu', 210, NULL, 'PCR仪', 'PCR仪', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, '2018-11-26 14:44:15', NULL, NULL);
    410. 

  410. INSERT INTO `base_itemdetails` VALUES (527, 'ssVtu', 210, NULL, '摇床', '摇床', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    411. 

  411. INSERT INTO `base_itemdetails` VALUES (528, 'ssVtu', 210, NULL, '电泳设备', '电泳设备', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    412. 

  412. INSERT INTO `base_itemdetails` VALUES (529, 'ssVtu', 210, NULL, '制冰机', '制冰机', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    413. 

  413. INSERT INTO `base_itemdetails` VALUES (530, 'ssVtu', 210, NULL, '旋涡混合仪', '旋涡混合仪', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    414. 

  414. INSERT INTO `base_itemdetails` VALUES (531, 'ssVtu', 210, NULL, '磁力搅拌器', '磁力搅拌器', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    415. 

  415. INSERT INTO `base_itemdetails` VALUES (532, 'ssVtu', 210, NULL, '电转染仪', '电转染仪', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    416. 

  416. INSERT INTO `base_itemdetails` VALUES (533, 'ssVtu', 210, NULL, '尘埃粒子计数器', '尘埃粒子计数器', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    417. 

  417. INSERT INTO `base_itemdetails` VALUES (534, 'ssVtu', 212, NULL, '英潍捷基', '英潍捷基', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    418. 

  418. INSERT INTO `base_itemdetails` VALUES (535, 'ssVtu', 212, NULL, 'CST', 'CST', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    419. 

  419. INSERT INTO `base_itemdetails` VALUES (536, 'ssVtu', 213, NULL, 'CST', 'CST', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    420. 

  420. INSERT INTO `base_itemdetails` VALUES (537, 'ssVtu', 212, NULL, 'Santa Cruz', 'Santa Cruz', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    421. 

  421. INSERT INTO `base_itemdetails` VALUES (538, 'ssVtu', 213, NULL, 'Santa Cruz', 'Santa Cruz', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    422. 

  422. INSERT INTO `base_itemdetails` VALUES (539, 'ssVtu', 212, NULL, 'Abcam', 'Abcam', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    423. 

  423. INSERT INTO `base_itemdetails` VALUES (540, 'ssVtu', 213, NULL, 'Abcam', 'Abcam', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    424. 

  424. INSERT INTO `base_itemdetails` VALUES (541, 'ssVtu', 212, NULL, 'SMOBio', 'SMOBio', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    425. 

  425. INSERT INTO `base_itemdetails` VALUES (542, 'ssVtu', 213, NULL, 'SMOBio', 'SMOBio', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    426. 

  426. INSERT INTO `base_itemdetails` VALUES (543, 'ssVtu', 211, NULL, 'RXN', 'RXN', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    427. 

  427. INSERT INTO `base_itemdetails` VALUES (544, 'ssVtu', 211, NULL, 'tst', 'tst', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    428. 

  428. INSERT INTO `base_itemdetails` VALUES (545, 'ssVtu', 212, NULL, 'Lonza', 'Lonza', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    429. 

  429. INSERT INTO `base_itemdetails` VALUES (546, 'ssVtu', 213, NULL, 'Lonza', 'Lonza', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    430. 

  430. INSERT INTO `base_itemdetails` VALUES (547, 'ssVtu', 211, NULL, '桶', '桶', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    431. 

  431. INSERT INTO `base_itemdetails` VALUES (548, 'ssVtu', 212, NULL, 'Stemcell', 'Stemcell', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    432. 

  432. INSERT INTO `base_itemdetails` VALUES (549, 'ssVtu', 213, NULL, 'Stemcell', 'Stemcell', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    433. 

  433. INSERT INTO `base_itemdetails` VALUES (550, 'ssVtu', 213, NULL, 'Axygene', 'Axygene', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    434. 

  434. INSERT INTO `base_itemdetails` VALUES (551, 'ssVtu', 213, NULL, 'Corning', 'Corning', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    435. 

  435. INSERT INTO `base_itemdetails` VALUES (552, 'ssVtu', 213, NULL, 'Biosharp', 'Biosharp', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    436. 

  436. INSERT INTO `base_itemdetails` VALUES (553, 'ssVtu', 212, NULL, 'Axygene', 'Axygene', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    437. 

  437. INSERT INTO `base_itemdetails` VALUES (554, 'ssVtu', 212, NULL, 'Corning', 'Corning', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    438. 

  438. INSERT INTO `base_itemdetails` VALUES (555, 'ssVtu', 212, NULL, 'Biosharp', 'Biosharp', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    439. 

  439. INSERT INTO `base_itemdetails` VALUES (556, 'ssVtu', 212, NULL, 'Falcon', 'Falcon', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    440. 

  440. INSERT INTO `base_itemdetails` VALUES (557, 'ssVtu', 213, NULL, 'Falcon', 'Falcon', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    441. 

  441. INSERT INTO `base_itemdetails` VALUES (558, 'ssVtu', 210, NULL, '凝胶成像设备', '凝胶成像设备', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    442. 

  442. INSERT INTO `base_itemdetails` VALUES (567, '', 210, NULL, '液氮存储罐', '液氮存储罐', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    443. 

  443. INSERT INTO `base_itemdetails` VALUES (568, '', 210, NULL, '提取设备', '自动化核酸提取仪', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    444. 

  444. INSERT INTO `base_itemdetails` VALUES (569, '', 210, NULL, '分析设备', '生物分析仪', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    445. 

  445. INSERT INTO `base_itemdetails` VALUES (570, '', 210, NULL, '分离设备', '台式低速离心机', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    446. 

  446. INSERT INTO `base_itemdetails` VALUES (571, '', 210, NULL, '分离设备1', '高速冷冻离心机', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    447. 

  447. INSERT INTO `base_itemdetails` VALUES (572, '', 210, NULL, '显微镜', '倒置显微镜', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    448. 

  448. INSERT INTO `base_itemdetails` VALUES (573, '', 210, NULL, '细胞计数仪', '细胞计数仪', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    449. 

  449. INSERT INTO `base_itemdetails` VALUES (574, '', 210, NULL, '生物安全柜', '生物安全柜', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    450. 

  450. INSERT INTO `base_itemdetails` VALUES (575, '', 210, NULL, ' 消毒设备', '立式压力灭菌器', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    451. 

  451. INSERT INTO `base_itemdetails` VALUES (576, '', 210, NULL, ' 培养箱', '二氧化碳培养箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    452. 

  452. INSERT INTO `base_itemdetails` VALUES (577, '', 210, NULL, ' 培养箱1', '生化培养箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    453. 

  453. INSERT INTO `base_itemdetails` VALUES (578, '', 210, NULL, '干燥箱', '鼓风干燥箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    454. 

  454. INSERT INTO `base_itemdetails` VALUES (579, '', 210, NULL, '恒温水浴箱', '恒温水浴箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    455. 

  455. INSERT INTO `base_itemdetails` VALUES (580, '', 210, NULL, '移液器', '电动移液器', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    456. 

  456. INSERT INTO `base_itemdetails` VALUES (581, '', 210, NULL, '移液器1', '手动移液器', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    457. 

  457. INSERT INTO `base_itemdetails` VALUES (582, '', 210, NULL, '医用热合机', '医用热合机', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    458. 

  458. INSERT INTO `base_itemdetails` VALUES (583, '', 210, NULL, '分装设备', '低温分装平台', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    459. 

  459. INSERT INTO `base_itemdetails` VALUES (584, '', 210, NULL, '分装设备1', '低温分装平台-小容量', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    460. 

  460. INSERT INTO `base_itemdetails` VALUES (585, '', 210, NULL, '纯水仪', '纯水仪', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    461. 

  461. INSERT INTO `base_itemdetails` VALUES (586, '', 210, NULL, '纯水系统', '实验室超纯水系统', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    462. 

  462. INSERT INTO `base_itemdetails` VALUES (587, '', 210, NULL, '冰箱', '4℃冰箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    463. 

  463. INSERT INTO `base_itemdetails` VALUES (588, '', 210, NULL, '冰箱1', '-40℃冰箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    464. 

  464. INSERT INTO `base_itemdetails` VALUES (589, '', 210, NULL, '制冰机', '制冰机', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    465. 

  465. INSERT INTO `base_itemdetails` VALUES (590, '', 210, NULL, '4度冷柜', '4度冷柜', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    466. 

  466. INSERT INTO `base_itemdetails` VALUES (591, '', 210, NULL, '洗衣机', '洗衣机', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    467. 

  467. INSERT INTO `base_itemdetails` VALUES (592, '', 210, NULL, '家用冰箱', '家用冰箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    468. 

  468. INSERT INTO `base_itemdetails` VALUES (593, '', 210, NULL, '办公设备', '激光打印机', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    469. 

  469. INSERT INTO `base_itemdetails` VALUES (594, '', 210, NULL, '扫描设备', '整盘扫描仪', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    470. 

  470. INSERT INTO `base_itemdetails` VALUES (595, '', 210, NULL, '暂存冰箱', '4℃暂存冰箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    471. 

  471. INSERT INTO `base_itemdetails` VALUES (596, '', 210, NULL, '程序降温仪', '程序降温仪', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    472. 

  472. INSERT INTO `base_itemdetails` VALUES (597, '', 210, NULL, '低温操作台', '2-8℃低温操作台', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    473. 

  473. INSERT INTO `base_itemdetails` VALUES (598, '', 210, NULL, '整理冰箱', '零下40℃超低温冰箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    474. 

  474. INSERT INTO `base_itemdetails` VALUES (599, '', 210, NULL, '液氮存储罐1', '便携式液氮罐', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    475. 

  475. INSERT INTO `base_itemdetails` VALUES (603, '', 199, NULL, '支', '支', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    476. 

  476. INSERT INTO `base_itemdetails` VALUES (604, '', 209, NULL, '健康', '健康', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    477. 

  477. INSERT INTO `base_itemdetails` VALUES (605, '', 211, NULL, '瓶', '瓶', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    478. 

  478. INSERT INTO `base_itemdetails` VALUES (611, '', 215, NULL, '个人', '个人', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    479. 

  479. INSERT INTO `base_itemdetails` VALUES (612, '', 215, NULL, '科研机构', '科研机构', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    480. 

  480. INSERT INTO `base_itemdetails` VALUES (613, '', 215, NULL, '医院', '医院', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    481. 

  481. INSERT INTO `base_itemdetails` VALUES (614, '', 215, NULL, '企业', '企业', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    482. 

  482. INSERT INTO `base_itemdetails` VALUES (616, '', 211, NULL, 'uL', 'uL', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    483. 

  483. INSERT INTO `base_itemdetails` VALUES (617, '', 208, NULL, '脐带血干细胞', '脐带血干细胞', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    484. 

  484. INSERT INTO `base_itemdetails` VALUES (618, '', 204, NULL, '脐带血干细胞', '脐带血干细胞', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    485. 

  485. INSERT INTO `base_itemdetails` VALUES (619, 'ssVtu', 209, NULL, '脂肪肝', '脂肪肝', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    486. 

  486. INSERT INTO `base_itemdetails` VALUES (620, 'ssVtu', 209, NULL, '肝硬化', '肝硬化', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    487. 

  487. INSERT INTO `base_itemdetails` VALUES (621, '', 199, NULL, '10^6', '10^6', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    488. 

  488. INSERT INTO `base_itemdetails` VALUES (622, 'sOcmO', 204, NULL, '脐带血干细胞', '脐带血干细胞', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    489. 

  489. INSERT INTO `base_itemdetails` VALUES (623, 'sOcmO', 204, NULL, '细胞制备', '细胞制备', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    490. 

  490. INSERT INTO `base_itemdetails` VALUES (624, 'sOcmO', 206, NULL, '顺丰', '顺丰', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    491. 

  491. INSERT INTO `base_itemdetails` VALUES (625, 'sOcmO', 206, NULL, '韵达', '韵达', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    492. 

  492. INSERT INTO `base_itemdetails` VALUES (626, 'sOcmO', 208, NULL, '脐带血干细胞', '脐带血干细胞', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    493. 

  493. INSERT INTO `base_itemdetails` VALUES (627, 'sOcmO', 208, NULL, '细胞制备', '细胞制备', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    494. 

  494. INSERT INTO `base_itemdetails` VALUES (628, 'sOcmO', 199, NULL, '毫克', 'mg', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    495. 

  495. INSERT INTO `base_itemdetails` VALUES (629, 'sOcmO', 199, NULL, '毫升', 'ml', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    496. 

  496. INSERT INTO `base_itemdetails` VALUES (630, 'sOcmO', 199, NULL, '支', '支', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    497. 

  497. INSERT INTO `base_itemdetails` VALUES (631, 'sOcmO', 199, NULL, '10^6', '10^6', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    498. 

  498. INSERT INTO `base_itemdetails` VALUES (632, 'sOcmO', 209, NULL, '高血压', '高血压', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    499. 

  499. INSERT INTO `base_itemdetails` VALUES (633, 'sOcmO', 209, NULL, '乙肝', '乙肝', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    500. 

  500. INSERT INTO `base_itemdetails` VALUES (634, 'sOcmO', 209, NULL, '健康', '健康', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    501. 

  501. INSERT INTO `base_itemdetails` VALUES (635, 'sOcmO', 210, NULL, '液氮存储罐1', '便携式液氮罐', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    502. 

  502. INSERT INTO `base_itemdetails` VALUES (636, 'sOcmO', 210, NULL, '整理冰箱', '零下40℃超低温冰箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    503. 

  503. INSERT INTO `base_itemdetails` VALUES (637, 'sOcmO', 210, NULL, '低温操作台', '2-8℃低温操作台', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    504. 

  504. INSERT INTO `base_itemdetails` VALUES (638, 'sOcmO', 210, NULL, '程序降温仪', '程序降温仪', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    505. 

  505. INSERT INTO `base_itemdetails` VALUES (639, 'sOcmO', 210, NULL, '暂存冰箱', '4℃暂存冰箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    506. 

  506. INSERT INTO `base_itemdetails` VALUES (640, 'sOcmO', 210, NULL, '扫描设备', '整盘扫描仪', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    507. 

  507. INSERT INTO `base_itemdetails` VALUES (641, 'sOcmO', 210, NULL, '办公设备', '激光打印机', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    508. 

  508. INSERT INTO `base_itemdetails` VALUES (642, 'sOcmO', 210, NULL, '家用冰箱', '家用冰箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    509. 

  509. INSERT INTO `base_itemdetails` VALUES (643, 'sOcmO', 210, NULL, '洗衣机', '洗衣机', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    510. 

  510. INSERT INTO `base_itemdetails` VALUES (644, 'sOcmO', 210, NULL, '4度冷柜', '4度冷柜', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    511. 

  511. INSERT INTO `base_itemdetails` VALUES (645, 'sOcmO', 210, NULL, '制冰机', '制冰机', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    512. 

  512. INSERT INTO `base_itemdetails` VALUES (646, 'sOcmO', 210, NULL, '冰箱1', '-40℃冰箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    513. 

  513. INSERT INTO `base_itemdetails` VALUES (647, 'sOcmO', 210, NULL, '冰箱', '4℃冰箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    514. 

  514. INSERT INTO `base_itemdetails` VALUES (648, 'sOcmO', 210, NULL, '纯水系统', '实验室超纯水系统', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    515. 

  515. INSERT INTO `base_itemdetails` VALUES (649, 'sOcmO', 210, NULL, '纯水仪', '纯水仪', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    516. 

  516. INSERT INTO `base_itemdetails` VALUES (650, 'sOcmO', 210, NULL, '分装设备1', '低温分装平台-小容量', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    517. 

  517. INSERT INTO `base_itemdetails` VALUES (651, 'sOcmO', 210, NULL, '分装设备', '低温分装平台', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    518. 

  518. INSERT INTO `base_itemdetails` VALUES (652, 'sOcmO', 210, NULL, '医用热合机', '医用热合机', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    519. 

  519. INSERT INTO `base_itemdetails` VALUES (653, 'sOcmO', 210, NULL, '移液器1', '手动移液器', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    520. 

  520. INSERT INTO `base_itemdetails` VALUES (654, 'sOcmO', 210, NULL, '移液器', '电动移液器', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    521. 

  521. INSERT INTO `base_itemdetails` VALUES (655, 'sOcmO', 210, NULL, '恒温水浴箱', '恒温水浴箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    522. 

  522. INSERT INTO `base_itemdetails` VALUES (656, 'sOcmO', 210, NULL, '干燥箱', '鼓风干燥箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    523. 

  523. INSERT INTO `base_itemdetails` VALUES (657, 'sOcmO', 210, NULL, '培养箱1', '生化培养箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    524. 

  524. INSERT INTO `base_itemdetails` VALUES (658, 'sOcmO', 210, NULL, '培养箱', '二氧化碳培养箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    525. 

  525. INSERT INTO `base_itemdetails` VALUES (659, 'sOcmO', 210, NULL, '消毒设备', '立式压力灭菌器', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    526. 

  526. INSERT INTO `base_itemdetails` VALUES (660, 'sOcmO', 210, NULL, '生物安全柜', '生物安全柜', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    527. 

  527. INSERT INTO `base_itemdetails` VALUES (661, 'sOcmO', 210, NULL, '细胞计数仪', '细胞计数仪', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    528. 

  528. INSERT INTO `base_itemdetails` VALUES (662, 'sOcmO', 210, NULL, '显微镜', '倒置显微镜', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    529. 

  529. INSERT INTO `base_itemdetails` VALUES (663, 'sOcmO', 210, NULL, '分离设备1', '高速冷冻离心机', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    530. 

  530. INSERT INTO `base_itemdetails` VALUES (664, 'sOcmO', 210, NULL, '分离设备', '台式低速离心机', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    531. 

  531. INSERT INTO `base_itemdetails` VALUES (665, 'sOcmO', 210, NULL, '分析设备', '生物分析仪', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    532. 

  532. INSERT INTO `base_itemdetails` VALUES (666, 'sOcmO', 210, NULL, '提取设备', '自动化核酸提取仪', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    533. 

  533. INSERT INTO `base_itemdetails` VALUES (667, 'sOcmO', 210, NULL, '液氮存储罐', '液氮存储罐', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    534. 

  534. INSERT INTO `base_itemdetails` VALUES (668, 'sOcmO', 211, NULL, 'uL', 'uL', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    535. 

  535. INSERT INTO `base_itemdetails` VALUES (669, 'sOcmO', 211, NULL, '瓶', '瓶', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    536. 

  536. INSERT INTO `base_itemdetails` VALUES (670, 'sOcmO', 211, NULL, '箱', '箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    537. 

  537. INSERT INTO `base_itemdetails` VALUES (671, 'sOcmO', 211, NULL, '盒', '盒', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    538. 

  538. INSERT INTO `base_itemdetails` VALUES (672, 'sOcmO', 211, NULL, '个', '个', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    539. 

  539. INSERT INTO `base_itemdetails` VALUES (673, 'sOcmO', 211, NULL, '袋', '袋', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    540. 

  540. INSERT INTO `base_itemdetails` VALUES (674, 'sOcmO', 211, NULL, '支', '支', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    541. 

  541. INSERT INTO `base_itemdetails` VALUES (675, 'sOcmO', 212, NULL, 'Thermo', 'Thermo', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    542. 

  542. INSERT INTO `base_itemdetails` VALUES (676, 'sOcmO', 212, NULL, 'Meck', 'Meck', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    543. 

  543. INSERT INTO `base_itemdetails` VALUES (677, 'sOcmO', 213, NULL, 'Nunc', 'Nunc', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    544. 

  544. INSERT INTO `base_itemdetails` VALUES (678, 'sOcmO', 213, NULL, 'Invitrogen', 'Invitrogen', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    545. 

  545. INSERT INTO `base_itemdetails` VALUES (679, 'sOcmO', 213, NULL, 'Hyclone', 'Hyclone', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    546. 

  546. INSERT INTO `base_itemdetails` VALUES (680, 'sOcmO', 213, NULL, 'Gibco', 'Gibco', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    547. 

  547. INSERT INTO `base_itemdetails` VALUES (681, 'sOcmO', 213, NULL, '美菱', '美菱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    548. 

  548. INSERT INTO `base_itemdetails` VALUES (687, 'sOcmO', 215, NULL, '高校', '高校', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    549. 

  549. INSERT INTO `base_itemdetails` VALUES (688, 'sOcmO', 215, NULL, '企业', '企业', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    550. 

  550. INSERT INTO `base_itemdetails` VALUES (689, 'sOcmO', 215, NULL, '医院', '医院', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    551. 

  551. INSERT INTO `base_itemdetails` VALUES (690, 'sOcmO', 215, NULL, '科研机构', '科研机构', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    552. 

  552. INSERT INTO `base_itemdetails` VALUES (691, 'sOcmO', 215, NULL, '个人', '个人', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    553. 

  553. INSERT INTO `base_itemdetails` VALUES (692, 'sOcmO', 216, NULL, '样本异常', '样本异常', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    554. 

  554. INSERT INTO `base_itemdetails` VALUES (693, 'sOcmO', 218, NULL, '实验正常', '实验结果正常，无异常现象', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    555. 

  555. INSERT INTO `base_itemdetails` VALUES (694, 'sOcmO', 218, NULL, '实验异常', '实验结果异常，存在异常数据', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    556. 

  556. INSERT INTO `base_itemdetails` VALUES (695, 'sOcmO', 219, NULL, '审核不通过', '数据、操作存在异常，审核不通过', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    557. 

  557. INSERT INTO `base_itemdetails` VALUES (696, 'sOcmO', 219, NULL, '审核通过', '数据、操作正常，无异常数据，审核通过', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    558. 

  558. INSERT INTO `base_itemdetails` VALUES (697, 's6FgC', 204, NULL, '细胞制备', '细胞制备', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    559. 

  559. INSERT INTO `base_itemdetails` VALUES (698, 's6FgC', 204, NULL, '脐带血干细胞提取', '脐带血干细胞提取', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    560. 

  560. INSERT INTO `base_itemdetails` VALUES (699, 's6FgC', 206, NULL, '顺丰', '顺丰', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    561. 

  561. INSERT INTO `base_itemdetails` VALUES (700, 's6FgC', 206, NULL, '韵达', '韵达', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    562. 

  562. INSERT INTO `base_itemdetails` VALUES (701, 's6FgC', 208, NULL, '脐带血干细胞提取', '脐带血干细胞提取', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    563. 

  563. INSERT INTO `base_itemdetails` VALUES (702, 's6FgC', 208, NULL, '细胞制备', '细胞制备', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    564. 

  564. INSERT INTO `base_itemdetails` VALUES (703, 's6FgC', 199, NULL, '10的6次方', '10^6', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    565. 

  565. INSERT INTO `base_itemdetails` VALUES (704, 's6FgC', 209, NULL, '健康', '健康', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    566. 

  566. INSERT INTO `base_itemdetails` VALUES (705, 's6FgC', 209, NULL, '高血压', '高血压', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    567. 

  567. INSERT INTO `base_itemdetails` VALUES (706, 's6FgC', 209, NULL, '乙肝', '乙肝', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    568. 

  568. INSERT INTO `base_itemdetails` VALUES (707, 's6FgC', 210, NULL, '液氮存储罐1', '液氮存储罐', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    569. 

  569. INSERT INTO `base_itemdetails` VALUES (708, 's6FgC', 210, NULL, '整理冰箱', '零下40℃超低温冰箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    570. 

  570. INSERT INTO `base_itemdetails` VALUES (709, 's6FgC', 210, NULL, '低温操作台', '2-8℃低温操作台', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    571. 

  571. INSERT INTO `base_itemdetails` VALUES (710, 's6FgC', 210, NULL, '程序降温仪', '程序降温仪', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    572. 

  572. INSERT INTO `base_itemdetails` VALUES (711, 's6FgC', 210, NULL, '暂存冰箱', '4℃暂存冰箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    573. 

  573. INSERT INTO `base_itemdetails` VALUES (712, 's6FgC', 210, NULL, '扫描设备', '整盘扫描仪', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    574. 

  574. INSERT INTO `base_itemdetails` VALUES (713, 's6FgC', 210, NULL, '办公设备', '激光打印机', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    575. 

  575. INSERT INTO `base_itemdetails` VALUES (714, 's6FgC', 210, NULL, '家用冰箱', '家用冰箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    576. 

  576. INSERT INTO `base_itemdetails` VALUES (715, 's6FgC', 210, NULL, '洗衣机', '洗衣机', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    577. 

  577. INSERT INTO `base_itemdetails` VALUES (716, 's6FgC', 210, NULL, '4度冷柜', '4度冷柜', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    578. 

  578. INSERT INTO `base_itemdetails` VALUES (717, 's6FgC', 210, NULL, '制冰机', '制冰机', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    579. 

  579. INSERT INTO `base_itemdetails` VALUES (718, 's6FgC', 210, NULL, '冰箱1', '-40℃冰箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    580. 

  580. INSERT INTO `base_itemdetails` VALUES (719, 's6FgC', 210, NULL, '冰箱', '4℃冰箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    581. 

  581. INSERT INTO `base_itemdetails` VALUES (720, 's6FgC', 210, NULL, '纯水系统', '实验室超纯水系统', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    582. 

  582. INSERT INTO `base_itemdetails` VALUES (721, 's6FgC', 210, NULL, '纯水仪', '纯水仪', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    583. 

  583. INSERT INTO `base_itemdetails` VALUES (722, 's6FgC', 210, NULL, '分装设备1', '低温分装平台-小容量', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    584. 

  584. INSERT INTO `base_itemdetails` VALUES (723, 's6FgC', 210, NULL, '分装设备', '低温分装平台', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    585. 

  585. INSERT INTO `base_itemdetails` VALUES (724, 's6FgC', 210, NULL, '医用热合机', '医用热合机', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    586. 

  586. INSERT INTO `base_itemdetails` VALUES (725, 's6FgC', 210, NULL, '移液器1', '手动移液器', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    587. 

  587. INSERT INTO `base_itemdetails` VALUES (726, 's6FgC', 210, NULL, '移液器', '电动移液器', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    588. 

  588. INSERT INTO `base_itemdetails` VALUES (727, 's6FgC', 210, NULL, '恒温水浴箱', '恒温水浴箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    589. 

  589. INSERT INTO `base_itemdetails` VALUES (728, 's6FgC', 210, NULL, '干燥箱', '鼓风干燥箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    590. 

  590. INSERT INTO `base_itemdetails` VALUES (729, 's6FgC', 210, NULL, '培养箱1', '生化培养箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    591. 

  591. INSERT INTO `base_itemdetails` VALUES (730, 's6FgC', 210, NULL, '培养箱', '二氧化碳培养箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    592. 

  592. INSERT INTO `base_itemdetails` VALUES (731, 's6FgC', 210, NULL, '消毒设备', '立式压力灭菌器', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    593. 

  593. INSERT INTO `base_itemdetails` VALUES (732, 's6FgC', 210, NULL, '生物安全柜', '生物安全柜', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    594. 

  594. INSERT INTO `base_itemdetails` VALUES (733, 's6FgC', 210, NULL, '细胞计数仪', '细胞计数仪', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    595. 

  595. INSERT INTO `base_itemdetails` VALUES (734, 's6FgC', 210, NULL, '显微镜', '倒置显微镜', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    596. 

  596. INSERT INTO `base_itemdetails` VALUES (735, 's6FgC', 210, NULL, '分离设备1', '高速冷冻离心机', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    597. 

  597. INSERT INTO `base_itemdetails` VALUES (736, 's6FgC', 210, NULL, '分离设备', '台式低速离心机', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    598. 

  598. INSERT INTO `base_itemdetails` VALUES (737, 's6FgC', 210, NULL, '分析设备', '生物分析仪', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    599. 

  599. INSERT INTO `base_itemdetails` VALUES (738, 's6FgC', 210, NULL, '提取设备', '自动化核酸提取仪', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    600. 

  600. INSERT INTO `base_itemdetails` VALUES (739, 's6FgC', 211, NULL, 'uL', 'uL', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    601. 

  601. INSERT INTO `base_itemdetails` VALUES (740, 's6FgC', 211, NULL, '瓶', '瓶', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    602. 

  602. INSERT INTO `base_itemdetails` VALUES (741, 's6FgC', 211, NULL, '箱', '箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    603. 

  603. INSERT INTO `base_itemdetails` VALUES (742, 's6FgC', 211, NULL, '盒', '盒', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    604. 

  604. INSERT INTO `base_itemdetails` VALUES (743, 's6FgC', 211, NULL, '个', '个', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    605. 

  605. INSERT INTO `base_itemdetails` VALUES (744, 's6FgC', 211, NULL, '袋', '袋', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    606. 

  606. INSERT INTO `base_itemdetails` VALUES (745, 's6FgC', 211, NULL, '支', '支', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    607. 

  607. INSERT INTO `base_itemdetails` VALUES (746, 's6FgC', 212, NULL, 'Thermo', 'Thermo', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    608. 

  608. INSERT INTO `base_itemdetails` VALUES (747, 's6FgC', 212, NULL, 'Meck', 'Meck', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    609. 

  609. INSERT INTO `base_itemdetails` VALUES (748, 's6FgC', 213, NULL, 'Nunc', 'Nunc', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    610. 

  610. INSERT INTO `base_itemdetails` VALUES (749, 's6FgC', 213, NULL, 'Invitrogen', 'Invitrogen', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    611. 

  611. INSERT INTO `base_itemdetails` VALUES (750, 's6FgC', 213, NULL, 'Hyclone', 'Hyclone', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    612. 

  612. INSERT INTO `base_itemdetails` VALUES (751, 's6FgC', 213, NULL, 'Gibco', 'Gibco', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    613. 

  613. INSERT INTO `base_itemdetails` VALUES (757, '', 215, NULL, '高校', '高校', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    614. 

  614. INSERT INTO `base_itemdetails` VALUES (762, 's6FgC', 216, NULL, '样本异常', '样本异常', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    615. 

  615. INSERT INTO `base_itemdetails` VALUES (763, 's6FgC', 218, NULL, '实验正常', '实验结果正常，无异常现象', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    616. 

  616. INSERT INTO `base_itemdetails` VALUES (764, 's6FgC', 218, NULL, '实验异常', '	 实验结果异常，存在异常数据', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    617. 

  617. INSERT INTO `base_itemdetails` VALUES (765, 's6FgC', 219, NULL, '审核不通过', '数据、操作存在异常，审核不通过', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    618. 

  618. INSERT INTO `base_itemdetails` VALUES (766, 's6FgC', 219, NULL, '审核通过', '数据、操作正常，无异常数据，审核通过', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    619. 

  619. INSERT INTO `base_itemdetails` VALUES (767, '', 204, NULL, '免疫细胞保存', '免疫细胞保存', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    620. 

  620. INSERT INTO `base_itemdetails` VALUES (768, '', 204, NULL, '自体NK细胞治疗', '自体NK细胞治疗', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    621. 

  621. INSERT INTO `base_itemdetails` VALUES (769, '', 204, NULL, '活细胞青春术', '活细胞青春术', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    622. 

  622. INSERT INTO `base_itemdetails` VALUES (770, 'ssVtu', 209, NULL, '遗传性扩张性毛细血管扩张', '遗传性扩张性毛细血管扩张', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    623. 

  623. INSERT INTO `base_itemdetails` VALUES (777, '', 225, NULL, '开始制备', '1', 1, 1, 1, NULL, NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    624. 

  624. INSERT INTO `base_itemdetails` VALUES (779, '', 225, NULL, '选择样本', '2', 1, 1, 1, NULL, NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    625. 

  625. INSERT INTO `base_itemdetails` VALUES (781, '', 225, NULL, '样本采集', '6', 1, 1, 1, NULL, NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    626. 

  626. INSERT INTO `base_itemdetails` VALUES (783, '', 225, NULL, '样本收获', '15', 1, 1, 1, NULL, NULL, 1, 0, NULL, NULL, NULL, '2019-10-18 11:37:39', NULL, NULL);
    627. 

  627. INSERT INTO `base_itemdetails` VALUES (785, '', 225, NULL, '样本存储', '3', 1, 1, 1, NULL, NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    628. 

  628. INSERT INTO `base_itemdetails` VALUES (787, '', 225, NULL, '传代', '4', 1, 1, 1, NULL, NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    629. 

  629. INSERT INTO `base_itemdetails` VALUES (789, '', 225, NULL, '记录制备进度', '5', 1, 1, 1, NULL, NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    630. 

  630. INSERT INTO `base_itemdetails` VALUES (791, '', 225, NULL, '检测', '7', 1, 1, 1, NULL, NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    631. 

  631. INSERT INTO `base_itemdetails` VALUES (793, '', 225, NULL, '送检', '18', 1, 1, 1, NULL, NULL, 1, 0, NULL, NULL, NULL, '2019-11-07 09:28:31', NULL, NULL);
    632. 

  632. INSERT INTO `base_itemdetails` VALUES (795, '', 225, NULL, '制备完成', '14', 1, 1, 1, NULL, NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    633. 

  633. INSERT INTO `base_itemdetails` VALUES (797, '', 225, NULL, '成品分装', '17', 1, 1, 1, NULL, NULL, 1, 0, NULL, NULL, NULL, '2019-10-18 11:37:48', NULL, NULL);
    634. 

  634. INSERT INTO `base_itemdetails` VALUES (799, '', 225, NULL, '成品入库', '16', 1, 1, 1, NULL, NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    635. 

  635. INSERT INTO `base_itemdetails` VALUES (803, '', 225, NULL, '样本交接', '20', 1, 1, 1, NULL, NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    636. 

  636. INSERT INTO `base_itemdetails` VALUES (805, ' ', 225, NULL, '提取', '21', 1, 1, 1, NULL, NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    637. 

  637. INSERT INTO `base_itemdetails` VALUES (809, ' ', 199, NULL, '厘米', 'cm', 1, 1, 1, NULL, NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    638. 

  638. INSERT INTO `base_itemdetails` VALUES (811, ' ', 199, NULL, '个每平方厘米', '*10^5个/cm^2', 1, 1, 1, NULL, NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
    639. 

  639. INSERT INTO `base_itemdetails` VALUES (855, '', 212, '', 'DB', 'DB', 0, 0, 0, 0, '', 0, 0, '2019-09-19 16:20:52', '0', '', '2019-09-19 16:20:52', '0', '');
    640. 

  640. INSERT INTO `base_itemdetails` VALUES (857, '', 213, '', 'GER', 'GER', 0, 0, 0, 0, '', 0, 0, '2019-09-19 16:43:00', '0', '', '2019-09-19 16:43:00', '0', '');
    641. 

  641. INSERT INTO `base_itemdetails` VALUES (859, '', 199, '', 'umgg', 'umgg', 0, 0, 0, 0, '', 0, 0, '2019-09-19 17:22:14', '0', '', '2019-09-19 17:22:14', '0', '');
    642. 

  642. INSERT INTO `base_itemdetails` VALUES (861, '', 214, '', '设备校准', '设备校准', 1, 0, 0, 0, '', 0, 0, '2019-10-18 09:05:16', '0', '', '2019-10-18 09:05:16', '0', '');
    643. 

  643. INSERT INTO `base_itemdetails` VALUES (863, '', 214, '', '周期性维护', '周期性维护', 1, 0, 0, 0, '', 0, 0, '2019-10-18 09:06:46', '0', '', '2019-10-18 09:06:46', '0', '');
    644. 

  644. INSERT INTO `base_itemdetails` VALUES (865, '', 214, '', '设备维修', '设备维修', 1, 0, 0, 0, '', 0, 0, '2019-10-18 10:03:53', '0', '', '2019-10-18 10:03:53', '0', '');
    645. 

  645. INSERT INTO `base_itemdetails` VALUES (867, '', 225, '', '送存储', '23', 0, 0, 0, 0, '', 0, 0, '2019-10-18 11:23:37', '0', '', '2019-10-18 11:23:37', '0', '');
    646. 

  646. INSERT INTO `base_itemdetails` VALUES (869, '', 227, '', '生产A区', '生产A区', 1, 0, 0, 0, '', 0, 0, '2019-10-23 18:50:43', '0', '', '2019-10-23 18:50:43', '0', '');
    647. 

  647. INSERT INTO `base_itemdetails` VALUES (871, '', 227, '', '生产B区', '生产B区', 1, 0, 0, 0, '', 0, 0, '2019-10-23 19:42:19', '0', '', '2019-10-23 19:42:19', '0', '');
    648. 

  648. INSERT INTO `base_itemdetails` VALUES (873, '', 227, '', '实验室', '实验室', 1, 0, 0, 0, '', 0, 0, '2019-10-23 19:42:36', '0', '', '2019-10-23 19:42:36', '0', '');
    649. 

  649. INSERT INTO `base_itemdetails` VALUES (875, '', 225, '', '复苏申请', '24', 1, 0, 0, 0, '', 0, 0, '2019-11-05 11:54:43', '0', '', '2019-11-07 09:27:58', '0', '');
    650. 

  650. INSERT INTO `base_itemdetails` VALUES (877, '', 225, '', '复苏', '25', 1, 0, 0, 0, '', 0, 0, '2019-11-05 11:55:04', '0', '', '2019-11-07 09:28:10', '0', '');
    651. 

  651. INSERT INTO `base_itemdetails` VALUES (881, '', 225, '', '细胞培养', '26', 1, 0, 0, 0, '', 0, 0, '2019-11-07 09:27:57', '0', '', '2019-11-07 09:28:16', '0', '');
    652. 

  652. INSERT INTO `base_itemdetails` VALUES (883, '', 221, '', '管理组', '管理组', 1, 0, 0, 0, '', 0, 0, '2019-11-08 15:15:33', '0', '', '2019-11-08 15:15:33', '0', '');
    653. 

  653. INSERT INTO `base_itemdetails` VALUES (885, '', 221, '', '浏览组', '浏览组', 1, 0, 0, 0, '', 0, 0, '2019-11-08 15:16:04', '0', '', '2019-11-08 15:16:04', '0', '');
    654. 

  654. INSERT INTO `base_itemdetails` VALUES (889, ' ', 229, NULL, '外部合作客户样本', '外部合作客户样本', 1, 0, 0, 0, NULL, 0, 0, '2019-11-11 15:22:36', NULL, NULL, '2019-11-11 15:22:37', NULL, NULL);
    655. 

  655. INSERT INTO `base_itemdetails` VALUES (891, ' ', 229, NULL, '其他', '其他', 1, 0, 0, 0, NULL, 0, 0, '2019-11-11 15:23:04', NULL, NULL, '2019-11-11 15:23:06', NULL, NULL);
    656. 

  656. INSERT INTO `base_itemdetails` VALUES (893, ' ', 231, NULL, '实验使用', '实验使用', 1, 0, 0, 0, '', 0, 0, '2019-11-11 15:23:54', NULL, NULL, '2019-11-11 15:23:56', NULL, NULL);
    657. 

  657. INSERT INTO `base_itemdetails` VALUES (895, ' ', 231, NULL, '检验使用', '检验使用', 1, 0, 0, 0, NULL, 0, 0, '2019-11-11 15:24:22', NULL, NULL, '2019-11-11 15:24:23', NULL, NULL);
    658. 

  658. INSERT INTO `base_itemdetails` VALUES (897, '', 233, '', '2ml冻存管', '2DC', 1, 0, 0, 0, '', 0, 0, '2019-11-18 14:14:37', '0', '', '2019-11-18 14:14:37', '0', '');
    659. 

  659. INSERT INTO `base_itemdetails` VALUES (899, '', 233, '', '1.5ml冻存管', '1.5DC', 1, 0, 0, 0, '', 0, 0, '2019-11-18 14:14:56', '0', '', '2019-11-18 14:15:15', '0', '');
    660. 

  660. INSERT INTO `base_itemdetails` VALUES (901, '', 233, '', '20ml盐水袋', '20YSD', 1, 0, 0, 0, '', 0, 0, '2019-11-18 14:15:41', '0', '', '2019-11-18 14:15:41', '0', '');
    661. 

  661. INSERT INTO `base_itemdetails` VALUES (903, '', 233, '', '40ml盐水袋', '40YSD', 1, 0, 0, 0, '', 0, 0, '2019-11-18 14:16:02', '0', '', '2019-11-18 14:16:02', '0', '');
    662. 

  662. INSERT INTO `base_itemdetails` VALUES (905, '', 233, '', '50ml盐水袋', '50YSD', 1, 0, 0, 0, '', 0, 0, '2019-11-18 14:16:41', '0', '', '2019-11-18 14:16:41', '0', '');
    663. 

  663. INSERT INTO `base_itemdetails` VALUES (907, '', 212, '', '供应商1', '供应商1', 1, 0, 0, 0, '', 0, 0, '2019-11-21 10:24:30', '0', '', '2019-11-21 10:24:30', '0', '');
    664. 

  664. INSERT INTO `base_itemdetails` VALUES (909, '', 212, '', '供应商2', '供应商2', 1, 0, 0, 0, '', 0, 0, '2019-11-21 10:26:51', '0', '', '2019-11-21 10:26:51', '0', '');
    665. 

  665. INSERT INTO `base_itemdetails` VALUES (911, '', 212, '', '供应商3', '供应商3', 1, 0, 0, 0, '', 0, 0, '2019-11-21 10:26:57', '0', '', '2019-11-21 10:26:57', '0', '');
    666. 

  666. INSERT INTO `base_itemdetails` VALUES (913, '', 212, '', '供应商4', '供应商4', 1, 0, 0, 0, '', 0, 0, '2019-11-21 10:27:04', '0', '', '2019-11-21 10:27:04', '0', '');
    667. 

  667. INSERT INTO `base_itemdetails` VALUES (915, '', 211, '', 'ml', 'ml', 1, 0, 0, 0, '', 0, 0, '2019-11-21 11:51:55', '0', '', '2019-11-21 11:51:55', '0', '');
    668. 

  668. INSERT INTO `base_itemdetails` VALUES (919, '', 210, '', '离心机19', '离心机19', 1, 0, 0, 0, '', 0, 0, '2019-11-28 14:28:55', '0', '', '2019-11-28 14:28:55', '0', '');
    669. 

  669. INSERT INTO `base_itemdetails` VALUES (925, '', 235, '', 'cm', 'cm', 1, 0, 0, 0, '', 0, 0, '2019-11-28 19:54:14', '0', '', '2019-11-28 19:54:14', '0', '');
    670. 

  670. INSERT INTO `base_itemdetails` VALUES (927, '', 235, '', 'r/min', 'r/min', 1, 0, 0, 0, '', 0, 0, '2019-11-28 19:56:16', '0', '', '2019-11-28 19:56:16', '0', '');
    671. 

  671. INSERT INTO `base_itemdetails` VALUES (929, '', 214, '', '设备确认', '设备确认', 1, 0, 0, 0, '', 0, 0, '2019-11-29 11:29:49', '0', '', '2019-11-29 11:29:49', '0', '');
    672. 

  672. INSERT INTO `base_itemdetails` VALUES (931, '', 214, '', '设备报废', '设备报废', 1, 0, 0, 0, '', 0, 0, '2019-11-29 11:30:10', '0', '', '2019-11-29 11:30:10', '0', '');
    673. 

  673. INSERT INTO `base_itemdetails` VALUES (933, '', 225, '', '样本复苏申请', '27', 1, 0, 0, 0, '', 0, 0, '2019-12-11 16:00:23', '0', '', '2019-12-11 16:00:36', '0', '');
    674. 

  674. INSERT INTO `base_itemdetails` VALUES (935, '', 225, '', '样本复苏', '28', 1, 0, 0, 0, '', 0, 0, '2019-12-11 16:00:47', '0', '', '2019-12-11 16:00:47', '0', '');
    675. 

  675. INSERT INTO `base_itemdetails` VALUES (937, '', 235, '', '℃', '℃', 1, 0, 0, 0, '', 0, 0, '2019-12-14 11:03:19', '0', '', '2019-12-14 11:03:19', '0', '');
    676. 

  676. INSERT INTO `base_itemdetails` VALUES (939, '', 237, '', '血液来源样本', 'BE', 1, 0, 0, 0, '', 0, 0, '2019-12-19 16:29:16', '0', '', '2019-12-20 09:32:09', '0', '');
    677. 

  677. INSERT INTO `base_itemdetails` VALUES (941, '', 237, '', '脐带来源', 'UM', 1, 0, 0, 0, '', 0, 0, '2019-12-19 16:29:44', '0', '', '2019-12-20 09:32:19', '0', '');
    678. 

  678. INSERT INTO `base_itemdetails` VALUES (943, '', 237, '', 'iPSC分化来源', 'IX', 1, 0, 0, 0, '', 0, 0, '2019-12-19 16:29:58', '0', '', '2019-12-20 09:32:31', '0', '');
    679. 

  679. INSERT INTO `base_itemdetails` VALUES (945, '', 239, '', '间充质干细胞', 'M', 1, 0, 0, 0, '', 0, 0, '2019-12-19 16:31:13', '0', '', '2019-12-19 16:31:13', '0', '');
    680. 

  680. INSERT INTO `base_itemdetails` VALUES (947, '', 239, '', 'EP来源', 'E', 1, 0, 0, 0, '', 0, 0, '2019-12-19 16:31:24', '0', '', '2019-12-19 16:31:24', '0', '');
    681. 

  681. INSERT INTO `base_itemdetails` VALUES (949, '', 239, '', 'T细胞来源', 'T', 1, 0, 0, 0, '', 0, 0, '2019-12-19 16:31:35', '0', '', '2019-12-19 16:31:35', '0', '');
    682. 

  682. INSERT INTO `base_itemdetails` VALUES (951, '', 239, '', '血液和PBMC', 'X', 1, 0, 0, 0, '', 0, 0, '2019-12-19 16:31:50', '0', '', '2019-12-19 16:31:50', '0', '');
    683. 

  683. INSERT INTO `base_itemdetails` VALUES (953, '', 237, '', '脐带血', 'QX', 1, 0, 0, 0, '', 0, 0, '2019-12-20 09:35:17', '0', '', '2019-12-20 09:35:17', '0', '');
    684. 

  684. INSERT INTO `base_itemdetails` VALUES (955, '', 237, '', '干细胞', 'SC', 1, 0, 0, 0, '', 0, 0, '2019-12-20 09:35:37', '0', '', '2019-12-20 09:35:37', '0', '');
    685. 

  685. INSERT INTO `base_itemdetails` VALUES (957, '', 237, '', '红细胞', 'BE', 1, 0, 0, 0, '', 0, 0, '2019-12-20 09:35:50', '0', '', '2019-12-20 09:35:50', '0', '');
    686. 

  686. INSERT INTO `base_itemdetails` VALUES (959, '', 237, '', '血浆', 'BC', 1, 0, 0, 0, '', 0, 0, '2019-12-20 09:36:07', '0', '', '2019-12-20 09:36:07', '0', '');
    687. 

  687. INSERT INTO `base_itemdetails` VALUES (961, '', 237, '', '白细胞', 'BW', 1, 0, 0, 0, '', 0, 0, '2019-12-20 09:36:17', '0', '', '2019-12-20 09:36:17', '0', '');
    688. 

  688. INSERT INTO `base_itemdetails` VALUES (963, '', 237, '', '脐带', 'QD', 1, 0, 0, 0, '', 0, 0, '2019-12-20 09:36:27', '0', '', '2019-12-20 09:36:27', '0', '');
    689. 

  689. INSERT INTO `base_itemdetails` VALUES (965, '', 237, '', '脐血细胞', 'QDXB', 1, 0, 0, 0, '', 0, 0, '2019-12-20 09:36:50', '0', '', '2019-12-20 09:36:50', '0', '');
    690. 

  690. INSERT INTO `base_itemdetails` VALUES (967, '', 237, '', '骨髓干细胞', 'GS', 1, 0, 0, 0, '', 0, 0, '2019-12-20 09:37:11', '0', '', '2019-12-20 09:37:11', '0', '');
    691. 

  691. INSERT INTO `base_itemdetails` VALUES (969, '', 237, '', '血清', 'XQ', 1, 0, 0, 0, '', 0, 0, '2019-12-20 09:37:22', '0', '', '2019-12-20 09:37:22', '0', '');
    692. 

  692. INSERT INTO `base_itemdetails` VALUES (971, '', 237, '', '骨间充质干细胞', 'GJGX', 1, 0, 0, 0, '', 0, 0, '2019-12-20 09:37:51', '0', '', '2019-12-20 09:37:51', '0', '');
    693. 

  693. INSERT INTO `base_itemdetails` VALUES (973, '', 237, '', '器官', 'QG', 1, 0, 0, 0, '', 0, 0, '2019-12-20 09:38:08', '0', '', '2019-12-20 09:38:08', '0', '');
    694. 

  694. INSERT INTO `base_itemdetails` VALUES (975, '', 237, '', '造血干细胞', 'ZXGXB', 1, 0, 0, 0, '', 0, 0, '2019-12-20 09:38:28', '0', '', '2019-12-20 09:38:28', '0', '');
    695. 

  695. INSERT INTO `base_itemdetails` VALUES (977, '', 237, '', '肝癌细胞', 'LGA', 1, 0, 0, 0, '', 0, 0, '2019-12-20 09:38:52', '0', '', '2019-12-20 09:38:52', '0', '');
    696. 

  696. INSERT INTO `base_itemdetails` VALUES (979, '', 237, '', '肝血管瘤细胞', 'GXGL', 1, 0, 0, 0, '', 0, 0, '2019-12-20 09:39:22', '0', '', '2019-12-20 09:39:22', '0', '');
    697. 

  697. INSERT INTO `base_itemdetails` VALUES (981, '', 237, '', '肝脂肪瘤细胞', 'GZFL', 1, 0, 0, 0, '', 0, 0, '2019-12-20 09:39:46', '0', '', '2019-12-20 09:39:46', '0', '');
    698. 

  698. INSERT INTO `base_itemdetails` VALUES (983, '', 237, '', '肝肉瘤细胞', 'GRL', 1, 0, 0, 0, '', 0, 0, '2019-12-20 09:40:00', '0', '', '2019-12-20 09:40:00', '0', '');
    699. 

  699. INSERT INTO `base_itemdetails` VALUES (985, '', 237, '', '乙型肝炎病毒', 'HBV', 1, 0, 0, 0, '', 0, 0, '2019-12-20 09:40:19', '0', '', '2019-12-20 09:40:19', '0', '');
    700. 

  700. INSERT INTO `base_itemdetails` VALUES (987, '', 237, '', '丙型肝炎病毒', 'HCV', 1, 0, 0, 0, '', 0, 0, '2019-12-20 09:40:28', '0', '', '2019-12-20 09:40:28', '0', '');
    701. 

  701. INSERT INTO `base_itemdetails` VALUES (989, '', 237, '', '肝癌旁组织', 'GCAP', 1, 0, 0, 0, '', 0, 0, '2019-12-20 09:40:51', '0', '', '2019-12-20 09:40:51', '0', '');
    702. 

  702. INSERT INTO `base_itemdetails` VALUES (991, '', 237, '', '脐带血细胞', 'CS', 1, 0, 0, 0, '', 0, 0, '2019-12-20 09:41:12', '0', '', '2019-12-20 09:41:12', '0', '');
    703. 

  703. INSERT INTO `base_itemdetails` VALUES (993, '', 237, '', '脐血上清', 'QXSQ', 1, 0, 0, 0, '', 0, 0, '2019-12-20 09:41:31', '0', '', '2019-12-20 09:41:31', '0', '');
    704. 

  704. INSERT INTO `base_itemdetails` VALUES (995, '', 231, '', '复苏出库(勿删)', '复苏使用', 1, 0, 0, 0, '', 0, 0, '2019-12-24 10:57:06', '0', '', '2019-12-24 10:57:30', '0', '');
    705. 

  705. INSERT INTO `base_itemdetails` VALUES (997, NULL, 240, 'Term', '春季学期', '1', 1, 1, 1, NULL, NULL, 1, 0, '2020-12-15 17:20:41', NULL, NULL, '2020-12-23 11:33:33', NULL, NULL);
    706. 

  706. INSERT INTO `base_itemdetails` VALUES (998, NULL, 240, 'Term', '秋季学期', '2', 1, 1, 1, NULL, NULL, 1, 0, '2020-12-15 17:21:01', NULL, NULL, '2020-12-22 14:15:39', NULL, NULL);
    707. 

  707. INSERT INTO `base_itemdetails` VALUES (999, NULL, 245, 'InformationStatusOptions', '全部', '-1', 1, 1, 1, NULL, NULL, 1, 0, '2020-12-15 18:59:19', NULL, NULL, '2020-12-16 09:55:58', NULL, NULL);
    708. 

  708. INSERT INTO `base_itemdetails` VALUES (1000, NULL, 245, 'InformationStatusOptions', '草稿', '0', 1, 1, 1, NULL, NULL, 1, 0, '2020-12-15 18:59:27', NULL, NULL, '2020-12-16 09:56:05', NULL, NULL);
    709. 

  709. INSERT INTO `base_itemdetails` VALUES (1001, NULL, 245, 'InformationStatusOptions', '已发布', '1', 1, 1, 1, NULL, NULL, 1, 0, '2020-12-15 18:59:38', NULL, NULL, '2020-12-16 09:56:03', NULL, NULL);
    710. 

  710. INSERT INTO `base_itemdetails` VALUES (1004, NULL, 247, 'Teacher', '1号教师', '1', 1, 1, 1, NULL, NULL, 1, 0, '2020-12-18 09:03:45', NULL, NULL, NULL, NULL, NULL);
    711. 

  711. INSERT INTO `base_itemdetails` VALUES (1005, NULL, 248, 'Time', '第一节', '1', 1, 1, 1, NULL, NULL, 1, 0, '2020-12-18 09:08:23', NULL, NULL, NULL, NULL, NULL);
    712. 

  712. INSERT INTO `base_itemdetails` VALUES (1006, NULL, 248, 'Time', '第二节', '2', 1, 1, 1, NULL, NULL, 1, 0, '2020-12-18 09:08:39', NULL, NULL, NULL, NULL, NULL);
    713. 

  713. INSERT INTO `base_itemdetails` VALUES (1007, NULL, 248, 'Time', '第三节', '3', 1, 1, 1, NULL, NULL, 1, 0, '2020-12-18 09:08:52', NULL, NULL, NULL, NULL, NULL);
    714. 

  714. INSERT INTO `base_itemdetails` VALUES (1008, NULL, 248, 'Time', '第四节', '4', 1, 1, 1, NULL, NULL, 1, 0, '2020-12-18 09:09:04', NULL, NULL, '2020-12-18 09:09:31', NULL, NULL);
    715. 

  715. INSERT INTO `base_itemdetails` VALUES (1009, NULL, 248, 'Time', '第五节', '5', 1, 1, 1, NULL, NULL, 1, 0, '2020-12-18 09:09:19', NULL, NULL, NULL, NULL, NULL);
    716. 

  716. INSERT INTO `base_itemdetails` VALUES (1010, NULL, 248, 'Time', '第六节', '6', 1, 1, 1, NULL, NULL, 1, 0, '2020-12-18 09:09:43', NULL, NULL, NULL, NULL, NULL);
    717. 

  717. INSERT INTO `base_itemdetails` VALUES (1011, NULL, 248, 'Time', '第七节', '7', 1, 1, 1, NULL, NULL, 1, 0, '2020-12-18 09:09:58', NULL, NULL, NULL, NULL, NULL);
    718. 

  718. INSERT INTO `base_itemdetails` VALUES (1012, NULL, 248, 'Time', '第八节', '8', 1, 1, 1, NULL, NULL, 1, 0, '2020-12-18 09:10:33', NULL, NULL, NULL, NULL, NULL);
    719. 

  719. INSERT INTO `base_itemdetails` VALUES (1013, NULL, 248, 'Time', '第九节', '9', 1, 1, 1, NULL, NULL, 1, 0, '2020-12-18 09:10:46', NULL, NULL, NULL, NULL, NULL);
    720. 

  720. INSERT INTO `base_itemdetails` VALUES (1014, NULL, 248, 'Time', '第十节', '10', 1, 1, 1, NULL, NULL, 1, 0, '2020-12-18 09:10:59', NULL, NULL, NULL, NULL, NULL);
    721. 

  721. INSERT INTO `base_itemdetails` VALUES (1015, NULL, 248, 'Time', '第十一节', '11', 1, 1, 1, NULL, NULL, 1, 0, '2020-12-18 09:11:15', NULL, NULL, NULL, NULL, NULL);
    722. 

  722. INSERT INTO `base_itemdetails` VALUES (1016, NULL, 248, 'Time', '第十二节', '12', 1, 1, 1, NULL, NULL, 1, 0, '2020-12-18 09:11:42', NULL, NULL, NULL, NULL, NULL);
    723. 

  723. INSERT INTO `base_itemdetails` VALUES (1017, NULL, 249, 'PublishStatus', '草稿', '0', 1, 1, 1, NULL, NULL, 1, 0, '2020-12-21 09:21:51', NULL, NULL, NULL, NULL, NULL);
    724. 

  724. INSERT INTO `base_itemdetails` VALUES (1018, NULL, 249, 'PublishStatus', '发布', '1', 1, 1, 1, NULL, NULL, 1, 0, '2020-12-21 09:22:02', NULL, NULL, '2020-12-21 10:18:41', NULL, NULL);
    725. 

  725. INSERT INTO `base_itemdetails` VALUES (1019, NULL, 250, 'Local', '教学楼', '1', 1, 1, 1, NULL, NULL, 1, 0, '2020-12-22 15:10:08', NULL, NULL, '2020-12-28 14:30:57', NULL, NULL);
    726. 

  726. INSERT INTO `base_itemdetails` VALUES (1020, NULL, 250, 'Local', '计算机楼', '2', 1, 1, 1, NULL, NULL, 1, 0, '2020-12-22 15:10:20', NULL, NULL, NULL, NULL, NULL);
    727. 

  727. INSERT INTO `base_itemdetails` VALUES (1021, NULL, 251, 'People', '人员甲', '1', 1, 1, 1, NULL, NULL, 1, 0, '2020-12-22 15:17:34', NULL, NULL, NULL, NULL, NULL);
    728. 

  728. INSERT INTO `base_itemdetails` VALUES (1022, NULL, 251, 'People', '人员乙', '2', 1, 1, 1, NULL, NULL, 1, 0, '2020-12-22 15:18:01', NULL, NULL, NULL, NULL, NULL);
    729. 

  729. INSERT INTO `base_itemdetails` VALUES (1023, NULL, 251, 'People', '人员丙', '3', 1, 1, 1, NULL, NULL, 1, 0, '2020-12-22 15:18:16', NULL, NULL, NULL, NULL, NULL);
    730. 

  730. INSERT INTO `base_itemdetails` VALUES (1024, NULL, 251, 'People', '人员丁', '4', 1, 1, 1, NULL, NULL, 1, 0, '2020-12-22 15:18:29', NULL, NULL, NULL, NULL, NULL);
    731. 

  731. INSERT INTO `base_itemdetails` VALUES (1025, NULL, 252, 'DutyTime', '8：00-9：00', '1', 1, 1, 1, NULL, NULL, 1, 0, '2020-12-22 16:34:18', NULL, NULL, NULL, NULL, NULL);
    732. 

  732. INSERT INTO `base_itemdetails` VALUES (1026, NULL, 252, 'DutyTime', '10：00-11：00', '2', 1, 1, 1, NULL, NULL, 1, 0, '2020-12-22 16:34:45', NULL, NULL, NULL, NULL, NULL);
    733. 

  733. INSERT INTO `base_itemdetails` VALUES (1027, NULL, 252, 'DutyTime', '13：00-15：00', '3', 1, 1, 1, NULL, NULL, 1, 0, '2020-12-22 16:34:58', NULL, NULL, NULL, NULL, NULL);
    734. 

  734. INSERT INTO `base_itemdetails` VALUES (1028, NULL, 252, 'DutyTime', '18：00-20：00', '4', 1, 1, 1, NULL, NULL, 1, 0, '2020-12-22 16:35:20', NULL, NULL, NULL, NULL, NULL);
    735. 

  735. INSERT INTO `base_itemdetails` VALUES (1029, NULL, 251, 'People', '人员戍', '5', 1, 1, 1, NULL, NULL, 1, 0, '2020-12-22 20:55:48', NULL, NULL, NULL, NULL, NULL);
    736. 

  736. INSERT INTO `base_itemdetails` VALUES (1031, NULL, 251, 'People', '休息', '6', 1, 1, 1, NULL, NULL, 1, 0, '2020-12-24 11:05:29', NULL, NULL, NULL, NULL, NULL);
    737. 

  737. INSERT INTO `base_itemdetails` VALUES (1032, NULL, 255, 'RoomType', '计算机实验室', '1', 1, 1, 1, NULL, NULL, 1, 0, '2020-12-29 09:14:55', NULL, NULL, '2020-12-29 11:33:20', NULL, NULL);
    738. 

  738. 

  739. -- ----------------------------
    740. 

  740. -- Table structure for base_items
    741. 

  741. -- ----------------------------
    742. 

  742. DROP TABLE IF EXISTS `base_items`;
    743. 

  743. CREATE TABLE `base_items`  (
    744. 

  744.   `Id` int(10) NOT NULL AUTO_INCREMENT,
    745. 

  745.   `ParentId` int(10) NULL DEFAULT NULL,
    746. 

  746.   `Code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    747. 

  747.   `FullName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    748. 

  748.   `TargetTable` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    749. 

  749.   `IsTree` int(10) NOT NULL COMMENT '0：普通结构，1：树型结构',
    750. 

  750.   `UseItemCode` int(10) NULL DEFAULT NULL,
    751. 

  751.   `UseItemName` int(10) NULL DEFAULT NULL,
    752. 

  752.   `UseItemValue` int(10) NULL DEFAULT NULL,
    753. 

  753.   `Enabled` int(10) NOT NULL,
    754. 

  754.   `AllowEdit` int(10) NOT NULL,
    755. 

  755.   `AllowDelete` int(10) NOT NULL,
    756. 

  756.   `DeletionStateCode` int(10) NOT NULL DEFAULT 0,
    757. 

  757.   `SortCode` int(10) NULL DEFAULT NULL,
    758. 

  758.   `Description` varchar(800) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    759. 

  759.   `CreateOn` datetime(0) NULL DEFAULT NULL,
    760. 

  760.   `CreateUserId` int(11) NULL DEFAULT NULL,
    761. 

  761.   `CreateBy` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    762. 

  762.   `ModifiedOn` datetime(0) NULL DEFAULT NULL,
    763. 

  763.   `ModifiedUserId` int(11) NULL DEFAULT NULL,
    764. 

  764.   `ModifiedBy` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    765. 

  765.   PRIMARY KEY (`Id`) USING BTREE
    766. 

  766. ) ENGINE = InnoDB AUTO_INCREMENT = 256 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    767. 

  767. 

  768. -- ----------------------------
    769. 

  769. -- Records of base_items
    770. 

  770. -- ----------------------------
    771. 

  771. INSERT INTO `base_items` VALUES (1, 0, 'Area', '地区', 'Base_ItemDetails_Area', 1, 1, 1, 1, 0, 0, 0, 0, 10000048, '', '2010-12-31 00:00:00', 0, '', '2010-12-31 00:00:00', 0, '');
    772. 

  772. INSERT INTO `base_items` VALUES (200, 0, 'FRelation', '家族关系', 'Base_ItemDetails_FRelation', 0, 1, 1, 1, 0, 0, 0, 0, 10000048, '', '2010-12-31 00:00:00', 0, '', '2010-12-31 00:00:00', 0, '');
    773. 

  773. INSERT INTO `base_items` VALUES (203, 0, 'TubeItem', '试管类型', 'Base_ItemDetails', 0, 1, 1, 1, 0, 0, 0, 0, 10000048, '', '2010-12-31 00:00:00', 0, '', '2010-12-31 00:00:00', 0, '');
    774. 

  774. INSERT INTO `base_items` VALUES (204, 0, 'BusinessItem', '合同管理>业务类型', 'Base_ItemDetails', 0, 1, 1, 1, 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
    775. 

  775. INSERT INTO `base_items` VALUES (206, 0, 'Express', '样本采集>样本运输>快递公司', 'Base_ItemDetails', 0, 1, 1, 1, 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
    776. 

  776. INSERT INTO `base_items` VALUES (208, 0, 'MakeProject', '制备管理>制备项目', 'Base_ItemDetails', 0, 1, 1, 1, 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
    777. 

  777. INSERT INTO `base_items` VALUES (209, 0, 'Diseases', '样本采集>疾病类型', 'Base_ItemDetails', 0, 1, 1, 1, 0, 0, 0, 0, 10000048, '', '2010-12-31 00:00:00', 0, '', '2010-12-31 00:00:00', 0, '');
    778. 

  778. INSERT INTO `base_items` VALUES (214, 0, 'OperaTpye', '设备管理>维护类型', 'Base_ItemDetails', 0, 1, 1, 1, 1, 0, 0, 0, 10000048, '', '2010-12-31 00:00:00', 0, '', '2010-12-31 00:00:00', 0, '');
    779. 

  779. INSERT INTO `base_items` VALUES (216, 0, 'TransportAbnormalInfo', '交接管理>交接异常信息', 'Base_ItemDetails', 0, 1, 1, 1, 0, 0, 0, 0, 10000048, '', '2010-12-31 00:00:00', 0, '', '2010-12-31 00:00:00', 0, '');
    780. 

  780. INSERT INTO `base_items` VALUES (217, 0, 'DocumentType', '文档结构', 'Base_ItemTreeDetails', 1, 1, 1, 1, 0, 0, 0, 0, 10000048, '', '2010-12-31 00:00:00', 0, '', '2010-12-31 00:00:00', 0, '');
    781. 

  781. INSERT INTO `base_items` VALUES (218, 0, 'PrepareComplete', '制备管理>实验结果信息', 'Base_ItemDetails', 0, 1, 1, 1, 0, 0, 0, 0, 10000048, '', '2010-12-31 00:00:00', 0, '', '2010-12-31 00:00:00', 0, '');
    782. 

  782. INSERT INTO `base_items` VALUES (219, 0, 'PrepareAudit', '制备管理>审核说明', 'Base_ItemDetails', 0, 1, 1, 1, 0, 0, 0, 0, 10000048, '', '2010-12-31 00:00:00', 0, '', '2010-12-31 00:00:00', 0, '');
    783. 

  783. INSERT INTO `base_items` VALUES (225, 0, 'TaskOpero', '实验操作选项', 'Base_ItemDetails', 0, 1, 1, 1, 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
    784. 

  784. INSERT INTO `base_items` VALUES (240, NULL, 'Term', '学期', 'Base_ItemDetails', 0, 1, 0, 0, 1, 0, 0, 0, NULL, NULL, '2020-12-15 15:32:06', NULL, NULL, '2020-12-15 18:12:24', NULL, NULL);
    785. 

  785. INSERT INTO `base_items` VALUES (245, NULL, 'InformationStatusOptions', '信息发布下拉', 'Base_ItemDetails', 0, 1, 0, 0, 1, 0, 0, 0, NULL, NULL, '2020-12-15 18:58:13', NULL, NULL, '2020-12-15 18:58:22', NULL, NULL);
    786. 

  786. INSERT INTO `base_items` VALUES (247, NULL, 'Teacher', '教师', 'Base_ItemDetails', 0, 1, 0, 0, 1, 0, 0, 0, NULL, NULL, '2020-12-16 16:20:36', NULL, NULL, NULL, NULL, NULL);
    787. 

  787. INSERT INTO `base_items` VALUES (248, NULL, 'Time', '课程节次', 'Base_ItemDetails', 0, 1, 0, 0, 1, 0, 0, 0, NULL, NULL, '2020-12-18 09:07:37', NULL, NULL, '2020-12-18 09:07:49', NULL, NULL);
    788. 

  788. INSERT INTO `base_items` VALUES (249, NULL, 'PublishStatus', '发布状态', 'Base_ItemDetails', 0, 1, 0, 0, 1, 0, 0, 0, NULL, NULL, '2020-12-21 09:21:23', NULL, NULL, NULL, NULL, NULL);
    789. 

  789. INSERT INTO `base_items` VALUES (250, NULL, 'Local', '地点', 'Base_ItemDetails', 0, 1, 0, 0, 1, 0, 0, 0, NULL, NULL, '2020-12-22 15:08:43', NULL, NULL, '2020-12-22 15:09:00', NULL, NULL);
    790. 

  790. INSERT INTO `base_items` VALUES (252, NULL, 'DutyTime', '值班时间段', 'Base_ItemDetails', 0, 1, 0, 0, 1, 0, 0, 0, NULL, NULL, '2020-12-22 16:33:38', NULL, NULL, '2020-12-29 11:34:04', NULL, NULL);
    791. 

  791. INSERT INTO `base_items` VALUES (255, NULL, 'RoomType', '实验室类型', 'Base_ItemDetails', 0, 0, 0, 0, 1, 0, 0, 0, NULL, NULL, '2020-12-25 16:31:20', NULL, NULL, '2020-12-29 11:04:53', NULL, NULL);
    792. 

  792. 

  793. -- ----------------------------
    794. 

  794. -- Table structure for base_menu
    795. 

  795. -- ----------------------------
    796. 

  796. DROP TABLE IF EXISTS `base_menu`;
    797. 

  797. CREATE TABLE `base_menu`  (
    798. 

  798.   `Id` int(11) NOT NULL AUTO_INCREMENT,
    799. 

  799.   `Title` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    800. 

  800.   `ParentId` int(11) NULL DEFAULT NULL,
    801. 

  801.   `Paths` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '路径索引',
    802. 

  802.   `Url` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '访问路径',
    803. 

  803.   `Action` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '无' COMMENT '请求方式',
    804. 

  804.   `Permission` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '权限编码',
    805. 

  805.   `MenuType` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '菜单类型 D目录 M菜单 F按钮或功能 I接口',
    806. 

  806.   `RouteName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '路由名称',
    807. 

  807.   `Icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '图标',
    808. 

  808.   `Component` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    809. 

  809.   `Sort` int(4) NULL DEFAULT 1 COMMENT '排序',
    810. 

  810.   `Visible` int(4) NOT NULL DEFAULT 1 COMMENT '是否显示 1 显示',
    811. 

  811.   PRIMARY KEY (`Id`) USING BTREE
    812. 

  812. ) ENGINE = InnoDB AUTO_INCREMENT = 56 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '菜单表' ROW_FORMAT = Dynamic;
    813. 

  813. 

  814. -- ----------------------------
    815. 

  815. -- Records of base_menu
    816. 

  816. -- ----------------------------
    817. 

  817. INSERT INTO `base_menu` VALUES (22, '系统设置', 0, '22', '', '', '', 'D', '', 'gear', '', 11, 1);
    818. 

  818. INSERT INTO `base_menu` VALUES (23, '账号管理', 50, '50/23', '/sysadmin/user', '', '', 'M', '', 'user', '', 8, 1);
    819. 

  819. INSERT INTO `base_menu` VALUES (24, '部门管理', 50, '50/24', '/sysadmin/organize', '', '', 'M', '', 'sitemap', '', 9, 1);
    820. 

  820. INSERT INTO `base_menu` VALUES (25, '角色管理', 50, '50/25', '/sysadmin/role', '', '', 'M', '', 'vcard-o', '', 3, 1);
    821. 

  821. INSERT INTO `base_menu` VALUES (26, '菜单管理', 22, '22/26', '/sysadmin/menu', '', '', 'M', '', 'book', '', 4, 1);
    822. 

  822. INSERT INTO `base_menu` VALUES (36, '字典分类', 22, '22/36', '/sysadmin/item', '', 'item', 'D', '', 'book', '', 11, 1);
    823. 

  823. INSERT INTO `base_menu` VALUES (39, '实验室管理', 0, '39', '/managingrooms', '无', 'managingrooms', 'M', '', 'book', '', 6, 1);
    824. 

  824. INSERT INTO `base_menu` VALUES (41, '班级管理', 0, '41', '/class', '', 'class', 'D', '', 'university', '', 5, 1);
    825. 

  825. INSERT INTO `base_menu` VALUES (42, '信息公告发布', 0, '42', '/information', '', 'information', 'M', 'information', 'file', '', 7, 1);
    826. 

  826. INSERT INTO `base_menu` VALUES (43, '设备管理', 0, '43', '', '无', '', 'D', '', 'gears', '', 8, 1);
    827. 

  827. INSERT INTO `base_menu` VALUES (45, '设备管理', 43, '43/45', '/instrument', '', '', 'M', '', 'get-pocket', '', 1, 1);
    828. 

  828. INSERT INTO `base_menu` VALUES (47, '值班管理', 0, '47', '/duty', '', 'duty', 'D', '', 'address-card', '', 3, 1);
    829. 

  829. INSERT INTO `base_menu` VALUES (48, '维护保养', 43, '43/48', '/instrument/maintainlog', '', '', 'M', '', 'sitemap', '', 1, 1);
    830. 

  830. INSERT INTO `base_menu` VALUES (49, '确认及报废', 43, '43/49', '/instrument/confirmandscrap', '', '', 'M', '', 'film', '', 1, 1);
    831. 

  831. INSERT INTO `base_menu` VALUES (50, '组织管理', 0, '50', '', '无', '', 'D', '', 'address-card', '', 10, 1);
    832. 

  832. INSERT INTO `base_menu` VALUES (51, '课程管理', 0, '51', '/course', '', 'course', 'D', '', 'book', '', 4, 1);
    833. 

  833. INSERT INTO `base_menu` VALUES (52, '值班人员', 0, '52', '/personnel', '无', 'personnel', 'M', 'personnel', 'book', '', 5, 1);
    834. 

  834. INSERT INTO `base_menu` VALUES (53, '平台首页', 0, '53', '/index', '', 'index', 'D', '', 'home', '', 1, 1);
    835. 

  835. 

  836. -- ----------------------------
    837. 

  837. -- Table structure for base_operationlog
    838. 

  838. -- ----------------------------
    839. 

  839. DROP TABLE IF EXISTS `base_operationlog`;
    840. 

  840. CREATE TABLE `base_operationlog`  (
    841. 

  841.   `Id` bigint(20) NOT NULL AUTO_INCREMENT,
    842. 

  842.   `AccCode` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '账户',
    843. 

  843.   `OpTage` int(11) NOT NULL COMMENT '1 修改 2删除',
    844. 

  844.   `TableName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    845. 

  845.   `TableDesc` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    846. 

  846.   `RecordId` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    847. 

  847.   `RecordData` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    848. 

  848.   `Createon` datetime(0) NULL DEFAULT NULL,
    849. 

  849.   `Createuserid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    850. 

  850.   `Createby` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    851. 

  851.   `OpDesc` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作描述',
    852. 

  852.   `Remark` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
    853. 

  853.   PRIMARY KEY (`Id`) USING BTREE
    854. 

  854. ) ENGINE = InnoDB AUTO_INCREMENT = 31780 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '操作日志' ROW_FORMAT = DYNAMIC;
    855. 

  855. 

  856. -- ----------------------------
    857. 

  857. -- Records of base_operationlog
    858. 

  858. -- ----------------------------
    859. 

  859. INSERT INTO `base_operationlog` VALUES (31772, '', 1, 'InstrumenMaintainLog', '设备管理', '136', '{\"Id\":136,\"InstrumenId\":252,\"InstrumenName\":\"电视\",\"InstrumenCode\":\"HX-YV-01\",\"OperaRemark\":\"2344\",\"OperaTpye\":\"设备维修\",\"TypeCode\":2,\"OperaUser\":\"123\",\"OperaOn\":\"2020-12-29T10:33:37+08:00\",\"CreateOn\":\"2020-12-29T10:33:49+08:00\",\"CreateUserId\":0,\"CreateBy\":\"\",\"ModifiedOn\":\"2020-12-29T10:33:49+08:00\",\"ModifiedUserId\":0,\"ModifiedBy\":\"\"}', '2020-12-29 17:22:02', '', '', '质量管理-HX-YV-01', '');
    860. 

  860. INSERT INTO `base_operationlog` VALUES (31773, '', 1, 'InstrumenMaintainLog', '设备管理', '137', '{\"Id\":137,\"InstrumenId\":252,\"InstrumenName\":\"电视\",\"InstrumenCode\":\"HX-YV-01\",\"OperaRemark\":\"123\",\"OperaTpye\":\"设备报废\",\"TypeCode\":2,\"OperaUser\":\"王天\",\"OperaOn\":\"2020-12-29T17:13:20+08:00\",\"CreateOn\":\"2020-12-29T17:15:20+08:00\",\"CreateUserId\":0,\"CreateBy\":\"\",\"ModifiedOn\":\"2020-12-29T17:15:20+08:00\",\"ModifiedUserId\":0,\"ModifiedBy\":\"\"}', '2020-12-29 17:22:12', '', '', '质量管理-HX-YV-01', '');
    861. 

  861. INSERT INTO `base_operationlog` VALUES (31774, '', 1, 'InstrumenMaintainLog', '设备管理', '139', '{\"Id\":139,\"InstrumenId\":252,\"InstrumenName\":\"电视\",\"InstrumenCode\":\"HX-YV-01\",\"OperaRemark\":\"123\",\"OperaTpye\":\"设备确认\",\"TypeCode\":2,\"OperaUser\":\"王\",\"OperaOn\":\"2020-12-29T17:41:07+08:00\",\"CreateOn\":\"2020-12-29T17:41:19+08:00\",\"CreateUserId\":0,\"CreateBy\":\"\",\"ModifiedOn\":\"2020-12-29T17:41:19+08:00\",\"ModifiedUserId\":0,\"ModifiedBy\":\"\"}', '2020-12-29 17:41:28', '', '', '质量管理-HX-YV-01', '');
    862. 

  862. INSERT INTO `base_operationlog` VALUES (31775, '', 1, 'InstrumenMaintainLog', '设备管理', '142', '{\"Id\":142,\"InstrumenId\":252,\"InstrumenName\":\"电视\",\"InstrumenCode\":\"HX-YV-01\",\"OperaRemark\":\"123\",\"OperaTpye\":\"设备确认\",\"TypeCode\":1,\"OperaUser\":\"123\",\"OperaOn\":\"2020-12-29T17:46:27+08:00\",\"CreateOn\":\"2020-12-29T17:46:39+08:00\",\"CreateUserId\":0,\"CreateBy\":\"\",\"ModifiedOn\":\"2020-12-29T17:46:39+08:00\",\"ModifiedUserId\":0,\"ModifiedBy\":\"\"}', '2020-12-29 17:47:01', '', '', '质量管理-HX-YV-01', '');
    863. 

  863. INSERT INTO `base_operationlog` VALUES (31776, '', 1, 'InstrumenMaintainLog', '设备管理', '135', '{\"Id\":135,\"InstrumenId\":252,\"InstrumenName\":\"电视\",\"InstrumenCode\":\"HX-YV-01\",\"OperaRemark\":\"345345\",\"OperaTpye\":\"设备确认\",\"TypeCode\":1,\"OperaUser\":\"123\",\"OperaOn\":\"2020-12-29T10:29:59+08:00\",\"CreateOn\":\"2020-12-29T10:30:11+08:00\",\"CreateUserId\":0,\"CreateBy\":\"\",\"ModifiedOn\":\"2020-12-29T10:30:11+08:00\",\"ModifiedUserId\":0,\"ModifiedBy\":\"\"}', '2020-12-29 17:47:21', '', '', '质量管理-HX-YV-01', '');
    864. 

  864. INSERT INTO `base_operationlog` VALUES (31777, '', 1, 'InstrumenMaintainLog', '设备管理', '138', '{\"Id\":138,\"InstrumenId\":252,\"InstrumenName\":\"电视\",\"InstrumenCode\":\"HX-YV-01\",\"OperaRemark\":\"123\",\"OperaTpye\":\"设备报废\",\"TypeCode\":2,\"OperaUser\":\"wang \",\"OperaOn\":\"2020-12-29T17:35:56+08:00\",\"CreateOn\":\"2020-12-29T17:36:06+08:00\",\"CreateUserId\":0,\"CreateBy\":\"\",\"ModifiedOn\":\"2020-12-29T17:36:06+08:00\",\"ModifiedUserId\":0,\"ModifiedBy\":\"\"}', '2020-12-29 17:50:22', '', '', '质量管理-HX-YV-01', '');
    865. 

  865. INSERT INTO `base_operationlog` VALUES (31778, '', 1, 'InstrumenMaintainLog', '设备管理', '137', '{\"Id\":137,\"InstrumenId\":252,\"InstrumenName\":\"电视\",\"InstrumenCode\":\"HX-YV-01\",\"OperaRemark\":\"123\",\"OperaTpye\":\"设备报废\",\"TypeCode\":2,\"OperaUser\":\"王天\",\"OperaOn\":\"2020-12-29T17:13:20+08:00\",\"CreateOn\":\"2020-12-29T17:15:20+08:00\",\"CreateUserId\":0,\"CreateBy\":\"\",\"ModifiedOn\":\"2020-12-29T17:22:12+08:00\",\"ModifiedUserId\":0,\"ModifiedBy\":\"\"}', '2020-12-29 17:50:31', '', '', '质量管理-HX-YV-01', '');
    866. 

  866. INSERT INTO `base_operationlog` VALUES (31779, '', 1, 'InstrumenMaintainLog', '设备管理', '136', '{\"Id\":136,\"InstrumenId\":252,\"InstrumenName\":\"电视\",\"InstrumenCode\":\"HX-YV-01\",\"OperaRemark\":\"2344\",\"OperaTpye\":\"设备维修\",\"TypeCode\":2,\"OperaUser\":\"张伟\",\"OperaOn\":\"2020-12-29T10:33:37+08:00\",\"CreateOn\":\"2020-12-29T10:33:49+08:00\",\"CreateUserId\":0,\"CreateBy\":\"\",\"ModifiedOn\":\"2020-12-29T17:22:02+08:00\",\"ModifiedUserId\":0,\"ModifiedBy\":\"\"}', '2020-12-29 17:50:37', '', '', '质量管理-HX-YV-01', '');
    867. 

  867. 

  868. -- ----------------------------
    869. 

  869. -- Table structure for base_organize
    870. 

  870. -- ----------------------------
    871. 

  871. DROP TABLE IF EXISTS `base_organize`;
    872. 

  872. CREATE TABLE `base_organize`  (
    873. 

  873.   `Id` int(10) NOT NULL AUTO_INCREMENT,
    874. 

  874.   `AccCode` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    875. 

  875.   `ParentId` int(10) NULL DEFAULT NULL COMMENT '上级组织id',
    876. 

  876.   `Paths` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '路径索引',
    877. 

  877.   `Code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    878. 

  878.   `FullName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
    879. 

  879.   `ShortName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '简称',
    880. 

  880.   `Category` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '分类',
    881. 

  881.   `OuterPhone` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '外部电话',
    882. 

  882.   `InnerPhone` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '内部电话',
    883. 

  883.   `Fax` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '传真',
    884. 

  884.   `Postalcode` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮政编码',
    885. 

  885.   `Address` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '地址',
    886. 

  886.   `Web` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    887. 

  887.   `Bank` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    888. 

  888.   `BankAccount` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    889. 

  889.   `Manager` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    890. 

  890.   `Layer` int(10) NULL DEFAULT NULL,
    891. 

  891.   `AssistantManager` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    892. 

  892.   `IsInnerOrganize` int(10) NOT NULL DEFAULT 1 COMMENT '是否时内部组织',
    893. 

  893.   `SortCode` int(10) NULL DEFAULT NULL COMMENT '排序码',
    894. 

  894.   `Description` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    895. 

  895.   `DeletionStateCode` int(10) NULL DEFAULT 0 COMMENT '删除状态码，未删除：0，已删除：1',
    896. 

  896.   `Enabled` int(10) NOT NULL DEFAULT 1,
    897. 

  897.   `CreateOn` datetime(0) NULL DEFAULT NULL,
    898. 

  898.   `CreateUserId` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    899. 

  899.   `CreateBy` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    900. 

  900.   `ModifiedOn` datetime(0) NULL DEFAULT NULL,
    901. 

  901.   `ModifiedUserId` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    902. 

  902.   `ModifiedBy` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    903. 

  903.   PRIMARY KEY (`Id`) USING BTREE
    904. 

  904. ) ENGINE = InnoDB AUTO_INCREMENT = 31 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    905. 

  905. 

  906. -- ----------------------------
    907. 

  907. -- Records of base_organize
    908. 

  908. -- ----------------------------
    909. 

  909. 

  910. -- ----------------------------
    911. 

  911. -- Table structure for base_parameter
    912. 

  912. -- ----------------------------
    913. 

  913. DROP TABLE IF EXISTS `base_parameter`;
    914. 

  914. CREATE TABLE `base_parameter`  (
    915. 

  915.   `ID` int(10) NOT NULL AUTO_INCREMENT,
    916. 

  916.   `CategoryID` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    917. 

  917.   `ParameterID` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    918. 

  918.   `ParameterCode` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    919. 

  919.   `ParameterContent` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    920. 

  920.   `Worked` int(11) NOT NULL DEFAULT 0,
    921. 

  921.   `Enabled` int(11) NOT NULL DEFAULT 0,
    922. 

  922.   `DeletionStateCode` int(11) NULL DEFAULT NULL,
    923. 

  923.   `SortCode` int(11) NULL DEFAULT NULL,
    924. 

  924.   `Description` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    925. 

  925.   `CreateOn` datetime(0) NULL DEFAULT NULL,
    926. 

  926.   `CreateUserId` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    927. 

  927.   `CreateBy` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    928. 

  928.   `ModifiedOn` datetime(0) NULL DEFAULT NULL,
    929. 

  929.   `ModifiedUserId` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    930. 

  930.   `ModifiedBy` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    931. 

  931.   PRIMARY KEY (`ID`) USING BTREE
    932. 

  932. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    933. 

  933. 

  934. -- ----------------------------
    935. 

  935. -- Records of base_parameter
    936. 

  936. -- ----------------------------
    937. 

  937. 

  938. -- ----------------------------
    939. 

  939. -- Table structure for base_role
    940. 

  940. -- ----------------------------
    941. 

  941. DROP TABLE IF EXISTS `base_role`;
    942. 

  942. CREATE TABLE `base_role`  (
    943. 

  943.   `Id` int(10) NOT NULL AUTO_INCREMENT,
    944. 

  944.   `AccCode` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    945. 

  945.   `SystemId` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    946. 

  946.   `OrganizeId` int(10) NULL DEFAULT NULL,
    947. 

  947.   `Code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    948. 

  948.   `Realname` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    949. 

  949.   `Category` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    950. 

  950.   `AllowEdit` int(10) NOT NULL DEFAULT 1,
    951. 

  951.   `DataScope` int(10) NOT NULL DEFAULT 1 COMMENT '数据集合权限 1：仅本人；2：本部门；3：本部门及以下；4：自定义；5：全部',
    952. 

  952.   `AllowDelete` int(10) NOT NULL DEFAULT 1,
    953. 

  953.   `SortCode` int(10) NULL DEFAULT 0,
    954. 

  954.   `DeletionStateCode` int(10) NOT NULL DEFAULT 0,
    955. 

  955.   `Enabled` int(10) NOT NULL DEFAULT 1,
    956. 

  956.   `IsVisible` int(10) NOT NULL DEFAULT 1 COMMENT '1显示',
    957. 

  957.   `Description` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    958. 

  958.   `CreateOn` datetime(0) NULL DEFAULT NULL,
    959. 

  959.   `CreateUserId` int(11) NULL DEFAULT NULL,
    960. 

  960.   `CreateBy` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    961. 

  961.   `ModifiedOn` datetime(0) NULL DEFAULT NULL,
    962. 

  962.   `ModifiedUserId` int(11) NULL DEFAULT NULL,
    963. 

  963.   `ModifiedBy` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    964. 

  964.   PRIMARY KEY (`Id`) USING BTREE
    965. 

  965. ) ENGINE = InnoDB AUTO_INCREMENT = 27 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    966. 

  966. 

  967. -- ----------------------------
    968. 

  968. -- Records of base_role
    969. 

  969. -- ----------------------------
    970. 

  970. INSERT INTO `base_role` VALUES (1, '', '', 0, 'admin', '管理员', '', 1, 5, 1, 0, 0, 1, 1, '', NULL, NULL, NULL, '2020-12-16 09:10:34', 1, '系统管理员');
    971. 

  971. INSERT INTO `base_role` VALUES (24, '', '', 0, 'role01', '角色01', '', 0, 4, 0, 0, 0, 0, 0, '', '2020-08-22 22:49:12', 1, '系统管理员', '2020-11-30 10:18:40', 10, 'test06');
    972. 

  972. INSERT INTO `base_role` VALUES (25, '', '', 0, 'role02', '教师', '', 0, 1, 0, 0, 0, 0, 0, '', '2020-11-30 17:00:00', 1, '系统管理员', '2020-11-30 17:00:20', 1, '系统管理员');
    973. 

  973. 

  974. -- ----------------------------
    975. 

  975. -- Table structure for base_role_datascope
    976. 

  976. -- ----------------------------
    977. 

  977. DROP TABLE IF EXISTS `base_role_datascope`;
    978. 

  978. CREATE TABLE `base_role_datascope`  (
    979. 

  979.   `Id` int(11) NOT NULL AUTO_INCREMENT,
    980. 

  980.   `RoleId` int(11) NOT NULL COMMENT '角色ID',
    981. 

  981.   `DataIds` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '数据ID',
    982. 

  982.   `DataType` int(11) NOT NULL DEFAULT 1 COMMENT '集合类型，1：组织结构，2：人员，3：地区',
    983. 

  983.   PRIMARY KEY (`Id`) USING BTREE
    984. 

  984. ) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '数据集合权限表' ROW_FORMAT = Dynamic;
    985. 

  985. 

  986. -- ----------------------------
    987. 

  987. -- Records of base_role_datascope
    988. 

  988. -- ----------------------------
    989. 

  989. INSERT INTO `base_role_datascope` VALUES (13, 1, '2,4', 1);
    990. 

  990. INSERT INTO `base_role_datascope` VALUES (14, 24, '2,4', 1);
    991. 

  991. 

  992. -- ----------------------------
    993. 

  993. -- Table structure for base_role_menu
    994. 

  994. -- ----------------------------
    995. 

  995. DROP TABLE IF EXISTS `base_role_menu`;
    996. 

  996. CREATE TABLE `base_role_menu`  (
    997. 

  997.   `Id` int(11) NOT NULL AUTO_INCREMENT,
    998. 

  998.   `RoleId` int(11) NULL DEFAULT NULL COMMENT '角色id',
    999. 

  999.   `MenuIds` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '权限id',
    1000. 

  1000.   PRIMARY KEY (`Id`) USING BTREE
    1001. 

  1001. ) ENGINE = InnoDB AUTO_INCREMENT = 27 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
    1002. 

  1002. 

  1003. -- ----------------------------
    1004. 

  1004. -- Records of base_role_menu
    1005. 

  1005. -- ----------------------------
    1006. 

  1006. INSERT INTO `base_role_menu` VALUES (12, 1, '22,26,36,39,41,42,43,45,46,48,49,47,50,23,24,25,51,52,53');
    1007. 

  1007. INSERT INTO `base_role_menu` VALUES (24, 24, '22,23,24,25,26,32,36,37,38');
    1008. 

  1008. INSERT INTO `base_role_menu` VALUES (25, 25, '22,26,32,36,28,29,30,31,33,34,35,39,41,43,45,46,48,49');
    1009. 

  1009. 

  1010. -- ----------------------------
    1011. 

  1011. -- Table structure for base_updated
    1012. 

  1012. -- ----------------------------
    1013. 

  1013. DROP TABLE IF EXISTS `base_updated`;
    1014. 

  1014. CREATE TABLE `base_updated`  (
    1015. 

  1015.   `Id` bigint(20) NOT NULL AUTO_INCREMENT,
    1016. 

  1016.   `TableName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    1017. 

  1017.   `RecordId` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    1018. 

  1018.   `RecordData` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    1019. 

  1019.   `Createon` datetime(0) NULL DEFAULT NULL,
    1020. 

  1020.   `Createuserid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1021. 

  1021.   `Createby` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1022. 

  1022.   PRIMARY KEY (`Id`) USING BTREE
    1023. 

  1023. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    1024. 

  1024. 

  1025. -- ----------------------------
    1026. 

  1026. -- Records of base_updated
    1027. 

  1027. -- ----------------------------
    1028. 

  1028. 

  1029. -- ----------------------------
    1030. 

  1030. -- Table structure for base_user
    1031. 

  1031. -- ----------------------------
    1032. 

  1032. DROP TABLE IF EXISTS `base_user`;
    1033. 

  1033. CREATE TABLE `base_user`  (
    1034. 

  1034.   `Id` int(10) NOT NULL AUTO_INCREMENT,
    1035. 

  1035.   `Uuid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户Id标识，不易猜出',
    1036. 

  1036.   `AccCode` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '区分不同App的用户',
    1037. 

  1037.   `Code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '编码',
    1038. 

  1038.   `UserName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户登录名',
    1039. 

  1039.   `Realname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户名',
    1040. 

  1040.   `RoleId` int(10) NULL DEFAULT NULL COMMENT '角色id',
    1041. 

  1041.   `SecurityLevel` int(10) NULL DEFAULT NULL,
    1042. 

  1042.   `UserFrom` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1043. 

  1043.   `CompanyId` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '公司id',
    1044. 

  1044.   `CompanyName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '公司名称',
    1045. 

  1045.   `DepartmentId` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '部门id ',
    1046. 

  1046.   `DepartmentName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '部门名称',
    1047. 

  1047.   `WorkgroupId` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '工作组id',
    1048. 

  1048.   `WorkgroupName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '工作组名称',
    1049. 

  1049.   `WorkCategory` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1050. 

  1050.   `Duty` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '职务',
    1051. 

  1051.   `Title` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '头衔',
    1052. 

  1052.   `Gender` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '性别',
    1053. 

  1053.   `Birthday` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1054. 

  1054.   `Mobile` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1055. 

  1055.   `Telephone` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1056. 

  1056.   `Email` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1057. 

  1057.   `OICQ` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1058. 

  1058.   `HomeAddress` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1059. 

  1059.   `UserPassword` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1060. 

  1060.   `ChangePasswordDate` datetime(0) NULL DEFAULT NULL COMMENT '改密码时间',
    1061. 

  1061.   `CommunicationPassword` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1062. 

  1062.   `PublicKey` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1063. 

  1063.   `SignedPassword` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1064. 

  1064.   `Lang` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1065. 

  1065.   `Theme` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1066. 

  1066.   `AllowStartTime` datetime(0) NULL DEFAULT NULL,
    1067. 

  1067.   `AllowEndTime` datetime(0) NULL DEFAULT NULL,
    1068. 

  1068.   `LockStartDate` datetime(0) NULL DEFAULT NULL,
    1069. 

  1069.   `LockEndDate` datetime(0) NULL DEFAULT NULL,
    1070. 

  1070.   `FirstVisit` datetime(0) NULL DEFAULT NULL,
    1071. 

  1071.   `PreviousVisit` datetime(0) NULL DEFAULT NULL,
    1072. 

  1072.   `LastVisit` datetime(0) NULL DEFAULT NULL,
    1073. 

  1073.   `LogOnCount` int(10) NOT NULL DEFAULT 0,
    1074. 

  1074.   `IsStaff` int(10) NOT NULL DEFAULT 1,
    1075. 

  1075.   `UserOnLine` int(10) NOT NULL DEFAULT 1,
    1076. 

  1076.   `IsVisible` int(10) NOT NULL DEFAULT 1 COMMENT '是否可视，1为可视 ',
    1077. 

  1077.   `OpenId` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1078. 

  1078.   `IPAddress` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1079. 

  1079.   `MACAddress` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1080. 

  1080.   `Question` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1081. 

  1081.   `AnswerQuestion` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1082. 

  1082.   `UserAddressId` int(10) NULL DEFAULT NULL,
    1083. 

  1083.   `Enabled` int(10) NOT NULL DEFAULT 1 COMMENT '是否可用',
    1084. 

  1084.   `AuditStatus` int(50) NULL DEFAULT NULL COMMENT '激活状态（1激活）',
    1085. 

  1085.   `DeletionStateCode` int(10) NOT NULL DEFAULT 0 COMMENT '删除状态',
    1086. 

  1086.   `SortCode` int(10) NULL DEFAULT NULL,
    1087. 

  1087.   `Description` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1088. 

  1088.   `CreateOn` datetime(0) NULL DEFAULT NULL,
    1089. 

  1089.   `CreateUserId` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1090. 

  1090.   `CreateBy` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1091. 

  1091.   `ModifiedOn` datetime(0) NULL DEFAULT NULL,
    1092. 

  1092.   `ModifiedUserId` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1093. 

  1093.   `ModifiedBy` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1094. 

  1094.   `Photo` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1095. 

  1095.   `QRCode` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1096. 

  1096.   `QRCodeImage` blob NULL,
    1097. 

  1097.   `IsCompanyUser` int(11) NULL DEFAULT NULL COMMENT '是否是企业用户（供方字段用）',
    1098. 

  1098.   `Superior` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '上级部门',
    1099. 

  1099.   `UnitId` int(11) NULL DEFAULT NULL COMMENT '二级单位ID（供方字段用）',
    1100. 

  1100.   `Unit` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1101. 

  1101.   PRIMARY KEY (`Id`) USING BTREE
    1102. 

  1102. ) ENGINE = InnoDB AUTO_INCREMENT = 20 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户表' ROW_FORMAT = Dynamic;
    1103. 

  1103. 

  1104. -- ----------------------------
    1105. 

  1105. -- Records of base_user
    1106. 

  1106. -- ----------------------------
    1107. 

  1107. INSERT INTO `base_user` VALUES (1, '095771e03f6fbd20af351dc259560232', '', 'Administrator', 'dashoo', '系统管理员', 0, 0, '', '0', '总部', '1', '大数华创', '', '', '', '0', '222304196903262000', '0', '1969-03-26 00:00:00', '18561558841', '1234', '12345678@163.com', '', '青岛市七级社区 ', '71wYTFTaOn0=', NULL, '', 'eeZp3CxZQ7rcQfPAQLjckHMa', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 1, 0, '', '', '', '', '', 0, 1, 1, 0, 0, 'dashoo大数', NULL, '', '', '2020-08-22 23:50:51', '1', '系统管理员', '', '6a95f83c285b7e8bc44ce7e56fca2a32', NULL, 0, '', 0, '');
    1108. 

  1108. 

  1109. -- ----------------------------
    1110. 

  1110. -- Table structure for base_user_role
    1111. 

  1111. -- ----------------------------
    1112. 

  1112. DROP TABLE IF EXISTS `base_user_role`;
    1113. 

  1113. CREATE TABLE `base_user_role`  (
    1114. 

  1114.   `Id` int(11) NOT NULL AUTO_INCREMENT,
    1115. 

  1115.   `UserId` int(11) NOT NULL,
    1116. 

  1116.   `RoleIds` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
    1117. 

  1117.   PRIMARY KEY (`Id`) USING BTREE
    1118. 

  1118. ) ENGINE = InnoDB AUTO_INCREMENT = 19 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
    1119. 

  1119. 

  1120. -- ----------------------------
    1121. 

  1121. -- Records of base_user_role
    1122. 

  1122. -- ----------------------------
    1123. 

  1123. INSERT INTO `base_user_role` VALUES (2, 1, '1,24');
    1124. 

  1124. INSERT INTO `base_user_role` VALUES (3, 3, '23');
    1125. 

  1125. INSERT INTO `base_user_role` VALUES (4, 4, '2,1');
    1126. 

  1126. INSERT INTO `base_user_role` VALUES (5, 7, '1,2,23');
    1127. 

  1127. INSERT INTO `base_user_role` VALUES (6, 8, '1,23,2');
    1128. 

  1128. INSERT INTO `base_user_role` VALUES (7, 0, '1,23');
    1129. 

  1129. INSERT INTO `base_user_role` VALUES (8, 9, '1');
    1130. 

  1130. INSERT INTO `base_user_role` VALUES (9, 10, '1');
    1131. 

  1131. INSERT INTO `base_user_role` VALUES (10, 11, '1');
    1132. 

  1132. INSERT INTO `base_user_role` VALUES (11, 12, '1');
    1133. 

  1133. INSERT INTO `base_user_role` VALUES (12, 13, '1');
    1134. 

  1134. INSERT INTO `base_user_role` VALUES (13, 14, '1');
    1135. 

  1135. INSERT INTO `base_user_role` VALUES (14, 15, '1');
    1136. 

  1136. INSERT INTO `base_user_role` VALUES (15, 16, '1');
    1137. 

  1137. INSERT INTO `base_user_role` VALUES (16, 17, '1');
    1138. 

  1138. INSERT INTO `base_user_role` VALUES (17, 18, '1');
    1139. 

  1139. INSERT INTO `base_user_role` VALUES (18, 19, '1');
    1140. 

  1140. 

  1141. -- ----------------------------
    1142. 

  1142. -- Table structure for base_userequipment
    1143. 

  1143. -- ----------------------------
    1144. 

  1144. DROP TABLE IF EXISTS `base_userequipment`;
    1145. 

  1145. CREATE TABLE `base_userequipment`  (
    1146. 

  1146.   `Id` int(10) NOT NULL AUTO_INCREMENT,
    1147. 

  1147.   `AccCode` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1148. 

  1148.   `UserId` int(10) NULL DEFAULT NULL,
    1149. 

  1149.   `EquipmentId` int(10) NOT NULL,
    1150. 

  1150.   `SortCode` int(10) NULL DEFAULT NULL,
    1151. 

  1151.   `Enabled` int(10) NOT NULL DEFAULT 1,
    1152. 

  1152.   `DeletionStateCode` int(10) NOT NULL DEFAULT 0,
    1153. 

  1153.   `Description` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1154. 

  1154.   `CreateOn` datetime(0) NULL DEFAULT NULL,
    1155. 

  1155.   `CreateUserId` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1156. 

  1156.   `CreateBy` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1157. 

  1157.   `ModifiedOn` datetime(0) NULL DEFAULT NULL,
    1158. 

  1158.   `ModifiedUserId` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1159. 

  1159.   `ModifiedBy` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1160. 

  1160.   PRIMARY KEY (`Id`) USING BTREE
    1161. 

  1161. ) ENGINE = InnoDB AUTO_INCREMENT = 67 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户设备权限' ROW_FORMAT = Dynamic;
    1162. 

  1162. 

  1163. -- ----------------------------
    1164. 

  1164. -- Records of base_userequipment
    1165. 

  1165. -- ----------------------------
    1166. 

  1166. INSERT INTO `base_userequipment` VALUES (37, 'sJclw', 244, 26, 0, 0, 0, '', '2015-09-11 09:43:28', '241', '青岛第二肿瘤医院', '2015-09-11 09:43:28', '0', '');
    1167. 

  1167. INSERT INTO `base_userequipment` VALUES (39, 'sdC45', 254, 43, 0, 0, 0, '', '2015-10-23 15:38:48', '252', 'cloud health', '2015-10-23 15:38:48', '0', '');
    1168. 

  1168. INSERT INTO `base_userequipment` VALUES (41, 'ss3Gt', 256, 45, 0, 0, 0, '', '2015-10-26 16:13:29', '255', '复旦公共卫生学院', '2015-10-26 16:13:29', '0', '');
    1169. 

  1169. INSERT INTO `base_userequipment` VALUES (45, 'sYDVw', 263, 51, 0, 0, 0, '', '2015-11-25 07:41:51', '257', '上海长征医院', '2015-11-25 07:41:51', '0', '');
    1170. 

  1170. INSERT INTO `base_userequipment` VALUES (46, 'sJclw', 260, 63, 0, 0, 0, '', '2016-01-06 10:37:16', '241', '贝尔科技样本库中心（超低温库）', '2016-01-06 10:37:16', '0', '');
    1171. 

  1171. INSERT INTO `base_userequipment` VALUES (47, 'sp2Fq', 285, 88, 0, 0, 0, '', '2016-05-09 12:32:06', '282', '上海第一妇婴保健院', '2016-05-09 12:32:05', '0', '');
    1172. 

  1172. INSERT INTO `base_userequipment` VALUES (48, 's5OVE', 292, 117, 0, 0, 0, '', '2016-09-21 09:43:18', '284', '演示用户', '2016-09-21 09:43:18', '0', '');
    1173. 

  1173. INSERT INTO `base_userequipment` VALUES (49, 's5OVE', 293, 78, 0, 0, 0, '', '2016-09-21 12:41:53', '284', '演示用户', '2016-09-21 12:41:53', '0', '');
    1174. 

  1174. INSERT INTO `base_userequipment` VALUES (50, 's5OVE', 294, 117, 0, 0, 0, '', '2016-09-22 13:16:36', '284', '演示用户', '2016-09-22 13:16:36', '0', '');
    1175. 

  1175. INSERT INTO `base_userequipment` VALUES (51, 's5OVE', 294, 110, 0, 0, 0, '', '2016-09-22 13:16:36', '284', '演示用户', '2016-09-22 13:16:36', '0', '');
    1176. 

  1176. INSERT INTO `base_userequipment` VALUES (52, 's5OVE', 294, 78, 0, 0, 0, '', '2016-09-22 13:16:36', '284', '演示用户', '2016-09-22 13:16:36', '0', '');
    1177. 

  1177. INSERT INTO `base_userequipment` VALUES (53, 's5OVE', 294, 121, 0, 0, 0, '', '2016-09-22 13:16:36', '284', '演示用户', '2016-09-22 13:16:36', '0', '');
    1178. 

  1178. INSERT INTO `base_userequipment` VALUES (54, 's5OVE', 294, 77, 0, 0, 0, '', '2016-09-22 13:16:36', '284', '演示用户', '2016-09-22 13:16:36', '0', '');
    1179. 

  1179. INSERT INTO `base_userequipment` VALUES (55, 's5OVE', 294, 119, 0, 0, 0, '', '2016-09-22 13:16:36', '284', '演示用户', '2016-09-22 13:16:36', '0', '');
    1180. 

  1180. INSERT INTO `base_userequipment` VALUES (56, 's5OVE', 294, 76, 0, 0, 0, '', '2016-09-22 13:16:36', '284', '演示用户', '2016-09-22 13:16:36', '0', '');
    1181. 

  1181. INSERT INTO `base_userequipment` VALUES (57, 's5OVE', 294, 96, 0, 0, 0, '', '2016-09-22 13:16:36', '284', '演示用户', '2016-09-22 13:16:36', '0', '');
    1182. 

  1182. INSERT INTO `base_userequipment` VALUES (58, 's5OVE', 294, 90, 0, 0, 0, '', '2016-09-22 13:16:36', '284', '演示用户', '2016-09-22 13:16:36', '0', '');
    1183. 

  1183. INSERT INTO `base_userequipment` VALUES (61, 'sc1HK', 280, 171, 0, 0, 0, '', '2017-02-17 10:16:33', '273', 'yanqing', '2017-02-17 10:16:33', '0', '');
    1184. 

  1184. INSERT INTO `base_userequipment` VALUES (62, 's5OVE', 295, 110, 0, 0, 0, '', '2017-04-18 09:54:05', '284', '演示用户', '2017-04-18 09:54:05', '0', '');
    1185. 

  1185. INSERT INTO `base_userequipment` VALUES (63, 's5OVE', 295, 78, 0, 0, 0, '', '2017-04-18 09:54:05', '284', '演示用户', '2017-04-18 09:54:05', '0', '');
    1186. 

  1186. INSERT INTO `base_userequipment` VALUES (64, 'sJclw', 299, 66, 0, 0, 0, '', '2017-04-20 14:26:13', '241', '贝尔科技样本库中心（综合库）', '2017-04-20 14:26:13', '0', '');
    1187. 

  1187. INSERT INTO `base_userequipment` VALUES (65, 'sJclw', 299, 85, 0, 0, 0, '', '2017-04-20 14:26:13', '241', '贝尔科技样本库中心（综合库）', '2017-04-20 14:26:13', '0', '');
    1188. 

  1188. INSERT INTO `base_userequipment` VALUES (66, 'sdkXu', 307, 193, 0, 0, 0, '', '2017-06-22 10:34:31', '259', '南昌市第九医院', '2017-06-22 10:34:31', '0', '');
    1189. 

  1189. 

  1190. -- ----------------------------
    1191. 

  1191. -- Table structure for class
    1192. 

  1192. -- ----------------------------
    1193. 

  1193. DROP TABLE IF EXISTS `class`;
    1194. 

  1194. CREATE TABLE `class`  (
    1195. 

  1195.   `Id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
    1196. 

  1196.   `Year` int(11) NULL DEFAULT NULL COMMENT '年级',
    1197. 

  1197.   `Name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '班级名称',
    1198. 

  1198.   `CreatedBy` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人',
    1199. 

  1199.   `CreatedTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
    1200. 

  1200.   `UpdatedBy` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人',
    1201. 

  1201.   `UpdatedTime` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
    1202. 

  1202.   `IsDel` int(11) NOT NULL COMMENT '删除标志',
    1203. 

  1203.   PRIMARY KEY (`Id`) USING BTREE
    1204. 

  1204. ) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '班级表' ROW_FORMAT = Dynamic;
    1205. 

  1205. 

  1206. -- ----------------------------
    1207. 

  1207. -- Records of class
    1208. 

  1208. -- ----------------------------
    1209. 

  1209. INSERT INTO `class` VALUES (11, 2020, '计算机软件一班', '', '2020-12-28 14:26:40', '', '2020-12-28 14:26:40', 0);
    1210. 

  1210. INSERT INTO `class` VALUES (12, 2020, '计算机软件二班', '', '2020-12-28 14:26:47', '', '2020-12-28 14:26:47', 0);
    1211. 

  1211. 

  1212. -- ----------------------------
    1213. 

  1213. -- Table structure for course
    1214. 

  1214. -- ----------------------------
    1215. 

  1215. DROP TABLE IF EXISTS `course`;
    1216. 

  1216. CREATE TABLE `course`  (
    1217. 

  1217.   `Id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
    1218. 

  1218.   `Year` int(11) NULL DEFAULT NULL COMMENT '学年',
    1219. 

  1219.   `Term` int(11) NULL DEFAULT NULL COMMENT '学期',
    1220. 

  1220.   `ClassId` int(11) NULL DEFAULT NULL COMMENT '班级ID',
    1221. 

  1221.   `CourseWeek` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '教学周',
    1222. 

  1222.   `Title` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '标题',
    1223. 

  1223.   `Status` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '状态',
    1224. 

  1224.   `CreatedBy` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人',
    1225. 

  1225.   `CreatedTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
    1226. 

  1226.   `UpdatedBy` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人',
    1227. 

  1227.   `UpdatedTime` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
    1228. 

  1228.   `IsDel` int(11) NOT NULL COMMENT '删除标志',
    1229. 

  1229.   PRIMARY KEY (`Id`) USING BTREE
    1230. 

  1230. ) ENGINE = InnoDB AUTO_INCREMENT = 30 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '课程表' ROW_FORMAT = Dynamic;
    1231. 

  1231. 

  1232. -- ----------------------------
    1233. 

  1233. -- Records of course
    1234. 

  1234. -- ----------------------------
    1235. 

  1235. INSERT INTO `course` VALUES (2, 2020, 2, 11, '第1-20周课表', '第1-20周课表', '1', '', '2020-12-15 19:28:32', '系统管理员', '2020-12-28 17:39:19', 0);
    1236. 

  1236. INSERT INTO `course` VALUES (4, 2020, 2, 12, '321', '第20-30周课表', '1', '', '2020-12-16 11:13:05', '系统管理员', '2020-12-28 17:26:11', 0);
    1237. 

  1237. INSERT INTO `course` VALUES (7, 2020, 1, 11, '2', '第30-54周课表', '1', '', '2020-12-16 11:57:14', '系统管理员', '2020-12-28 17:26:33', 0);
    1238. 

  1238. 

  1239. -- ----------------------------
    1240. 

  1240. -- Table structure for course_detail
    1241. 

  1241. -- ----------------------------
    1242. 

  1242. DROP TABLE IF EXISTS `course_detail`;
    1243. 

  1243. CREATE TABLE `course_detail`  (
    1244. 

  1244.   `Id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
    1245. 

  1245.   `CourseId` int(11) NULL DEFAULT NULL COMMENT '课程表ID',
    1246. 

  1246.   `Year` int(11) NULL DEFAULT NULL COMMENT '学年',
    1247. 

  1247.   `Term` int(11) NULL DEFAULT NULL COMMENT '学期',
    1248. 

  1248.   `CourseName` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '课程名',
    1249. 

  1249.   `Teacher` int(11) NULL DEFAULT NULL COMMENT '授课老师',
    1250. 

  1250.   `Local` int(11) NULL DEFAULT NULL COMMENT '实验地点',
    1251. 

  1251.   `Class` int(11) NULL DEFAULT NULL COMMENT '授课班级',
    1252. 

  1252.   `Mark` decimal(32, 8) NULL DEFAULT NULL COMMENT '学分',
    1253. 

  1253.   `Num` int(11) NULL DEFAULT NULL COMMENT '人数',
    1254. 

  1254.   `WeekTitle` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '教学周',
    1255. 

  1255.   `DayOfWeek` int(11) NULL DEFAULT NULL COMMENT '周次 1-7',
    1256. 

  1256.   `Time` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '节次',
    1257. 

  1257.   `Status` int(11) NULL DEFAULT NULL COMMENT '状态 发布状态',
    1258. 

  1258.   `CreatedBy` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人',
    1259. 

  1259.   `CreatedTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
    1260. 

  1260.   `UpdatedBy` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人',
    1261. 

  1261.   `UpdatedTime` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
    1262. 

  1262.   `IsDel` int(11) NOT NULL COMMENT '删除标志',
    1263. 

  1263.   PRIMARY KEY (`Id`) USING BTREE
    1264. 

  1264. ) ENGINE = InnoDB AUTO_INCREMENT = 18 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '课程明细表' ROW_FORMAT = Dynamic;
    1265. 

  1265. 

  1266. -- ----------------------------
    1267. 

  1267. -- Records of course_detail
    1268. 

  1268. -- ----------------------------
    1269. 

  1269. INSERT INTO `course_detail` VALUES (1, 4, 321, 321, '软件技术', 1, 365, 0, 10.00000000, 30, '2', 0, '2,6,11', 1, '', '2020-12-16 19:03:58', '', '2020-12-29 11:09:20', 0);
    1270. 

  1270. INSERT INTO `course_detail` VALUES (2, 15, 2020, 0, '数学', 1, 0, 0, 10.00000000, 30, '2', 2, '2', 0, '', '2020-12-17 11:43:13', '系统管理员', '2020-12-17 17:37:16', 1);
    1271. 

  1271. INSERT INTO `course_detail` VALUES (3, 15, 2020, 0, '高数', 1, 362, 0, 20.00000000, 30, '2', 2, '1,2', 0, '系统管理员', '2020-12-17 14:17:34', '', '2020-12-25 20:04:08', 0);
    1272. 

  1272. INSERT INTO `course_detail` VALUES (4, 13, 123, 123, '英语', 1, 0, 0, 20.00000000, 20, '2', 2, '2', 0, '', '2020-12-17 14:26:09', '系统管理员', '2020-12-17 17:37:42', 1);
    1273. 

  1273. INSERT INTO `course_detail` VALUES (5, 13, 123, 123, '英语', 1, 0, 0, 20.00000000, 20, '2', 2, '2', 1, '', '2020-12-17 14:28:34', '系统管理员', '2020-12-17 17:37:42', 1);
    1274. 

  1274. INSERT INTO `course_detail` VALUES (6, 13, 123, 123, '英语', 1, 331, 0, 20.00000000, 20, '2', 2, '', 1, '', '2020-12-17 14:48:38', '', '2020-12-25 19:36:52', 0);
    1275. 

  1275. INSERT INTO `course_detail` VALUES (7, 15, 2020, 0, '123', 1, 0, 0, 312.00000000, 312, '31', 31, '1,2', 0, '系统管理员', '2020-12-18 11:12:14', '', '2020-12-25 09:46:00', 1);
    1276. 

  1276. INSERT INTO `course_detail` VALUES (8, 15, 2020, 0, '1233', 1, 0, 0, 312.00000000, 312, '312', 312, '1,2,3', 0, '系统管理员', '2020-12-18 11:12:55', '系统管理员', '2020-12-18 11:13:10', 1);
    1277. 

  1277. INSERT INTO `course_detail` VALUES (9, 15, 2020, 0, '体育', 1, 364, 0, 10.00000000, 30, '2', 2, '1,2', 0, '系统管理员', '2020-12-18 18:04:30', '', NULL, 0);
    1278. 

  1278. INSERT INTO `course_detail` VALUES (10, 2, 2018, 0, '软件工程', 1, 364, 0, 10.00000000, 30, '20周', 0, '', 0, '', '2020-12-22 13:58:32', '', '2020-12-28 17:39:25', 0);
    1279. 

  1279. INSERT INTO `course_detail` VALUES (13, 15, 2020, 1, '美术', 1, 362, 0, 10.00000000, 30, '2', 1, '1,2', 0, '', '2020-12-25 19:37:41', '', '2020-12-25 19:54:10', 1);
    1280. 

  1280. INSERT INTO `course_detail` VALUES (14, 15, 2020, 1, '美术', 1, 362, 0, 10.00000000, 30, '2', 2, '1,2', 0, '', '2020-12-25 19:57:22', '', '2020-12-25 19:57:26', 1);
    1281. 

  1281. INSERT INTO `course_detail` VALUES (15, 7, 2020, 1, 'JAVA开发', 1, 369, 0, 20.00000000, 100, '第31周', 1, '1,2', 0, '', '2020-12-28 17:33:31', '', '2020-12-29 14:55:47', 0);
    1282. 

  1282. INSERT INTO `course_detail` VALUES (16, 7, 2020, 1, '计算机', 1, 369, 0, 12.00000000, 5, '3', 4, '1,12,2', 0, '', '2020-12-28 18:19:38', '', '2020-12-29 14:55:55', 0);
    1283. 

  1283. INSERT INTO `course_detail` VALUES (17, 7, 2020, 1, '计算机知识', 1, 364, 0, 15.00000000, 5, '第二周', 5, '2,6,11', 0, '', '2020-12-28 18:20:01', '', '2020-12-29 11:09:10', 0);
    1284. 

  1284. 

  1285. -- ----------------------------
    1286. 

  1286. -- Table structure for duty
    1287. 

  1287. -- ----------------------------
    1288. 

  1288. DROP TABLE IF EXISTS `duty`;
    1289. 

  1289. CREATE TABLE `duty`  (
    1290. 

  1290.   `Id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
    1291. 

  1291.   `Year` int(11) NOT NULL COMMENT '学年',
    1292. 

  1292.   `Term` int(11) NOT NULL COMMENT '学期',
    1293. 

  1293.   `Title` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '标题',
    1294. 

  1294.   `Status` int(11) NOT NULL COMMENT '状态',
    1295. 

  1295.   `CreatedBy` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人',
    1296. 

  1296.   `CreatedTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
    1297. 

  1297.   `UpdatedBy` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人',
    1298. 

  1298.   `UpdatedTime` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
    1299. 

  1299.   `IsDel` int(11) NOT NULL COMMENT '删除标志',
    1300. 

  1300.   PRIMARY KEY (`Id`) USING BTREE
    1301. 

  1301. ) ENGINE = InnoDB AUTO_INCREMENT = 325 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '值班表 ' ROW_FORMAT = Dynamic;
    1302. 

  1302. 

  1303. -- ----------------------------
    1304. 

  1304. -- Records of duty
    1305. 

  1305. -- ----------------------------
    1306. 

  1306. INSERT INTO `duty` VALUES (22, 2020, 1, '计算机楼1-24周值班表1', 1, '', '2020-12-28 14:30:32', '', '2020-12-28 17:31:07', 0);
    1307. 

  1307. INSERT INTO `duty` VALUES (323, 2020, 1, '计算机楼24-54周值班表', 1, '', '2020-12-28 17:44:28', '', '2020-12-28 19:16:32', 0);
    1308. 

  1308. INSERT INTO `duty` VALUES (324, 2020, 1, '第1-21周', 1, '', '2020-12-28 19:20:12', '', '2020-12-28 19:43:45', 0);
    1309. 

  1309. INSERT INTO `duty` VALUES (325, 2020, 2, '12日计划', 1, '', '2020-12-29 15:38:30', '', NULL, 0);
    1310. 

  1310. 

  1311. -- ----------------------------
    1312. 

  1312. -- Table structure for duty_detail
    1313. 

  1313. -- ----------------------------
    1314. 

  1314. DROP TABLE IF EXISTS `duty_detail`;
    1315. 

  1315. CREATE TABLE `duty_detail`  (
    1316. 

  1316.   `Id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
    1317. 

  1317.   `DutyId` int(11) NOT NULL COMMENT '值班ID',
    1318. 

  1318.   `Local` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '地点',
    1319. 

  1319.   `Time` int(11) NULL DEFAULT NULL COMMENT '时间段',
    1320. 

  1320.   `Status` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_as_ci NULL DEFAULT NULL COMMENT '状态',
    1321. 

  1321.   `People` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '值班人员',
    1322. 

  1322.   `Monday` int(11) NULL DEFAULT NULL COMMENT '周一',
    1323. 

  1323.   `Tuesday` int(11) NULL DEFAULT NULL COMMENT '周二',
    1324. 

  1324.   `Wednesday` int(11) NULL DEFAULT NULL COMMENT '周三',
    1325. 

  1325.   `Thursday` int(11) NULL DEFAULT NULL COMMENT '周四',
    1326. 

  1326.   `Friday` int(11) NULL DEFAULT NULL COMMENT '周五',
    1327. 

  1327.   `Saturday` int(11) NULL DEFAULT NULL COMMENT '周六',
    1328. 

  1328.   `Sunday` int(11) NULL DEFAULT NULL COMMENT '周天',
    1329. 

  1329.   `CreatedBy` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人',
    1330. 

  1330.   `CreatedTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
    1331. 

  1331.   `UpdatedBy` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人',
    1332. 

  1332.   `UpdatedTime` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
    1333. 

  1333.   `IsDel` int(11) NOT NULL COMMENT '删除标志',
    1334. 

  1334.   PRIMARY KEY (`Id`) USING BTREE
    1335. 

  1335. ) ENGINE = InnoDB AUTO_INCREMENT = 179 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '值班详情表' ROW_FORMAT = Dynamic;
    1336. 

  1336. 

  1337. -- ----------------------------
    1338. 

  1338. -- Records of duty_detail
    1339. 

  1339. -- ----------------------------
    1340. 

  1340. INSERT INTO `duty_detail` VALUES (129, 20, '2', 1, '', '', 1, 2, 0, 0, 1, 0, 4, '', '2020-12-28 14:31:32', '', '2020-12-28 15:09:36', 1);
    1341. 

  1341. INSERT INTO `duty_detail` VALUES (130, 20, '2', 3, '', '', 0, 2, 0, 0, 1, 4, 0, '', '2020-12-28 14:31:32', '', '2020-12-28 15:09:36', 1);
    1342. 

  1342. INSERT INTO `duty_detail` VALUES (131, 20, '2', 2, '', '', 0, 2, 1, 0, 1, 0, 0, '', '2020-12-28 14:31:32', '', '2020-12-28 15:09:36', 1);
    1343. 

  1343. INSERT INTO `duty_detail` VALUES (132, 20, '2', 4, '', '', 0, 2, 0, 1, 1, 0, 0, '', '2020-12-28 14:31:32', '', '2020-12-28 15:09:36', 1);
    1344. 

  1344. INSERT INTO `duty_detail` VALUES (133, 20, '1', 1, '', '', 0, 2, 4, 0, 1, 0, 0, '', '2020-12-28 14:31:32', '', '2020-12-28 15:09:36', 1);
    1345. 

  1345. INSERT INTO `duty_detail` VALUES (134, 20, '1', 3, '', '', 0, 2, 0, 0, 1, 1, 0, '', '2020-12-28 14:31:32', '', '2020-12-28 15:09:36', 1);
    1346. 

  1346. INSERT INTO `duty_detail` VALUES (135, 20, '1', 2, '', '', 4, 2, 0, 0, 1, 0, 1, '', '2020-12-28 14:31:32', '', '2020-12-28 15:09:36', 1);
    1347. 

  1347. INSERT INTO `duty_detail` VALUES (136, 20, '1', 4, '', '', 4, 2, 0, 0, 1, 0, 0, '', '2020-12-28 14:31:32', '', '2020-12-28 15:09:36', 1);
    1348. 

  1348. INSERT INTO `duty_detail` VALUES (137, 20, '2', 1, '', '', 0, 0, 0, 0, 0, 0, 0, '', '2020-12-28 14:43:14', '', '2020-12-28 15:09:36', 1);
    1349. 

  1349. INSERT INTO `duty_detail` VALUES (138, 20, '1', 1, '', '', 0, 0, 0, 0, 0, 0, 0, '', '2020-12-28 14:43:14', '', '2020-12-28 15:09:36', 1);
    1350. 

  1350. INSERT INTO `duty_detail` VALUES (139, 21, '2', 1, '', '', 5, 0, 4, 6, 0, 1, 0, '', '2020-12-28 14:47:03', '', NULL, 0);
    1351. 

  1351. INSERT INTO `duty_detail` VALUES (140, 21, '2', 3, '', '', 0, 5, 4, 5, 0, 1, 5, '', '2020-12-28 14:47:03', '', NULL, 0);
    1352. 

  1352. INSERT INTO `duty_detail` VALUES (141, 21, '2', 4, '', '', 0, 6, 4, 0, 0, 1, 0, '', '2020-12-28 14:47:03', '', NULL, 0);
    1353. 

  1353. INSERT INTO `duty_detail` VALUES (142, 21, '2', 2, '', '', 0, 0, 4, 0, 0, 1, 0, '', '2020-12-28 14:47:03', '', NULL, 0);
    1354. 

  1354. INSERT INTO `duty_detail` VALUES (143, 21, '1', 1, '', '', 0, 0, 4, 0, 5, 1, 0, '', '2020-12-28 14:47:03', '', NULL, 0);
    1355. 

  1355. INSERT INTO `duty_detail` VALUES (144, 21, '1', 3, '', '', 5, 0, 4, 5, 0, 1, 5, '', '2020-12-28 14:47:03', '', NULL, 0);
    1356. 

  1356. INSERT INTO `duty_detail` VALUES (145, 21, '1', 4, '', '', 0, 5, 4, 0, 0, 1, 0, '', '2020-12-28 14:47:03', '', NULL, 0);
    1357. 

  1357. INSERT INTO `duty_detail` VALUES (146, 21, '1', 2, '', '', 0, 0, 4, 6, 0, 1, 0, '', '2020-12-28 14:47:03', '', NULL, 0);
    1358. 

  1358. INSERT INTO `duty_detail` VALUES (147, 20, '2', 1, '', '', 0, 0, 0, 0, 0, 0, 0, '', '2020-12-28 14:58:12', '', '2020-12-28 15:09:36', 1);
    1359. 

  1359. INSERT INTO `duty_detail` VALUES (148, 20, '2', 3, '', '', 0, 0, 0, 5, 0, 0, 5, '', '2020-12-28 14:58:12', '', '2020-12-28 15:09:36', 1);
    1360. 

  1360. INSERT INTO `duty_detail` VALUES (149, 20, '2', 2, '', '', 0, 5, 0, 0, 5, 0, 0, '', '2020-12-28 14:58:12', '', '2020-12-28 15:09:36', 1);
    1361. 

  1361. INSERT INTO `duty_detail` VALUES (150, 20, '1', 1, '', '', 5, 0, 0, 0, 0, 0, 0, '', '2020-12-28 14:58:12', '', '2020-12-28 15:09:36', 1);
    1362. 

  1362. INSERT INTO `duty_detail` VALUES (151, 20, '1', 3, '', '', 0, 0, 0, 5, 0, 0, 0, '', '2020-12-28 14:58:12', '', '2020-12-28 15:09:36', 1);
    1363. 

  1363. INSERT INTO `duty_detail` VALUES (152, 20, '1', 2, '', '', 0, 5, 0, 5, 0, 5, 0, '', '2020-12-28 14:58:12', '', '2020-12-28 15:09:36', 1);
    1364. 

  1364. INSERT INTO `duty_detail` VALUES (153, 20, '2', 1, '', '', 4, 4, 4, 4, 4, 4, 4, '', '2020-12-28 15:09:36', '', NULL, 0);
    1365. 

  1365. INSERT INTO `duty_detail` VALUES (154, 20, '2', 3, '', '', 4, 4, 4, 4, 4, 4, 4, '', '2020-12-28 15:09:36', '', NULL, 0);
    1366. 

  1366. INSERT INTO `duty_detail` VALUES (155, 20, '2', 2, '', '', 0, 0, 0, 0, 0, 0, 0, '', '2020-12-28 15:04:02', '', '2020-12-28 15:09:36', 1);
    1367. 

  1367. INSERT INTO `duty_detail` VALUES (156, 20, '2', 4, '', '', 0, 0, 0, 0, 0, 0, 0, '', '2020-12-28 15:04:02', '', '2020-12-28 15:09:36', 1);
    1368. 

  1368. INSERT INTO `duty_detail` VALUES (157, 20, '1', 1, '', '', 0, 0, 0, 0, 0, 0, 0, '', '2020-12-28 15:04:02', '', '2020-12-28 15:09:36', 1);
    1369. 

  1369. INSERT INTO `duty_detail` VALUES (158, 20, '1', 3, '', '', 0, 0, 0, 0, 0, 0, 0, '', '2020-12-28 15:04:02', '', '2020-12-28 15:09:36', 1);
    1370. 

  1370. INSERT INTO `duty_detail` VALUES (159, 20, '1', 2, '', '', 0, 0, 0, 0, 0, 0, 0, '', '2020-12-28 15:04:02', '', '2020-12-28 15:09:36', 1);
    1371. 

  1371. INSERT INTO `duty_detail` VALUES (160, 20, '1', 4, '', '', 4, 4, 4, 4, 4, 4, 4, '', '2020-12-28 15:06:34', '', '2020-12-28 15:09:36', 1);
    1372. 

  1372. INSERT INTO `duty_detail` VALUES (161, 22, '1', 1, '', '', 1, 1, 1, 1, 1, 1, 1, '', '2020-12-28 15:56:48', '', '2020-12-28 16:28:32', 1);
    1373. 

  1373. INSERT INTO `duty_detail` VALUES (162, 22, '1', 1, '', '', 3, 3, 3, 3, 3, 3, 3, '', '2020-12-28 16:28:32', '', NULL, 0);
    1374. 

  1374. INSERT INTO `duty_detail` VALUES (163, 323, '1', 1, '', '', 171, 5, 0, 5, 5, 5, 171, '', '2020-12-28 18:28:55', '', '2020-12-28 18:43:04', 1);
    1375. 

  1375. INSERT INTO `duty_detail` VALUES (164, 323, '1', 3, '', '', 171, 268, 268, 5, 0, 1, 171, '', '2020-12-28 18:43:04', '', NULL, 0);
    1376. 

  1376. INSERT INTO `duty_detail` VALUES (165, 323, '1', 2, '', '', 171, 171, 171, 171, 5, 264, 171, '', '2020-12-28 18:43:04', '', NULL, 0);
    1377. 

  1377. INSERT INTO `duty_detail` VALUES (166, 323, '1', 4, '', '', 171, 1, 0, 5, 264, 0, 178, '', '2020-12-28 18:43:04', '', NULL, 0);
    1378. 

  1378. INSERT INTO `duty_detail` VALUES (167, 323, '2', 1, '', '', 171, 168, 168, 168, 1, 264, 171, '', '2020-12-28 18:43:04', '', NULL, 0);
    1379. 

  1379. INSERT INTO `duty_detail` VALUES (168, 323, '2', 3, '', '', 171, 5, 0, 0, 264, 5, 171, '', '2020-12-28 18:43:04', '', NULL, 0);
    1380. 

  1380. INSERT INTO `duty_detail` VALUES (169, 323, '2', 2, '', '', 171, 0, 5, 5, 5, 264, 171, '', '2020-12-28 18:43:04', '', NULL, 0);
    1381. 

  1381. INSERT INTO `duty_detail` VALUES (170, 323, '2', 4, '', '', 178, 178, 178, 178, 178, 178, 171, '', '2020-12-28 18:43:04', '', NULL, 0);
    1382. 

  1382. INSERT INTO `duty_detail` VALUES (171, 324, '2', 1, '', '', 168, 0, 0, 0, 0, 0, 0, '', '2020-12-28 19:21:03', '', NULL, 0);
    1383. 

  1383. INSERT INTO `duty_detail` VALUES (172, 324, '2', 3, '', '', 264, 0, 0, 168, 0, 168, 0, '', '2020-12-28 19:21:03', '', NULL, 0);
    1384. 

  1384. INSERT INTO `duty_detail` VALUES (173, 324, '2', 4, '', '', 178, 168, 0, 0, 168, 0, 0, '', '2020-12-28 19:21:03', '', NULL, 0);
    1385. 

  1385. INSERT INTO `duty_detail` VALUES (174, 324, '2', 2, '', '', 264, 178, 0, 264, 0, 0, 0, '', '2020-12-28 19:21:03', '', NULL, 0);
    1386. 

  1386. INSERT INTO `duty_detail` VALUES (175, 324, '1', 1, '', '', 0, 0, 168, 0, 0, 0, 168, '', '2020-12-28 19:21:03', '', NULL, 0);
    1387. 

  1387. INSERT INTO `duty_detail` VALUES (176, 324, '1', 3, '', '', 264, 0, 0, 168, 0, 168, 0, '', '2020-12-28 19:21:03', '', NULL, 0);
    1388. 

  1388. INSERT INTO `duty_detail` VALUES (177, 324, '1', 4, '', '', 0, 0, 0, 264, 168, 0, 0, '', '2020-12-28 19:21:03', '', NULL, 0);
    1389. 

  1389. INSERT INTO `duty_detail` VALUES (178, 324, '1', 2, '', '', 0, 0, 0, 264, 0, 0, 0, '', '2020-12-28 19:21:03', '', NULL, 0);
    1390. 

  1390. INSERT INTO `duty_detail` VALUES (179, 325, '2', 1, '', '', 178, 168, 0, 0, 178, 0, 0, '', '2020-12-29 15:38:51', '', NULL, 0);
    1391. 

  1391. INSERT INTO `duty_detail` VALUES (180, 325, '2', 2, '', '', 178, 0, 178, 168, 178, 0, 0, '', '2020-12-29 15:38:51', '', NULL, 0);
    1392. 

  1392. INSERT INTO `duty_detail` VALUES (181, 325, '2', 3, '', '', 178, 0, 0, 0, 168, 0, 0, '', '2020-12-29 15:38:51', '', NULL, 0);
    1393. 

  1393. INSERT INTO `duty_detail` VALUES (182, 325, '2', 4, '', '', 178, 0, 168, 0, 0, 0, 0, '', '2020-12-29 15:38:51', '', NULL, 0);
    1394. 

  1394. 

  1395. -- ----------------------------
    1396. 

  1396. -- Table structure for information
    1397. 

  1397. -- ----------------------------
    1398. 

  1398. DROP TABLE IF EXISTS `information`;
    1399. 

  1399. CREATE TABLE `information`  (
    1400. 

  1400.   `Id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
    1401. 

  1401.   `Title` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '标题',
    1402. 

  1402.   `Content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '内容',
    1403. 

  1403.   `Flag` int(11) NULL DEFAULT NULL COMMENT '类别',
    1404. 

  1404.   `Status` int(11) NULL DEFAULT NULL COMMENT '状态',
    1405. 

  1405.   `CreatedBy` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人',
    1406. 

  1406.   `CreatedTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
    1407. 

  1407.   `UpdatedBy` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人',
    1408. 

  1408.   `UpdatedTime` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
    1409. 

  1409.   `IsDel` int(11) NOT NULL COMMENT '删除标志',
    1410. 

  1410.   PRIMARY KEY (`Id`) USING BTREE
    1411. 

  1411. ) ENGINE = InnoDB AUTO_INCREMENT = 56 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '信息表' ROW_FORMAT = Dynamic;
    1412. 

  1412. 

  1413. -- ----------------------------
    1414. 

  1414. -- Records of information
    1415. 

  1415. -- ----------------------------
    1416. 

  1416. INSERT INTO `information` VALUES (53, '自治区党委书记、人大常委会主任石泰峰来我校作形势政策报告', '12月8日上午，自治区党委书记、人大常委会主任石泰峰书记看望我校师生代表，与学生一起听思想政治理论课，并对学生们提出希望和要求。\n石泰峰书记作的高校形势政策报告在我校青年师生中引发热烈反响，在场师生纷纷表示，青年学生为新时代的见证者、亲历者和建设者，要自觉肩负新使命、新担当，坚定理想信念、树立远大志向，为全面建设社会主义现代化国家新征程贡献青春力量。\n\n\n\n', NULL, 1, NULL, '2020-12-28 14:37:59', NULL, '2020-12-28 18:49:51', 0);
    1417. 

  1417. INSERT INTO `information` VALUES (54, '足迹：习近平总书记考察内蒙古大学一周年纪实', '犹记去年此时\n\n校园杨柳依依，草木茵茵\n\n桃李湖碧波荡漾\n\n习近平总书记冒着濛濛细雨\n\n亲临学校考察\n\n深情嘱托我们\n\n要开放办学，在竞争中发展\n\n办好特色鲜明的一流大学\n\n深情嘱托我们\n\n要加强对蒙古文古籍的\n\n搜集、整理、保护\n\n挖掘弘扬蕴含其中的\n\n民族团结进步思想内涵\n\n激励各族人民\n\n共同团结奋斗、共同繁荣发展\n\n深情嘱托同学们\n\n要志存高远、脚踏实地\n\n学好知识、打好基础、增长才干\n\n将来为中华民族伟大复兴\n\n贡献自己的智慧和力量', NULL, 1, NULL, '2020-12-28 14:40:51', NULL, '2020-12-28 18:49:53', 0);
    1418. 

  1418. INSERT INTO `information` VALUES (55, '321', '321321321', NULL, 1, NULL, '2020-12-28 18:50:07', NULL, '2020-12-28 18:50:20', 1);
    1419. 

  1419. 

  1420. -- ----------------------------
    1421. 

  1421. -- Table structure for instr_room
    1422. 

  1422. -- ----------------------------
    1423. 

  1423. DROP TABLE IF EXISTS `instr_room`;
    1424. 

  1424. CREATE TABLE `instr_room`  (
    1425. 

  1425.   `Id` int(11) NOT NULL AUTO_INCREMENT COMMENT '房间id',
    1426. 

  1426.   `RoomNum` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '房间号',
    1427. 

  1427.   `RoomName` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '房间名称',
    1428. 

  1428.   `RoomType` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '房间类型',
    1429. 

  1429.   `RoomDescribe` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '房间描述',
    1430. 

  1430.   `PositionInformation` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '位置信息',
    1431. 

  1431.   `CreateOn` datetime(0) NULL DEFAULT NULL,
    1432. 

  1432.   `CreateUserId` int(11) NULL DEFAULT NULL,
    1433. 

  1433.   `CreateBy` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
    1434. 

  1434.   `ModifiedOn` datetime(0) NULL DEFAULT NULL,
    1435. 

  1435.   `ModifiedUserId` int(11) NULL DEFAULT NULL,
    1436. 

  1436.   `ModifiedBy` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
    1437. 

  1437.   `building` int(11) NULL DEFAULT NULL COMMENT '建筑信息',
    1438. 

  1438.   PRIMARY KEY (`Id`) USING BTREE
    1439. 

  1439. ) ENGINE = InnoDB AUTO_INCREMENT = 371 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;
    1440. 

  1440. 

  1441. -- ----------------------------
    1442. 

  1442. -- Records of instr_room
    1443. 

  1443. -- ----------------------------
    1444. 

  1444. INSERT INTO `instr_room` VALUES (369, '001', '计算机实验室3', '1', '123', '4楼', '2020-12-29 10:27:51', 0, '', '2020-12-29 17:47:15', 0, '', 1);
    1445. 

  1445. INSERT INTO `instr_room` VALUES (370, '002', '计算机实验室1', '1', '', '3楼', '2020-12-29 11:28:32', 0, '', '2020-12-29 17:47:24', 0, '', 2);
    1446. 

  1446. INSERT INTO `instr_room` VALUES (371, '003', '计算机02', '1', '', '02层', '2020-12-29 12:02:52', 0, '', '2020-12-29 14:48:22', 0, '', 2);
    1447. 

  1447. 

  1448. -- ----------------------------
    1449. 

  1449. -- Table structure for instrumenmaintainlog
    1450. 

  1450. -- ----------------------------
    1451. 

  1451. DROP TABLE IF EXISTS `instrumenmaintainlog`;
    1452. 

  1452. CREATE TABLE `instrumenmaintainlog`  (
    1453. 

  1453.   `Id` int(10) NOT NULL AUTO_INCREMENT,
    1454. 

  1454.   `InstrumenId` int(10) NULL DEFAULT NULL COMMENT '设备Id',
    1455. 

  1455.   `InstrumenName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '设备名称',
    1456. 

  1456.   `InstrumenCode` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '设备编号',
    1457. 

  1457.   `OperaRemark` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '维护说明',
    1458. 

  1458.   `OperaTpye` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '维护类型，从字典表下拉，字典项 InstrumenMaintainType',
    1459. 

  1459.   `OperaUser` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作人',
    1460. 

  1460.   `OperaOn` datetime(0) NULL DEFAULT NULL COMMENT '操作日期',
    1461. 

  1461.   `CreateUserId` int(10) NULL DEFAULT NULL,
    1462. 

  1462.   `CreateBy` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1463. 

  1463.   `CreateOn` datetime(0) NULL DEFAULT NULL,
    1464. 

  1464.   `TypeCode` int(4) NULL DEFAULT NULL,
    1465. 

  1465.   `ModifiedUserId` int(10) NULL DEFAULT NULL,
    1466. 

  1466.   `ModifiedBy` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1467. 

  1467.   `ModifiedOn` datetime(0) NULL DEFAULT NULL,
    1468. 

  1468.   PRIMARY KEY (`Id`) USING BTREE
    1469. 

  1469. ) ENGINE = InnoDB AUTO_INCREMENT = 137 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '设备维护记录，质量管理' ROW_FORMAT = Dynamic;
    1470. 

  1470. 

  1471. -- ----------------------------
    1472. 

  1472. -- Records of instrumenmaintainlog
    1473. 

  1473. -- ----------------------------
    1474. 

  1474. INSERT INTO `instrumenmaintainlog` VALUES (135, 252, '电视', 'HX-YV-01', '设备确认', '设备确认', '张天', '2020-12-29 10:29:59', 0, '', '2020-12-29 10:30:11', 1, 0, '', '2020-12-29 17:47:21');
    1475. 

  1475. INSERT INTO `instrumenmaintainlog` VALUES (136, 252, '电视', 'HX-YV-01', '维修中', '设备维修', '张伟', '2020-12-29 10:33:37', 0, '', '2020-12-29 10:33:49', 2, 0, '', '2020-12-29 17:50:37');
    1476. 

  1476. INSERT INTO `instrumenmaintainlog` VALUES (137, 252, '电视', 'HX-YV-01', '报废', '设备报废', '王天', '2020-12-29 17:13:20', 0, '', '2020-12-29 17:15:20', 2, 0, '', '2020-12-29 17:50:31');
    1477. 

  1477. INSERT INTO `instrumenmaintainlog` VALUES (138, 252, '电视', 'HX-YV-01', '报废申请', '设备报废', 'wang ', '2020-12-29 17:35:56', 0, '', '2020-12-29 17:36:06', 2, 0, '', '2020-12-29 17:50:22');
    1478. 

  1478. INSERT INTO `instrumenmaintainlog` VALUES (142, 252, '电视', 'HX-YV-01', '确认设备', '设备确认', '王伟', '2020-12-29 17:46:27', 0, '', '2020-12-29 17:46:39', 1, 0, '', '2020-12-29 17:47:01');
    1479. 

  1479. 

  1480. -- ----------------------------
    1481. 

  1481. -- Table structure for instrumenrunrecord
    1482. 

  1482. -- ----------------------------
    1483. 

  1483. DROP TABLE IF EXISTS `instrumenrunrecord`;
    1484. 

  1484. CREATE TABLE `instrumenrunrecord`  (
    1485. 

  1485.   `Id` int(10) NOT NULL AUTO_INCREMENT,
    1486. 

  1486.   `InstrumentId` int(10) NULL DEFAULT NULL COMMENT '设备Id',
    1487. 

  1487.   `InstrumenName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '设备名称',
    1488. 

  1488.   `InstrumenCode` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '设备编号',
    1489. 

  1489.   `RecordRemark` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '运行说明',
    1490. 

  1490.   `ContractNo` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '合同编号',
    1491. 

  1491.   `PrepinfoDetailId` int(10) NULL DEFAULT NULL COMMENT '制备详情Id',
    1492. 

  1492.   `CreateUserId` int(10) NULL DEFAULT NULL COMMENT '操作人ID',
    1493. 

  1493.   `CreateBy` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作人',
    1494. 

  1494.   `CreateOn` datetime(0) NULL DEFAULT NULL COMMENT '操作时间',
    1495. 

  1495.   `ModifiedUserId` int(10) NULL DEFAULT NULL,
    1496. 

  1496.   `ModifiedBy` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1497. 

  1497.   `ModifiedOn` datetime(0) NULL DEFAULT NULL,
    1498. 

  1498.   PRIMARY KEY (`Id`) USING BTREE
    1499. 

  1499. ) ENGINE = InnoDB AUTO_INCREMENT = 142 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '设备运行记录' ROW_FORMAT = Dynamic;
    1500. 

  1500. 

  1501. -- ----------------------------
    1502. 

  1502. -- Records of instrumenrunrecord
    1503. 

  1503. -- ----------------------------
    1504. 

  1504. 

  1505. -- ----------------------------
    1506. 

  1506. -- Table structure for instrument
    1507. 

  1507. -- ----------------------------
    1508. 

  1508. DROP TABLE IF EXISTS `instrument`;
    1509. 

  1509. CREATE TABLE `instrument`  (
    1510. 

  1510.   `Id` int(11) NOT NULL AUTO_INCREMENT,
    1511. 

  1511.   `RoomId` int(11) NULL DEFAULT NULL COMMENT '所属房间Id，instr_room.Id',
    1512. 

  1512.   `Code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '设备编码',
    1513. 

  1513.   `Name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '设备名称',
    1514. 

  1514.   `SupplierId` int(11) NULL DEFAULT NULL,
    1515. 

  1515.   `Supplier` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '供应商',
    1516. 

  1516.   `FactoryNum` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '出厂编号',
    1517. 

  1517.   `Model` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '型号',
    1518. 

  1518.   `Brand` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '设备品牌',
    1519. 

  1519.   `Classification` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '设备大类',
    1520. 

  1520.   `State` int(11) NOT NULL DEFAULT 1 COMMENT '设备状态 1正常2异常',
    1521. 

  1521.   `Location` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '设备所在位置',
    1522. 

  1522.   `Remarks` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
    1523. 

  1523.   `IsFixedPoint` int(11) NULL DEFAULT 0 COMMENT '参与点检: 0. 否(默认) 1. 是',
    1524. 

  1524.   `CalibrationTime` datetime(0) NULL DEFAULT NULL COMMENT '校准时间',
    1525. 

  1525.   `CalibrationDeadline` int(11) NULL DEFAULT NULL COMMENT '校准使用期限',
    1526. 

  1526.   `CalibrationDeadlineType` int(11) NULL DEFAULT NULL COMMENT ' 期限类型:1:天 2：周 3：月 4：年 ',
    1527. 

  1527.   `MaintenCycle` int(11) NULL DEFAULT NULL COMMENT '维护周期数',
    1528. 

  1528.   `CycleType` int(11) NULL DEFAULT NULL COMMENT ' 期限类型:1:天 2：周 3：月 4：年 ',
    1529. 

  1529.   `HeartbeatTime` datetime(0) NOT NULL COMMENT '心跳时间 对应上报时间',
    1530. 

  1530.   `CreateOn` datetime(0) NOT NULL,
    1531. 

  1531.   `CreateUserId` int(11) NULL DEFAULT NULL,
    1532. 

  1532.   `CreateBy` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1533. 

  1533.   `ModifiedOn` datetime(0) NULL DEFAULT NULL,
    1534. 

  1534.   `ModifiedUserId` int(11) NULL DEFAULT NULL,
    1535. 

  1535.   `ModifiedBy` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1536. 

  1536.   `FileUrl` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作规程文件路径',
    1537. 

  1537.   `FileName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文件名',
    1538. 

  1538.   `Remark` tinytext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
    1539. 

  1539.   `TimeNotification` int(11) NULL DEFAULT NULL COMMENT '有效期提醒',
    1540. 

  1540.   `Sharable` tinyint(4) NULL DEFAULT NULL COMMENT '是否共享(可预约)',
    1541. 

  1541.   `EndTime` datetime(0) NULL DEFAULT NULL COMMENT '截止日期',
    1542. 

  1542.   `Responsible` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '责任人',
    1543. 

  1543.   `MaintenTime` date NULL DEFAULT NULL COMMENT '最后维护时间',
    1544. 

  1544.   `Purchasedate` datetime(0) NULL DEFAULT NULL COMMENT '采购日期',
    1545. 

  1545.   `JoinPlan` tinyint(4) NULL DEFAULT 1 COMMENT '计划: 1参与 0 不参与',
    1546. 

  1546.   `Spec` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '规格',
    1547. 

  1547.   PRIMARY KEY (`Id`) USING BTREE,
    1548. 

  1548.   UNIQUE INDEX `Code`(`Code`) USING BTREE
    1549. 

  1549. ) ENGINE = InnoDB AUTO_INCREMENT = 253 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '设备信息' ROW_FORMAT = DYNAMIC;
    1550. 

  1550. 

  1551. -- ----------------------------
    1552. 

  1552. -- Records of instrument
    1553. 

  1553. -- ----------------------------
    1554. 

  1554. INSERT INTO `instrument` VALUES (252, NULL, 'HX-YV-01', '电视', 0, '', 'HX-TV-01', 'HX-TV-01', '海信', '', 1, '电热间', '计算机教室403', 0, NULL, 1, 3, 1, 3, '2020-12-28 09:13:59', '2020-12-28 17:15:15', 1, '系统管理员', '2020-12-29 17:50:05', 1, '系统管理员', '', '', '', 0, 0, NULL, '刘', NULL, NULL, 0, '');
    1555. 

  1555. INSERT INTO `instrument` VALUES (255, NULL, 'HX-YV-012', '电脑', 0, '', '1004', 'HP', '惠普', '', 1, '计算机实验室3', '机房01', 0, NULL, 2, 3, 1, 3, '2020-12-29 09:47:27', '2020-12-29 17:48:37', 1, '系统管理员', '2020-12-29 17:49:23', 1, '系统管理员', '', '', '', 0, 0, NULL, '张天', NULL, NULL, 0, '');
    1556. 

  1556. 

  1557. -- ----------------------------
    1558. 

  1558. -- Table structure for personnel
    1559. 

  1559. -- ----------------------------
    1560. 

  1560. DROP TABLE IF EXISTS `personnel`;
    1561. 

  1561. CREATE TABLE `personnel`  (
    1562. 

  1562.   `Id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
    1563. 

  1563.   `PersonnelName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
    1564. 

  1564.   `PersonneCode` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '编号',
    1565. 

  1565.   `Person` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系人',
    1566. 

  1566.   `Telephone` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '电话',
    1567. 

  1567.   `Mailbox` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱',
    1568. 

  1568.   `CardId` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '身份证号',
    1569. 

  1569.   `Address` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '地址',
    1570. 

  1570.   `Established` date NULL DEFAULT NULL COMMENT '入职时间',
    1571. 

  1571.   `ZipCode` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮编',
    1572. 

  1572.   `Website` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '网站地址',
    1573. 

  1573.   `DepartmentId` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '组织id',
    1574. 

  1574.   `DepartmentName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '组织名称',
    1575. 

  1575.   `Type` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '类型',
    1576. 

  1576.   `CreateOn` datetime(0) NULL DEFAULT NULL,
    1577. 

  1577.   `CreateUserId` int(10) NULL DEFAULT NULL,
    1578. 

  1578.   `CreateBy` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1579. 

  1579.   `ModifiedOn` datetime(0) NULL DEFAULT NULL,
    1580. 

  1580.   `ModifiedUserId` int(10) NULL DEFAULT NULL,
    1581. 

  1581.   `ModifiedBy` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1582. 

  1582.   `Remarks` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
    1583. 

  1583.   PRIMARY KEY (`Id`) USING BTREE
    1584. 

  1584. ) ENGINE = InnoDB AUTO_INCREMENT = 298 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '人员管理' ROW_FORMAT = Dynamic;
    1585. 

  1585. 

  1586. -- ----------------------------
    1587. 

  1587. -- Records of personnel
    1588. 

  1588. -- ----------------------------
    1589. 

  1589. INSERT INTO `personnel` VALUES (164, '小杜', '1', '', '12384', '123@qq', '199806047', '青岛', NULL, NULL, '', '1', '大数', '1', NULL, 0, '', '2020-12-25 16:49:29', 1, '系统管理员', '');
    1590. 

  1590. INSERT INTO `personnel` VALUES (168, '小郑', '9527', '', '13305265854', 'zhengyouqian@163.com', '330021199502154587', '青岛市崂山区', NULL, NULL, '', '', '', '', '2020-12-03 16:14:02', 1, '系统管理员', '2020-12-28 18:55:14', 1, '系统管理员', '');
    1591. 

  1591. INSERT INTO `personnel` VALUES (171, '王佳玉', '1104781', '', '18514255217', 'ask@qq.com', '232330200378447147', '崂山区', NULL, NULL, '', '', '', '', '2020-12-24 16:20:57', 1, '系统管理员', '2020-12-25 14:48:32', 1, '系统管理员', '人员');
    1592. 

  1592. INSERT INTO `personnel` VALUES (178, '小明', '1123456', '', '123456', '123@qq.com', '123345435234', '青岛', NULL, NULL, '', '', '', '', '2020-12-25 11:28:38', 1, '系统管理员', '2020-12-25 11:28:38', 1, '系统管理员', NULL);
    1593. 

  1593. INSERT INTO `personnel` VALUES (264, '小白', '137812', '', '12384', '123@qq', '199806047', '青岛', NULL, NULL, '', '1', '大数', '1', NULL, 0, '', '2020-12-25 13:37:41', 1, '系统管理员', NULL);
    1594. 

  1594. INSERT INTO `personnel` VALUES (298, '小李', '1002', '', '15211111111', '123@qq.com', '12312312', '北京', NULL, NULL, '', '', '', '', '2020-12-29 16:57:50', 0, '', '2020-12-29 16:57:50', 0, '', '');
    1595. 

  1595. 

  1596. SET FOREIGN_KEY_CHECKS = 1;
    1597.