| 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549 |
- /*
- Navicat Premium Data Transfer
- Source Server : l_lims
- Source Server Type : MySQL
- Source Server Version : 80016
- Source Host : rm-8vbk16zx2rbfu6jt6uo.mysql.zhangbei.rds.aliyuncs.com:3306
- Source Schema : l_lims
- Target Server Type : MySQL
- Target Server Version : 80016
- File Encoding : 65001
- Date: 29/12/2020 18:07:18
- */
- SET NAMES utf8mb4;
- SET FOREIGN_KEY_CHECKS = 0;
- -- ----------------------------
- -- Table structure for base_itemdetails
- -- ----------------------------
- DROP TABLE IF EXISTS `base_itemdetails`;
- CREATE TABLE `base_itemdetails` (
- `Id` int(10) NOT NULL AUTO_INCREMENT,
- `AccCode` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `ParentId` int(10) NULL DEFAULT NULL,
- `ItemCode` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `ItemName` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `ItemValue` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `Enabled` int(10) NOT NULL DEFAULT 1,
- `AllowEdit` int(10) NOT NULL DEFAULT 1,
- `AllowDelete` int(10) NOT NULL DEFAULT 1,
- `SortCode` int(10) NULL DEFAULT NULL,
- `Description` varchar(800) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `IsPublic` int(10) NOT NULL DEFAULT 1,
- `DeletionStateCode` int(10) NOT NULL DEFAULT 0,
- `CreateOn` datetime(0) NULL DEFAULT NULL,
- `CreateUserId` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `CreateBy` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `ModifiedOn` datetime(0) NULL DEFAULT NULL,
- `ModifiedUserId` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `ModifiedBy` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- PRIMARY KEY (`Id`) USING BTREE
- ) ENGINE = InnoDB AUTO_INCREMENT = 1034 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
- -- ----------------------------
- -- Records of base_itemdetails
- -- ----------------------------
- 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);
- INSERT INTO `base_itemdetails` VALUES (169, '', 203, NULL, '紫管', '紫管', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- 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);
- 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);
- INSERT INTO `base_itemdetails` VALUES (173, '', 206, NULL, '顺丰', '顺丰快递', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (174, '', 206, NULL, '中通', '中通快递', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (175, '', 206, NULL, '邮政', '邮政快递', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (176, '', 208, NULL, 'Ipc项目', 'Ipc项目', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- 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);
- INSERT INTO `base_itemdetails` VALUES (178, '', 209, NULL, '感冒', '感冒', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (179, '', 209, NULL, '发烧', '发烧', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (180, '', 209, NULL, '头疼', '头疼', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (181, '', 210, NULL, '第一类医疗设备', '第一类医疗设备', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- 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);
- INSERT INTO `base_itemdetails` VALUES (184, '', 211, NULL, '个', '个', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (185, '', 211, NULL, '瓶', '瓶', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (186, '', 211, NULL, '箱', '箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (187, '', 211, NULL, '袋', '袋', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (188, '', 211, NULL, '支', '支', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (189, '', 211, NULL, '盒', '盒', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- 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);
- 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);
- INSERT INTO `base_itemdetails` VALUES (192, '', 213, NULL, 'BD', 'BD', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (193, '', 213, NULL, 'Life', 'Life', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (194, '', 213, NULL, 'Gibco', 'Gibco', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (200, 'sQLQ4', 206, NULL, '顺丰', '顺丰', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (201, 'sQLQ4', 206, NULL, '邮政', '邮政', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- 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);
- INSERT INTO `base_itemdetails` VALUES (203, 'sQLQ4', 204, NULL, 'iPSCs细胞制备', 'iPSCs细胞制备', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (204, 'sQLQ4', 199, NULL, 'ml', 'ml', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (205, 'sQLQ4', 199, NULL, 'g', 'g', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (206, 'sQLQ4', 210, NULL, '离心机', '离心机', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (207, 'sQLQ4', 209, NULL, '心脏病', '心脏病', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (208, 'sQLQ4', 209, NULL, '冠心病', '冠心病', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (209, 'sQLQ4', 211, NULL, '个', '个', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (210, 'sQLQ4', 211, NULL, '盒', '盒', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (211, 'sQLQ4', 211, NULL, '箱', '箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- 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);
- INSERT INTO `base_itemdetails` VALUES (213, 'sQLQ4', 213, NULL, '品牌1', '品牌1', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (216, 'sQLQ4', 215, NULL, '国有企业', '国有企业', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (217, 'sQLQ4', 216, NULL, '样本异常', '样本异常', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (218, 's4JrT', 204, NULL, 'iPSCs制备', 'iPSCs制备', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (219, 's4JrT', 206, NULL, '顺丰', '顺丰', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (220, 's4JrT', 206, NULL, '邮政', '邮政', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (221, 's4JrT', 208, NULL, 'iPSCs项目', 'iPSCs项目', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (225, 's4JrT', 209, NULL, '乙肝', '乙肝', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (226, 's4JrT', 209, NULL, '高血压', '高血压', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (228, 's4JrT', 211, NULL, '个', '个', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (229, 's4JrT', 211, NULL, '支', '支', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (230, 's4JrT', 211, NULL, '盒', '盒', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (231, 's4JrT', 211, NULL, '箱', '箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (233, 's4JrT', 213, NULL, '品牌A', '品牌A', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (236, 's4JrT', 215, NULL, '国有企业', '国有企业', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (237, 's4JrT', 215, NULL, '合资企业', '合资企业', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (238, 's4JrT', 216, NULL, '样本异常', '样本异常', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- 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);
- INSERT INTO `base_itemdetails` VALUES (241, 's4JrT', 210, NULL, '洁净工作台', '洁净工作台', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (242, 's4JrT', 210, NULL, '生物安全柜', '生物安全柜', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (243, 's4JrT', 210, NULL, '倒置荧光显微镜', '倒置荧光显微镜', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (244, 's4JrT', 210, NULL, '4℃医用冰箱', '4℃医用冰箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (245, 's4JrT', 210, NULL, '负20℃医用冰箱', '负20℃医用冰箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (246, 's4JrT', 210, NULL, '负80℃超低温冰箱', '负80℃超低温冰箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (247, 's4JrT', 210, NULL, '液氮罐', '液氮罐', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (248, 's4JrT', 210, NULL, '灭菌柜', '灭菌柜', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (249, 's4JrT', 210, NULL, '三分类血液分析仪', '三分类血液分析仪', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (250, 's4JrT', 210, NULL, '自动细胞计数仪', '自动细胞计数仪', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (251, 's4JrT', 210, NULL, '微生物培养仪', '微生物培养仪', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (252, 's4JrT', 210, NULL, '流式细胞仪', '流式细胞仪', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (253, 's4JrT', 210, NULL, '光学显微镜', '光学显微镜', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (258, 'sQLQ4', 212, NULL, 'Meck', 'Meck', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (259, 'sQLQ4', 212, NULL, 'Corning', 'Corning', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- 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);
- INSERT INTO `base_itemdetails` VALUES (261, 'sQLQ4', 212, NULL, 'BD', 'BD', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (262, 'sQLQ4', 213, NULL, 'Gibco', 'Gibco', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (263, 'sQLQ4', 213, NULL, 'Invitrogen', 'Invitrogen', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (264, 'sQLQ4', 213, NULL, 'Hyclone', 'Hyclone', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (265, 'sQLQ4', 213, NULL, 'Nunc', 'Nunc', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (266, 's4JrT', 212, NULL, '厂商B', '物料B', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (267, 's4JrT', 218, NULL, '实验异常', '实验结果异常,存在异常数据', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (268, 's4JrT', 218, NULL, '实验正常', '实验结果正常,无异常现象', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (269, 's4JrT', 219, NULL, '审核通过', '数据、操作正常,无异常数据,审核通过', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (270, 's4JrT', 219, NULL, '审核不通过', '数据、操作存在异常,审核不通过', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (271, 'sD8gC', 199, NULL, '毫克', 'mg', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (272, 'sD8gC', 199, NULL, '克', 'g', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (273, 'sD8gC', 199, NULL, '毫升', 'ml', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (274, 'sD8gC', 204, NULL, 'iPSCs制备', 'iPSCs制备', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (275, 'sD8gC', 204, NULL, 'SCNT移植', 'SCNT移植', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (276, 'sD8gC', 204, NULL, 'CRSIPR', 'CRSIPR', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- 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);
- 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);
- 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);
- 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);
- 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);
- INSERT INTO `base_itemdetails` VALUES (282, 'sD8gC', 208, NULL, 'iPSCs项目', 'iPSCs项目', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (283, 'sD8gC', 208, NULL, 'CIK', 'CIK', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (284, 'sD8gC', 208, NULL, 'CRSIPR', 'CRSIPR', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (285, 'sD8gC', 208, NULL, 'SCNT', 'SCNT', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (286, 'sD8gC', 209, NULL, '高血压', '高血压', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (287, 'sD8gC', 209, NULL, '乙肝', '乙肝', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- INSERT INTO `base_itemdetails` VALUES (326, 'sD8gC', 218, NULL, '实验正常', '实验结果正常,无异常现象', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (327, 'sD8gC', 218, NULL, '实验异常', '实验结果异常,存在异常数据', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (328, 'sD8gC', 219, NULL, '审核不通过', '数据、操作存在异常,审核不通过', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (329, 'sD8gC', 219, NULL, '审核通过', '数据、操作正常,无异常数据,审核通过', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (330, 'sD8gC', 216, NULL, '运输时间过长,样本失效', '运输时间过长,样本失效', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (331, 'sD8gC', 211, NULL, '瓶', '瓶', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- 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);
- INSERT INTO `base_itemdetails` VALUES (335, 'sQLQ4', 215, NULL, '高校', '高校课题组', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (336, 'sQLQ4', 215, NULL, '有限责任公司', '有限责任公司', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (337, 'sQLQ4', 215, NULL, '股份有限公司', '股份有限公司', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (338, 'sQLQ4', 215, NULL, '其他', '其他', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (339, 'sQLQ4', 215, NULL, '科研单位', '科研单位', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (340, 'sQLQ4', 208, NULL, 'iPSCs-心肌分化', 'iPSCs-心肌分化', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (341, 'sQLQ4', 208, NULL, 'iPSCs-神经分化', 'iPSCs-神经分化', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (342, 'sD8gC', 211, NULL, '张', '张', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (343, 'sUUKC', 215, NULL, '001', '001', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (344, 'sUUKC', 204, NULL, '业务01', '01', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (345, 'sUUKC', 199, NULL, 'ML', 'ML', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (346, 'sUUKC', 209, NULL, '疾病类型01', '01', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (347, 'sUUKC', 213, NULL, '22', '22', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (349, 'sD8gC', 213, NULL, '大数', '大数', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (350, 'sD8gC', 211, NULL, '台', '台', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (351, 'sUUKC', 208, NULL, '抗凝血', '1', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (352, 'sUUKC', 211, NULL, '支', '1', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (354, 'sAGCH', 199, NULL, '毫升', 'mL', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (355, 'sAGCH', 204, NULL, '脐血保存', '脐血保存', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (356, 'sAGCH', 215, NULL, '医院', '医院', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (357, 'sYzpG', 199, NULL, 'g', 'g', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (358, 'sYzpG', 199, NULL, 'mL', 'mL', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (359, 'sYzpG', 204, NULL, 'iPSCs细胞制备', 'iPSCs细胞制备', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (360, 'sYzpG', 206, NULL, '顺丰', '顺丰', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (361, 'sYzpG', 208, NULL, 'iPSCs-心肌分化', 'iPSCs-心肌分化', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (362, 'sYzpG', 209, NULL, '冠心病', '冠心病', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (363, 'sYzpG', 209, NULL, '心脏病', '心脏病', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (365, 'sYzpG', 211, NULL, '箱', '箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (366, 'sYzpG', 211, NULL, '盒', '盒', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (367, 'sYzpG', 211, NULL, '个', '个', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (368, 'sYzpG', 212, NULL, 'BD', 'BD', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- 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);
- INSERT INTO `base_itemdetails` VALUES (370, 'sYzpG', 212, NULL, 'Thermo', 'Thermo', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (371, 'sYzpG', 212, NULL, 'Corning', 'Corning', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (372, 'sYzpG', 213, NULL, 'Gibco', 'Gibco', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (373, 'sYzpG', 213, NULL, 'Invitrogen', 'Invitrogen', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (374, 'sYzpG', 213, NULL, 'Hyclone', 'Hyclone', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (380, 'sYzpG', 216, NULL, '样本异常', '样本异常', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (381, 'sYzpG', 215, NULL, '科研单位', '科研单位', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (382, 'sYzpG', 215, NULL, '医院', '医院', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (383, 'sYzpG', 215, NULL, '高校', '高校', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (384, 'sYzpG', 215, NULL, '私营企业', '私营企业', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (385, 'sYzpG', 218, NULL, '实验正常', '实验结果正常,无异常现象', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (386, 'sYzpG', 218, NULL, '实验异常', '实验结果异常,存在异常数据', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (387, 'sYzpG', 219, NULL, '审核不通过', '数据、操作存在异常,审核不通过', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (388, 'sYzpG', 219, NULL, '审核通过', '数据、操作正常,无异常数据,审核通过', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (389, 'sYzpG', 213, NULL, 'Nunc', 'Nunc', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (390, 's4JrT', 212, NULL, 'Thermo', 'Thermo', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (391, 's4JrT', 212, NULL, 'Meck', 'Meck', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (392, 's4JrT', 212, NULL, 'Corning', 'Corning', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (393, 's4JrT', 213, NULL, 'Nunc', 'Nunc', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (394, 's4JrT', 213, NULL, 'Hyclone', 'Hyclone', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (395, 's4JrT', 213, NULL, 'Invitrogen', 'Invitrogen', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (396, 's4JrT', 213, NULL, 'Gibco', 'Gibco', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (397, 'sAGCH', 206, NULL, '顺丰', '顺丰', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (398, 'sAGCH', 212, NULL, 'Thermo', 'Thermo', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (399, 'sAGCH', 212, NULL, 'Meck', 'Meck', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (400, 'sAGCH', 211, NULL, '箱', '箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (401, 'sAGCH', 211, NULL, '盒', '盒', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (402, 'sAGCH', 211, NULL, '个', '个', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (403, 'sAGCH', 211, NULL, '袋', '袋', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (404, 'sAGCH', 211, NULL, '支', '支', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (405, 'sAGCH', 213, NULL, 'Nunc', 'Nunc', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (406, 'sAGCH', 213, NULL, 'Invitrogen', 'Invitrogen', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (407, 'sAGCH', 213, NULL, 'Hyclone', 'Hyclone', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (408, 'sAGCH', 213, NULL, 'Gibco', 'Gibco', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (409, 'sAGCH', 210, NULL, '离心机', '离心机', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (410, 'sAGCH', 208, NULL, '脐带', '脐带', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (411, 'sAGCH', 209, NULL, '高血压', '高血压', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (412, 'sAGCH', 209, NULL, '乙肝', '乙肝', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (413, 'sAGCH', 219, NULL, '审核不通过', '数据、操作存在异常,审核不通过', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (414, 'sAGCH', 219, NULL, '审核通过', '数据、操作正常,无异常数据,审核通过', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (415, 'sAGCH', 218, NULL, '实验正常', '实验结果正常,无异常现象', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (416, 'sAGCH', 218, NULL, '实验异常', '实验结果异常,存在异常数据', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (417, 'sAGCH', 216, NULL, '样本异常', '样本异常', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (418, '', 204, NULL, '细胞制备', '细胞制备', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (419, '', 206, NULL, '顺丰', '顺丰', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (420, '', 208, NULL, '细胞制备', '细胞制备', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (421, '', 199, NULL, '毫升', 'mL', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (422, '', 199, NULL, '毫克', 'mg', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (423, '', 209, NULL, '乙肝', '乙肝', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (424, '', 209, NULL, '高血压', '高血压', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (426, '', 211, NULL, '支', '支', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (427, '', 211, NULL, '袋', '袋', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (428, '', 211, NULL, '个', '个', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (429, '', 211, NULL, '盒', '盒', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (430, '', 211, NULL, '箱', '箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (431, '', 212, NULL, 'Meck', 'Meck', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (432, '', 212, NULL, 'Thermo', 'Thermo', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (433, '', 213, NULL, 'Gibco', 'Gibco', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (434, '', 213, NULL, 'Hyclone', 'Hyclone', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (435, '', 213, NULL, 'Invitrogen', 'Invitrogen', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (436, '', 213, NULL, 'Nunc', 'Nunc', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (438, '', 216, NULL, '样本异常', '样本异常', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (439, '', 218, NULL, '实验异常', ' 实验结果异常,存在异常数据', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (440, '', 218, NULL, '实验正常', '实验结果正常,无异常现象', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (441, '', 219, NULL, '审核通过', '数据、操作正常,无异常数据,审核通过', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (442, '', 219, NULL, '审核不通过', '数据、操作存在异常,审核不通过', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (444, 'ssVtu', 210, NULL, '生物安全柜', '生物安全柜', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (445, 'ssVtu', 210, NULL, '细胞计数仪', '细胞计数仪', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (446, 'ssVtu', 210, NULL, '培养箱', '培养箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (447, 'ssVtu', 210, NULL, '冰箱', '冰箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (448, 'ssVtu', 210, NULL, '液氮罐', '液氮罐', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (449, 'ssVtu', 210, NULL, '显微镜', '显微镜', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (450, 'ssVtu', 210, NULL, '烘箱', '烘箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (451, 'ssVtu', 210, NULL, '灭菌锅', '灭菌锅', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (452, 'ssVtu', 210, NULL, '移液器', '移液器', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (453, 'ssVtu', 210, NULL, '电脑', '电脑', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (454, 'ssVtu', 210, NULL, '打印机', '打印机', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- 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);
- INSERT INTO `base_itemdetails` VALUES (456, 'ssVtu', 209, NULL, '帕金森综合征', 'PD', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (457, 'ssVtu', 209, NULL, '抑郁症', '抑郁症', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (458, 'ssVtu', 209, NULL, '癫痫', '癫痫', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (459, 'ssVtu', 209, NULL, '心脏衰竭', '心脏衰竭', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (460, 'ssVtu', 209, NULL, '视网膜色素变性', '视网膜色素变性', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (461, 'ssVtu', 218, NULL, '正常', '正常', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (462, 'ssVtu', 218, NULL, '异常', '异常', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (463, 'ssVtu', 211, NULL, '箱', '箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (464, 'ssVtu', 211, NULL, '盒', '盒', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (465, 'ssVtu', 211, NULL, '袋', '袋', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (466, 'ssVtu', 211, NULL, '瓶', '瓶', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (467, 'ssVtu', 211, NULL, '支', '支', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (468, 'ssVtu', 211, NULL, 'g', 'g', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (469, 'ssVtu', 211, NULL, 'mg', 'mg', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (470, 'ssVtu', 211, NULL, 'ug', 'ug', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (471, 'ssVtu', 211, NULL, 'L', 'L', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (472, 'ssVtu', 211, NULL, 'mL', 'mL', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (473, 'ssVtu', 211, NULL, 'uL', 'uL', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (474, 'ssVtu', 211, NULL, '个', '个', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (475, 'ssVtu', 213, NULL, 'Nunc', 'Nunc', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (476, 'ssVtu', 213, NULL, 'Life', 'Life', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (477, 'ssVtu', 213, NULL, 'ABI', 'ABI', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (478, 'ssVtu', 213, NULL, 'RD', 'RD', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (479, 'ssVtu', 213, NULL, 'BD', 'BD', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (480, 'ssVtu', 213, NULL, '生工', '生工', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- 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);
- INSERT INTO `base_itemdetails` VALUES (482, 'ssVtu', 213, NULL, 'Thermo', 'Thermo', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (483, 'ssVtu', 213, NULL, '其他', '其他', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (484, 'ssVtu', 209, NULL, '健康', '健康', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (485, 'ssVtu', 199, NULL, 'mL', 'mL', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (486, 'ssVtu', 199, NULL, 'g', 'g', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- 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);
- INSERT INTO `base_itemdetails` VALUES (492, 'ssVtu', 219, NULL, '审核通过', '审核通过', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (493, 'ssVtu', 212, NULL, 'Thermo', 'Thermo', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- 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);
- INSERT INTO `base_itemdetails` VALUES (495, 'ssVtu', 212, NULL, 'RD', 'RD', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (496, 'ssVtu', 212, NULL, 'BD', 'BD', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (497, 'ssVtu', 212, NULL, '生工', '生工', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (498, 'ssVtu', 212, NULL, '国药', '国药', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (499, 'ssVtu', 212, NULL, '其他', '其他', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (500, 'ssVtu', 204, NULL, 'iPSCs制备', 'iPSCs制备', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (501, 'ssVtu', 204, NULL, '神经干细胞分化', '神经干细胞分化', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (502, 'ssVtu', 204, NULL, '心肌细胞分化', '心肌细胞分化', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (503, 'ssVtu', 204, NULL, '肝脏细胞分化', '肝脏细胞分化', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (504, 'ssVtu', 208, NULL, 'iPSCs细胞系制备', 'iPSCs细胞系制备', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (506, 'ssVtu', 215, NULL, '企业', '企业', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (507, 'ssVtu', 215, NULL, '医院', '医院', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (508, 'ssVtu', 215, NULL, '科研机构', '科研机构', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (509, 'ssVtu', 215, NULL, '学校', '学校', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (510, 'ssVtu', 206, NULL, '顺丰快递', '顺丰快递', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (511, 'ssVtu', 206, NULL, '圆通快递', '圆通快递', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (512, 'ssVtu', 206, NULL, '中通快递', '中通快递', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (513, 'ssVtu', 206, NULL, 'EMS', 'EMS', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (514, 'ssVtu', 206, NULL, '申通快递', '申通快递', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (515, 'ssVtu', 206, NULL, '冷链公司-上海百奥泉', '冷链公司-上海百奥泉', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (516, 'ssVtu', 206, NULL, '韵达快递', '韵达快递', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (517, 'ssVtu', 206, NULL, '其他', '其他', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (518, 'ssVtu', 199, NULL, '支', '支', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (519, 'ssVtu', 210, NULL, '洗衣机', '洗衣机', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (520, 'ssVtu', 210, NULL, '水浴锅', '水浴锅', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (521, 'ssVtu', 210, NULL, '微波炉', '微波炉', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- 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);
- INSERT INTO `base_itemdetails` VALUES (523, 'ssVtu', 210, NULL, 'PH计', 'PH计', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (524, 'ssVtu', 210, NULL, '纯净水仪', '纯净水仪', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (525, 'ssVtu', 210, NULL, '电子天平', '电子天平', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- 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);
- INSERT INTO `base_itemdetails` VALUES (527, 'ssVtu', 210, NULL, '摇床', '摇床', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (528, 'ssVtu', 210, NULL, '电泳设备', '电泳设备', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (529, 'ssVtu', 210, NULL, '制冰机', '制冰机', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (530, 'ssVtu', 210, NULL, '旋涡混合仪', '旋涡混合仪', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (531, 'ssVtu', 210, NULL, '磁力搅拌器', '磁力搅拌器', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (532, 'ssVtu', 210, NULL, '电转染仪', '电转染仪', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (533, 'ssVtu', 210, NULL, '尘埃粒子计数器', '尘埃粒子计数器', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (534, 'ssVtu', 212, NULL, '英潍捷基', '英潍捷基', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (535, 'ssVtu', 212, NULL, 'CST', 'CST', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (536, 'ssVtu', 213, NULL, 'CST', 'CST', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- 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);
- 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);
- INSERT INTO `base_itemdetails` VALUES (539, 'ssVtu', 212, NULL, 'Abcam', 'Abcam', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (540, 'ssVtu', 213, NULL, 'Abcam', 'Abcam', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (541, 'ssVtu', 212, NULL, 'SMOBio', 'SMOBio', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (542, 'ssVtu', 213, NULL, 'SMOBio', 'SMOBio', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (543, 'ssVtu', 211, NULL, 'RXN', 'RXN', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (544, 'ssVtu', 211, NULL, 'tst', 'tst', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (545, 'ssVtu', 212, NULL, 'Lonza', 'Lonza', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (546, 'ssVtu', 213, NULL, 'Lonza', 'Lonza', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (547, 'ssVtu', 211, NULL, '桶', '桶', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (548, 'ssVtu', 212, NULL, 'Stemcell', 'Stemcell', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (549, 'ssVtu', 213, NULL, 'Stemcell', 'Stemcell', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (550, 'ssVtu', 213, NULL, 'Axygene', 'Axygene', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (551, 'ssVtu', 213, NULL, 'Corning', 'Corning', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (552, 'ssVtu', 213, NULL, 'Biosharp', 'Biosharp', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (553, 'ssVtu', 212, NULL, 'Axygene', 'Axygene', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (554, 'ssVtu', 212, NULL, 'Corning', 'Corning', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (555, 'ssVtu', 212, NULL, 'Biosharp', 'Biosharp', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (556, 'ssVtu', 212, NULL, 'Falcon', 'Falcon', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (557, 'ssVtu', 213, NULL, 'Falcon', 'Falcon', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (558, 'ssVtu', 210, NULL, '凝胶成像设备', '凝胶成像设备', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (567, '', 210, NULL, '液氮存储罐', '液氮存储罐', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (568, '', 210, NULL, '提取设备', '自动化核酸提取仪', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (569, '', 210, NULL, '分析设备', '生物分析仪', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (570, '', 210, NULL, '分离设备', '台式低速离心机', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (571, '', 210, NULL, '分离设备1', '高速冷冻离心机', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (572, '', 210, NULL, '显微镜', '倒置显微镜', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (573, '', 210, NULL, '细胞计数仪', '细胞计数仪', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (574, '', 210, NULL, '生物安全柜', '生物安全柜', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (575, '', 210, NULL, ' 消毒设备', '立式压力灭菌器', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (576, '', 210, NULL, ' 培养箱', '二氧化碳培养箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (577, '', 210, NULL, ' 培养箱1', '生化培养箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (578, '', 210, NULL, '干燥箱', '鼓风干燥箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (579, '', 210, NULL, '恒温水浴箱', '恒温水浴箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (580, '', 210, NULL, '移液器', '电动移液器', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (581, '', 210, NULL, '移液器1', '手动移液器', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (582, '', 210, NULL, '医用热合机', '医用热合机', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (583, '', 210, NULL, '分装设备', '低温分装平台', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (584, '', 210, NULL, '分装设备1', '低温分装平台-小容量', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (585, '', 210, NULL, '纯水仪', '纯水仪', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (586, '', 210, NULL, '纯水系统', '实验室超纯水系统', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (587, '', 210, NULL, '冰箱', '4℃冰箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (588, '', 210, NULL, '冰箱1', '-40℃冰箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (589, '', 210, NULL, '制冰机', '制冰机', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (590, '', 210, NULL, '4度冷柜', '4度冷柜', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (591, '', 210, NULL, '洗衣机', '洗衣机', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (592, '', 210, NULL, '家用冰箱', '家用冰箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (593, '', 210, NULL, '办公设备', '激光打印机', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (594, '', 210, NULL, '扫描设备', '整盘扫描仪', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (595, '', 210, NULL, '暂存冰箱', '4℃暂存冰箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (596, '', 210, NULL, '程序降温仪', '程序降温仪', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (597, '', 210, NULL, '低温操作台', '2-8℃低温操作台', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (598, '', 210, NULL, '整理冰箱', '零下40℃超低温冰箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (599, '', 210, NULL, '液氮存储罐1', '便携式液氮罐', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (603, '', 199, NULL, '支', '支', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (604, '', 209, NULL, '健康', '健康', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (605, '', 211, NULL, '瓶', '瓶', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (611, '', 215, NULL, '个人', '个人', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (612, '', 215, NULL, '科研机构', '科研机构', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (613, '', 215, NULL, '医院', '医院', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (614, '', 215, NULL, '企业', '企业', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (616, '', 211, NULL, 'uL', 'uL', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (617, '', 208, NULL, '脐带血干细胞', '脐带血干细胞', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (618, '', 204, NULL, '脐带血干细胞', '脐带血干细胞', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (619, 'ssVtu', 209, NULL, '脂肪肝', '脂肪肝', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (620, 'ssVtu', 209, NULL, '肝硬化', '肝硬化', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (621, '', 199, NULL, '10^6', '10^6', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (622, 'sOcmO', 204, NULL, '脐带血干细胞', '脐带血干细胞', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (623, 'sOcmO', 204, NULL, '细胞制备', '细胞制备', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (624, 'sOcmO', 206, NULL, '顺丰', '顺丰', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (625, 'sOcmO', 206, NULL, '韵达', '韵达', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (626, 'sOcmO', 208, NULL, '脐带血干细胞', '脐带血干细胞', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (627, 'sOcmO', 208, NULL, '细胞制备', '细胞制备', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (628, 'sOcmO', 199, NULL, '毫克', 'mg', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (629, 'sOcmO', 199, NULL, '毫升', 'ml', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (630, 'sOcmO', 199, NULL, '支', '支', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- 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);
- INSERT INTO `base_itemdetails` VALUES (632, 'sOcmO', 209, NULL, '高血压', '高血压', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (633, 'sOcmO', 209, NULL, '乙肝', '乙肝', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (634, 'sOcmO', 209, NULL, '健康', '健康', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (635, 'sOcmO', 210, NULL, '液氮存储罐1', '便携式液氮罐', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (636, 'sOcmO', 210, NULL, '整理冰箱', '零下40℃超低温冰箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (637, 'sOcmO', 210, NULL, '低温操作台', '2-8℃低温操作台', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (638, 'sOcmO', 210, NULL, '程序降温仪', '程序降温仪', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (639, 'sOcmO', 210, NULL, '暂存冰箱', '4℃暂存冰箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (640, 'sOcmO', 210, NULL, '扫描设备', '整盘扫描仪', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (641, 'sOcmO', 210, NULL, '办公设备', '激光打印机', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (642, 'sOcmO', 210, NULL, '家用冰箱', '家用冰箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (643, 'sOcmO', 210, NULL, '洗衣机', '洗衣机', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (644, 'sOcmO', 210, NULL, '4度冷柜', '4度冷柜', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (645, 'sOcmO', 210, NULL, '制冰机', '制冰机', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (646, 'sOcmO', 210, NULL, '冰箱1', '-40℃冰箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (647, 'sOcmO', 210, NULL, '冰箱', '4℃冰箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (648, 'sOcmO', 210, NULL, '纯水系统', '实验室超纯水系统', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (649, 'sOcmO', 210, NULL, '纯水仪', '纯水仪', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (650, 'sOcmO', 210, NULL, '分装设备1', '低温分装平台-小容量', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (651, 'sOcmO', 210, NULL, '分装设备', '低温分装平台', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (652, 'sOcmO', 210, NULL, '医用热合机', '医用热合机', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (653, 'sOcmO', 210, NULL, '移液器1', '手动移液器', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (654, 'sOcmO', 210, NULL, '移液器', '电动移液器', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (655, 'sOcmO', 210, NULL, '恒温水浴箱', '恒温水浴箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (656, 'sOcmO', 210, NULL, '干燥箱', '鼓风干燥箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (657, 'sOcmO', 210, NULL, '培养箱1', '生化培养箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (658, 'sOcmO', 210, NULL, '培养箱', '二氧化碳培养箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (659, 'sOcmO', 210, NULL, '消毒设备', '立式压力灭菌器', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (660, 'sOcmO', 210, NULL, '生物安全柜', '生物安全柜', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (661, 'sOcmO', 210, NULL, '细胞计数仪', '细胞计数仪', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (662, 'sOcmO', 210, NULL, '显微镜', '倒置显微镜', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (663, 'sOcmO', 210, NULL, '分离设备1', '高速冷冻离心机', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (664, 'sOcmO', 210, NULL, '分离设备', '台式低速离心机', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (665, 'sOcmO', 210, NULL, '分析设备', '生物分析仪', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (666, 'sOcmO', 210, NULL, '提取设备', '自动化核酸提取仪', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (667, 'sOcmO', 210, NULL, '液氮存储罐', '液氮存储罐', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (668, 'sOcmO', 211, NULL, 'uL', 'uL', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (669, 'sOcmO', 211, NULL, '瓶', '瓶', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (670, 'sOcmO', 211, NULL, '箱', '箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (671, 'sOcmO', 211, NULL, '盒', '盒', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (672, 'sOcmO', 211, NULL, '个', '个', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (673, 'sOcmO', 211, NULL, '袋', '袋', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (674, 'sOcmO', 211, NULL, '支', '支', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (675, 'sOcmO', 212, NULL, 'Thermo', 'Thermo', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (676, 'sOcmO', 212, NULL, 'Meck', 'Meck', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (677, 'sOcmO', 213, NULL, 'Nunc', 'Nunc', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (678, 'sOcmO', 213, NULL, 'Invitrogen', 'Invitrogen', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (679, 'sOcmO', 213, NULL, 'Hyclone', 'Hyclone', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (680, 'sOcmO', 213, NULL, 'Gibco', 'Gibco', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (681, 'sOcmO', 213, NULL, '美菱', '美菱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (687, 'sOcmO', 215, NULL, '高校', '高校', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (688, 'sOcmO', 215, NULL, '企业', '企业', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (689, 'sOcmO', 215, NULL, '医院', '医院', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (690, 'sOcmO', 215, NULL, '科研机构', '科研机构', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (691, 'sOcmO', 215, NULL, '个人', '个人', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (692, 'sOcmO', 216, NULL, '样本异常', '样本异常', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (693, 'sOcmO', 218, NULL, '实验正常', '实验结果正常,无异常现象', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (694, 'sOcmO', 218, NULL, '实验异常', '实验结果异常,存在异常数据', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (695, 'sOcmO', 219, NULL, '审核不通过', '数据、操作存在异常,审核不通过', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (696, 'sOcmO', 219, NULL, '审核通过', '数据、操作正常,无异常数据,审核通过', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (697, 's6FgC', 204, NULL, '细胞制备', '细胞制备', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (698, 's6FgC', 204, NULL, '脐带血干细胞提取', '脐带血干细胞提取', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (699, 's6FgC', 206, NULL, '顺丰', '顺丰', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (700, 's6FgC', 206, NULL, '韵达', '韵达', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (701, 's6FgC', 208, NULL, '脐带血干细胞提取', '脐带血干细胞提取', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (702, 's6FgC', 208, NULL, '细胞制备', '细胞制备', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- 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);
- INSERT INTO `base_itemdetails` VALUES (704, 's6FgC', 209, NULL, '健康', '健康', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (705, 's6FgC', 209, NULL, '高血压', '高血压', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (706, 's6FgC', 209, NULL, '乙肝', '乙肝', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (707, 's6FgC', 210, NULL, '液氮存储罐1', '液氮存储罐', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (708, 's6FgC', 210, NULL, '整理冰箱', '零下40℃超低温冰箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (709, 's6FgC', 210, NULL, '低温操作台', '2-8℃低温操作台', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (710, 's6FgC', 210, NULL, '程序降温仪', '程序降温仪', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (711, 's6FgC', 210, NULL, '暂存冰箱', '4℃暂存冰箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (712, 's6FgC', 210, NULL, '扫描设备', '整盘扫描仪', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (713, 's6FgC', 210, NULL, '办公设备', '激光打印机', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (714, 's6FgC', 210, NULL, '家用冰箱', '家用冰箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (715, 's6FgC', 210, NULL, '洗衣机', '洗衣机', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (716, 's6FgC', 210, NULL, '4度冷柜', '4度冷柜', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (717, 's6FgC', 210, NULL, '制冰机', '制冰机', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (718, 's6FgC', 210, NULL, '冰箱1', '-40℃冰箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (719, 's6FgC', 210, NULL, '冰箱', '4℃冰箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (720, 's6FgC', 210, NULL, '纯水系统', '实验室超纯水系统', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (721, 's6FgC', 210, NULL, '纯水仪', '纯水仪', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (722, 's6FgC', 210, NULL, '分装设备1', '低温分装平台-小容量', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (723, 's6FgC', 210, NULL, '分装设备', '低温分装平台', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (724, 's6FgC', 210, NULL, '医用热合机', '医用热合机', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (725, 's6FgC', 210, NULL, '移液器1', '手动移液器', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (726, 's6FgC', 210, NULL, '移液器', '电动移液器', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (727, 's6FgC', 210, NULL, '恒温水浴箱', '恒温水浴箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (728, 's6FgC', 210, NULL, '干燥箱', '鼓风干燥箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (729, 's6FgC', 210, NULL, '培养箱1', '生化培养箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (730, 's6FgC', 210, NULL, '培养箱', '二氧化碳培养箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (731, 's6FgC', 210, NULL, '消毒设备', '立式压力灭菌器', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (732, 's6FgC', 210, NULL, '生物安全柜', '生物安全柜', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (733, 's6FgC', 210, NULL, '细胞计数仪', '细胞计数仪', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (734, 's6FgC', 210, NULL, '显微镜', '倒置显微镜', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (735, 's6FgC', 210, NULL, '分离设备1', '高速冷冻离心机', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (736, 's6FgC', 210, NULL, '分离设备', '台式低速离心机', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (737, 's6FgC', 210, NULL, '分析设备', '生物分析仪', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (738, 's6FgC', 210, NULL, '提取设备', '自动化核酸提取仪', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (739, 's6FgC', 211, NULL, 'uL', 'uL', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (740, 's6FgC', 211, NULL, '瓶', '瓶', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (741, 's6FgC', 211, NULL, '箱', '箱', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (742, 's6FgC', 211, NULL, '盒', '盒', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (743, 's6FgC', 211, NULL, '个', '个', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (744, 's6FgC', 211, NULL, '袋', '袋', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (745, 's6FgC', 211, NULL, '支', '支', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (746, 's6FgC', 212, NULL, 'Thermo', 'Thermo', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (747, 's6FgC', 212, NULL, 'Meck', 'Meck', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (748, 's6FgC', 213, NULL, 'Nunc', 'Nunc', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (749, 's6FgC', 213, NULL, 'Invitrogen', 'Invitrogen', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (750, 's6FgC', 213, NULL, 'Hyclone', 'Hyclone', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (751, 's6FgC', 213, NULL, 'Gibco', 'Gibco', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (757, '', 215, NULL, '高校', '高校', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (762, 's6FgC', 216, NULL, '样本异常', '样本异常', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (763, 's6FgC', 218, NULL, '实验正常', '实验结果正常,无异常现象', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (764, 's6FgC', 218, NULL, '实验异常', ' 实验结果异常,存在异常数据', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (765, 's6FgC', 219, NULL, '审核不通过', '数据、操作存在异常,审核不通过', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (766, 's6FgC', 219, NULL, '审核通过', '数据、操作正常,无异常数据,审核通过', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (767, '', 204, NULL, '免疫细胞保存', '免疫细胞保存', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (768, '', 204, NULL, '自体NK细胞治疗', '自体NK细胞治疗', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (769, '', 204, NULL, '活细胞青春术', '活细胞青春术', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (770, 'ssVtu', 209, NULL, '遗传性扩张性毛细血管扩张', '遗传性扩张性毛细血管扩张', 1, 1, 1, NULL, '', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (777, '', 225, NULL, '开始制备', '1', 1, 1, 1, NULL, NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (779, '', 225, NULL, '选择样本', '2', 1, 1, 1, NULL, NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (781, '', 225, NULL, '样本采集', '6', 1, 1, 1, NULL, NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- 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);
- INSERT INTO `base_itemdetails` VALUES (785, '', 225, NULL, '样本存储', '3', 1, 1, 1, NULL, NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (787, '', 225, NULL, '传代', '4', 1, 1, 1, NULL, NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (789, '', 225, NULL, '记录制备进度', '5', 1, 1, 1, NULL, NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (791, '', 225, NULL, '检测', '7', 1, 1, 1, NULL, NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- 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);
- INSERT INTO `base_itemdetails` VALUES (795, '', 225, NULL, '制备完成', '14', 1, 1, 1, NULL, NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- 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);
- INSERT INTO `base_itemdetails` VALUES (799, '', 225, NULL, '成品入库', '16', 1, 1, 1, NULL, NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (803, '', 225, NULL, '样本交接', '20', 1, 1, 1, NULL, NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (805, ' ', 225, NULL, '提取', '21', 1, 1, 1, NULL, NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- INSERT INTO `base_itemdetails` VALUES (809, ' ', 199, NULL, '厘米', 'cm', 1, 1, 1, NULL, NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
- 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);
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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);
- 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);
- 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);
- 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);
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- -- ----------------------------
- -- Table structure for base_items
- -- ----------------------------
- DROP TABLE IF EXISTS `base_items`;
- CREATE TABLE `base_items` (
- `Id` int(10) NOT NULL AUTO_INCREMENT,
- `ParentId` int(10) NULL DEFAULT NULL,
- `Code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `FullName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `TargetTable` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `IsTree` int(10) NOT NULL COMMENT '0:普通结构,1:树型结构',
- `UseItemCode` int(10) NULL DEFAULT NULL,
- `UseItemName` int(10) NULL DEFAULT NULL,
- `UseItemValue` int(10) NULL DEFAULT NULL,
- `Enabled` int(10) NOT NULL,
- `AllowEdit` int(10) NOT NULL,
- `AllowDelete` int(10) NOT NULL,
- `DeletionStateCode` int(10) NOT NULL DEFAULT 0,
- `SortCode` int(10) NULL DEFAULT NULL,
- `Description` varchar(800) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `CreateOn` datetime(0) NULL DEFAULT NULL,
- `CreateUserId` int(11) NULL DEFAULT NULL,
- `CreateBy` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `ModifiedOn` datetime(0) NULL DEFAULT NULL,
- `ModifiedUserId` int(11) NULL DEFAULT NULL,
- `ModifiedBy` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- PRIMARY KEY (`Id`) USING BTREE
- ) ENGINE = InnoDB AUTO_INCREMENT = 256 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
- -- ----------------------------
- -- Records of base_items
- -- ----------------------------
- 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, '');
- 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, '');
- 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, '');
- 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);
- 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);
- 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);
- 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, '');
- 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, '');
- 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, '');
- 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, '');
- 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, '');
- 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, '');
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- -- ----------------------------
- -- Table structure for base_menu
- -- ----------------------------
- DROP TABLE IF EXISTS `base_menu`;
- CREATE TABLE `base_menu` (
- `Id` int(11) NOT NULL AUTO_INCREMENT,
- `Title` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
- `ParentId` int(11) NULL DEFAULT NULL,
- `Paths` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '路径索引',
- `Url` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '访问路径',
- `Action` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '无' COMMENT '请求方式',
- `Permission` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '权限编码',
- `MenuType` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '菜单类型 D目录 M菜单 F按钮或功能 I接口',
- `RouteName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '路由名称',
- `Icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '图标',
- `Component` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
- `Sort` int(4) NULL DEFAULT 1 COMMENT '排序',
- `Visible` int(4) NOT NULL DEFAULT 1 COMMENT '是否显示 1 显示',
- PRIMARY KEY (`Id`) USING BTREE
- ) ENGINE = InnoDB AUTO_INCREMENT = 56 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '菜单表' ROW_FORMAT = Dynamic;
- -- ----------------------------
- -- Records of base_menu
- -- ----------------------------
- INSERT INTO `base_menu` VALUES (22, '系统设置', 0, '22', '', '', '', 'D', '', 'gear', '', 11, 1);
- INSERT INTO `base_menu` VALUES (23, '账号管理', 50, '50/23', '/sysadmin/user', '', '', 'M', '', 'user', '', 8, 1);
- INSERT INTO `base_menu` VALUES (24, '部门管理', 50, '50/24', '/sysadmin/organize', '', '', 'M', '', 'sitemap', '', 9, 1);
- INSERT INTO `base_menu` VALUES (25, '角色管理', 50, '50/25', '/sysadmin/role', '', '', 'M', '', 'vcard-o', '', 3, 1);
- INSERT INTO `base_menu` VALUES (26, '菜单管理', 22, '22/26', '/sysadmin/menu', '', '', 'M', '', 'book', '', 4, 1);
- INSERT INTO `base_menu` VALUES (36, '字典分类', 22, '22/36', '/sysadmin/item', '', 'item', 'D', '', 'book', '', 11, 1);
- INSERT INTO `base_menu` VALUES (39, '实验室管理', 0, '39', '/managingrooms', '无', 'managingrooms', 'M', '', 'book', '', 6, 1);
- INSERT INTO `base_menu` VALUES (41, '班级管理', 0, '41', '/class', '', 'class', 'D', '', 'university', '', 5, 1);
- INSERT INTO `base_menu` VALUES (42, '信息公告发布', 0, '42', '/information', '', 'information', 'M', 'information', 'file', '', 7, 1);
- INSERT INTO `base_menu` VALUES (43, '设备管理', 0, '43', '', '无', '', 'D', '', 'gears', '', 8, 1);
- INSERT INTO `base_menu` VALUES (45, '设备管理', 43, '43/45', '/instrument', '', '', 'M', '', 'get-pocket', '', 1, 1);
- INSERT INTO `base_menu` VALUES (47, '值班管理', 0, '47', '/duty', '', 'duty', 'D', '', 'address-card', '', 3, 1);
- INSERT INTO `base_menu` VALUES (48, '维护保养', 43, '43/48', '/instrument/maintainlog', '', '', 'M', '', 'sitemap', '', 1, 1);
- INSERT INTO `base_menu` VALUES (49, '确认及报废', 43, '43/49', '/instrument/confirmandscrap', '', '', 'M', '', 'film', '', 1, 1);
- INSERT INTO `base_menu` VALUES (50, '组织管理', 0, '50', '', '无', '', 'D', '', 'address-card', '', 10, 1);
- INSERT INTO `base_menu` VALUES (51, '课程管理', 0, '51', '/course', '', 'course', 'D', '', 'book', '', 4, 1);
- INSERT INTO `base_menu` VALUES (52, '值班人员', 0, '52', '/personnel', '无', 'personnel', 'M', 'personnel', 'book', '', 5, 1);
- INSERT INTO `base_menu` VALUES (53, '平台首页', 0, '53', '/index', '', 'index', 'D', '', 'home', '', 1, 1);
- -- ----------------------------
- -- Table structure for base_operationlog
- -- ----------------------------
- DROP TABLE IF EXISTS `base_operationlog`;
- CREATE TABLE `base_operationlog` (
- `Id` bigint(20) NOT NULL AUTO_INCREMENT,
- `AccCode` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '账户',
- `OpTage` int(11) NOT NULL COMMENT '1 修改 2删除',
- `TableName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `TableDesc` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `RecordId` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `RecordData` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `Createon` datetime(0) NULL DEFAULT NULL,
- `Createuserid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `Createby` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `OpDesc` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作描述',
- `Remark` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
- PRIMARY KEY (`Id`) USING BTREE
- ) ENGINE = InnoDB AUTO_INCREMENT = 31780 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '操作日志' ROW_FORMAT = DYNAMIC;
- -- ----------------------------
- -- Records of base_operationlog
- -- ----------------------------
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- -- ----------------------------
- -- Table structure for base_organize
- -- ----------------------------
- DROP TABLE IF EXISTS `base_organize`;
- CREATE TABLE `base_organize` (
- `Id` int(10) NOT NULL AUTO_INCREMENT,
- `AccCode` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `ParentId` int(10) NULL DEFAULT NULL COMMENT '上级组织id',
- `Paths` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '路径索引',
- `Code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `FullName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
- `ShortName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '简称',
- `Category` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '分类',
- `OuterPhone` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '外部电话',
- `InnerPhone` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '内部电话',
- `Fax` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '传真',
- `Postalcode` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮政编码',
- `Address` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '地址',
- `Web` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `Bank` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `BankAccount` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `Manager` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `Layer` int(10) NULL DEFAULT NULL,
- `AssistantManager` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `IsInnerOrganize` int(10) NOT NULL DEFAULT 1 COMMENT '是否时内部组织',
- `SortCode` int(10) NULL DEFAULT NULL COMMENT '排序码',
- `Description` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `DeletionStateCode` int(10) NULL DEFAULT 0 COMMENT '删除状态码,未删除:0,已删除:1',
- `Enabled` int(10) NOT NULL DEFAULT 1,
- `CreateOn` datetime(0) NULL DEFAULT NULL,
- `CreateUserId` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `CreateBy` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `ModifiedOn` datetime(0) NULL DEFAULT NULL,
- `ModifiedUserId` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `ModifiedBy` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- PRIMARY KEY (`Id`) USING BTREE
- ) ENGINE = InnoDB AUTO_INCREMENT = 31 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
- -- ----------------------------
- -- Records of base_organize
- -- ----------------------------
- -- ----------------------------
- -- Table structure for base_parameter
- -- ----------------------------
- DROP TABLE IF EXISTS `base_parameter`;
- CREATE TABLE `base_parameter` (
- `ID` int(10) NOT NULL AUTO_INCREMENT,
- `CategoryID` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `ParameterID` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `ParameterCode` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `ParameterContent` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `Worked` int(11) NOT NULL DEFAULT 0,
- `Enabled` int(11) NOT NULL DEFAULT 0,
- `DeletionStateCode` int(11) NULL DEFAULT NULL,
- `SortCode` int(11) NULL DEFAULT NULL,
- `Description` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `CreateOn` datetime(0) NULL DEFAULT NULL,
- `CreateUserId` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `CreateBy` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `ModifiedOn` datetime(0) NULL DEFAULT NULL,
- `ModifiedUserId` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `ModifiedBy` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- PRIMARY KEY (`ID`) USING BTREE
- ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
- -- ----------------------------
- -- Records of base_parameter
- -- ----------------------------
- -- ----------------------------
- -- Table structure for base_role
- -- ----------------------------
- DROP TABLE IF EXISTS `base_role`;
- CREATE TABLE `base_role` (
- `Id` int(10) NOT NULL AUTO_INCREMENT,
- `AccCode` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `SystemId` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `OrganizeId` int(10) NULL DEFAULT NULL,
- `Code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `Realname` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `Category` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `AllowEdit` int(10) NOT NULL DEFAULT 1,
- `DataScope` int(10) NOT NULL DEFAULT 1 COMMENT '数据集合权限 1:仅本人;2:本部门;3:本部门及以下;4:自定义;5:全部',
- `AllowDelete` int(10) NOT NULL DEFAULT 1,
- `SortCode` int(10) NULL DEFAULT 0,
- `DeletionStateCode` int(10) NOT NULL DEFAULT 0,
- `Enabled` int(10) NOT NULL DEFAULT 1,
- `IsVisible` int(10) NOT NULL DEFAULT 1 COMMENT '1显示',
- `Description` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `CreateOn` datetime(0) NULL DEFAULT NULL,
- `CreateUserId` int(11) NULL DEFAULT NULL,
- `CreateBy` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `ModifiedOn` datetime(0) NULL DEFAULT NULL,
- `ModifiedUserId` int(11) NULL DEFAULT NULL,
- `ModifiedBy` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- PRIMARY KEY (`Id`) USING BTREE
- ) ENGINE = InnoDB AUTO_INCREMENT = 27 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
- -- ----------------------------
- -- Records of base_role
- -- ----------------------------
- 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, '系统管理员');
- 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');
- 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, '系统管理员');
- -- ----------------------------
- -- Table structure for base_role_datascope
- -- ----------------------------
- DROP TABLE IF EXISTS `base_role_datascope`;
- CREATE TABLE `base_role_datascope` (
- `Id` int(11) NOT NULL AUTO_INCREMENT,
- `RoleId` int(11) NOT NULL COMMENT '角色ID',
- `DataIds` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '数据ID',
- `DataType` int(11) NOT NULL DEFAULT 1 COMMENT '集合类型,1:组织结构,2:人员,3:地区',
- PRIMARY KEY (`Id`) USING BTREE
- ) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '数据集合权限表' ROW_FORMAT = Dynamic;
- -- ----------------------------
- -- Records of base_role_datascope
- -- ----------------------------
- INSERT INTO `base_role_datascope` VALUES (13, 1, '2,4', 1);
- INSERT INTO `base_role_datascope` VALUES (14, 24, '2,4', 1);
- -- ----------------------------
- -- Table structure for base_role_menu
- -- ----------------------------
- DROP TABLE IF EXISTS `base_role_menu`;
- CREATE TABLE `base_role_menu` (
- `Id` int(11) NOT NULL AUTO_INCREMENT,
- `RoleId` int(11) NULL DEFAULT NULL COMMENT '角色id',
- `MenuIds` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '权限id',
- PRIMARY KEY (`Id`) USING BTREE
- ) ENGINE = InnoDB AUTO_INCREMENT = 27 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
- -- ----------------------------
- -- Records of base_role_menu
- -- ----------------------------
- 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');
- INSERT INTO `base_role_menu` VALUES (24, 24, '22,23,24,25,26,32,36,37,38');
- 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');
- -- ----------------------------
- -- Table structure for base_updated
- -- ----------------------------
- DROP TABLE IF EXISTS `base_updated`;
- CREATE TABLE `base_updated` (
- `Id` bigint(20) NOT NULL AUTO_INCREMENT,
- `TableName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `RecordId` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `RecordData` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
- `Createon` datetime(0) NULL DEFAULT NULL,
- `Createuserid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `Createby` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- PRIMARY KEY (`Id`) USING BTREE
- ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
- -- ----------------------------
- -- Records of base_updated
- -- ----------------------------
- -- ----------------------------
- -- Table structure for base_user
- -- ----------------------------
- DROP TABLE IF EXISTS `base_user`;
- CREATE TABLE `base_user` (
- `Id` int(10) NOT NULL AUTO_INCREMENT,
- `Uuid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户Id标识,不易猜出',
- `AccCode` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '区分不同App的用户',
- `Code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '编码',
- `UserName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户登录名',
- `Realname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户名',
- `RoleId` int(10) NULL DEFAULT NULL COMMENT '角色id',
- `SecurityLevel` int(10) NULL DEFAULT NULL,
- `UserFrom` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `CompanyId` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '公司id',
- `CompanyName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '公司名称',
- `DepartmentId` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '部门id ',
- `DepartmentName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '部门名称',
- `WorkgroupId` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '工作组id',
- `WorkgroupName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '工作组名称',
- `WorkCategory` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `Duty` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '职务',
- `Title` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '头衔',
- `Gender` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '性别',
- `Birthday` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `Mobile` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `Telephone` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `Email` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `OICQ` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `HomeAddress` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `UserPassword` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `ChangePasswordDate` datetime(0) NULL DEFAULT NULL COMMENT '改密码时间',
- `CommunicationPassword` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `PublicKey` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `SignedPassword` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `Lang` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `Theme` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `AllowStartTime` datetime(0) NULL DEFAULT NULL,
- `AllowEndTime` datetime(0) NULL DEFAULT NULL,
- `LockStartDate` datetime(0) NULL DEFAULT NULL,
- `LockEndDate` datetime(0) NULL DEFAULT NULL,
- `FirstVisit` datetime(0) NULL DEFAULT NULL,
- `PreviousVisit` datetime(0) NULL DEFAULT NULL,
- `LastVisit` datetime(0) NULL DEFAULT NULL,
- `LogOnCount` int(10) NOT NULL DEFAULT 0,
- `IsStaff` int(10) NOT NULL DEFAULT 1,
- `UserOnLine` int(10) NOT NULL DEFAULT 1,
- `IsVisible` int(10) NOT NULL DEFAULT 1 COMMENT '是否可视,1为可视 ',
- `OpenId` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `IPAddress` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `MACAddress` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `Question` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `AnswerQuestion` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `UserAddressId` int(10) NULL DEFAULT NULL,
- `Enabled` int(10) NOT NULL DEFAULT 1 COMMENT '是否可用',
- `AuditStatus` int(50) NULL DEFAULT NULL COMMENT '激活状态(1激活)',
- `DeletionStateCode` int(10) NOT NULL DEFAULT 0 COMMENT '删除状态',
- `SortCode` int(10) NULL DEFAULT NULL,
- `Description` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `CreateOn` datetime(0) NULL DEFAULT NULL,
- `CreateUserId` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `CreateBy` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `ModifiedOn` datetime(0) NULL DEFAULT NULL,
- `ModifiedUserId` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `ModifiedBy` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `Photo` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `QRCode` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `QRCodeImage` blob NULL,
- `IsCompanyUser` int(11) NULL DEFAULT NULL COMMENT '是否是企业用户(供方字段用)',
- `Superior` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '上级部门',
- `UnitId` int(11) NULL DEFAULT NULL COMMENT '二级单位ID(供方字段用)',
- `Unit` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- PRIMARY KEY (`Id`) USING BTREE
- ) ENGINE = InnoDB AUTO_INCREMENT = 20 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户表' ROW_FORMAT = Dynamic;
- -- ----------------------------
- -- Records of base_user
- -- ----------------------------
- 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, '');
- -- ----------------------------
- -- Table structure for base_user_role
- -- ----------------------------
- DROP TABLE IF EXISTS `base_user_role`;
- CREATE TABLE `base_user_role` (
- `Id` int(11) NOT NULL AUTO_INCREMENT,
- `UserId` int(11) NOT NULL,
- `RoleIds` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
- PRIMARY KEY (`Id`) USING BTREE
- ) ENGINE = InnoDB AUTO_INCREMENT = 19 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
- -- ----------------------------
- -- Records of base_user_role
- -- ----------------------------
- INSERT INTO `base_user_role` VALUES (2, 1, '1,24');
- INSERT INTO `base_user_role` VALUES (3, 3, '23');
- INSERT INTO `base_user_role` VALUES (4, 4, '2,1');
- INSERT INTO `base_user_role` VALUES (5, 7, '1,2,23');
- INSERT INTO `base_user_role` VALUES (6, 8, '1,23,2');
- INSERT INTO `base_user_role` VALUES (7, 0, '1,23');
- INSERT INTO `base_user_role` VALUES (8, 9, '1');
- INSERT INTO `base_user_role` VALUES (9, 10, '1');
- INSERT INTO `base_user_role` VALUES (10, 11, '1');
- INSERT INTO `base_user_role` VALUES (11, 12, '1');
- INSERT INTO `base_user_role` VALUES (12, 13, '1');
- INSERT INTO `base_user_role` VALUES (13, 14, '1');
- INSERT INTO `base_user_role` VALUES (14, 15, '1');
- INSERT INTO `base_user_role` VALUES (15, 16, '1');
- INSERT INTO `base_user_role` VALUES (16, 17, '1');
- INSERT INTO `base_user_role` VALUES (17, 18, '1');
- INSERT INTO `base_user_role` VALUES (18, 19, '1');
- -- ----------------------------
- -- Table structure for base_userequipment
- -- ----------------------------
- DROP TABLE IF EXISTS `base_userequipment`;
- CREATE TABLE `base_userequipment` (
- `Id` int(10) NOT NULL AUTO_INCREMENT,
- `AccCode` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `UserId` int(10) NULL DEFAULT NULL,
- `EquipmentId` int(10) NOT NULL,
- `SortCode` int(10) NULL DEFAULT NULL,
- `Enabled` int(10) NOT NULL DEFAULT 1,
- `DeletionStateCode` int(10) NOT NULL DEFAULT 0,
- `Description` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `CreateOn` datetime(0) NULL DEFAULT NULL,
- `CreateUserId` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `CreateBy` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `ModifiedOn` datetime(0) NULL DEFAULT NULL,
- `ModifiedUserId` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `ModifiedBy` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- PRIMARY KEY (`Id`) USING BTREE
- ) ENGINE = InnoDB AUTO_INCREMENT = 67 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户设备权限' ROW_FORMAT = Dynamic;
- -- ----------------------------
- -- Records of base_userequipment
- -- ----------------------------
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- 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', '');
- -- ----------------------------
- -- Table structure for class
- -- ----------------------------
- DROP TABLE IF EXISTS `class`;
- CREATE TABLE `class` (
- `Id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
- `Year` int(11) NULL DEFAULT NULL COMMENT '年级',
- `Name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '班级名称',
- `CreatedBy` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人',
- `CreatedTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
- `UpdatedBy` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '更新人',
- `UpdatedTime` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
- `IsDel` int(11) NOT NULL COMMENT '删除标志',
- PRIMARY KEY (`Id`) USING BTREE
- ) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '班级表' ROW_FORMAT = Dynamic;
- -- ----------------------------
- -- Records of class
- -- ----------------------------
- INSERT INTO `class` VALUES (11, 2020, '计算机软件一班', '', '2020-12-28 14:26:40', '', '2020-12-28 14:26:40', 0);
- INSERT INTO `class` VALUES (12, 2020, '计算机软件二班', '', '2020-12-28 14:26:47', '', '2020-12-28 14:26:47', 0);
- -- ----------------------------
- -- Table structure for course
- -- ----------------------------
- DROP TABLE IF EXISTS `course`;
- CREATE TABLE `course` (
- `Id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
- `Year` int(11) NULL DEFAULT NULL COMMENT '学年',
- `Term` int(11) NULL DEFAULT NULL COMMENT '学期',
- `ClassId` int(11) NULL DEFAULT NULL COMMENT '班级ID',
- `CourseWeek` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '教学周',
- `Title` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '标题',
- `Status` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '状态',
- `CreatedBy` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人',
- `CreatedTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
- `UpdatedBy` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '更新人',
- `UpdatedTime` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
- `IsDel` int(11) NOT NULL COMMENT '删除标志',
- PRIMARY KEY (`Id`) USING BTREE
- ) ENGINE = InnoDB AUTO_INCREMENT = 30 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '课程表' ROW_FORMAT = Dynamic;
- -- ----------------------------
- -- Records of course
- -- ----------------------------
- 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);
- 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);
- 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);
- -- ----------------------------
- -- Table structure for course_detail
- -- ----------------------------
- DROP TABLE IF EXISTS `course_detail`;
- CREATE TABLE `course_detail` (
- `Id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
- `CourseId` int(11) NULL DEFAULT NULL COMMENT '课程表ID',
- `Year` int(11) NULL DEFAULT NULL COMMENT '学年',
- `Term` int(11) NULL DEFAULT NULL COMMENT '学期',
- `CourseName` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '课程名',
- `Teacher` int(11) NULL DEFAULT NULL COMMENT '授课老师',
- `Local` int(11) NULL DEFAULT NULL COMMENT '实验地点',
- `Class` int(11) NULL DEFAULT NULL COMMENT '授课班级',
- `Mark` decimal(32, 8) NULL DEFAULT NULL COMMENT '学分',
- `Num` int(11) NULL DEFAULT NULL COMMENT '人数',
- `WeekTitle` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '教学周',
- `DayOfWeek` int(11) NULL DEFAULT NULL COMMENT '周次 1-7',
- `Time` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '节次',
- `Status` int(11) NULL DEFAULT NULL COMMENT '状态 发布状态',
- `CreatedBy` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人',
- `CreatedTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
- `UpdatedBy` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '更新人',
- `UpdatedTime` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
- `IsDel` int(11) NOT NULL COMMENT '删除标志',
- PRIMARY KEY (`Id`) USING BTREE
- ) ENGINE = InnoDB AUTO_INCREMENT = 18 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '课程明细表' ROW_FORMAT = Dynamic;
- -- ----------------------------
- -- Records of course_detail
- -- ----------------------------
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- -- ----------------------------
- -- Table structure for duty
- -- ----------------------------
- DROP TABLE IF EXISTS `duty`;
- CREATE TABLE `duty` (
- `Id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
- `Year` int(11) NOT NULL COMMENT '学年',
- `Term` int(11) NOT NULL COMMENT '学期',
- `Title` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '标题',
- `Status` int(11) NOT NULL COMMENT '状态',
- `CreatedBy` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人',
- `CreatedTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
- `UpdatedBy` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '更新人',
- `UpdatedTime` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
- `IsDel` int(11) NOT NULL COMMENT '删除标志',
- PRIMARY KEY (`Id`) USING BTREE
- ) ENGINE = InnoDB AUTO_INCREMENT = 325 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '值班表 ' ROW_FORMAT = Dynamic;
- -- ----------------------------
- -- Records of duty
- -- ----------------------------
- INSERT INTO `duty` VALUES (22, 2020, 1, '计算机楼1-24周值班表1', 1, '', '2020-12-28 14:30:32', '', '2020-12-28 17:31:07', 0);
- INSERT INTO `duty` VALUES (323, 2020, 1, '计算机楼24-54周值班表', 1, '', '2020-12-28 17:44:28', '', '2020-12-28 19:16:32', 0);
- INSERT INTO `duty` VALUES (324, 2020, 1, '第1-21周', 1, '', '2020-12-28 19:20:12', '', '2020-12-28 19:43:45', 0);
- INSERT INTO `duty` VALUES (325, 2020, 2, '12日计划', 1, '', '2020-12-29 15:38:30', '', NULL, 0);
- -- ----------------------------
- -- Table structure for duty_detail
- -- ----------------------------
- DROP TABLE IF EXISTS `duty_detail`;
- CREATE TABLE `duty_detail` (
- `Id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
- `DutyId` int(11) NOT NULL COMMENT '值班ID',
- `Local` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '地点',
- `Time` int(11) NULL DEFAULT NULL COMMENT '时间段',
- `Status` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '状态',
- `People` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '值班人员',
- `Monday` int(11) NULL DEFAULT NULL COMMENT '周一',
- `Tuesday` int(11) NULL DEFAULT NULL COMMENT '周二',
- `Wednesday` int(11) NULL DEFAULT NULL COMMENT '周三',
- `Thursday` int(11) NULL DEFAULT NULL COMMENT '周四',
- `Friday` int(11) NULL DEFAULT NULL COMMENT '周五',
- `Saturday` int(11) NULL DEFAULT NULL COMMENT '周六',
- `Sunday` int(11) NULL DEFAULT NULL COMMENT '周天',
- `CreatedBy` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人',
- `CreatedTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
- `UpdatedBy` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '更新人',
- `UpdatedTime` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
- `IsDel` int(11) NOT NULL COMMENT '删除标志',
- PRIMARY KEY (`Id`) USING BTREE
- ) ENGINE = InnoDB AUTO_INCREMENT = 179 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '值班详情表' ROW_FORMAT = Dynamic;
- -- ----------------------------
- -- Records of duty_detail
- -- ----------------------------
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- INSERT INTO `duty_detail` VALUES (139, 21, '2', 1, '', '', 5, 0, 4, 6, 0, 1, 0, '', '2020-12-28 14:47:03', '', NULL, 0);
- INSERT INTO `duty_detail` VALUES (140, 21, '2', 3, '', '', 0, 5, 4, 5, 0, 1, 5, '', '2020-12-28 14:47:03', '', NULL, 0);
- INSERT INTO `duty_detail` VALUES (141, 21, '2', 4, '', '', 0, 6, 4, 0, 0, 1, 0, '', '2020-12-28 14:47:03', '', NULL, 0);
- INSERT INTO `duty_detail` VALUES (142, 21, '2', 2, '', '', 0, 0, 4, 0, 0, 1, 0, '', '2020-12-28 14:47:03', '', NULL, 0);
- INSERT INTO `duty_detail` VALUES (143, 21, '1', 1, '', '', 0, 0, 4, 0, 5, 1, 0, '', '2020-12-28 14:47:03', '', NULL, 0);
- INSERT INTO `duty_detail` VALUES (144, 21, '1', 3, '', '', 5, 0, 4, 5, 0, 1, 5, '', '2020-12-28 14:47:03', '', NULL, 0);
- INSERT INTO `duty_detail` VALUES (145, 21, '1', 4, '', '', 0, 5, 4, 0, 0, 1, 0, '', '2020-12-28 14:47:03', '', NULL, 0);
- INSERT INTO `duty_detail` VALUES (146, 21, '1', 2, '', '', 0, 0, 4, 6, 0, 1, 0, '', '2020-12-28 14:47:03', '', NULL, 0);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- INSERT INTO `duty_detail` VALUES (153, 20, '2', 1, '', '', 4, 4, 4, 4, 4, 4, 4, '', '2020-12-28 15:09:36', '', NULL, 0);
- INSERT INTO `duty_detail` VALUES (154, 20, '2', 3, '', '', 4, 4, 4, 4, 4, 4, 4, '', '2020-12-28 15:09:36', '', NULL, 0);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- 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);
- INSERT INTO `duty_detail` VALUES (162, 22, '1', 1, '', '', 3, 3, 3, 3, 3, 3, 3, '', '2020-12-28 16:28:32', '', NULL, 0);
- 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);
- INSERT INTO `duty_detail` VALUES (164, 323, '1', 3, '', '', 171, 268, 268, 5, 0, 1, 171, '', '2020-12-28 18:43:04', '', NULL, 0);
- INSERT INTO `duty_detail` VALUES (165, 323, '1', 2, '', '', 171, 171, 171, 171, 5, 264, 171, '', '2020-12-28 18:43:04', '', NULL, 0);
- INSERT INTO `duty_detail` VALUES (166, 323, '1', 4, '', '', 171, 1, 0, 5, 264, 0, 178, '', '2020-12-28 18:43:04', '', NULL, 0);
- INSERT INTO `duty_detail` VALUES (167, 323, '2', 1, '', '', 171, 168, 168, 168, 1, 264, 171, '', '2020-12-28 18:43:04', '', NULL, 0);
- INSERT INTO `duty_detail` VALUES (168, 323, '2', 3, '', '', 171, 5, 0, 0, 264, 5, 171, '', '2020-12-28 18:43:04', '', NULL, 0);
- INSERT INTO `duty_detail` VALUES (169, 323, '2', 2, '', '', 171, 0, 5, 5, 5, 264, 171, '', '2020-12-28 18:43:04', '', NULL, 0);
- INSERT INTO `duty_detail` VALUES (170, 323, '2', 4, '', '', 178, 178, 178, 178, 178, 178, 171, '', '2020-12-28 18:43:04', '', NULL, 0);
- INSERT INTO `duty_detail` VALUES (171, 324, '2', 1, '', '', 168, 0, 0, 0, 0, 0, 0, '', '2020-12-28 19:21:03', '', NULL, 0);
- INSERT INTO `duty_detail` VALUES (172, 324, '2', 3, '', '', 264, 0, 0, 168, 0, 168, 0, '', '2020-12-28 19:21:03', '', NULL, 0);
- INSERT INTO `duty_detail` VALUES (173, 324, '2', 4, '', '', 178, 168, 0, 0, 168, 0, 0, '', '2020-12-28 19:21:03', '', NULL, 0);
- INSERT INTO `duty_detail` VALUES (174, 324, '2', 2, '', '', 264, 178, 0, 264, 0, 0, 0, '', '2020-12-28 19:21:03', '', NULL, 0);
- INSERT INTO `duty_detail` VALUES (175, 324, '1', 1, '', '', 0, 0, 168, 0, 0, 0, 168, '', '2020-12-28 19:21:03', '', NULL, 0);
- INSERT INTO `duty_detail` VALUES (176, 324, '1', 3, '', '', 264, 0, 0, 168, 0, 168, 0, '', '2020-12-28 19:21:03', '', NULL, 0);
- INSERT INTO `duty_detail` VALUES (177, 324, '1', 4, '', '', 0, 0, 0, 264, 168, 0, 0, '', '2020-12-28 19:21:03', '', NULL, 0);
- INSERT INTO `duty_detail` VALUES (178, 324, '1', 2, '', '', 0, 0, 0, 264, 0, 0, 0, '', '2020-12-28 19:21:03', '', NULL, 0);
- INSERT INTO `duty_detail` VALUES (179, 325, '2', 1, '', '', 178, 168, 0, 0, 178, 0, 0, '', '2020-12-29 15:38:51', '', NULL, 0);
- INSERT INTO `duty_detail` VALUES (180, 325, '2', 2, '', '', 178, 0, 178, 168, 178, 0, 0, '', '2020-12-29 15:38:51', '', NULL, 0);
- INSERT INTO `duty_detail` VALUES (181, 325, '2', 3, '', '', 178, 0, 0, 0, 168, 0, 0, '', '2020-12-29 15:38:51', '', NULL, 0);
- INSERT INTO `duty_detail` VALUES (182, 325, '2', 4, '', '', 178, 0, 168, 0, 0, 0, 0, '', '2020-12-29 15:38:51', '', NULL, 0);
- -- ----------------------------
- -- Table structure for information
- -- ----------------------------
- DROP TABLE IF EXISTS `information`;
- CREATE TABLE `information` (
- `Id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
- `Title` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '标题',
- `Content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '内容',
- `Flag` int(11) NULL DEFAULT NULL COMMENT '类别',
- `Status` int(11) NULL DEFAULT NULL COMMENT '状态',
- `CreatedBy` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人',
- `CreatedTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
- `UpdatedBy` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '更新人',
- `UpdatedTime` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
- `IsDel` int(11) NOT NULL COMMENT '删除标志',
- PRIMARY KEY (`Id`) USING BTREE
- ) ENGINE = InnoDB AUTO_INCREMENT = 56 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '信息表' ROW_FORMAT = Dynamic;
- -- ----------------------------
- -- Records of information
- -- ----------------------------
- 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);
- 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);
- INSERT INTO `information` VALUES (55, '321', '321321321', NULL, 1, NULL, '2020-12-28 18:50:07', NULL, '2020-12-28 18:50:20', 1);
- -- ----------------------------
- -- Table structure for instr_room
- -- ----------------------------
- DROP TABLE IF EXISTS `instr_room`;
- CREATE TABLE `instr_room` (
- `Id` int(11) NOT NULL AUTO_INCREMENT COMMENT '房间id',
- `RoomNum` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '房间号',
- `RoomName` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '房间名称',
- `RoomType` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '房间类型',
- `RoomDescribe` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '房间描述',
- `PositionInformation` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '位置信息',
- `CreateOn` datetime(0) NULL DEFAULT NULL,
- `CreateUserId` int(11) NULL DEFAULT NULL,
- `CreateBy` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
- `ModifiedOn` datetime(0) NULL DEFAULT NULL,
- `ModifiedUserId` int(11) NULL DEFAULT NULL,
- `ModifiedBy` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
- `building` int(11) NULL DEFAULT NULL COMMENT '建筑信息',
- PRIMARY KEY (`Id`) USING BTREE
- ) ENGINE = InnoDB AUTO_INCREMENT = 371 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;
- -- ----------------------------
- -- Records of instr_room
- -- ----------------------------
- 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);
- 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);
- 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);
- -- ----------------------------
- -- Table structure for instrumenmaintainlog
- -- ----------------------------
- DROP TABLE IF EXISTS `instrumenmaintainlog`;
- CREATE TABLE `instrumenmaintainlog` (
- `Id` int(10) NOT NULL AUTO_INCREMENT,
- `InstrumenId` int(10) NULL DEFAULT NULL COMMENT '设备Id',
- `InstrumenName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '设备名称',
- `InstrumenCode` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '设备编号',
- `OperaRemark` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '维护说明',
- `OperaTpye` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '维护类型,从字典表下拉,字典项 InstrumenMaintainType',
- `OperaUser` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作人',
- `OperaOn` datetime(0) NULL DEFAULT NULL COMMENT '操作日期',
- `CreateUserId` int(10) NULL DEFAULT NULL,
- `CreateBy` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `CreateOn` datetime(0) NULL DEFAULT NULL,
- `TypeCode` int(4) NULL DEFAULT NULL,
- `ModifiedUserId` int(10) NULL DEFAULT NULL,
- `ModifiedBy` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `ModifiedOn` datetime(0) NULL DEFAULT NULL,
- PRIMARY KEY (`Id`) USING BTREE
- ) ENGINE = InnoDB AUTO_INCREMENT = 137 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '设备维护记录,质量管理' ROW_FORMAT = Dynamic;
- -- ----------------------------
- -- Records of instrumenmaintainlog
- -- ----------------------------
- 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');
- 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');
- 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');
- 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');
- 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');
- -- ----------------------------
- -- Table structure for instrumenrunrecord
- -- ----------------------------
- DROP TABLE IF EXISTS `instrumenrunrecord`;
- CREATE TABLE `instrumenrunrecord` (
- `Id` int(10) NOT NULL AUTO_INCREMENT,
- `InstrumentId` int(10) NULL DEFAULT NULL COMMENT '设备Id',
- `InstrumenName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '设备名称',
- `InstrumenCode` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '设备编号',
- `RecordRemark` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '运行说明',
- `ContractNo` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '合同编号',
- `PrepinfoDetailId` int(10) NULL DEFAULT NULL COMMENT '制备详情Id',
- `CreateUserId` int(10) NULL DEFAULT NULL COMMENT '操作人ID',
- `CreateBy` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作人',
- `CreateOn` datetime(0) NULL DEFAULT NULL COMMENT '操作时间',
- `ModifiedUserId` int(10) NULL DEFAULT NULL,
- `ModifiedBy` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `ModifiedOn` datetime(0) NULL DEFAULT NULL,
- PRIMARY KEY (`Id`) USING BTREE
- ) ENGINE = InnoDB AUTO_INCREMENT = 142 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '设备运行记录' ROW_FORMAT = Dynamic;
- -- ----------------------------
- -- Records of instrumenrunrecord
- -- ----------------------------
- -- ----------------------------
- -- Table structure for instrument
- -- ----------------------------
- DROP TABLE IF EXISTS `instrument`;
- CREATE TABLE `instrument` (
- `Id` int(11) NOT NULL AUTO_INCREMENT,
- `RoomId` int(11) NULL DEFAULT NULL COMMENT '所属房间Id,instr_room.Id',
- `Code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '设备编码',
- `Name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '设备名称',
- `SupplierId` int(11) NULL DEFAULT NULL,
- `Supplier` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '供应商',
- `FactoryNum` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '出厂编号',
- `Model` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '型号',
- `Brand` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '设备品牌',
- `Classification` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '设备大类',
- `State` int(11) NOT NULL DEFAULT 1 COMMENT '设备状态 1正常2异常',
- `Location` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '设备所在位置',
- `Remarks` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
- `IsFixedPoint` int(11) NULL DEFAULT 0 COMMENT '参与点检: 0. 否(默认) 1. 是',
- `CalibrationTime` datetime(0) NULL DEFAULT NULL COMMENT '校准时间',
- `CalibrationDeadline` int(11) NULL DEFAULT NULL COMMENT '校准使用期限',
- `CalibrationDeadlineType` int(11) NULL DEFAULT NULL COMMENT ' 期限类型:1:天 2:周 3:月 4:年 ',
- `MaintenCycle` int(11) NULL DEFAULT NULL COMMENT '维护周期数',
- `CycleType` int(11) NULL DEFAULT NULL COMMENT ' 期限类型:1:天 2:周 3:月 4:年 ',
- `HeartbeatTime` datetime(0) NOT NULL COMMENT '心跳时间 对应上报时间',
- `CreateOn` datetime(0) NOT NULL,
- `CreateUserId` int(11) NULL DEFAULT NULL,
- `CreateBy` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `ModifiedOn` datetime(0) NULL DEFAULT NULL,
- `ModifiedUserId` int(11) NULL DEFAULT NULL,
- `ModifiedBy` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `FileUrl` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作规程文件路径',
- `FileName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文件名',
- `Remark` tinytext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
- `TimeNotification` int(11) NULL DEFAULT NULL COMMENT '有效期提醒',
- `Sharable` tinyint(4) NULL DEFAULT NULL COMMENT '是否共享(可预约)',
- `EndTime` datetime(0) NULL DEFAULT NULL COMMENT '截止日期',
- `Responsible` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '责任人',
- `MaintenTime` date NULL DEFAULT NULL COMMENT '最后维护时间',
- `Purchasedate` datetime(0) NULL DEFAULT NULL COMMENT '采购日期',
- `JoinPlan` tinyint(4) NULL DEFAULT 1 COMMENT '计划: 1参与 0 不参与',
- `Spec` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '规格',
- PRIMARY KEY (`Id`) USING BTREE,
- UNIQUE INDEX `Code`(`Code`) USING BTREE
- ) ENGINE = InnoDB AUTO_INCREMENT = 253 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '设备信息' ROW_FORMAT = DYNAMIC;
- -- ----------------------------
- -- Records of instrument
- -- ----------------------------
- 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, '');
- 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, '');
- -- ----------------------------
- -- Table structure for personnel
- -- ----------------------------
- DROP TABLE IF EXISTS `personnel`;
- CREATE TABLE `personnel` (
- `Id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `PersonnelName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
- `PersonneCode` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '编号',
- `Person` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系人',
- `Telephone` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '电话',
- `Mailbox` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱',
- `CardId` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '身份证号',
- `Address` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '地址',
- `Established` date NULL DEFAULT NULL COMMENT '入职时间',
- `ZipCode` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮编',
- `Website` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '网站地址',
- `DepartmentId` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '组织id',
- `DepartmentName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '组织名称',
- `Type` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '类型',
- `CreateOn` datetime(0) NULL DEFAULT NULL,
- `CreateUserId` int(10) NULL DEFAULT NULL,
- `CreateBy` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `ModifiedOn` datetime(0) NULL DEFAULT NULL,
- `ModifiedUserId` int(10) NULL DEFAULT NULL,
- `ModifiedBy` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
- `Remarks` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
- PRIMARY KEY (`Id`) USING BTREE
- ) ENGINE = InnoDB AUTO_INCREMENT = 298 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '人员管理' ROW_FORMAT = Dynamic;
- -- ----------------------------
- -- Records of personnel
- -- ----------------------------
- INSERT INTO `personnel` VALUES (164, '小杜', '1', '', '12384', '123@qq', '199806047', '青岛', NULL, NULL, '', '1', '大数', '1', NULL, 0, '', '2020-12-25 16:49:29', 1, '系统管理员', '');
- 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, '系统管理员', '');
- 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, '系统管理员', '人员');
- 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);
- INSERT INTO `personnel` VALUES (264, '小白', '137812', '', '12384', '123@qq', '199806047', '青岛', NULL, NULL, '', '1', '大数', '1', NULL, 0, '', '2020-12-25 13:37:41', 1, '系统管理员', NULL);
- 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, '', '');
- SET FOREIGN_KEY_CHECKS = 1;
|