首頁 探索 說明
註冊 登入
dashoo
/
lims_college
2
0
複刻 0
檔案 問題管理 0 合併請求 0 Wiki
目錄樹: ee01c0de19
分支列表 標籤列表
lims_college
/
doc
/
部署相关
/
l_lims.sql

l_lims.sql 172 KB
文件歷史 原始文件

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549 
  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 18:07:18
    15. 

  15. */
    16. 

  16. 

  17. SET NAMES utf8mb4;
    18. 

  18. SET FOREIGN_KEY_CHECKS = 0;
    19. 

  19. 

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

  21. -- Table structure for base_itemdetails
    22. 

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

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

  24. CREATE TABLE `base_itemdetails`  (
    25. 

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

  26.   `AccCode` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    27. 

  27.   `ParentId` int(10) NULL DEFAULT NULL,
    28. 

  28.   `ItemCode` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    29. 

  29.   `ItemName` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    30. 

  30.   `ItemValue` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    31. 

  31.   `Enabled` int(10) NOT NULL DEFAULT 1,
    32. 

  32.   `AllowEdit` int(10) NOT NULL DEFAULT 1,
    33. 

  33.   `AllowDelete` int(10) NOT NULL DEFAULT 1,
    34. 

  34.   `SortCode` int(10) NULL DEFAULT NULL,
    35. 

  35.   `Description` varchar(800) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    36. 

  36.   `IsPublic` int(10) NOT NULL DEFAULT 1,
    37. 

  37.   `DeletionStateCode` int(10) NOT NULL DEFAULT 0,
    38. 

  38.   `CreateOn` datetime(0) NULL DEFAULT NULL,
    39. 

  39.   `CreateUserId` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    40. 

  40.   `CreateBy` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    41. 

  41.   `ModifiedOn` datetime(0) NULL DEFAULT NULL,
    42. 

  42.   `ModifiedUserId` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    43. 

  43.   `ModifiedBy` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    44. 

  44.   PRIMARY KEY (`Id`) USING BTREE
    45. 

  45. ) ENGINE = InnoDB AUTO_INCREMENT = 1034 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    46. 

  46. 

  47. -- ----------------------------
    48. 

  48. -- Records of base_itemdetails
    49. 

  49. -- ----------------------------
    50. 

  50. 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);
    51. 

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

  52. 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);
    53. 

  53. 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);
    54. 

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

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

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

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

  58. 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);
    59. 

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

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

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

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

  63. 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);
    64. 

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

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

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

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

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

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

  70. 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);
    71. 

  71. 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);
    72. 

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

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

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

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

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

  77. 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);
    78. 

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

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

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

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

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

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

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

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

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

  87. 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);
    88. 

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  105. 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);
    106. 

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  121. 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);
    122. 

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  138. 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);
    139. 

  139. 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);
    140. 

  140. 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);
    141. 

  141. 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);
    142. 

  142. 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);
    143. 

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

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

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

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

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

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

  149. 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);
    150. 

  150. 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);
    151. 

  151. 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);
    152. 

  152. 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);
    153. 

  153. 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);
    154. 

  154. 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);
    155. 

  155. 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);
    156. 

  156. 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);
    157. 

  157. 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);
    158. 

  158. 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);
    159. 

  159. 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);
    160. 

  160. 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);
    161. 

  161. 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);
    162. 

  162. 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);
    163. 

  163. 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);
    164. 

  164. 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);
    165. 

  165. 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);
    166. 

  166. 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);
    167. 

  167. 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);
    168. 

  168. 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);
    169. 

  169. 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);
    170. 

  170. 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);
    171. 

  171. 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);
    172. 

  172. 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);
    173. 

  173. 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);
    174. 

  174. 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);
    175. 

  175. 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);
    176. 

  176. 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);
    177. 

  177. 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);
    178. 

  178. 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);
    179. 

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

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

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

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

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

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

  185. 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);
    186. 

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  217. 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);
    218. 

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  295. 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);
    296. 

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  321. 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);
    322. 

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

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

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

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

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

  327. 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);
    328. 

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

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

  330. 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);
    331. 

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  357. 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);
    358. 

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

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

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

  361. 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);
    362. 

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

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

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

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

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

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

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

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

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

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

  372. 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);
    373. 

  373. 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);
    374. 

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  449. 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);
    450. 

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  516. 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);
    517. 

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  578. 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);
    579. 

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

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

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

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

  583. 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);
    584. 

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

  585. 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);
    586. 

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

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

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

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

  590. 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);
    591. 

  591. 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', '');
    592. 

  592. 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', '');
    593. 

  593. 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', '');
    594. 

  594. 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', '');
    595. 

  595. 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', '');
    596. 

  596. 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', '');
    597. 

  597. 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', '');
    598. 

  598. 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', '');
    599. 

  599. 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', '');
    600. 

  600. 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', '');
    601. 

  601. 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', '');
    602. 

  602. 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', '');
    603. 

  603. 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', '');
    604. 

  604. 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', '');
    605. 

  605. 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', '');
    606. 

  606. 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);
    607. 

  607. 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);
    608. 

  608. 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);
    609. 

  609. 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);
    610. 

  610. 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', '');
    611. 

  611. 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', '');
    612. 

  612. 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', '');
    613. 

  613. 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', '');
    614. 

  614. 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', '');
    615. 

  615. 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', '');
    616. 

  616. 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', '');
    617. 

  617. 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', '');
    618. 

  618. 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', '');
    619. 

  619. 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', '');
    620. 

  620. 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', '');
    621. 

  621. 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', '');
    622. 

  622. 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', '');
    623. 

  623. 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', '');
    624. 

  624. 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', '');
    625. 

  625. 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', '');
    626. 

  626. 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', '');
    627. 

  627. 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', '');
    628. 

  628. 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', '');
    629. 

  629. 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', '');
    630. 

  630. 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', '');
    631. 

  631. 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', '');
    632. 

  632. 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', '');
    633. 

  633. 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', '');
    634. 

  634. 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', '');
    635. 

  635. 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', '');
    636. 

  636. 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', '');
    637. 

  637. 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', '');
    638. 

  638. 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', '');
    639. 

  639. 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', '');
    640. 

  640. 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', '');
    641. 

  641. 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', '');
    642. 

  642. 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', '');
    643. 

  643. 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', '');
    644. 

  644. 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', '');
    645. 

  645. 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', '');
    646. 

  646. 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', '');
    647. 

  647. 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', '');
    648. 

  648. 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', '');
    649. 

  649. 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', '');
    650. 

  650. 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', '');
    651. 

  651. 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', '');
    652. 

  652. 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', '');
    653. 

  653. 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', '');
    654. 

  654. 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', '');
    655. 

  655. 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', '');
    656. 

  656. 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', '');
    657. 

  657. 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);
    658. 

  658. 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);
    659. 

  659. 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);
    660. 

  660. 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);
    661. 

  661. 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);
    662. 

  662. 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);
    663. 

  663. 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);
    664. 

  664. 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);
    665. 

  665. 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);
    666. 

  666. 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);
    667. 

  667. 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);
    668. 

  668. 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);
    669. 

  669. 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);
    670. 

  670. 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);
    671. 

  671. 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);
    672. 

  672. 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);
    673. 

  673. 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);
    674. 

  674. 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);
    675. 

  675. 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);
    676. 

  676. 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);
    677. 

  677. 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);
    678. 

  678. 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);
    679. 

  679. 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);
    680. 

  680. 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);
    681. 

  681. 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);
    682. 

  682. 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);
    683. 

  683. 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);
    684. 

  684. 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);
    685. 

  685. 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);
    686. 

  686. 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);
    687. 

  687. 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);
    688. 

  688. 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);
    689. 

  689. 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);
    690. 

  690. 

  691. -- ----------------------------
    692. 

  692. -- Table structure for base_items
    693. 

  693. -- ----------------------------
    694. 

  694. DROP TABLE IF EXISTS `base_items`;
    695. 

  695. CREATE TABLE `base_items`  (
    696. 

  696.   `Id` int(10) NOT NULL AUTO_INCREMENT,
    697. 

  697.   `ParentId` int(10) NULL DEFAULT NULL,
    698. 

  698.   `Code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    699. 

  699.   `FullName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    700. 

  700.   `TargetTable` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    701. 

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

  702.   `UseItemCode` int(10) NULL DEFAULT NULL,
    703. 

  703.   `UseItemName` int(10) NULL DEFAULT NULL,
    704. 

  704.   `UseItemValue` int(10) NULL DEFAULT NULL,
    705. 

  705.   `Enabled` int(10) NOT NULL,
    706. 

  706.   `AllowEdit` int(10) NOT NULL,
    707. 

  707.   `AllowDelete` int(10) NOT NULL,
    708. 

  708.   `DeletionStateCode` int(10) NOT NULL DEFAULT 0,
    709. 

  709.   `SortCode` int(10) NULL DEFAULT NULL,
    710. 

  710.   `Description` varchar(800) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    711. 

  711.   `CreateOn` datetime(0) NULL DEFAULT NULL,
    712. 

  712.   `CreateUserId` int(11) NULL DEFAULT NULL,
    713. 

  713.   `CreateBy` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    714. 

  714.   `ModifiedOn` datetime(0) NULL DEFAULT NULL,
    715. 

  715.   `ModifiedUserId` int(11) NULL DEFAULT NULL,
    716. 

  716.   `ModifiedBy` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    717. 

  717.   PRIMARY KEY (`Id`) USING BTREE
    718. 

  718. ) ENGINE = InnoDB AUTO_INCREMENT = 256 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    719. 

  719. 

  720. -- ----------------------------
    721. 

  721. -- Records of base_items
    722. 

  722. -- ----------------------------
    723. 

  723. 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, '');
    724. 

  724. 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, '');
    725. 

  725. 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, '');
    726. 

  726. 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);
    727. 

  727. 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);
    728. 

  728. 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);
    729. 

  729. 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, '');
    730. 

  730. 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, '');
    731. 

  731. 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, '');
    732. 

  732. 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, '');
    733. 

  733. 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, '');
    734. 

  734. 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, '');
    735. 

  735. 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);
    736. 

  736. 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);
    737. 

  737. 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);
    738. 

  738. 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);
    739. 

  739. 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);
    740. 

  740. 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);
    741. 

  741. 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);
    742. 

  742. 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);
    743. 

  743. 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);
    744. 

  744. 

  745. -- ----------------------------
    746. 

  746. -- Table structure for base_menu
    747. 

  747. -- ----------------------------
    748. 

  748. DROP TABLE IF EXISTS `base_menu`;
    749. 

  749. CREATE TABLE `base_menu`  (
    750. 

  750.   `Id` int(11) NOT NULL AUTO_INCREMENT,
    751. 

  751.   `Title` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    752. 

  752.   `ParentId` int(11) NULL DEFAULT NULL,
    753. 

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

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

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

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

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

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

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

  760.   `Component` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    761. 

  761.   `Sort` int(4) NULL DEFAULT 1 COMMENT '排序',
    762. 

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

  763.   PRIMARY KEY (`Id`) USING BTREE
    764. 

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

  765. 

  766. -- ----------------------------
    767. 

  767. -- Records of base_menu
    768. 

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  787. 

  788. -- ----------------------------
    789. 

  789. -- Table structure for base_operationlog
    790. 

  790. -- ----------------------------
    791. 

  791. DROP TABLE IF EXISTS `base_operationlog`;
    792. 

  792. CREATE TABLE `base_operationlog`  (
    793. 

  793.   `Id` bigint(20) NOT NULL AUTO_INCREMENT,
    794. 

  794.   `AccCode` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '账户',
    795. 

  795.   `OpTage` int(11) NOT NULL COMMENT '1 修改 2删除',
    796. 

  796.   `TableName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    797. 

  797.   `TableDesc` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    798. 

  798.   `RecordId` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    799. 

  799.   `RecordData` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    800. 

  800.   `Createon` datetime(0) NULL DEFAULT NULL,
    801. 

  801.   `Createuserid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    802. 

  802.   `Createby` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    803. 

  803.   `OpDesc` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作描述',
    804. 

  804.   `Remark` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
    805. 

  805.   PRIMARY KEY (`Id`) USING BTREE
    806. 

  806. ) ENGINE = InnoDB AUTO_INCREMENT = 31780 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '操作日志' ROW_FORMAT = DYNAMIC;
    807. 

  807. 

  808. -- ----------------------------
    809. 

  809. -- Records of base_operationlog
    810. 

  810. -- ----------------------------
    811. 

  811. 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', '');
    812. 

  812. 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', '');
    813. 

  813. 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', '');
    814. 

  814. 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', '');
    815. 

  815. 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', '');
    816. 

  816. 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', '');
    817. 

  817. 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', '');
    818. 

  818. 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', '');
    819. 

  819. INSERT INTO `base_operationlog` VALUES (31780, '', 1, 'InstrumenMaintainLog', '设备管理', '138', '{\"Id\":138,\"InstrumenId\":252,\"InstrumenName\":\"电视\",\"InstrumenCode\":\"HX-YV-01\",\"OperaRemark\":\"报废申请\",\"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:50:22+08:00\",\"ModifiedUserId\":0,\"ModifiedBy\":\"\"}', '2020-12-29 17:59:58', '', '', '质量管理-HX-YV-01', '');
    820. 

  820. 

  821. -- ----------------------------
    822. 

  822. -- Table structure for base_organize
    823. 

  823. -- ----------------------------
    824. 

  824. DROP TABLE IF EXISTS `base_organize`;
    825. 

  825. CREATE TABLE `base_organize`  (
    826. 

  826.   `Id` int(10) NOT NULL AUTO_INCREMENT,
    827. 

  827.   `AccCode` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    828. 

  828.   `ParentId` int(10) NULL DEFAULT NULL COMMENT '上级组织id',
    829. 

  829.   `Paths` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '路径索引',
    830. 

  830.   `Code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    831. 

  831.   `FullName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
    832. 

  832.   `ShortName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '简称',
    833. 

  833.   `Category` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '分类',
    834. 

  834.   `OuterPhone` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '外部电话',
    835. 

  835.   `InnerPhone` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '内部电话',
    836. 

  836.   `Fax` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '传真',
    837. 

  837.   `Postalcode` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮政编码',
    838. 

  838.   `Address` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '地址',
    839. 

  839.   `Web` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    840. 

  840.   `Bank` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    841. 

  841.   `BankAccount` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    842. 

  842.   `Manager` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    843. 

  843.   `Layer` int(10) NULL DEFAULT NULL,
    844. 

  844.   `AssistantManager` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    845. 

  845.   `IsInnerOrganize` int(10) NOT NULL DEFAULT 1 COMMENT '是否时内部组织',
    846. 

  846.   `SortCode` int(10) NULL DEFAULT NULL COMMENT '排序码',
    847. 

  847.   `Description` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    848. 

  848.   `DeletionStateCode` int(10) NULL DEFAULT 0 COMMENT '删除状态码，未删除：0，已删除：1',
    849. 

  849.   `Enabled` int(10) NOT NULL DEFAULT 1,
    850. 

  850.   `CreateOn` datetime(0) NULL DEFAULT NULL,
    851. 

  851.   `CreateUserId` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    852. 

  852.   `CreateBy` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    853. 

  853.   `ModifiedOn` datetime(0) NULL DEFAULT NULL,
    854. 

  854.   `ModifiedUserId` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    855. 

  855.   `ModifiedBy` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    856. 

  856.   PRIMARY KEY (`Id`) USING BTREE
    857. 

  857. ) ENGINE = InnoDB AUTO_INCREMENT = 31 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    858. 

  858. 

  859. -- ----------------------------
    860. 

  860. -- Records of base_organize
    861. 

  861. -- ----------------------------
    862. 

  862. 

  863. -- ----------------------------
    864. 

  864. -- Table structure for base_parameter
    865. 

  865. -- ----------------------------
    866. 

  866. DROP TABLE IF EXISTS `base_parameter`;
    867. 

  867. CREATE TABLE `base_parameter`  (
    868. 

  868.   `ID` int(10) NOT NULL AUTO_INCREMENT,
    869. 

  869.   `CategoryID` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    870. 

  870.   `ParameterID` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    871. 

  871.   `ParameterCode` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    872. 

  872.   `ParameterContent` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    873. 

  873.   `Worked` int(11) NOT NULL DEFAULT 0,
    874. 

  874.   `Enabled` int(11) NOT NULL DEFAULT 0,
    875. 

  875.   `DeletionStateCode` int(11) NULL DEFAULT NULL,
    876. 

  876.   `SortCode` int(11) NULL DEFAULT NULL,
    877. 

  877.   `Description` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    878. 

  878.   `CreateOn` datetime(0) NULL DEFAULT NULL,
    879. 

  879.   `CreateUserId` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    880. 

  880.   `CreateBy` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    881. 

  881.   `ModifiedOn` datetime(0) NULL DEFAULT NULL,
    882. 

  882.   `ModifiedUserId` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    883. 

  883.   `ModifiedBy` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    884. 

  884.   PRIMARY KEY (`ID`) USING BTREE
    885. 

  885. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    886. 

  886. 

  887. -- ----------------------------
    888. 

  888. -- Records of base_parameter
    889. 

  889. -- ----------------------------
    890. 

  890. 

  891. -- ----------------------------
    892. 

  892. -- Table structure for base_role
    893. 

  893. -- ----------------------------
    894. 

  894. DROP TABLE IF EXISTS `base_role`;
    895. 

  895. CREATE TABLE `base_role`  (
    896. 

  896.   `Id` int(10) NOT NULL AUTO_INCREMENT,
    897. 

  897.   `AccCode` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    898. 

  898.   `SystemId` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    899. 

  899.   `OrganizeId` int(10) NULL DEFAULT NULL,
    900. 

  900.   `Code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    901. 

  901.   `Realname` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    902. 

  902.   `Category` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    903. 

  903.   `AllowEdit` int(10) NOT NULL DEFAULT 1,
    904. 

  904.   `DataScope` int(10) NOT NULL DEFAULT 1 COMMENT '数据集合权限 1：仅本人；2：本部门；3：本部门及以下；4：自定义；5：全部',
    905. 

  905.   `AllowDelete` int(10) NOT NULL DEFAULT 1,
    906. 

  906.   `SortCode` int(10) NULL DEFAULT 0,
    907. 

  907.   `DeletionStateCode` int(10) NOT NULL DEFAULT 0,
    908. 

  908.   `Enabled` int(10) NOT NULL DEFAULT 1,
    909. 

  909.   `IsVisible` int(10) NOT NULL DEFAULT 1 COMMENT '1显示',
    910. 

  910.   `Description` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    911. 

  911.   `CreateOn` datetime(0) NULL DEFAULT NULL,
    912. 

  912.   `CreateUserId` int(11) NULL DEFAULT NULL,
    913. 

  913.   `CreateBy` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    914. 

  914.   `ModifiedOn` datetime(0) NULL DEFAULT NULL,
    915. 

  915.   `ModifiedUserId` int(11) NULL DEFAULT NULL,
    916. 

  916.   `ModifiedBy` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    917. 

  917.   PRIMARY KEY (`Id`) USING BTREE
    918. 

  918. ) ENGINE = InnoDB AUTO_INCREMENT = 27 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    919. 

  919. 

  920. -- ----------------------------
    921. 

  921. -- Records of base_role
    922. 

  922. -- ----------------------------
    923. 

  923. 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, '系统管理员');
    924. 

  924. 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');
    925. 

  925. 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, '系统管理员');
    926. 

  926. 

  927. -- ----------------------------
    928. 

  928. -- Table structure for base_role_datascope
    929. 

  929. -- ----------------------------
    930. 

  930. DROP TABLE IF EXISTS `base_role_datascope`;
    931. 

  931. CREATE TABLE `base_role_datascope`  (
    932. 

  932.   `Id` int(11) NOT NULL AUTO_INCREMENT,
    933. 

  933.   `RoleId` int(11) NOT NULL COMMENT '角色ID',
    934. 

  934.   `DataIds` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '数据ID',
    935. 

  935.   `DataType` int(11) NOT NULL DEFAULT 1 COMMENT '集合类型，1：组织结构，2：人员，3：地区',
    936. 

  936.   PRIMARY KEY (`Id`) USING BTREE
    937. 

  937. ) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '数据集合权限表' ROW_FORMAT = Dynamic;
    938. 

  938. 

  939. -- ----------------------------
    940. 

  940. -- Records of base_role_datascope
    941. 

  941. -- ----------------------------
    942. 

  942. INSERT INTO `base_role_datascope` VALUES (13, 1, '2,4', 1);
    943. 

  943. INSERT INTO `base_role_datascope` VALUES (14, 24, '2,4', 1);
    944. 

  944. 

  945. -- ----------------------------
    946. 

  946. -- Table structure for base_role_menu
    947. 

  947. -- ----------------------------
    948. 

  948. DROP TABLE IF EXISTS `base_role_menu`;
    949. 

  949. CREATE TABLE `base_role_menu`  (
    950. 

  950.   `Id` int(11) NOT NULL AUTO_INCREMENT,
    951. 

  951.   `RoleId` int(11) NULL DEFAULT NULL COMMENT '角色id',
    952. 

  952.   `MenuIds` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '权限id',
    953. 

  953.   PRIMARY KEY (`Id`) USING BTREE
    954. 

  954. ) ENGINE = InnoDB AUTO_INCREMENT = 27 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
    955. 

  955. 

  956. -- ----------------------------
    957. 

  957. -- Records of base_role_menu
    958. 

  958. -- ----------------------------
    959. 

  959. 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');
    960. 

  960. INSERT INTO `base_role_menu` VALUES (24, 24, '22,23,24,25,26,32,36,37,38');
    961. 

  961. 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');
    962. 

  962. 

  963. -- ----------------------------
    964. 

  964. -- Table structure for base_updated
    965. 

  965. -- ----------------------------
    966. 

  966. DROP TABLE IF EXISTS `base_updated`;
    967. 

  967. CREATE TABLE `base_updated`  (
    968. 

  968.   `Id` bigint(20) NOT NULL AUTO_INCREMENT,
    969. 

  969.   `TableName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    970. 

  970.   `RecordId` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    971. 

  971.   `RecordData` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    972. 

  972.   `Createon` datetime(0) NULL DEFAULT NULL,
    973. 

  973.   `Createuserid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    974. 

  974.   `Createby` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    975. 

  975.   PRIMARY KEY (`Id`) USING BTREE
    976. 

  976. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    977. 

  977. 

  978. -- ----------------------------
    979. 

  979. -- Records of base_updated
    980. 

  980. -- ----------------------------
    981. 

  981. 

  982. -- ----------------------------
    983. 

  983. -- Table structure for base_user
    984. 

  984. -- ----------------------------
    985. 

  985. DROP TABLE IF EXISTS `base_user`;
    986. 

  986. CREATE TABLE `base_user`  (
    987. 

  987.   `Id` int(10) NOT NULL AUTO_INCREMENT,
    988. 

  988.   `Uuid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户Id标识，不易猜出',
    989. 

  989.   `AccCode` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '区分不同App的用户',
    990. 

  990.   `Code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '编码',
    991. 

  991.   `UserName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户登录名',
    992. 

  992.   `Realname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户名',
    993. 

  993.   `RoleId` int(10) NULL DEFAULT NULL COMMENT '角色id',
    994. 

  994.   `SecurityLevel` int(10) NULL DEFAULT NULL,
    995. 

  995.   `UserFrom` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    996. 

  996.   `CompanyId` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '公司id',
    997. 

  997.   `CompanyName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '公司名称',
    998. 

  998.   `DepartmentId` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '部门id ',
    999. 

  999.   `DepartmentName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '部门名称',
    1000. 

  1000.   `WorkgroupId` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '工作组id',
    1001. 

  1001.   `WorkgroupName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '工作组名称',
    1002. 

  1002.   `WorkCategory` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1003. 

  1003.   `Duty` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '职务',
    1004. 

  1004.   `Title` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '头衔',
    1005. 

  1005.   `Gender` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '性别',
    1006. 

  1006.   `Birthday` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1007. 

  1007.   `Mobile` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1008. 

  1008.   `Telephone` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1009. 

  1009.   `Email` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1010. 

  1010.   `OICQ` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1011. 

  1011.   `HomeAddress` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1012. 

  1012.   `UserPassword` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1013. 

  1013.   `ChangePasswordDate` datetime(0) NULL DEFAULT NULL COMMENT '改密码时间',
    1014. 

  1014.   `CommunicationPassword` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1015. 

  1015.   `PublicKey` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1016. 

  1016.   `SignedPassword` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1017. 

  1017.   `Lang` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1018. 

  1018.   `Theme` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1019. 

  1019.   `AllowStartTime` datetime(0) NULL DEFAULT NULL,
    1020. 

  1020.   `AllowEndTime` datetime(0) NULL DEFAULT NULL,
    1021. 

  1021.   `LockStartDate` datetime(0) NULL DEFAULT NULL,
    1022. 

  1022.   `LockEndDate` datetime(0) NULL DEFAULT NULL,
    1023. 

  1023.   `FirstVisit` datetime(0) NULL DEFAULT NULL,
    1024. 

  1024.   `PreviousVisit` datetime(0) NULL DEFAULT NULL,
    1025. 

  1025.   `LastVisit` datetime(0) NULL DEFAULT NULL,
    1026. 

  1026.   `LogOnCount` int(10) NOT NULL DEFAULT 0,
    1027. 

  1027.   `IsStaff` int(10) NOT NULL DEFAULT 1,
    1028. 

  1028.   `UserOnLine` int(10) NOT NULL DEFAULT 1,
    1029. 

  1029.   `IsVisible` int(10) NOT NULL DEFAULT 1 COMMENT '是否可视，1为可视 ',
    1030. 

  1030.   `OpenId` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1031. 

  1031.   `IPAddress` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1032. 

  1032.   `MACAddress` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1033. 

  1033.   `Question` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1034. 

  1034.   `AnswerQuestion` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1035. 

  1035.   `UserAddressId` int(10) NULL DEFAULT NULL,
    1036. 

  1036.   `Enabled` int(10) NOT NULL DEFAULT 1 COMMENT '是否可用',
    1037. 

  1037.   `AuditStatus` int(50) NULL DEFAULT NULL COMMENT '激活状态（1激活）',
    1038. 

  1038.   `DeletionStateCode` int(10) NOT NULL DEFAULT 0 COMMENT '删除状态',
    1039. 

  1039.   `SortCode` int(10) NULL DEFAULT NULL,
    1040. 

  1040.   `Description` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1041. 

  1041.   `CreateOn` datetime(0) NULL DEFAULT NULL,
    1042. 

  1042.   `CreateUserId` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1043. 

  1043.   `CreateBy` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1044. 

  1044.   `ModifiedOn` datetime(0) NULL DEFAULT NULL,
    1045. 

  1045.   `ModifiedUserId` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1046. 

  1046.   `ModifiedBy` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1047. 

  1047.   `Photo` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1048. 

  1048.   `QRCode` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1049. 

  1049.   `QRCodeImage` blob NULL,
    1050. 

  1050.   `IsCompanyUser` int(11) NULL DEFAULT NULL COMMENT '是否是企业用户（供方字段用）',
    1051. 

  1051.   `Superior` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '上级部门',
    1052. 

  1052.   `UnitId` int(11) NULL DEFAULT NULL COMMENT '二级单位ID（供方字段用）',
    1053. 

  1053.   `Unit` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1054. 

  1054.   PRIMARY KEY (`Id`) USING BTREE
    1055. 

  1055. ) ENGINE = InnoDB AUTO_INCREMENT = 20 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户表' ROW_FORMAT = Dynamic;
    1056. 

  1056. 

  1057. -- ----------------------------
    1058. 

  1058. -- Records of base_user
    1059. 

  1059. -- ----------------------------
    1060. 

  1060. 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, '');
    1061. 

  1061. 

  1062. -- ----------------------------
    1063. 

  1063. -- Table structure for base_user_role
    1064. 

  1064. -- ----------------------------
    1065. 

  1065. DROP TABLE IF EXISTS `base_user_role`;
    1066. 

  1066. CREATE TABLE `base_user_role`  (
    1067. 

  1067.   `Id` int(11) NOT NULL AUTO_INCREMENT,
    1068. 

  1068.   `UserId` int(11) NOT NULL,
    1069. 

  1069.   `RoleIds` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
    1070. 

  1070.   PRIMARY KEY (`Id`) USING BTREE
    1071. 

  1071. ) ENGINE = InnoDB AUTO_INCREMENT = 19 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
    1072. 

  1072. 

  1073. -- ----------------------------
    1074. 

  1074. -- Records of base_user_role
    1075. 

  1075. -- ----------------------------
    1076. 

  1076. INSERT INTO `base_user_role` VALUES (2, 1, '1,24');
    1077. 

  1077. INSERT INTO `base_user_role` VALUES (3, 3, '23');
    1078. 

  1078. INSERT INTO `base_user_role` VALUES (4, 4, '2,1');
    1079. 

  1079. INSERT INTO `base_user_role` VALUES (5, 7, '1,2,23');
    1080. 

  1080. INSERT INTO `base_user_role` VALUES (6, 8, '1,23,2');
    1081. 

  1081. INSERT INTO `base_user_role` VALUES (7, 0, '1,23');
    1082. 

  1082. INSERT INTO `base_user_role` VALUES (8, 9, '1');
    1083. 

  1083. INSERT INTO `base_user_role` VALUES (9, 10, '1');
    1084. 

  1084. INSERT INTO `base_user_role` VALUES (10, 11, '1');
    1085. 

  1085. INSERT INTO `base_user_role` VALUES (11, 12, '1');
    1086. 

  1086. INSERT INTO `base_user_role` VALUES (12, 13, '1');
    1087. 

  1087. INSERT INTO `base_user_role` VALUES (13, 14, '1');
    1088. 

  1088. INSERT INTO `base_user_role` VALUES (14, 15, '1');
    1089. 

  1089. INSERT INTO `base_user_role` VALUES (15, 16, '1');
    1090. 

  1090. INSERT INTO `base_user_role` VALUES (16, 17, '1');
    1091. 

  1091. INSERT INTO `base_user_role` VALUES (17, 18, '1');
    1092. 

  1092. INSERT INTO `base_user_role` VALUES (18, 19, '1');
    1093. 

  1093. 

  1094. -- ----------------------------
    1095. 

  1095. -- Table structure for base_userequipment
    1096. 

  1096. -- ----------------------------
    1097. 

  1097. DROP TABLE IF EXISTS `base_userequipment`;
    1098. 

  1098. CREATE TABLE `base_userequipment`  (
    1099. 

  1099.   `Id` int(10) NOT NULL AUTO_INCREMENT,
    1100. 

  1100.   `AccCode` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1101. 

  1101.   `UserId` int(10) NULL DEFAULT NULL,
    1102. 

  1102.   `EquipmentId` int(10) NOT NULL,
    1103. 

  1103.   `SortCode` int(10) NULL DEFAULT NULL,
    1104. 

  1104.   `Enabled` int(10) NOT NULL DEFAULT 1,
    1105. 

  1105.   `DeletionStateCode` int(10) NOT NULL DEFAULT 0,
    1106. 

  1106.   `Description` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1107. 

  1107.   `CreateOn` datetime(0) NULL DEFAULT NULL,
    1108. 

  1108.   `CreateUserId` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1109. 

  1109.   `CreateBy` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1110. 

  1110.   `ModifiedOn` datetime(0) NULL DEFAULT NULL,
    1111. 

  1111.   `ModifiedUserId` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1112. 

  1112.   `ModifiedBy` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1113. 

  1113.   PRIMARY KEY (`Id`) USING BTREE
    1114. 

  1114. ) ENGINE = InnoDB AUTO_INCREMENT = 67 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户设备权限' ROW_FORMAT = Dynamic;
    1115. 

  1115. 

  1116. -- ----------------------------
    1117. 

  1117. -- Records of base_userequipment
    1118. 

  1118. -- ----------------------------
    1119. 

  1119. 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', '');
    1120. 

  1120. 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', '');
    1121. 

  1121. 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', '');
    1122. 

  1122. 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', '');
    1123. 

  1123. 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', '');
    1124. 

  1124. 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', '');
    1125. 

  1125. 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', '');
    1126. 

  1126. 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', '');
    1127. 

  1127. 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', '');
    1128. 

  1128. 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', '');
    1129. 

  1129. 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', '');
    1130. 

  1130. 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', '');
    1131. 

  1131. 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', '');
    1132. 

  1132. 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', '');
    1133. 

  1133. 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', '');
    1134. 

  1134. 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', '');
    1135. 

  1135. 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', '');
    1136. 

  1136. 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', '');
    1137. 

  1137. 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', '');
    1138. 

  1138. 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', '');
    1139. 

  1139. 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', '');
    1140. 

  1140. 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', '');
    1141. 

  1141. 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', '');
    1142. 

  1142. 

  1143. -- ----------------------------
    1144. 

  1144. -- Table structure for class
    1145. 

  1145. -- ----------------------------
    1146. 

  1146. DROP TABLE IF EXISTS `class`;
    1147. 

  1147. CREATE TABLE `class`  (
    1148. 

  1148.   `Id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
    1149. 

  1149.   `Year` int(11) NULL DEFAULT NULL COMMENT '年级',
    1150. 

  1150.   `Name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '班级名称',
    1151. 

  1151.   `CreatedBy` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人',
    1152. 

  1152.   `CreatedTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
    1153. 

  1153.   `UpdatedBy` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '更新人',
    1154. 

  1154.   `UpdatedTime` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
    1155. 

  1155.   `IsDel` int(11) NOT NULL COMMENT '删除标志',
    1156. 

  1156.   PRIMARY KEY (`Id`) USING BTREE
    1157. 

  1157. ) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '班级表' ROW_FORMAT = Dynamic;
    1158. 

  1158. 

  1159. -- ----------------------------
    1160. 

  1160. -- Records of class
    1161. 

  1161. -- ----------------------------
    1162. 

  1162. INSERT INTO `class` VALUES (11, 2020, '计算机软件一班', '', '2020-12-28 14:26:40', '', '2020-12-28 14:26:40', 0);
    1163. 

  1163. INSERT INTO `class` VALUES (12, 2020, '计算机软件二班', '', '2020-12-28 14:26:47', '', '2020-12-28 14:26:47', 0);
    1164. 

  1164. 

  1165. -- ----------------------------
    1166. 

  1166. -- Table structure for course
    1167. 

  1167. -- ----------------------------
    1168. 

  1168. DROP TABLE IF EXISTS `course`;
    1169. 

  1169. CREATE TABLE `course`  (
    1170. 

  1170.   `Id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
    1171. 

  1171.   `Year` int(11) NULL DEFAULT NULL COMMENT '学年',
    1172. 

  1172.   `Term` int(11) NULL DEFAULT NULL COMMENT '学期',
    1173. 

  1173.   `ClassId` int(11) NULL DEFAULT NULL COMMENT '班级ID',
    1174. 

  1174.   `CourseWeek` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '教学周',
    1175. 

  1175.   `Title` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '标题',
    1176. 

  1176.   `Status` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '状态',
    1177. 

  1177.   `CreatedBy` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人',
    1178. 

  1178.   `CreatedTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
    1179. 

  1179.   `UpdatedBy` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '更新人',
    1180. 

  1180.   `UpdatedTime` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
    1181. 

  1181.   `IsDel` int(11) NOT NULL COMMENT '删除标志',
    1182. 

  1182.   PRIMARY KEY (`Id`) USING BTREE
    1183. 

  1183. ) ENGINE = InnoDB AUTO_INCREMENT = 30 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '课程表' ROW_FORMAT = Dynamic;
    1184. 

  1184. 

  1185. -- ----------------------------
    1186. 

  1186. -- Records of course
    1187. 

  1187. -- ----------------------------
    1188. 

  1188. 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);
    1189. 

  1189. 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);
    1190. 

  1190. 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);
    1191. 

  1191. 

  1192. -- ----------------------------
    1193. 

  1193. -- Table structure for course_detail
    1194. 

  1194. -- ----------------------------
    1195. 

  1195. DROP TABLE IF EXISTS `course_detail`;
    1196. 

  1196. CREATE TABLE `course_detail`  (
    1197. 

  1197.   `Id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
    1198. 

  1198.   `CourseId` int(11) NULL DEFAULT NULL COMMENT '课程表ID',
    1199. 

  1199.   `Year` int(11) NULL DEFAULT NULL COMMENT '学年',
    1200. 

  1200.   `Term` int(11) NULL DEFAULT NULL COMMENT '学期',
    1201. 

  1201.   `CourseName` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '课程名',
    1202. 

  1202.   `Teacher` int(11) NULL DEFAULT NULL COMMENT '授课老师',
    1203. 

  1203.   `Local` int(11) NULL DEFAULT NULL COMMENT '实验地点',
    1204. 

  1204.   `Class` int(11) NULL DEFAULT NULL COMMENT '授课班级',
    1205. 

  1205.   `Mark` decimal(32, 8) NULL DEFAULT NULL COMMENT '学分',
    1206. 

  1206.   `Num` int(11) NULL DEFAULT NULL COMMENT '人数',
    1207. 

  1207.   `WeekTitle` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '教学周',
    1208. 

  1208.   `DayOfWeek` int(11) NULL DEFAULT NULL COMMENT '周次 1-7',
    1209. 

  1209.   `Time` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '节次',
    1210. 

  1210.   `Status` int(11) NULL DEFAULT NULL COMMENT '状态 发布状态',
    1211. 

  1211.   `CreatedBy` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人',
    1212. 

  1212.   `CreatedTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
    1213. 

  1213.   `UpdatedBy` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '更新人',
    1214. 

  1214.   `UpdatedTime` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
    1215. 

  1215.   `IsDel` int(11) NOT NULL COMMENT '删除标志',
    1216. 

  1216.   PRIMARY KEY (`Id`) USING BTREE
    1217. 

  1217. ) ENGINE = InnoDB AUTO_INCREMENT = 18 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '课程明细表' ROW_FORMAT = Dynamic;
    1218. 

  1218. 

  1219. -- ----------------------------
    1220. 

  1220. -- Records of course_detail
    1221. 

  1221. -- ----------------------------
    1222. 

  1222. 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);
    1223. 

  1223. 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);
    1224. 

  1224. 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);
    1225. 

  1225. 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);
    1226. 

  1226. 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);
    1227. 

  1227. 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);
    1228. 

  1228. 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);
    1229. 

  1229. 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);
    1230. 

  1230. 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);
    1231. 

  1231. 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);
    1232. 

  1232. 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);
    1233. 

  1233. 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);
    1234. 

  1234. 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);
    1235. 

  1235. 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);
    1236. 

  1236. 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);
    1237. 

  1237. 

  1238. -- ----------------------------
    1239. 

  1239. -- Table structure for duty
    1240. 

  1240. -- ----------------------------
    1241. 

  1241. DROP TABLE IF EXISTS `duty`;
    1242. 

  1242. CREATE TABLE `duty`  (
    1243. 

  1243.   `Id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
    1244. 

  1244.   `Year` int(11) NOT NULL COMMENT '学年',
    1245. 

  1245.   `Term` int(11) NOT NULL COMMENT '学期',
    1246. 

  1246.   `Title` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '标题',
    1247. 

  1247.   `Status` int(11) NOT NULL COMMENT '状态',
    1248. 

  1248.   `CreatedBy` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人',
    1249. 

  1249.   `CreatedTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
    1250. 

  1250.   `UpdatedBy` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '更新人',
    1251. 

  1251.   `UpdatedTime` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
    1252. 

  1252.   `IsDel` int(11) NOT NULL COMMENT '删除标志',
    1253. 

  1253.   PRIMARY KEY (`Id`) USING BTREE
    1254. 

  1254. ) ENGINE = InnoDB AUTO_INCREMENT = 325 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '值班表 ' ROW_FORMAT = Dynamic;
    1255. 

  1255. 

  1256. -- ----------------------------
    1257. 

  1257. -- Records of duty
    1258. 

  1258. -- ----------------------------
    1259. 

  1259. INSERT INTO `duty` VALUES (22, 2020, 1, '计算机楼1-24周值班表1', 1, '', '2020-12-28 14:30:32', '', '2020-12-28 17:31:07', 0);
    1260. 

  1260. INSERT INTO `duty` VALUES (323, 2020, 1, '计算机楼24-54周值班表', 1, '', '2020-12-28 17:44:28', '', '2020-12-28 19:16:32', 0);
    1261. 

  1261. INSERT INTO `duty` VALUES (324, 2020, 1, '第1-21周', 1, '', '2020-12-28 19:20:12', '', '2020-12-28 19:43:45', 0);
    1262. 

  1262. INSERT INTO `duty` VALUES (325, 2020, 2, '12日计划', 1, '', '2020-12-29 15:38:30', '', NULL, 0);
    1263. 

  1263. 

  1264. -- ----------------------------
    1265. 

  1265. -- Table structure for duty_detail
    1266. 

  1266. -- ----------------------------
    1267. 

  1267. DROP TABLE IF EXISTS `duty_detail`;
    1268. 

  1268. CREATE TABLE `duty_detail`  (
    1269. 

  1269.   `Id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
    1270. 

  1270.   `DutyId` int(11) NOT NULL COMMENT '值班ID',
    1271. 

  1271.   `Local` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '地点',
    1272. 

  1272.   `Time` int(11) NULL DEFAULT NULL COMMENT '时间段',
    1273. 

  1273.   `Status` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '状态',
    1274. 

  1274.   `People` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '值班人员',
    1275. 

  1275.   `Monday` int(11) NULL DEFAULT NULL COMMENT '周一',
    1276. 

  1276.   `Tuesday` int(11) NULL DEFAULT NULL COMMENT '周二',
    1277. 

  1277.   `Wednesday` int(11) NULL DEFAULT NULL COMMENT '周三',
    1278. 

  1278.   `Thursday` int(11) NULL DEFAULT NULL COMMENT '周四',
    1279. 

  1279.   `Friday` int(11) NULL DEFAULT NULL COMMENT '周五',
    1280. 

  1280.   `Saturday` int(11) NULL DEFAULT NULL COMMENT '周六',
    1281. 

  1281.   `Sunday` int(11) NULL DEFAULT NULL COMMENT '周天',
    1282. 

  1282.   `CreatedBy` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人',
    1283. 

  1283.   `CreatedTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
    1284. 

  1284.   `UpdatedBy` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '更新人',
    1285. 

  1285.   `UpdatedTime` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
    1286. 

  1286.   `IsDel` int(11) NOT NULL COMMENT '删除标志',
    1287. 

  1287.   PRIMARY KEY (`Id`) USING BTREE
    1288. 

  1288. ) ENGINE = InnoDB AUTO_INCREMENT = 179 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '值班详情表' ROW_FORMAT = Dynamic;
    1289. 

  1289. 

  1290. -- ----------------------------
    1291. 

  1291. -- Records of duty_detail
    1292. 

  1292. -- ----------------------------
    1293. 

  1293. 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);
    1294. 

  1294. 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);
    1295. 

  1295. 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);
    1296. 

  1296. 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);
    1297. 

  1297. 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);
    1298. 

  1298. 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);
    1299. 

  1299. 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);
    1300. 

  1300. 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);
    1301. 

  1301. 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);
    1302. 

  1302. 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);
    1303. 

  1303. INSERT INTO `duty_detail` VALUES (139, 21, '2', 1, '', '', 5, 0, 4, 6, 0, 1, 0, '', '2020-12-28 14:47:03', '', NULL, 0);
    1304. 

  1304. INSERT INTO `duty_detail` VALUES (140, 21, '2', 3, '', '', 0, 5, 4, 5, 0, 1, 5, '', '2020-12-28 14:47:03', '', NULL, 0);
    1305. 

  1305. INSERT INTO `duty_detail` VALUES (141, 21, '2', 4, '', '', 0, 6, 4, 0, 0, 1, 0, '', '2020-12-28 14:47:03', '', NULL, 0);
    1306. 

  1306. INSERT INTO `duty_detail` VALUES (142, 21, '2', 2, '', '', 0, 0, 4, 0, 0, 1, 0, '', '2020-12-28 14:47:03', '', NULL, 0);
    1307. 

  1307. INSERT INTO `duty_detail` VALUES (143, 21, '1', 1, '', '', 0, 0, 4, 0, 5, 1, 0, '', '2020-12-28 14:47:03', '', NULL, 0);
    1308. 

  1308. INSERT INTO `duty_detail` VALUES (144, 21, '1', 3, '', '', 5, 0, 4, 5, 0, 1, 5, '', '2020-12-28 14:47:03', '', NULL, 0);
    1309. 

  1309. INSERT INTO `duty_detail` VALUES (145, 21, '1', 4, '', '', 0, 5, 4, 0, 0, 1, 0, '', '2020-12-28 14:47:03', '', NULL, 0);
    1310. 

  1310. INSERT INTO `duty_detail` VALUES (146, 21, '1', 2, '', '', 0, 0, 4, 6, 0, 1, 0, '', '2020-12-28 14:47:03', '', NULL, 0);
    1311. 

  1311. 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);
    1312. 

  1312. 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);
    1313. 

  1313. 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);
    1314. 

  1314. 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);
    1315. 

  1315. 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);
    1316. 

  1316. 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);
    1317. 

  1317. INSERT INTO `duty_detail` VALUES (153, 20, '2', 1, '', '', 4, 4, 4, 4, 4, 4, 4, '', '2020-12-28 15:09:36', '', NULL, 0);
    1318. 

  1318. INSERT INTO `duty_detail` VALUES (154, 20, '2', 3, '', '', 4, 4, 4, 4, 4, 4, 4, '', '2020-12-28 15:09:36', '', NULL, 0);
    1319. 

  1319. 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);
    1320. 

  1320. 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);
    1321. 

  1321. 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);
    1322. 

  1322. 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);
    1323. 

  1323. 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);
    1324. 

  1324. 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);
    1325. 

  1325. 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);
    1326. 

  1326. INSERT INTO `duty_detail` VALUES (162, 22, '1', 1, '', '', 3, 3, 3, 3, 3, 3, 3, '', '2020-12-28 16:28:32', '', NULL, 0);
    1327. 

  1327. 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);
    1328. 

  1328. INSERT INTO `duty_detail` VALUES (164, 323, '1', 3, '', '', 171, 268, 268, 5, 0, 1, 171, '', '2020-12-28 18:43:04', '', NULL, 0);
    1329. 

  1329. INSERT INTO `duty_detail` VALUES (165, 323, '1', 2, '', '', 171, 171, 171, 171, 5, 264, 171, '', '2020-12-28 18:43:04', '', NULL, 0);
    1330. 

  1330. INSERT INTO `duty_detail` VALUES (166, 323, '1', 4, '', '', 171, 1, 0, 5, 264, 0, 178, '', '2020-12-28 18:43:04', '', NULL, 0);
    1331. 

  1331. INSERT INTO `duty_detail` VALUES (167, 323, '2', 1, '', '', 171, 168, 168, 168, 1, 264, 171, '', '2020-12-28 18:43:04', '', NULL, 0);
    1332. 

  1332. INSERT INTO `duty_detail` VALUES (168, 323, '2', 3, '', '', 171, 5, 0, 0, 264, 5, 171, '', '2020-12-28 18:43:04', '', NULL, 0);
    1333. 

  1333. INSERT INTO `duty_detail` VALUES (169, 323, '2', 2, '', '', 171, 0, 5, 5, 5, 264, 171, '', '2020-12-28 18:43:04', '', NULL, 0);
    1334. 

  1334. INSERT INTO `duty_detail` VALUES (170, 323, '2', 4, '', '', 178, 178, 178, 178, 178, 178, 171, '', '2020-12-28 18:43:04', '', NULL, 0);
    1335. 

  1335. INSERT INTO `duty_detail` VALUES (171, 324, '2', 1, '', '', 168, 0, 0, 0, 0, 0, 0, '', '2020-12-28 19:21:03', '', NULL, 0);
    1336. 

  1336. INSERT INTO `duty_detail` VALUES (172, 324, '2', 3, '', '', 264, 0, 0, 168, 0, 168, 0, '', '2020-12-28 19:21:03', '', NULL, 0);
    1337. 

  1337. INSERT INTO `duty_detail` VALUES (173, 324, '2', 4, '', '', 178, 168, 0, 0, 168, 0, 0, '', '2020-12-28 19:21:03', '', NULL, 0);
    1338. 

  1338. INSERT INTO `duty_detail` VALUES (174, 324, '2', 2, '', '', 264, 178, 0, 264, 0, 0, 0, '', '2020-12-28 19:21:03', '', NULL, 0);
    1339. 

  1339. INSERT INTO `duty_detail` VALUES (175, 324, '1', 1, '', '', 0, 0, 168, 0, 0, 0, 168, '', '2020-12-28 19:21:03', '', NULL, 0);
    1340. 

  1340. INSERT INTO `duty_detail` VALUES (176, 324, '1', 3, '', '', 264, 0, 0, 168, 0, 168, 0, '', '2020-12-28 19:21:03', '', NULL, 0);
    1341. 

  1341. INSERT INTO `duty_detail` VALUES (177, 324, '1', 4, '', '', 0, 0, 0, 264, 168, 0, 0, '', '2020-12-28 19:21:03', '', NULL, 0);
    1342. 

  1342. INSERT INTO `duty_detail` VALUES (178, 324, '1', 2, '', '', 0, 0, 0, 264, 0, 0, 0, '', '2020-12-28 19:21:03', '', NULL, 0);
    1343. 

  1343. INSERT INTO `duty_detail` VALUES (179, 325, '2', 1, '', '', 178, 168, 0, 0, 178, 0, 0, '', '2020-12-29 15:38:51', '', NULL, 0);
    1344. 

  1344. INSERT INTO `duty_detail` VALUES (180, 325, '2', 2, '', '', 178, 0, 178, 168, 178, 0, 0, '', '2020-12-29 15:38:51', '', NULL, 0);
    1345. 

  1345. INSERT INTO `duty_detail` VALUES (181, 325, '2', 3, '', '', 178, 0, 0, 0, 168, 0, 0, '', '2020-12-29 15:38:51', '', NULL, 0);
    1346. 

  1346. INSERT INTO `duty_detail` VALUES (182, 325, '2', 4, '', '', 178, 0, 168, 0, 0, 0, 0, '', '2020-12-29 15:38:51', '', NULL, 0);
    1347. 

  1347. 

  1348. -- ----------------------------
    1349. 

  1349. -- Table structure for information
    1350. 

  1350. -- ----------------------------
    1351. 

  1351. DROP TABLE IF EXISTS `information`;
    1352. 

  1352. CREATE TABLE `information`  (
    1353. 

  1353.   `Id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
    1354. 

  1354.   `Title` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '标题',
    1355. 

  1355.   `Content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '内容',
    1356. 

  1356.   `Flag` int(11) NULL DEFAULT NULL COMMENT '类别',
    1357. 

  1357.   `Status` int(11) NULL DEFAULT NULL COMMENT '状态',
    1358. 

  1358.   `CreatedBy` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人',
    1359. 

  1359.   `CreatedTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
    1360. 

  1360.   `UpdatedBy` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '更新人',
    1361. 

  1361.   `UpdatedTime` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
    1362. 

  1362.   `IsDel` int(11) NOT NULL COMMENT '删除标志',
    1363. 

  1363.   PRIMARY KEY (`Id`) USING BTREE
    1364. 

  1364. ) ENGINE = InnoDB AUTO_INCREMENT = 56 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '信息表' ROW_FORMAT = Dynamic;
    1365. 

  1365. 

  1366. -- ----------------------------
    1367. 

  1367. -- Records of information
    1368. 

  1368. -- ----------------------------
    1369. 

  1369. 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);
    1370. 

  1370. 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);
    1371. 

  1371. INSERT INTO `information` VALUES (55, '321', '321321321', NULL, 1, NULL, '2020-12-28 18:50:07', NULL, '2020-12-28 18:50:20', 1);
    1372. 

  1372. 

  1373. -- ----------------------------
    1374. 

  1374. -- Table structure for instr_room
    1375. 

  1375. -- ----------------------------
    1376. 

  1376. DROP TABLE IF EXISTS `instr_room`;
    1377. 

  1377. CREATE TABLE `instr_room`  (
    1378. 

  1378.   `Id` int(11) NOT NULL AUTO_INCREMENT COMMENT '房间id',
    1379. 

  1379.   `RoomNum` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '房间号',
    1380. 

  1380.   `RoomName` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '房间名称',
    1381. 

  1381.   `RoomType` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '房间类型',
    1382. 

  1382.   `RoomDescribe` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '房间描述',
    1383. 

  1383.   `PositionInformation` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '位置信息',
    1384. 

  1384.   `CreateOn` datetime(0) NULL DEFAULT NULL,
    1385. 

  1385.   `CreateUserId` int(11) NULL DEFAULT NULL,
    1386. 

  1386.   `CreateBy` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    1387. 

  1387.   `ModifiedOn` datetime(0) NULL DEFAULT NULL,
    1388. 

  1388.   `ModifiedUserId` int(11) NULL DEFAULT NULL,
    1389. 

  1389.   `ModifiedBy` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    1390. 

  1390.   `building` int(11) NULL DEFAULT NULL COMMENT '建筑信息',
    1391. 

  1391.   PRIMARY KEY (`Id`) USING BTREE
    1392. 

  1392. ) ENGINE = InnoDB AUTO_INCREMENT = 371 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;
    1393. 

  1393. 

  1394. -- ----------------------------
    1395. 

  1395. -- Records of instr_room
    1396. 

  1396. -- ----------------------------
    1397. 

  1397. 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);
    1398. 

  1398. 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);
    1399. 

  1399. 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);
    1400. 

  1400. 

  1401. -- ----------------------------
    1402. 

  1402. -- Table structure for instrumenmaintainlog
    1403. 

  1403. -- ----------------------------
    1404. 

  1404. DROP TABLE IF EXISTS `instrumenmaintainlog`;
    1405. 

  1405. CREATE TABLE `instrumenmaintainlog`  (
    1406. 

  1406.   `Id` int(10) NOT NULL AUTO_INCREMENT,
    1407. 

  1407.   `InstrumenId` int(10) NULL DEFAULT NULL COMMENT '设备Id',
    1408. 

  1408.   `InstrumenName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '设备名称',
    1409. 

  1409.   `InstrumenCode` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '设备编号',
    1410. 

  1410.   `OperaRemark` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '维护说明',
    1411. 

  1411.   `OperaTpye` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '维护类型，从字典表下拉，字典项 InstrumenMaintainType',
    1412. 

  1412.   `OperaUser` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作人',
    1413. 

  1413.   `OperaOn` datetime(0) NULL DEFAULT NULL COMMENT '操作日期',
    1414. 

  1414.   `CreateUserId` int(10) NULL DEFAULT NULL,
    1415. 

  1415.   `CreateBy` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1416. 

  1416.   `CreateOn` datetime(0) NULL DEFAULT NULL,
    1417. 

  1417.   `TypeCode` int(4) NULL DEFAULT NULL,
    1418. 

  1418.   `ModifiedUserId` int(10) NULL DEFAULT NULL,
    1419. 

  1419.   `ModifiedBy` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1420. 

  1420.   `ModifiedOn` datetime(0) NULL DEFAULT NULL,
    1421. 

  1421.   PRIMARY KEY (`Id`) USING BTREE
    1422. 

  1422. ) ENGINE = InnoDB AUTO_INCREMENT = 137 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '设备维护记录，质量管理' ROW_FORMAT = Dynamic;
    1423. 

  1423. 

  1424. -- ----------------------------
    1425. 

  1425. -- Records of instrumenmaintainlog
    1426. 

  1426. -- ----------------------------
    1427. 

  1427. 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');
    1428. 

  1428. 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');
    1429. 

  1429. 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');
    1430. 

  1430. INSERT INTO `instrumenmaintainlog` VALUES (138, 252, '电视', 'HX-YV-01', '报废申请', '设备报废', '王伟', '2020-12-29 17:35:56', 0, '', '2020-12-29 17:36:06', 2, 0, '', '2020-12-29 17:59:58');
    1431. 

  1431. 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');
    1432. 

  1432. 

  1433. -- ----------------------------
    1434. 

  1434. -- Table structure for instrumenrunrecord
    1435. 

  1435. -- ----------------------------
    1436. 

  1436. DROP TABLE IF EXISTS `instrumenrunrecord`;
    1437. 

  1437. CREATE TABLE `instrumenrunrecord`  (
    1438. 

  1438.   `Id` int(10) NOT NULL AUTO_INCREMENT,
    1439. 

  1439.   `InstrumentId` int(10) NULL DEFAULT NULL COMMENT '设备Id',
    1440. 

  1440.   `InstrumenName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '设备名称',
    1441. 

  1441.   `InstrumenCode` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '设备编号',
    1442. 

  1442.   `RecordRemark` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '运行说明',
    1443. 

  1443.   `ContractNo` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '合同编号',
    1444. 

  1444.   `PrepinfoDetailId` int(10) NULL DEFAULT NULL COMMENT '制备详情Id',
    1445. 

  1445.   `CreateUserId` int(10) NULL DEFAULT NULL COMMENT '操作人ID',
    1446. 

  1446.   `CreateBy` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作人',
    1447. 

  1447.   `CreateOn` datetime(0) NULL DEFAULT NULL COMMENT '操作时间',
    1448. 

  1448.   `ModifiedUserId` int(10) NULL DEFAULT NULL,
    1449. 

  1449.   `ModifiedBy` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1450. 

  1450.   `ModifiedOn` datetime(0) NULL DEFAULT NULL,
    1451. 

  1451.   PRIMARY KEY (`Id`) USING BTREE
    1452. 

  1452. ) ENGINE = InnoDB AUTO_INCREMENT = 142 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '设备运行记录' ROW_FORMAT = Dynamic;
    1453. 

  1453. 

  1454. -- ----------------------------
    1455. 

  1455. -- Records of instrumenrunrecord
    1456. 

  1456. -- ----------------------------
    1457. 

  1457. 

  1458. -- ----------------------------
    1459. 

  1459. -- Table structure for instrument
    1460. 

  1460. -- ----------------------------
    1461. 

  1461. DROP TABLE IF EXISTS `instrument`;
    1462. 

  1462. CREATE TABLE `instrument`  (
    1463. 

  1463.   `Id` int(11) NOT NULL AUTO_INCREMENT,
    1464. 

  1464.   `RoomId` int(11) NULL DEFAULT NULL COMMENT '所属房间Id，instr_room.Id',
    1465. 

  1465.   `Code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '设备编码',
    1466. 

  1466.   `Name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '设备名称',
    1467. 

  1467.   `SupplierId` int(11) NULL DEFAULT NULL,
    1468. 

  1468.   `Supplier` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '供应商',
    1469. 

  1469.   `FactoryNum` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '出厂编号',
    1470. 

  1470.   `Model` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '型号',
    1471. 

  1471.   `Brand` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '设备品牌',
    1472. 

  1472.   `Classification` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '设备大类',
    1473. 

  1473.   `State` int(11) NOT NULL DEFAULT 1 COMMENT '设备状态 1正常2异常',
    1474. 

  1474.   `Location` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '设备所在位置',
    1475. 

  1475.   `Remarks` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
    1476. 

  1476.   `IsFixedPoint` int(11) NULL DEFAULT 0 COMMENT '参与点检: 0. 否(默认) 1. 是',
    1477. 

  1477.   `CalibrationTime` datetime(0) NULL DEFAULT NULL COMMENT '校准时间',
    1478. 

  1478.   `CalibrationDeadline` int(11) NULL DEFAULT NULL COMMENT '校准使用期限',
    1479. 

  1479.   `CalibrationDeadlineType` int(11) NULL DEFAULT NULL COMMENT ' 期限类型:1:天 2：周 3：月 4：年 ',
    1480. 

  1480.   `MaintenCycle` int(11) NULL DEFAULT NULL COMMENT '维护周期数',
    1481. 

  1481.   `CycleType` int(11) NULL DEFAULT NULL COMMENT ' 期限类型:1:天 2：周 3：月 4：年 ',
    1482. 

  1482.   `HeartbeatTime` datetime(0) NOT NULL COMMENT '心跳时间 对应上报时间',
    1483. 

  1483.   `CreateOn` datetime(0) NOT NULL,
    1484. 

  1484.   `CreateUserId` int(11) NULL DEFAULT NULL,
    1485. 

  1485.   `CreateBy` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1486. 

  1486.   `ModifiedOn` datetime(0) NULL DEFAULT NULL,
    1487. 

  1487.   `ModifiedUserId` int(11) NULL DEFAULT NULL,
    1488. 

  1488.   `ModifiedBy` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1489. 

  1489.   `FileUrl` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作规程文件路径',
    1490. 

  1490.   `FileName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文件名',
    1491. 

  1491.   `Remark` tinytext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
    1492. 

  1492.   `TimeNotification` int(11) NULL DEFAULT NULL COMMENT '有效期提醒',
    1493. 

  1493.   `Sharable` tinyint(4) NULL DEFAULT NULL COMMENT '是否共享(可预约)',
    1494. 

  1494.   `EndTime` datetime(0) NULL DEFAULT NULL COMMENT '截止日期',
    1495. 

  1495.   `Responsible` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '责任人',
    1496. 

  1496.   `MaintenTime` date NULL DEFAULT NULL COMMENT '最后维护时间',
    1497. 

  1497.   `Purchasedate` datetime(0) NULL DEFAULT NULL COMMENT '采购日期',
    1498. 

  1498.   `JoinPlan` tinyint(4) NULL DEFAULT 1 COMMENT '计划: 1参与 0 不参与',
    1499. 

  1499.   `Spec` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '规格',
    1500. 

  1500.   PRIMARY KEY (`Id`) USING BTREE,
    1501. 

  1501.   UNIQUE INDEX `Code`(`Code`) USING BTREE
    1502. 

  1502. ) ENGINE = InnoDB AUTO_INCREMENT = 253 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '设备信息' ROW_FORMAT = DYNAMIC;
    1503. 

  1503. 

  1504. -- ----------------------------
    1505. 

  1505. -- Records of instrument
    1506. 

  1506. -- ----------------------------
    1507. 

  1507. 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, '');
    1508. 

  1508. 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, '');
    1509. 

  1509. 

  1510. -- ----------------------------
    1511. 

  1511. -- Table structure for personnel
    1512. 

  1512. -- ----------------------------
    1513. 

  1513. DROP TABLE IF EXISTS `personnel`;
    1514. 

  1514. CREATE TABLE `personnel`  (
    1515. 

  1515.   `Id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
    1516. 

  1516.   `PersonnelName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
    1517. 

  1517.   `PersonneCode` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '编号',
    1518. 

  1518.   `Person` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系人',
    1519. 

  1519.   `Telephone` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '电话',
    1520. 

  1520.   `Mailbox` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱',
    1521. 

  1521.   `CardId` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '身份证号',
    1522. 

  1522.   `Address` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '地址',
    1523. 

  1523.   `Established` date NULL DEFAULT NULL COMMENT '入职时间',
    1524. 

  1524.   `ZipCode` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮编',
    1525. 

  1525.   `Website` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '网站地址',
    1526. 

  1526.   `DepartmentId` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '组织id',
    1527. 

  1527.   `DepartmentName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '组织名称',
    1528. 

  1528.   `Type` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '类型',
    1529. 

  1529.   `CreateOn` datetime(0) NULL DEFAULT NULL,
    1530. 

  1530.   `CreateUserId` int(10) NULL DEFAULT NULL,
    1531. 

  1531.   `CreateBy` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1532. 

  1532.   `ModifiedOn` datetime(0) NULL DEFAULT NULL,
    1533. 

  1533.   `ModifiedUserId` int(10) NULL DEFAULT NULL,
    1534. 

  1534.   `ModifiedBy` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    1535. 

  1535.   `Remarks` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
    1536. 

  1536.   PRIMARY KEY (`Id`) USING BTREE
    1537. 

  1537. ) ENGINE = InnoDB AUTO_INCREMENT = 298 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '人员管理' ROW_FORMAT = Dynamic;
    1538. 

  1538. 

  1539. -- ----------------------------
    1540. 

  1540. -- Records of personnel
    1541. 

  1541. -- ----------------------------
    1542. 

  1542. INSERT INTO `personnel` VALUES (164, '小杜', '1', '', '12384', '123@qq', '199806047', '青岛', NULL, NULL, '', '1', '大数', '1', NULL, 0, '', '2020-12-25 16:49:29', 1, '系统管理员', '');
    1543. 

  1543. 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, '系统管理员', '');
    1544. 

  1544. 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, '系统管理员', '人员');
    1545. 

  1545. 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);
    1546. 

  1546. INSERT INTO `personnel` VALUES (264, '小白', '137812', '', '12384', '123@qq', '199806047', '青岛', NULL, NULL, '', '1', '大数', '1', NULL, 0, '', '2020-12-25 13:37:41', 1, '系统管理员', NULL);
    1547. 

  1547. 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, '', '');
    1548. 

  1548. 

  1549. SET FOREIGN_KEY_CHECKS = 1;
    1550.