From 23bb52b9fc372e575ed21e47ab948a7a8c2e533b Mon Sep 17 00:00:00 2001
From: XiaoRuby <3114200645@qq.com>
Date: 星期二, 25 七月 2023 16:30:12 +0800
Subject: [PATCH] LIMS管理系统框架-开发7-25标准库修改前
---
sql/lims.sql | 528 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 528 insertions(+), 0 deletions(-)
diff --git a/sql/lims.sql b/sql/lims.sql
new file mode 100644
index 0000000..fee83e7
--- /dev/null
+++ b/sql/lims.sql
@@ -0,0 +1,528 @@
+/*
+SQLyog Ultimate v13.1.1 (64 bit)
+MySQL - 5.7.32-log : Database - lims_laboratory
+*********************************************************************
+*/
+
+/*!40101 SET NAMES utf8 */;
+
+/*!40101 SET SQL_MODE=''*/;
+
+/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
+/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
+/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
+/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
+CREATE DATABASE /*!32312 IF NOT EXISTS*/`lims_laboratory` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;
+
+USE `lims_laboratory`;
+
+/*Table structure for table `classify` */
+
+DROP TABLE IF EXISTS `classify`;
+
+CREATE TABLE `classify` (
+ `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '鍒嗙被涓婚敭',
+ `father_name` varchar(25) NOT NULL COMMENT '鍒嗙被鐖跺悕绉�',
+ `son_name` varchar(25) DEFAULT NULL COMMENT '鍒嗙被瀛愬悕绉�',
+ `state` int(1) NOT NULL DEFAULT '1' COMMENT '閫昏緫鍒犻櫎',
+ `create_time` datetime NOT NULL COMMENT '鍒涘缓鏃堕棿',
+ `update_time` datetime NOT NULL COMMENT '鏇存柊鏃堕棿',
+ `version` int(1) NOT NULL DEFAULT '1' COMMENT '涔愯閿�',
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4;
+
+/*Data for the table `classify` */
+
+insert into `classify`(`id`,`father_name`,`son_name`,`state`,`create_time`,`update_time`,`version`) values
+(1,'娓╁害娴嬮噺浠〃','浣撴俯璁�',1,'2023-07-21 10:42:26','2023-07-21 14:14:54',1),
+(3,'浣撴俯璁�',NULL,1,'2023-07-21 10:48:51','2023-07-21 10:48:51',1),
+(5,'浣撴俯',NULL,1,'2023-07-21 10:53:32','2023-07-21 10:53:32',1),
+(10,'浣撴俯','浣撴俯',0,'2023-07-21 11:16:51','2023-07-21 13:45:52',1),
+(12,'浣撴俯','浣撴俯璁�',1,'2023-07-21 11:16:51','2023-07-21 11:16:51',1),
+(13,'浣撴俯','浣撴俯',1,'2023-07-21 13:50:52','2023-07-21 13:50:52',1);
+
+/*Table structure for table `enterprise` */
+
+DROP TABLE IF EXISTS `enterprise`;
+
+CREATE TABLE `enterprise` (
+ `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '浼佷笟缂栧彿',
+ `name` varchar(20) NOT NULL COMMENT '浼佷笟鍚嶅瓧',
+ `byname` varchar(20) NOT NULL COMMENT '浼佷笟绠�绉�',
+ `link_name` varchar(10) NOT NULL COMMENT '鑱旂郴浜哄悕瀛�',
+ `link_phone` varchar(11) NOT NULL COMMENT '鑱旂郴浜虹數璇�',
+ `create_time` datetime NOT NULL COMMENT '鍒涘缓鏃堕棿',
+ `update_time` datetime NOT NULL COMMENT '鏇存柊鏃堕棿',
+ `version` int(1) NOT NULL DEFAULT '1' COMMENT '閿�',
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;
+
+/*Data for the table `enterprise` */
+
+insert into `enterprise`(`id`,`name`,`byname`,`link_name`,`link_phone`,`create_time`,`update_time`,`version`) values
+(1,'涓ぉ绉戞妧缃戠粶鏈夐檺鍏徃','涓ぉ绉戞妧','鏉庢灄','18400000000','2023-07-07 10:51:38','2023-07-07 10:51:41',1);
+
+/*Table structure for table `equipment_point` */
+
+DROP TABLE IF EXISTS `equipment_point`;
+
+CREATE TABLE `equipment_point` (
+ `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '涓婚敭',
+ `instrument_id` int(10) NOT NULL COMMENT '浠櫒Id 鍏宠仈',
+ `user_id` int(10) NOT NULL COMMENT '鐢ㄦ埛Id 鍏宠仈',
+ `equipment_point` varchar(25) NOT NULL COMMENT '鐮佺偣缂栧彿',
+ `equipment_point_name` varchar(25) NOT NULL COMMENT '鐮佺偣鍚嶇О',
+ `unit` varchar(20) NOT NULL COMMENT '鍗曚綅',
+ `descriptiveness` varchar(100) DEFAULT '--' COMMENT '鎻忚堪',
+ `create_time` datetime NOT NULL COMMENT '鍒涘缓鏃ユ湡',
+ `update_time` datetime NOT NULL COMMENT '鏇存柊鏃ユ湡',
+ `state` int(11) NOT NULL DEFAULT '1' COMMENT '閫昏緫鍒犻櫎',
+ `version` int(11) DEFAULT '1' COMMENT '涔愯閿�',
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4;
+
+/*Data for the table `equipment_point` */
+
+insert into `equipment_point`(`id`,`instrument_id`,`user_id`,`equipment_point`,`equipment_point_name`,`unit`,`descriptiveness`,`create_time`,`update_time`,`state`,`version`) values
+(1,1,7,'Area-1','瀵间綋灞忚斀锛堝鍘氶潰绉級','mm','鐤簡锛屽仛涓嶄簡','2023-07-24 14:40:01','2023-07-24 17:23:15',1,1),
+(2,1,7,'Area-2','瀵间綋灞忚斀锛堝鍘氶潰绉級','mm','澶洶浜�','2023-07-24 14:40:01','2023-07-24 15:03:44',1,1);
+
+/*Table structure for table `inspection` */
+
+DROP TABLE IF EXISTS `inspection`;
+
+CREATE TABLE `inspection` (
+ `id` varchar(25) NOT NULL COMMENT '鎶ユ缂栧彿',
+ `type` int(1) NOT NULL COMMENT '0锛氬師鏉愭枡锛�1锛氫骇鍝侊紱2锛氬崐鎴愬搧锛�',
+ `inspection_status` int(1) NOT NULL DEFAULT '0' COMMENT '鎶ユ鐘舵�� 1锛氬凡妫�楠岋紱0鏈楠�',
+ `qualified_state` int(1) DEFAULT NULL COMMENT '鏄惁鍚堟牸 1锛氭槸锛�0鍚�',
+ `state` int(1) NOT NULL DEFAULT '1' COMMENT '1锛氬緟鎻愪氦锛�2锛氬凡鎻愪氦锛�0锛氬凡浣滃簾',
+ `create_time` datetime NOT NULL COMMENT '鎶ユ鏃堕棿',
+ `update_time` datetime NOT NULL,
+ `version` int(1) DEFAULT '1',
+ `user_name` varchar(25) NOT NULL COMMENT '鎶ユ浜�',
+ `inspect_user_id` int(10) DEFAULT NULL COMMENT '鍏宠仈 妫�楠屼汉锛堢敤鎴穒d锛�',
+ `inspect_start_time` datetime DEFAULT NULL COMMENT '妫�楠屽紑濮嬫棩鏈�',
+ `inspect_end_time` datetime DEFAULT NULL COMMENT '妫�楠岀粨鏉熸棩鏈�',
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
+
+/*Data for the table `inspection` */
+
+insert into `inspection`(`id`,`type`,`inspection_status`,`qualified_state`,`state`,`create_time`,`update_time`,`version`,`user_name`,`inspect_user_id`,`inspect_start_time`,`inspect_end_time`) values
+('1680929494813868034',0,0,NULL,1,'2023-07-17 21:16:36','2023-07-17 21:16:36',1,'娴嬭瘯浜哄憳',NULL,NULL,NULL),
+('1680929899014750210',0,0,NULL,1,'2023-07-17 21:18:13','2023-07-17 21:18:13',1,'娴嬭瘯浜哄憳',NULL,NULL,NULL),
+('1681215775833042945',0,0,NULL,1,'2023-07-18 16:14:11','2023-07-18 16:14:11',1,'娴嬭瘯浜哄憳',NULL,NULL,NULL);
+
+/*Table structure for table `inspection_material_list` */
+
+DROP TABLE IF EXISTS `inspection_material_list`;
+
+CREATE TABLE `inspection_material_list` (
+ `id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'id',
+ `material_id` varchar(25) NOT NULL COMMENT '鐗╂枡id',
+ `material_num` int(10) NOT NULL COMMENT '鎶ユ鏁伴噺-鐗╂枡鏁伴噺',
+ `material_supplier` varchar(25) NOT NULL COMMENT '渚涘簲鍟�',
+ `material_name` varchar(25) NOT NULL COMMENT '鐗╂枡鍚嶇О',
+ `material_location` varchar(25) NOT NULL COMMENT '鐗╂枡瀛樻斁鍦�',
+ `material_batch` varchar(25) NOT NULL COMMENT '鐗╂枡鎵规',
+ `material_reel_number` varchar(25) NOT NULL COMMENT '鐗╂枡鐩樺彿',
+ `specifications_serial_number` varchar(50) NOT NULL COMMENT '瑙勬牸鍚嶇О/鍨嬪彿鍚嶇О',
+ `specifications_voltage_level` varchar(30) DEFAULT NULL COMMENT '鐢靛帇绛夌骇',
+ `specifications_cross_section` varchar(30) DEFAULT NULL COMMENT '涓荤嚎蹇冩埅闈�',
+ `specifications_number_of_cores` varchar(30) DEFAULT NULL COMMENT '涓荤嚎鑺姱鏁�',
+ `specifications_instruct` varchar(30) DEFAULT NULL COMMENT '鐢熶骇鎸囦护鍙�',
+ `notes` varchar(100) DEFAULT NULL COMMENT '澶囨敞',
+ `state` int(1) NOT NULL DEFAULT '1',
+ `create_time` datetime NOT NULL COMMENT '鎶ユ鏃堕棿',
+ `update_time` datetime NOT NULL,
+ `version` int(1) DEFAULT '1',
+ `inspection_id` varchar(25) NOT NULL COMMENT '鍏宠仈 鎶ユ鍗昳d',
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4;
+
+/*Data for the table `inspection_material_list` */
+
+insert into `inspection_material_list`(`id`,`material_id`,`material_num`,`material_supplier`,`material_name`,`material_location`,`material_batch`,`material_reel_number`,`specifications_serial_number`,`specifications_voltage_level`,`specifications_cross_section`,`specifications_number_of_cores`,`specifications_instruct`,`notes`,`state`,`create_time`,`update_time`,`version`,`inspection_id`) values
+(1,'1680929494813868034',100,'涓ぉ','鐢电嚎鐢电紗','鍦颁笅涓�灞�','1','123','娴嬭瘯瑙勬牸/dsahj1','1','1','1','1',NULL,1,'2023-07-17 21:16:36','2023-07-17 21:16:36',1,'1681215775833042945'),
+(2,'1680929899014750210',100,'涓ぉ','鐢电嚎鐢电紗','鍦颁笅涓�灞�','1','123','娴嬭瘯瑙勬牸/dsahj1','1','1','1','1',NULL,1,'2023-07-17 21:18:13','2023-07-17 21:18:13',1,'1681215775833042945'),
+(3,'1681499095783407618',100,'涓ぉ','鐢电嚎鐢电紗','鍦颁笅涓�灞�','1','123','23123','3424','2131','2','123','312',1,'2023-07-19 11:00:00','2023-07-19 11:00:00',1,'1681215775833042945'),
+(4,'1',10,'涓ぉ','鐢电嚎鐢电紗','鍦颁笅涓�灞�','1','123','','','瑙勬牸/鍨嬪彿','','','',1,'2023-07-19 13:59:46','2023-07-19 13:59:46',1,'1681215775833042945'),
+(5,'1',10,'涓ぉ','鐢电嚎鐢电紗','鍦颁笅涓�灞�','1','123','','','瑙勬牸/鍨嬪彿','','','',1,'2023-07-19 14:00:51','2023-07-19 14:00:51',1,'1681215775833042945'),
+(6,'1',10,'涓ぉ','鐢电嚎鐢电紗','鍦颁笅涓�灞�','1','123','','','瑙勬牸/鍨嬪彿','','','',0,'2023-07-19 14:01:46','2023-07-19 14:01:46',1,'1681215775833042945'),
+(7,'1',10,'涓ぉ','鐢电嚎鐢电紗','鍦颁笅涓�灞�','1','123','','','瑙勬牸/鍨嬪彿','','','',0,'2023-07-19 14:02:47','2023-07-19 14:02:47',1,'1681215775833042945'),
+(8,'1',10,'涓ぉ','鐢电嚎鐢电紗','鍦颁笅涓�灞�','1','123','瑙勬牸/鍨嬪彿','5','2','4','3','1',1,'2023-07-19 14:25:56','2023-07-19 14:39:23',1,'1681215775833042945'),
+(9,'1',10,'涓ぉ','鐢电嚎鐢电紗','鍦颁笅涓�灞�','1','123','瑙勬牸/鍨嬪彿','5','2','4','3','1',1,'2023-07-19 15:17:56','2023-07-19 15:17:56',1,'1681215775833042945'),
+(13,'1',10,'涓ぉ','鐢电嚎鐢电紗','鍦颁笅涓�灞�','1','123','瑙勬牸/鍨嬪彿','5','2','4','3','1',0,'2023-07-19 15:44:51','2023-07-20 11:07:27',1,'1681215775833042945');
+
+/*Table structure for table `inspection_product_list` */
+
+DROP TABLE IF EXISTS `inspection_product_list`;
+
+CREATE TABLE `inspection_product_list` (
+ `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '椤圭洰id',
+ `name` varchar(25) NOT NULL COMMENT '椤圭洰鍚嶇О',
+ `method` varchar(25) NOT NULL COMMENT '璇曢獙鏂规硶',
+ `ask` varchar(30) DEFAULT NULL COMMENT '璇曢獙瑕佹眰',
+ `unit` varchar(20) NOT NULL COMMENT '鍗曚綅',
+ `required` varchar(20) NOT NULL COMMENT '鎷涙爣浜鸿姹傚��',
+ `internal` varchar(20) NOT NULL COMMENT '鍐呮帶鍊�',
+ `start_time` datetime DEFAULT NULL COMMENT '寮�濮嬫棩鏈�',
+ `end_time` datetime DEFAULT NULL COMMENT '缁撴潫鏃ユ湡',
+ `state` int(1) NOT NULL DEFAULT '1',
+ `create_time` datetime NOT NULL,
+ `update_time` datetime NOT NULL,
+ `version` int(1) DEFAULT '1',
+ `inspection_material_list_id` int(10) NOT NULL COMMENT '鍏宠仈 鎶ユ鐗╂枡id',
+ `user_id` int(10) NOT NULL COMMENT '鍏宠仈 鐢ㄦ埛id 璇曢獙鍛�',
+ `instrument_id` int(10) DEFAULT NULL COMMENT '鍏宠仈 璁惧id',
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4;
+
+/*Data for the table `inspection_product_list` */
+
+insert into `inspection_product_list`(`id`,`name`,`method`,`ask`,`unit`,`required`,`internal`,`start_time`,`end_time`,`state`,`create_time`,`update_time`,`version`,`inspection_material_list_id`,`user_id`,`instrument_id`) values
+(2,'椤圭洰涓�','灏鸿〃娴嬮噺',NULL,'绫�','>=1','>1',NULL,NULL,1,'2023-07-17 21:16:36','2023-07-17 21:16:36',1,1,1,NULL),
+(3,'椤圭洰涓�','灏鸿〃娴嬮噺',NULL,'绫�','>=1','>1',NULL,NULL,1,'2023-07-17 21:18:13','2023-07-17 21:18:13',1,2,1,NULL),
+(4,'椤圭洰浜�','娴嬭瘯鏂规硶',NULL,'浜烘皯甯�','>1','>2',NULL,NULL,1,'2023-07-17 21:18:13','2023-07-17 21:18:13',1,3,1,NULL),
+(5,'椤圭洰涓�','灏鸿〃娴嬮噺',NULL,'绫�','>=1','>1',NULL,NULL,0,'2023-07-19 15:44:51','2023-07-20 11:07:27',1,0,1,NULL),
+(6,'椤圭洰浜�','娴嬭瘯鏂规硶',NULL,'浜烘皯甯�','>1','>2',NULL,NULL,0,'2023-07-19 15:44:51','2023-07-20 11:07:27',1,0,1,NULL);
+
+/*Table structure for table `inspection_records` */
+
+DROP TABLE IF EXISTS `inspection_records`;
+
+CREATE TABLE `inspection_records` (
+ `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '璁板綍id',
+ `method` varchar(25) NOT NULL COMMENT '妫�娴嬫柟娉�',
+ `num` int(10) NOT NULL COMMENT '妫�娴嬬殑鏍峰搧鏁伴噺',
+ `value` varchar(25) NOT NULL COMMENT '妫�娴嬪��',
+ `submit_state` int(1) NOT NULL DEFAULT '0' COMMENT '鎻愪氦鐘舵�� 0锛氬緟鎻愪氦锛�1锛氬緟瀹℃牳锛�2锛氬凡閫氳繃',
+ `state` int(1) NOT NULL DEFAULT '1',
+ `create_time` datetime NOT NULL COMMENT '妫�娴嬫棩鏈�',
+ `update_time` datetime NOT NULL,
+ `version` int(1) DEFAULT NULL,
+ `inspection_product_list_id` int(10) NOT NULL COMMENT '鍏宠仈 鏍峰搧涓嬬殑椤圭洰id',
+ `user_name` int(10) DEFAULT NULL COMMENT '鍏宠仈 瀹℃壒浜猴紙鐢ㄦ埛鍚嶇О锛�',
+ `approval_time` datetime DEFAULT NULL COMMENT '瀹℃壒鏃ユ湡',
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
+
+/*Data for the table `inspection_records` */
+
+/*Table structure for table `instrument` */
+
+DROP TABLE IF EXISTS `instrument`;
+
+CREATE TABLE `instrument` (
+ `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '涓婚敭',
+ `classify_id` int(10) NOT NULL COMMENT '鍒嗙被ID 鍏宠仈',
+ `user_id` int(10) NOT NULL COMMENT '鐢ㄦ埛鍏宠仈 淇濈浜�',
+ `equipment_code` varchar(25) NOT NULL COMMENT '浠櫒璁惧缂栧彿',
+ `equipment_name` varchar(25) NOT NULL COMMENT '浠櫒璁惧鍚嶇О',
+ `conditions` int(1) NOT NULL COMMENT '榛樿1锛�1锛氳繍琛屻��2锛氭晠闅溿��3锛氭姤淇��4锛氭淇��5锛氬緟鏈�',
+ `specifications_models` varchar(25) NOT NULL COMMENT '瑙勬牸鍨嬪彿',
+ `measuring_range` varchar(25) DEFAULT '--' COMMENT '娴嬮噺鑼冨洿',
+ `error_rate` varchar(10) DEFAULT '--' COMMENT '璇樊',
+ `manufacturer` varchar(50) DEFAULT '--' COMMENT '鐢熶骇鍘傚',
+ `arrival_date` datetime DEFAULT NULL COMMENT '鍒拌揣鏃ユ湡',
+ `acceptance_date` datetime DEFAULT NULL COMMENT '楠屾敹鏃ユ湡',
+ `storage_place` varchar(100) DEFAULT '--' COMMENT '瀛樻斁鍦�',
+ `whether_data_acquisition` int(1) NOT NULL COMMENT '鏄惁鏀寔鏁伴噰',
+ `equipment_measurement` int(1) NOT NULL COMMENT '鏄惁闇�瑕佷华鍣ㄨ澶囪閲忥細濡傛灉闇�瑕佽閲忓懆鏈熷繀濉紱濡傛灉涓嶉渶瑕佽閲忓懆鏈熶笉蹇呭～',
+ `term_validity` int(11) NOT NULL COMMENT '璁￠噺鎴鏈夋晥鏈�',
+ `descriptiveness` varchar(100) DEFAULT '--' COMMENT '鎻忚堪',
+ `create_time` datetime NOT NULL COMMENT '鍒涘缓鏃堕棿',
+ `update_time` datetime NOT NULL COMMENT '鏇存柊鏃堕棿',
+ `state` int(1) NOT NULL DEFAULT '1' COMMENT '閫昏緫鍒犻櫎',
+ `version` int(1) DEFAULT '1' COMMENT '涔愯閿�',
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4;
+
+/*Data for the table `instrument` */
+
+insert into `instrument`(`id`,`classify_id`,`user_id`,`equipment_code`,`equipment_name`,`conditions`,`specifications_models`,`measuring_range`,`error_rate`,`manufacturer`,`arrival_date`,`acceptance_date`,`storage_place`,`whether_data_acquisition`,`equipment_measurement`,`term_validity`,`descriptiveness`,`create_time`,`update_time`,`state`,`version`) values
+(1,1,9,'JSTC-W1-00001','鏁板瓧鐢垫ˉ',1,'WCDMS-1','12姣背','0.000001寰背','姹熻嫃榈烽洀','2001-07-06 00:00:00','2060-07-06 00:00:00','鍦扮悆浜氭床涓浗姹熻嫃鍗楅��',1,0,12,'鐤媯鏄熸湡浜旓紒锛侊紒','2023-07-21 15:15:23','2023-07-24 17:10:17',1,1),
+(2,1,9,'JSTC-W1-00002','鏁板瓧鐢垫ˉ',1,'WCDMS-1','12姣背','0.000001寰背','姹熻嫃榈烽洀','2001-07-06 00:00:00','2060-07-06 00:00:00','鍦扮悆浜氭床涓浗姹熻嫃鍗楅��',1,0,12,'鐤媯鏄熸湡浜旓紒锛侊紒','2023-07-21 15:17:56','2023-07-21 15:58:35',1,1),
+(3,1,10,'JSTC-W1-00003','鏁板瓧鐢垫ˉ',3,'WCDMS-1','12姣背','0.000001寰背','姹熻嫃榈烽洀','2001-07-06 00:00:00','2060-07-06 00:00:00','鍦扮悆浜氭床涓浗姹熻嫃鍗楅��',1,0,12,'鐤媯鏄熸湡浜旓紒锛侊紒','2020-01-09 15:18:02','2023-07-21 15:18:02',1,1),
+(4,1,11,'JSTC-W1-00004','鏁板瓧鐢垫ˉ',2,'WCDMS-1','12姣背','0.000001寰背','姹熻嫃榈烽洀','2001-07-06 00:00:00','2060-07-06 00:00:00','鍦扮悆浜氭床涓浗姹熻嫃鍗楅��',1,0,12,'鐤媯鏄熸湡浜旓紒锛侊紒','2023-07-21 15:18:10','2023-07-21 15:18:10',1,1),
+(5,1,12,'JSTC-W1-00005','鏁板瓧鐢垫ˉ',4,'WCDMS-1','12姣背','0.000001寰背','姹熻嫃榈烽洀','2001-07-06 00:00:00','2060-07-06 00:00:00','鍦扮悆浜氭床涓浗姹熻嫃鍗楅��',1,0,12,'鐤媯鏄熸湡浜旓紒锛侊紒','2023-07-21 15:18:15','2023-07-21 15:18:15',1,1),
+(6,1,13,'JSTC-W1-00006','A鏁板瓧鐢垫ˉ',1,'WCDMS-1','12姣背','0.000001寰背','姹熻嫃榈烽洀','2001-07-06 00:00:00','2060-07-06 00:00:00','鍦扮悆浜氭床涓浗姹熻嫃鍗楅��',1,0,12,'鐤媯鏄熸湡浜旓紒锛侊紒','2023-07-21 15:18:19','2023-07-21 15:18:19',1,1),
+(7,1,14,'JSTC-W1-00007','鏁板瓧鐢垫ˉ',5,'WCDMS-1','12姣背','0.000001寰背','姹熻嫃榈烽洀','2001-07-06 00:00:00','2060-07-06 00:00:00','鍦扮悆浜氭床涓浗姹熻嫃鍗楅��',1,0,12,'鐤媯鏄熸湡浜旓紒锛侊紒','2023-07-21 15:18:23','2023-07-21 15:18:23',1,1),
+(8,1,9,'JSTC-W1-00008','鏁板瓧鐢垫ˉ',1,'WCDMS-1','12姣背','0.000001寰背','姹熻嫃榈烽洀','2001-07-06 00:00:00','2060-07-06 00:00:00','鍦扮悆浜氭床涓浗姹熻嫃鍗楅��',1,0,12,'鐤媯鏄熸湡浜旓紒锛侊紒','2023-07-24 14:16:07','2023-07-24 14:16:07',1,1);
+
+/*Table structure for table `material` */
+
+DROP TABLE IF EXISTS `material`;
+
+CREATE TABLE `material` (
+ `id` varchar(25) NOT NULL COMMENT '鐗╂枡id',
+ `name` varchar(25) NOT NULL COMMENT '鐗╂枡鍚嶇О',
+ `supplier` varchar(25) NOT NULL COMMENT '渚涘簲鍟�',
+ `location` varchar(25) NOT NULL COMMENT '鐗╂枡瀛樻斁鍦�',
+ `num` int(10) NOT NULL COMMENT '鐗╂枡鏁伴噺',
+ `batch` varchar(25) NOT NULL COMMENT '鎵规',
+ `reel_number` varchar(25) NOT NULL COMMENT '鐩樺彿',
+ `state` int(1) NOT NULL DEFAULT '1',
+ `create_time` datetime NOT NULL,
+ `update_time` datetime NOT NULL,
+ `version` int(1) NOT NULL DEFAULT '1',
+ `specifications_id` int(10) NOT NULL COMMENT '鍏宠仈 瑙勬牸id',
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
+
+/*Data for the table `material` */
+
+insert into `material`(`id`,`name`,`supplier`,`location`,`num`,`batch`,`reel_number`,`state`,`create_time`,`update_time`,`version`,`specifications_id`) values
+('11111111111111','22222222222','1111111111','1111111',1111111,'111111','1111111',0,'2023-07-20 15:19:11','2023-07-21 13:04:12',1,1),
+('112233445566','鎵嬫満','test','test',1,'2','3',1,'2023-07-21 13:29:57','2023-07-21 13:29:57',1,1),
+('11223456','test','鑵捐','浠撳簱涓�锛屼簩鍙锋灦',200,'2','152453211563232',1,'2023-07-21 13:51:21','2023-07-21 13:51:21',1,1),
+('12345','testmaterial','test','test',1,'123','1',0,'2023-07-21 13:08:44','2023-07-21 13:13:54',1,1),
+('123456','test','test','test',1,'1','1',0,'2023-07-21 13:14:49','2023-07-21 13:20:20',1,1),
+('152423211563212','鎵嬫満','鐧惧害','浠撳簱涓�锛屼簩鍙锋灦',200,'1','152453211563212',0,'2023-07-17 14:22:57','2023-07-21 13:28:54',1,1),
+('152453211563211','鐭冲ご','鐧惧害','浠撳簱涓�锛屼笁鍙锋灦',200,'1','152453211563212',0,'2023-07-17 14:14:03','2023-07-21 13:42:15',1,1),
+('152453211563212','鐭冲ご','鐧惧害','浠撳簱涓�锛屼簩鍙锋灦',200,'1','152453211563212',1,'2023-07-21 13:41:49','2023-07-21 13:41:49',1,1),
+('152453211563222','鐭冲ご','鐧惧害','浠撳簱涓�锛屼笁鍙锋灦',200,'1','152453211563212',1,'2023-07-17 14:14:03','2023-07-20 11:09:36',1,4),
+('152453211563233','鐭冲ご','鐧惧害','浠撳簱涓�锛屼笁鍙锋灦',200,'1','152453211563212',1,'2023-07-17 14:14:03','2023-07-20 11:00:29',1,4),
+('218469124614','1122333','test','test',1,'1','1',1,'2023-07-21 13:31:00','2023-07-21 13:31:00',1,1),
+('22222222','2222222','22222222','22222222',22222222,'2222222222','2222222',0,'2023-07-20 15:20:20','2023-07-21 13:21:25',1,1);
+
+/*Table structure for table `metrical_information` */
+
+DROP TABLE IF EXISTS `metrical_information`;
+
+CREATE TABLE `metrical_information` (
+ `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '涓婚敭',
+ `user_id` int(10) NOT NULL COMMENT '鐢ㄦ埛鍏宠仈Id',
+ `measurement_unit` varchar(15) NOT NULL COMMENT '璁￠噺鍗曚綅',
+ `begin_date` datetime NOT NULL COMMENT '寮�濮嬫棩鏈�',
+ `end_date` datetime NOT NULL COMMENT '缁撴潫鏃ユ湡',
+ `uncertainty` varchar(20) NOT NULL COMMENT '涓嶇‘瀹氬害',
+ `result` int(1) NOT NULL COMMENT '缁撴灉 1锛氬悎鏍硷紱2锛氱煫姝ｅ悗鍙敤锛�3锛氫笉鍚堟牸',
+ `performance_index` varchar(100) DEFAULT NULL COMMENT '鎬ц兘鎸囨爣',
+ `remarks` varchar(100) DEFAULT NULL COMMENT '澶囨敞',
+ `file_path` varchar(50) DEFAULT NULL COMMENT '鏂囦欢璺緞',
+ `create_time` datetime NOT NULL COMMENT '鍒涘缓鏃堕棿',
+ `update_time` datetime NOT NULL COMMENT '鏇存柊鏃堕棿',
+ `state` int(1) NOT NULL DEFAULT '1' COMMENT '閫昏緫鍒犻櫎',
+ `version` int(1) DEFAULT '1' COMMENT '涔愯閿�',
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4;
+
+/*Data for the table `metrical_information` */
+
+insert into `metrical_information`(`id`,`user_id`,`measurement_unit`,`begin_date`,`end_date`,`uncertainty`,`result`,`performance_index`,`remarks`,`file_path`,`create_time`,`update_time`,`state`,`version`) values
+(1,7,'1','2023-07-25 00:00:00','2023-07-25 00:00:00','1',1,'1','1','1690255123954_131493.png','2023-07-25 10:43:30','2023-07-25 13:50:24',1,1),
+(2,7,'2','2023-07-25 00:00:00','2023-07-25 00:00:00','2',2,'2','2','1690264656523_540845.png','2023-07-25 11:18:44','2023-07-25 13:57:37',1,1);
+
+/*Table structure for table `plan` */
+
+DROP TABLE IF EXISTS `plan`;
+
+CREATE TABLE `plan` (
+ `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '璁″垝缂栧彿',
+ `results` int(10) DEFAULT NULL COMMENT '妫�楠岀粨鏋� 0锛氭湭瀹屾垚锛�1锛氬凡瀹屾垚锛�',
+ `thing` varchar(50) DEFAULT NULL COMMENT '璇曢獙璇存槑',
+ `state` int(1) NOT NULL DEFAULT '1' COMMENT '1锛氬緟璁ら锛�2锛氬緟鍒嗛厤锛�3锛氬凡鍒嗛厤锛�4锛氳秴鏈熷緟鍒嗛厤锛�5锛氬凡瀹屾垚锛�0锛氬凡浣滃簾',
+ `create_time` datetime NOT NULL COMMENT '浠诲姟鐧昏鏃堕棿',
+ `update_time` datetime NOT NULL,
+ `version` int(1) DEFAULT '1',
+ `inspection_id` varchar(25) NOT NULL COMMENT '鍏宠仈 鎶ユid(鐢宠鍗曠紪鍙�)',
+ `user_id` int(10) DEFAULT NULL COMMENT '鍏宠仈 鐢ㄦ埛id(璐熻矗浜篿d)',
+ `device_id` int(10) DEFAULT NULL COMMENT '鍏宠仈 璁惧id',
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
+
+/*Data for the table `plan` */
+
+/*Table structure for table `product` */
+
+DROP TABLE IF EXISTS `product`;
+
+CREATE TABLE `product` (
+ `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '娴嬭瘯鏍囧噯id',
+ `name` varchar(25) NOT NULL COMMENT '娴嬭瘯鏍囧噯鍚嶇О',
+ `method` varchar(25) NOT NULL COMMENT '璇曢獙鏂规硶',
+ `father` varchar(20) DEFAULT NULL COMMENT '娴嬭瘯鏍囧噯鐖剁被',
+ `unit` varchar(20) NOT NULL COMMENT '鍗曚綅',
+ `required` varchar(20) NOT NULL COMMENT '鎷涙爣浜鸿姹傚��',
+ `internal` varchar(20) NOT NULL COMMENT '鍐呮帶鍊�',
+ `state` int(1) NOT NULL DEFAULT '1',
+ `create_time` datetime NOT NULL,
+ `update_time` datetime NOT NULL,
+ `version` int(1) NOT NULL DEFAULT '1',
+ `user_id` int(10) NOT NULL COMMENT '鍏宠仈 鐢ㄦ埛id',
+ `material_id` varchar(25) NOT NULL COMMENT '鍏宠仈 鐗╂枡id',
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4;
+
+/*Data for the table `product` */
+
+insert into `product`(`id`,`name`,`method`,`father`,`unit`,`required`,`internal`,`state`,`create_time`,`update_time`,`version`,`user_id`,`material_id`) values
+(1,'鍗曚綅闀垮害璐ㄩ噺','--','閾濆寘閽㈣姱閾濈粸绾�','km','<=0.3458','<=0.3458',0,'2023-07-17 14:56:22','2023-07-21 13:28:54',1,7,'152423211563212'),
+(2,'鍗曚綅瀹藉害璐ㄩ噺','--','閾濆寘閽㈣姱閾濈粸绾�','km','<=0.3458','<=0.3458',1,'2023-07-17 14:56:22','2023-07-20 11:09:36',1,7,'152453211563222'),
+(3,'鍗曚綅瀹藉害璐ㄩ噺','--',NULL,'km','<=0.3458','<=0.3458',1,'2023-07-17 14:56:22','2023-07-20 11:09:36',1,7,'152453211563222'),
+(4,'濂藉1','鎺у埗鍙橀噺娉�','1111111','濂藉1','2000','100',0,'2023-07-20 16:05:38','2023-07-21 13:04:12',1,7,'11111111111111'),
+(5,'濂藉濂藉','---','鏂扮殑鐖堕」鐩�','濂藉濂藉','200','100',0,'2023-07-20 16:10:19','2023-07-21 13:04:12',1,7,'11111111111111'),
+(6,'濂藉濂藉','---','鏂扮殑鐖堕」鐩�','濂藉濂藉','200','100',0,'2023-07-20 16:11:39','2023-07-21 13:04:12',1,7,'11111111111111'),
+(7,'1111111','test',NULL,'test','12','123',1,'2023-07-21 13:31:34','2023-07-21 13:31:34',1,7,'112233445566'),
+(8,'111111','1',NULL,'11','1','1',1,'2023-07-21 13:33:06','2023-07-21 13:33:06',1,7,'112233445566'),
+(9,'鍗曚綅闀垮害璐ㄩ噺','--','閾濆寘閽㈣姱閾濈粸绾�','km','<=0.3458','<=0.3458',1,'2023-07-21 13:39:28','2023-07-21 13:39:28',1,7,'152453211563212'),
+(10,'鍗曚綅闀垮害璐ㄩ噺','--','閾濆寘閽㈣姱閾濈粸绾�','km','<=0.3458','<=0.3458',0,'2023-07-21 13:42:01','2023-07-21 14:19:34',1,7,'152453211563212'),
+(11,'1111111111','1111','閾濆寘閽㈣姱閾濈粸绾�','cm','11','111',0,'2023-07-21 13:48:25','2023-07-21 14:20:50',1,7,'152453211563212'),
+(12,'11111111','1','閾濆寘閽㈣姱閾濈粸绾�','1111','1','1',0,'2023-07-21 13:48:59','2023-07-21 14:19:04',1,7,'112233445566'),
+(13,'11111','--','11111111','km','<=0.3458','<=0.3458',1,'2023-07-21 13:52:21','2023-07-21 13:52:21',1,7,'11223456'),
+(14,'12345','--','11111111','km','<=0.3458','<=0.3458',0,'2023-07-21 13:53:58','2023-07-21 13:56:17',1,7,'11223456'),
+(15,'11111111111111','1','閾濆寘閽㈣姱閾濈粸绾�','111','11','1',0,'2023-07-21 14:23:10','2023-07-21 14:23:22',1,7,'152453211563212');
+
+/*Table structure for table `role` */
+
+DROP TABLE IF EXISTS `role`;
+
+CREATE TABLE `role` (
+ `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '瑙掕壊id',
+ `name` varchar(30) NOT NULL COMMENT '瑙掕壊鍚�',
+ `power` int(1) NOT NULL COMMENT '0锛氭棤鏉冮檺锛�1锛氭湁鏉冮檺',
+ `state` int(1) NOT NULL DEFAULT '1' COMMENT '閫昏緫鍒犻櫎 姝ｅ父>=1,鍒犻櫎<=0',
+ `create_time` datetime NOT NULL,
+ `update_time` datetime NOT NULL,
+ `version` int(10) NOT NULL COMMENT '涔愯閿�',
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;
+
+/*Data for the table `role` */
+
+insert into `role`(`id`,`name`,`power`,`state`,`create_time`,`update_time`,`version`) values
+(1,'鏅�氫汉鍛�',1,1,'2023-07-07 11:30:06','2023-07-07 11:30:11',1);
+
+/*Table structure for table `serial_number` */
+
+DROP TABLE IF EXISTS `serial_number`;
+
+CREATE TABLE `serial_number` (
+ `id` varchar(25) NOT NULL COMMENT '鍨嬪彿缂栧彿',
+ `name` varchar(25) NOT NULL COMMENT '鍨嬪彿鍚嶇О',
+ `state` int(1) NOT NULL DEFAULT '1',
+ `create_time` datetime NOT NULL,
+ `update_time` datetime NOT NULL,
+ `version` int(1) NOT NULL DEFAULT '1',
+ `standards_id` varchar(15) NOT NULL COMMENT '鍏宠仈瀛楁 鏍囧噯id',
+ `user_id` int(10) NOT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
+
+/*Data for the table `serial_number` */
+
+insert into `serial_number`(`id`,`name`,`state`,`create_time`,`update_time`,`version`,`standards_id`,`user_id`) values
+('111222','鍨嬪彿1',0,'2023-07-20 15:01:08','2023-07-20 15:20:09',1,'111',7),
+('230711000002','鍏夌氦2.0.1',1,'2023-07-11 22:34:11','2023-07-20 09:28:19',1,'230711000001',7),
+('ModelNumber001','鍏夌氦2.0.1',1,'2023-07-20 10:51:01','2023-07-20 10:51:01',1,'230711000002',7),
+('ModelNumber002','鍏夌氦2.0.2',1,'2023-07-18 13:36:13','2023-07-20 09:28:19',1,'230711000001',7),
+('ModelNumber003','鍏夌氦2.0.3',1,'2023-07-18 13:36:23','2023-07-20 10:54:11',1,'230711000002',7),
+('num1','鍏夌氦2.0.3',1,'2023-07-20 14:18:24','2023-07-20 14:18:24',1,'230711000002',7),
+('num2','鍏夌氦2.0.4',1,'2023-07-20 14:19:34','2023-07-20 14:19:34',1,'230711000002',7),
+('PleasantGoat','1345',1,'2023-07-18 13:46:49','2023-07-20 10:22:42',1,'230711000002',7),
+('spiritless','78915',1,'2023-07-18 13:46:24','2023-07-18 13:46:24',1,'230711000004',7);
+
+/*Table structure for table `specifications` */
+
+DROP TABLE IF EXISTS `specifications`;
+
+CREATE TABLE `specifications` (
+ `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '瑙勬牸id',
+ `number` varchar(25) NOT NULL COMMENT '瑙勬牸缂栧彿',
+ `name` varchar(25) NOT NULL COMMENT '浜у搧瑙勬牸',
+ `instruct` varchar(25) DEFAULT NULL COMMENT '鐢熶骇鎸囦护鍙�',
+ `voltage_level` varchar(30) DEFAULT NULL COMMENT '鐢靛帇绛夌骇',
+ `cross_section` varchar(30) DEFAULT NULL COMMENT '涓荤嚎蹇冩埅闈�',
+ `number_of_cores` varchar(30) DEFAULT NULL COMMENT '涓荤嚎鑺姱鏁�',
+ `spe_state` int(1) NOT NULL DEFAULT '-1' COMMENT '瑙勬牸鐘舵�� 0锛氬仠鐢紱1锛氭甯革紱-1锛氳崏绋�',
+ `state` int(1) NOT NULL DEFAULT '1' COMMENT '閫昏緫鍒犻櫎 姝ｅ父>=1,鍒犻櫎<=0',
+ `create_time` datetime NOT NULL,
+ `update_time` datetime NOT NULL COMMENT '鏇存柊鏃堕棿',
+ `version` int(1) NOT NULL DEFAULT '1',
+ `vel` varchar(15) NOT NULL DEFAULT 'V1.0' COMMENT '瑙勬牸鐗堟湰',
+ `serial_id` varchar(25) NOT NULL COMMENT '鍏宠仈瀛楁 鍨嬪彿id',
+ `user_id` int(10) NOT NULL COMMENT '鍏宠仈瀛楁 鐢ㄦ埛id',
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4;
+
+/*Data for the table `specifications` */
+
+insert into `specifications`(`id`,`number`,`name`,`instruct`,`voltage_level`,`cross_section`,`number_of_cores`,`spe_state`,`state`,`create_time`,`update_time`,`version`,`vel`,`serial_id`,`user_id`) values
+(1,'111','ab','test','1','test','test',0,1,'2023-07-12 00:00:12','2023-07-21 09:52:22',1,'V1.0','230711000002',7),
+(2,'abc','AB','abc','abc','abc','abc',0,1,'2023-07-12 00:00:12','2023-07-20 16:34:38',1,'V1.0','230711000002',7),
+(4,'abc','AB','abc','abc','abc','abc',1,1,'2023-07-12 00:00:12','2023-07-20 11:00:29',1,'V1.0','ModelNumber003',7),
+(5,'abc','AB','abc','abc','abc','abc',1,1,'2023-07-12 00:00:12','2023-07-20 10:22:42',1,'V1.0','PleasantGoat',7),
+(6,'modelId','AB','test','test','test','test',-1,1,'2023-07-20 13:42:40','2023-07-20 13:42:40',1,'V1.0','230711000002',7),
+(7,'modelID1','test','test','test','test','test',-1,1,'2023-07-20 14:02:26','2023-07-20 14:02:26',1,'V1.0','230711000002',7),
+(8,'modelId2','test11','test','test','test','test',-1,1,'2023-07-20 14:03:54','2023-07-20 14:03:54',1,'V1.0','230711000002',7),
+(9,'111222','鍏夌氦2.0.3','test','test','test','test',-1,1,'2023-07-20 14:55:12','2023-07-20 14:55:12',1,'V1.0','230711000002',7);
+
+/*Table structure for table `standards` */
+
+DROP TABLE IF EXISTS `standards`;
+
+CREATE TABLE `standards` (
+ `id` varchar(15) NOT NULL COMMENT '鏍囧噯缂栧彿 yyMMdd000001(000001++)',
+ `name` varchar(25) NOT NULL COMMENT '鏍囧噯鍚嶇О',
+ `eng_name` varchar(25) NOT NULL COMMENT '鑻辨枃鍚嶇О',
+ `type` int(1) NOT NULL COMMENT '0锛氬師鏉愭枡锛�1锛氱數绾跨數缂�',
+ `state` int(1) NOT NULL DEFAULT '1' COMMENT '閫昏緫瀛楁 0锛氬垹闄わ紱1锛氭甯�',
+ `create_time` datetime NOT NULL COMMENT '鐢熸晥鏃ユ湡',
+ `update_time` datetime NOT NULL COMMENT '鏇存柊鏃ユ湡',
+ `version` int(1) NOT NULL DEFAULT '1',
+ `user_id` int(10) NOT NULL COMMENT '鍏宠仈瀛楁 鏇存柊浜篿d',
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
+
+/*Data for the table `standards` */
+
+insert into `standards`(`id`,`name`,`eng_name`,`type`,`state`,`create_time`,`update_time`,`version`,`user_id`) values
+('111','123131313','164654565',0,0,'2023-07-20 13:26:55','2023-07-20 15:20:09',1,7),
+('112233445566','楸奸奔','fish',1,0,'2023-07-20 10:54:12','2023-07-20 15:19:41',1,7),
+('230711000001','灏忕櫧','OpticalFibre',1,1,'2023-07-11 21:27:04','2023-07-20 09:28:19',1,6),
+('230711000002','鏉愭枡','OpticalFibrw',1,1,'2023-07-11 21:27:04','2023-07-20 10:22:42',1,6),
+('230711000003','鏄剧ず灞�','Monitor',2,1,'2023-07-18 13:43:52','2023-07-18 13:43:52',1,7),
+('230711000004','灏忛粦','Black',2,1,'2023-07-18 13:44:29','2023-07-18 13:44:29',1,7);
+
+/*Table structure for table `user` */
+
+DROP TABLE IF EXISTS `user`;
+
+CREATE TABLE `user` (
+ `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '鐢ㄦ埛id',
+ `account` varchar(20) NOT NULL COMMENT '璐﹀彿',
+ `password` varchar(100) NOT NULL COMMENT '瀵嗙爜',
+ `name` varchar(20) NOT NULL COMMENT '濮撳悕',
+ `phone` varchar(11) DEFAULT NULL COMMENT '鎵嬫満鍙�',
+ `email` varchar(30) DEFAULT NULL COMMENT '閭',
+ `age` int(3) DEFAULT NULL COMMENT '骞撮緞',
+ `job_state` int(1) NOT NULL DEFAULT '1' COMMENT '鍦ㄨ亴鐘舵�� 姝ｅ父>=1,绂昏亴<=0',
+ `info` varchar(100) DEFAULT NULL COMMENT '涓�х鍚�',
+ `create_time` datetime NOT NULL,
+ `update_time` datetime NOT NULL,
+ `version` int(1) NOT NULL DEFAULT '1',
+ `role_id` int(10) NOT NULL,
+ `enterprise_id` int(10) NOT NULL COMMENT '鍏宠仈 浼佷笟ID',
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `account_unique` (`account`)
+) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4;
+
+/*Data for the table `user` */
+
+insert into `user`(`id`,`account`,`password`,`name`,`phone`,`email`,`age`,`job_state`,`info`,`create_time`,`update_time`,`version`,`role_id`,`enterprise_id`) values
+(7,'123456','123456','灏忓皬','12345678981','12345678@qq.com',23,1,NULL,'2023-07-11 09:14:50','2023-07-11 09:14:50',1,1,1),
+(9,'1388967','123456','楸奸奔','19727565533','1981343953@qq.com',18,1,NULL,'2023-07-13 14:51:41','2023-07-13 14:51:41',1,1,1),
+(10,'1111111','123456','鍙彯褰�','17726824629','13958368246@gmail.com',13,1,NULL,'2023-07-13 14:57:23','2023-07-13 14:57:23',1,0,1),
+(11,'135686632','123456','鍙彯褰�','13795639054','19813438642@qq.com',18,1,NULL,'2023-07-13 14:58:45','2023-07-13 14:58:45',1,1,1),
+(12,'333','123456','楸奸奔','72398','2144',36,1,NULL,'2023-07-13 15:21:34','2023-07-13 15:21:34',1,0,1),
+(13,'199999','123456','楸奸奔','2154364646','18913908',34,1,NULL,'2023-07-13 15:22:16','2023-07-13 15:22:16',1,1,1),
+(14,'8957824','123456','寮犱笁','23875185298','2222222872',13,1,NULL,'2023-07-13 15:29:13','2023-07-13 15:29:13',1,1,1),
+(21,'45612345','123456','灏忛粦','12345678981','12345678@qq.com',23,1,NULL,'2023-07-17 10:36:23','2023-07-17 10:36:23',1,1,1),
+(23,'4561278345','123456','灏忛粦','12345678981','12345678@qq.com',23,1,NULL,'2023-07-17 11:28:50','2023-07-17 11:28:50',1,1,1);
+
+/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
+/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
+/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
+/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--
Gitblit v1.9.3