SHJX_GM/DataBase/hypermanganate_database.sql

/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 80019
 Source Host           : localhost:3306
 Source Schema         : hypermanganate_database

 Target Server Type    : MySQL
 Target Server Version : 80019
 File Encoding         : 65001

 Date: 17/10/2021 18:19:43
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for batch
-- ----------------------------
DROP TABLE IF EXISTS `batch`;
CREATE TABLE `batch`  (
  `SerialKey` int(0) NOT NULL AUTO_INCREMENT,
  `Createtime` datetime(0) NULL DEFAULT NULL,
  `currentvalue` int(0) NOT NULL,
  PRIMARY KEY (`SerialKey`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 19 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of batch
-- ----------------------------
INSERT INTO `batch` VALUES (19, '2021-10-16 14:12:22', 1);

-- ----------------------------
-- Table structure for dissolve_date
-- ----------------------------
DROP TABLE IF EXISTS `dissolve_date`;
CREATE TABLE `dissolve_date`  (
  `SerialKey` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `PositionName` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '地址名称',
  `SampleLocalName` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '样品地址名称',
  `LastTryTime` datetime(0) NULL DEFAULT NULL COMMENT '最后尝试时间',
  `Start` int(0) NULL DEFAULT NULL COMMENT '执行',
  PRIMARY KEY (`SerialKey`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of dissolve_date
-- ----------------------------
INSERT INTO `dissolve_date` VALUES (1, 'R1', '', '2021-10-16 14:14:23', 0);
INSERT INTO `dissolve_date` VALUES (2, 'R2', '', '2021-10-13 17:52:30', 0);
INSERT INTO `dissolve_date` VALUES (3, 'R3', '', '2021-09-10 11:12:43', 0);
INSERT INTO `dissolve_date` VALUES (4, 'R4', '', '0001-01-01 00:00:00', 0);
INSERT INTO `dissolve_date` VALUES (5, 'R5', '', '0001-01-01 00:00:00', 0);
INSERT INTO `dissolve_date` VALUES (6, 'R6', '', '0001-01-01 00:00:00', 0);
INSERT INTO `dissolve_date` VALUES (7, 'R7', '', '0001-01-01 00:00:00', 0);
INSERT INTO `dissolve_date` VALUES (8, 'R8', '', '0001-01-01 00:00:00', 0);
INSERT INTO `dissolve_date` VALUES (9, 'R9', '', '0001-01-01 00:00:00', 0);

-- ----------------------------
-- Table structure for dissolve_interval
-- ----------------------------
DROP TABLE IF EXISTS `dissolve_interval`;
CREATE TABLE `dissolve_interval`  (
  `SerialKey` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `LastTryTime` datetime(0) NULL DEFAULT NULL COMMENT '最后尝试时间',
  PRIMARY KEY (`SerialKey`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of dissolve_interval
-- ----------------------------
INSERT INTO `dissolve_interval` VALUES (1, '2021-08-14 15:50:42');

-- ----------------------------
-- Table structure for equipment_area
-- ----------------------------
DROP TABLE IF EXISTS `equipment_area`;
CREATE TABLE `equipment_area`  (
  `SerialKey` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键自增',
  `AreaName` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '区域名称',
  `PointName` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '点位名称',
  `LocationX` double(8, 3) NULL DEFAULT NULL COMMENT 'X位置',
  `LocationY` double(8, 3) NULL DEFAULT NULL COMMENT 'Y位置',
  `LocationZ` double(8, 3) NULL DEFAULT NULL COMMENT 'Z位置',
  `Enable` int(0) NULL DEFAULT NULL COMMENT '启用',
  PRIMARY KEY (`SerialKey`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 90 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of equipment_area
-- ----------------------------
INSERT INTO `equipment_area` VALUES (1, 'SamplePosition', 'A1', 3.700, 6.200, 100.000, 1);
INSERT INTO `equipment_area` VALUES (2, 'SamplePosition', 'A2', 30.500, 6.200, 100.000, 1);
INSERT INTO `equipment_area` VALUES (3, 'SamplePosition', 'A3', 57.300, 6.200, 100.000, 1);
INSERT INTO `equipment_area` VALUES (4, 'SamplePosition', 'A4', 84.300, 6.200, 100.000, 1);
INSERT INTO `equipment_area` VALUES (5, 'SamplePosition', 'A5', 111.300, 6.200, 100.000, 1);
INSERT INTO `equipment_area` VALUES (6, 'SamplePosition', 'A6', 138.300, 6.200, 100.000, 1);
INSERT INTO `equipment_area` VALUES (7, 'SamplePosition', 'A7', 7.957, 60.186, 100.000, 1);
INSERT INTO `equipment_area` VALUES (8, 'SamplePosition', 'A8', 34.914, 60.203, 100.000, 1);
INSERT INTO `equipment_area` VALUES (9, 'SamplePosition', 'A9', 61.871, 60.220, 100.000, 1);
INSERT INTO `equipment_area` VALUES (10, 'SamplePosition', 'A10', 88.829, 60.237, 100.000, 1);
INSERT INTO `equipment_area` VALUES (11, 'SamplePosition', 'A11', 115.786, 60.254, 100.000, 1);
INSERT INTO `equipment_area` VALUES (12, 'SamplePosition', 'A12', 142.743, 60.271, 100.000, 1);
INSERT INTO `equipment_area` VALUES (13, 'SamplePosition', 'A13', 8.014, 110.271, 100.000, 1);
INSERT INTO `equipment_area` VALUES (14, 'SamplePosition', 'A14', 34.969, 110.306, 100.000, 1);
INSERT INTO `equipment_area` VALUES (15, 'SamplePosition', 'A15', 61.923, 110.340, 100.000, 1);
INSERT INTO `equipment_area` VALUES (16, 'SamplePosition', 'A16', 88.877, 110.374, 100.000, 1);
INSERT INTO `equipment_area` VALUES (17, 'SamplePosition', 'A17', 115.831, 110.409, 100.000, 1);
INSERT INTO `equipment_area` VALUES (18, 'SamplePosition', 'A18', 142.786, 110.443, 100.000, 1);
INSERT INTO `equipment_area` VALUES (19, 'SamplePosition', 'A19', 8.071, 160.357, 100.000, 1);
INSERT INTO `equipment_area` VALUES (20, 'SamplePosition', 'A20', 35.023, 160.409, 100.000, 1);
INSERT INTO `equipment_area` VALUES (21, 'SamplePosition', 'A21', 61.974, 160.460, 100.000, 1);
INSERT INTO `equipment_area` VALUES (22, 'SamplePosition', 'A22', 88.926, 160.511, 100.000, 1);
INSERT INTO `equipment_area` VALUES (23, 'SamplePosition', 'A23', 115.877, 160.563, 100.000, 1);
INSERT INTO `equipment_area` VALUES (24, 'SamplePosition', 'A24', 142.829, 160.614, 100.000, 1);
INSERT INTO `equipment_area` VALUES (25, 'SamplePosition', 'A25', 8.129, 210.443, 100.000, 1);
INSERT INTO `equipment_area` VALUES (26, 'SamplePosition', 'A26', 35.077, 210.511, 100.000, 1);
INSERT INTO `equipment_area` VALUES (27, 'SamplePosition', 'A27', 62.026, 210.580, 100.000, 1);
INSERT INTO `equipment_area` VALUES (28, 'SamplePosition', 'A28', 88.974, 210.649, 100.000, 1);
INSERT INTO `equipment_area` VALUES (29, 'SamplePosition', 'A29', 115.923, 210.717, 100.000, 1);
INSERT INTO `equipment_area` VALUES (30, 'SamplePosition', 'A30', 142.871, 210.786, 100.000, 1);
INSERT INTO `equipment_area` VALUES (31, 'SamplePosition', 'A31', 8.186, 260.529, 100.000, 1);
INSERT INTO `equipment_area` VALUES (32, 'SamplePosition', 'A32', 35.131, 260.614, 100.000, 1);
INSERT INTO `equipment_area` VALUES (33, 'SamplePosition', 'A33', 62.077, 260.700, 100.000, 1);
INSERT INTO `equipment_area` VALUES (34, 'SamplePosition', 'A34', 89.023, 260.786, 100.000, 1);
INSERT INTO `equipment_area` VALUES (35, 'SamplePosition', 'A35', 115.969, 260.871, 100.000, 1);
INSERT INTO `equipment_area` VALUES (36, 'SamplePosition', 'A36', 142.914, 260.957, 100.000, 1);
INSERT INTO `equipment_area` VALUES (37, 'SamplePosition', 'A37', 8.243, 310.614, 100.000, 1);
INSERT INTO `equipment_area` VALUES (38, 'SamplePosition', 'A38', 35.186, 310.717, 100.000, 1);
INSERT INTO `equipment_area` VALUES (39, 'SamplePosition', 'A39', 62.129, 310.820, 100.000, 1);
INSERT INTO `equipment_area` VALUES (40, 'SamplePosition', 'A40', 89.071, 310.923, 100.000, 1);
INSERT INTO `equipment_area` VALUES (41, 'SamplePosition', 'A41', 116.014, 311.026, 100.000, 1);
INSERT INTO `equipment_area` VALUES (42, 'SamplePosition', 'A42', 142.957, 311.129, 100.000, 1);
INSERT INTO `equipment_area` VALUES (43, 'SamplePosition', 'A43', 8.300, 360.700, 100.000, 1);
INSERT INTO `equipment_area` VALUES (44, 'SamplePosition', 'A44', 35.240, 360.820, 100.000, 1);
INSERT INTO `equipment_area` VALUES (45, 'SamplePosition', 'A45', 62.180, 360.940, 100.000, 1);
INSERT INTO `equipment_area` VALUES (46, 'SamplePosition', 'A46', 89.120, 361.060, 100.000, 1);
INSERT INTO `equipment_area` VALUES (47, 'SamplePosition', 'A47', 116.060, 361.180, 100.000, 1);
INSERT INTO `equipment_area` VALUES (48, 'SamplePosition', 'A48', 143.000, 361.300, 100.000, 1);
INSERT INTO `equipment_area` VALUES (49, 'SamplePosition', 'A49', 172.700, 159.800, 100.000, 1);
INSERT INTO `equipment_area` VALUES (50, 'SamplePosition', 'A50', 199.650, 159.700, 100.000, 1);
INSERT INTO `equipment_area` VALUES (51, 'SamplePosition', 'A51', 226.600, 159.600, 100.000, 1);
INSERT INTO `equipment_area` VALUES (52, 'SamplePosition', 'A52', 253.550, 159.500, 100.000, 1);
INSERT INTO `equipment_area` VALUES (53, 'SamplePosition', 'A53', 280.500, 159.400, 100.000, 1);
INSERT INTO `equipment_area` VALUES (54, 'SamplePosition', 'A54', 172.825, 210.300, 100.000, 1);
INSERT INTO `equipment_area` VALUES (55, 'SamplePosition', 'A55', 199.775, 210.125, 100.000, 1);
INSERT INTO `equipment_area` VALUES (79, 'DissolvePosition', 'R1', 160.000, 18.500, 100.000, 1);
INSERT INTO `equipment_area` VALUES (80, 'DissolvePosition', 'R2', 227.800, 18.500, 100.000, 1);
INSERT INTO `equipment_area` VALUES (81, 'DissolvePosition', 'R3', 254.800, 18.500, 100.000, 1);
INSERT INTO `equipment_area` VALUES (82, 'DissolvePosition', 'R4', 281.800, 18.500, 100.000, 1);
INSERT INTO `equipment_area` VALUES (83, 'DissolvePosition', 'R5', 308.800, 18.500, 100.000, 1);
INSERT INTO `equipment_area` VALUES (84, 'DissolvePosition', 'R6', 174.500, 94.000, 100.000, 1);
INSERT INTO `equipment_area` VALUES (85, 'DissolvePosition', 'R7', 201.500, 94.000, 100.000, 1);
INSERT INTO `equipment_area` VALUES (86, 'DissolvePosition', 'R8', 228.500, 94.000, 100.000, 1);
INSERT INTO `equipment_area` VALUES (87, 'DissolvePosition', 'R9', 255.500, 94.000, 100.000, 1);
INSERT INTO `equipment_area` VALUES (88, 'DewaterPosition', 'C1', 260.500, 30.000, 100.000, 1);
INSERT INTO `equipment_area` VALUES (89, 'TitrationPosition', 'D1', 300.000, 95.000, 100.000, 1);
INSERT INTO `equipment_area` VALUES (90, 'AddLiquidPosition', 'L1', 300.000, 150.000, 100.000, 1);

-- ----------------------------
-- Table structure for equipment_task
-- ----------------------------
DROP TABLE IF EXISTS `equipment_task`;
CREATE TABLE `equipment_task`  (
  `SerialKey` int(0) NOT NULL AUTO_INCREMENT,
  `WaveKey` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '波次',
  `Source` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '原始地址',
  `CreateTime` datetime(0) NULL DEFAULT NULL COMMENT '创建事件',
  `Status` int(0) NULL DEFAULT NULL COMMENT '任务状态',
  `From` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '源地址',
  `To` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '目标地址',
  `Target` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '执行目标',
  `Amount` double(8, 3) NULL DEFAULT 0.000 COMMENT '滴定数量',
  `Result` double(8, 3) NULL DEFAULT NULL COMMENT '滴定结果',
  `CalibrationEnable` int(0) NULL DEFAULT NULL COMMENT '开启标定',
  `CalibrationAmount` double(8, 3) NULL DEFAULT NULL COMMENT '标定数量',
  `RouteID` int(0) NULL DEFAULT NULL COMMENT '路由ID',
  `RouteStep` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '路由步骤',
  `Record` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '记录',
  `RouteType` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '路由类型',
  `TaskType` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '任务类型',
  `AcidBaseProp` int(0) NULL DEFAULT NULL COMMENT '酸碱性',
  `TaskDetailName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '样品描述',
  `SampleVolume` double(8, 3) NULL DEFAULT NULL COMMENT '取样体积',
  `SampleMultiple` double(8, 3) NULL DEFAULT NULL COMMENT '取样倍数',
  `QuicklyTitration` int(0) NULL DEFAULT NULL COMMENT '快速滴定',
  `udf1` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '扩展字段一',
  `udf2` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '扩展字段二',
  `udf3` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '扩展字段三',
  PRIMARY KEY (`SerialKey`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3306 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of equipment_task
-- ----------------------------
INSERT INTO `equipment_task` VALUES (3291, '20211014004', 'A1', '2021-10-14 13:33:12', 4, 'C1', 'D1', 'To', 0.000, 0.000, 0, 0.000, 3, 'Titration', 'TitrationNa2C2O4', 'Sample', '样品', 1, '10143310', 0.200, NULL, 0, NULL, NULL, NULL);
INSERT INTO `equipment_task` VALUES (3292, '20211014004', 'A2', '2021-10-14 13:33:12', 4, 'A2', 'C1', 'To', 0.000, 0.000, 0, 0.000, 3, 'Titration', 'ReleaseAxis', 'Sample', '样品', 1, '10143308', 0.200, NULL, 0, NULL, NULL, NULL);
INSERT INTO `equipment_task` VALUES (3293, '20211014004', 'A3', '2021-10-14 13:33:13', 4, 'A3', 'L1', 'To', 0.000, 0.000, 0, 0.000, 1, 'AddLiquid', 'AddLiquidH2SO4', 'Sample', '样品', 1, '10143305', 0.200, NULL, 0, NULL, NULL, NULL);
INSERT INTO `equipment_task` VALUES (3294, '20211014005', 'A1', '2021-10-14 13:52:21', 4, 'A1', 'L1', 'To', 0.000, 0.000, 0, 0.000, 1, 'AddLiquid', 'AddLiquidH2SO4', 'Sample', '样品', 1, '10145210', 0.200, NULL, 0, NULL, NULL, NULL);
INSERT INTO `equipment_task` VALUES (3295, '20211014005', 'A2', '2021-10-14 13:52:21', 4, 'A2', 'A2', NULL, 0.000, 0.000, 0, 0.000, 1, 'AddLiquid', NULL, 'Sample', '样品', 1, '10145212', 0.200, NULL, 0, NULL, NULL, NULL);
INSERT INTO `equipment_task` VALUES (3296, '20211014005', 'A3', '2021-10-14 13:52:21', 4, 'A3', 'A3', NULL, 0.000, 0.000, 0, 0.000, 1, 'AddLiquid', NULL, 'Sample', '样品', 1, '10145213', 0.200, NULL, 0, NULL, NULL, NULL);
INSERT INTO `equipment_task` VALUES (3297, '20211014006', 'A1', '2021-10-14 15:54:46', 4, 'C1', 'D1', 'To', 0.000, 0.000, 0, 0.000, 3, 'Titration', 'TitrationNa2C2O4', 'Sample', '样品', 1, '10145439', 0.200, NULL, 0, NULL, NULL, NULL);
INSERT INTO `equipment_task` VALUES (3298, '20211014006', 'A2', '2021-10-14 15:54:46', 4, 'A2', 'C1', 'To', 0.000, 0.000, 0, 0.000, 3, 'Titration', 'ReleaseAxis', 'Sample', '样品', 1, '10145441', 0.200, NULL, 0, NULL, NULL, NULL);
INSERT INTO `equipment_task` VALUES (3299, '20211014006', 'A3', '2021-10-14 15:54:46', 4, 'A3', 'L1', 'To', 0.000, 0.000, 0, 0.000, 1, 'AddLiquid', 'AddLiquidH2SO4', 'Sample', '样品', 1, '10145443', 0.200, NULL, 0, NULL, NULL, NULL);
INSERT INTO `equipment_task` VALUES (3300, '20211014007', 'A1', '2021-10-14 16:13:39', 4, 'D1', 'A1', 'To', 0.078, 0.000, 0, 0.000, 3, 'Goback', 'ReleaseAxis', 'Sample', '样品', 1, '10141335', 0.200, NULL, 0, NULL, NULL, NULL);
INSERT INTO `equipment_task` VALUES (3301, '20211014007', 'A2', '2021-10-14 16:13:39', 4, 'D1', 'A2', 'To', 0.078, 0.000, 0, 0.000, 3, 'Goback', 'ReleaseAxis', 'Sample', '样品', 1, '10141332', 0.200, NULL, 0, NULL, NULL, NULL);
INSERT INTO `equipment_task` VALUES (3302, '20211014007', 'A3', '2021-10-14 16:13:39', 4, 'D1', 'A3', 'To', 0.078, 0.000, 0, 0.000, 3, 'Goback', 'ReleaseAxis', 'Sample', '样品', 1, '10141337', 0.200, NULL, 0, NULL, NULL, NULL);
INSERT INTO `equipment_task` VALUES (3303, NULL, 'A1', '2021-10-16 11:41:19', 4, '', '', NULL, 0.000, 0.000, 0, 0.000, 4, 'Wash', NULL, 'Wash', '清洗', 0, NULL, 0.000, 0.000, 0, NULL, NULL, NULL);
INSERT INTO `equipment_task` VALUES (3304, NULL, 'A1', '2021-10-16 13:45:42', 4, '', '', NULL, 0.000, 0.000, 0, 0.000, 4, 'Wash', NULL, 'Wash', '清洗', 0, NULL, 0.000, 0.000, 0, NULL, NULL, NULL);
INSERT INTO `equipment_task` VALUES (3305, '20211016001', 'A1', '2021-10-16 14:12:22', 4, 'C1', 'D1', 'To', 0.000, 0.000, 0, 0.000, 3, 'Titration', 'TitrationNa2C2O4', 'Sample', '样品', 1, '10161218', 100.000, 0.000, 0, NULL, NULL, NULL);

-- ----------------------------
-- Table structure for execute_time
-- ----------------------------
DROP TABLE IF EXISTS `execute_time`;
CREATE TABLE `execute_time`  (
  `SerialKey` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `TypeName` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '类型名称',
  `Value` double(4, 2) NULL DEFAULT NULL COMMENT '值',
  `Description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '描述',
  PRIMARY KEY (`SerialKey`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of execute_time
-- ----------------------------
INSERT INTO `execute_time` VALUES (1, 'DissolveTime', 1.00, '消解时间（min）');
INSERT INTO `execute_time` VALUES (3, 'DissolveInterval', 5.00, '消解间隔（min）');
INSERT INTO `execute_time` VALUES (5, 'DewaterTime', 5.00, '除水时间（s）');

-- ----------------------------
-- Table structure for liquid_amount
-- ----------------------------
DROP TABLE IF EXISTS `liquid_amount`;
CREATE TABLE `liquid_amount`  (
  `SerialKey` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `LiquidName` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '液体名称',
  `Capacity` double(8, 5) NULL DEFAULT NULL COMMENT '容量',
  `Amount` double(8, 5) NULL DEFAULT NULL COMMENT '数量',
  `ConvertRatio` int(0) NULL DEFAULT NULL COMMENT '转换比例',
  `Description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '描述',
  PRIMARY KEY (`SerialKey`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of liquid_amount
-- ----------------------------
INSERT INTO `liquid_amount` VALUES (1, 'SodiumOxalate', 1.00000, 0.24765, 20000, '草酸钠');
INSERT INTO `liquid_amount` VALUES (2, 'AddLiquidPotassiumPermanganate', 1.00000, 0.07811, 20000, '高锰酸钾（加液）');
INSERT INTO `liquid_amount` VALUES (3, 'TitrationPotassiumPermanganate', 1.00000, 0.07811, 1000, '高锰酸钾（滴定）');

-- ----------------------------
-- Table structure for liquid_volume
-- ----------------------------
DROP TABLE IF EXISTS `liquid_volume`;
CREATE TABLE `liquid_volume`  (
  `SerialKey` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `LiquidName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '液体名称',
  `ClearVolume` double(12, 3) NULL DEFAULT NULL COMMENT '清洗体积',
  `SampleVolume` double(12, 3) NULL DEFAULT NULL COMMENT '样品滴定体积',
  `Enable` int(0) NULL DEFAULT NULL COMMENT '启用',
  `Description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述',
  PRIMARY KEY (`SerialKey`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of liquid_volume
-- ----------------------------
INSERT INTO `liquid_volume` VALUES (6, 'SodiumOxalate', 10.000, 3.000, 1, '草酸钠（ml）');
INSERT INTO `liquid_volume` VALUES (7, 'SodiumHydroxide', 10.000, 5.000, 1, '氢氧化钠（s）');
INSERT INTO `liquid_volume` VALUES (8, 'AddLiquidPotassiumPermanganate', 10.000, 1.000, 1, '加液位高锰酸钾（ml）');
INSERT INTO `liquid_volume` VALUES (9, 'AddLiquidVitriol', 10.000, 5.000, 1, '加液位硫酸（s）');
INSERT INTO `liquid_volume` VALUES (10, 'TitrationPotassiumPermanganate', 10.000, 1.000, 1, '滴定位高锰酸钾（ml）');
INSERT INTO `liquid_volume` VALUES (11, 'TitrationVitriol', 10.000, 5.000, 1, '滴定位硫酸（s）');

-- ----------------------------
-- Table structure for motor_convert
-- ----------------------------
DROP TABLE IF EXISTS `motor_convert`;
CREATE TABLE `motor_convert`  (
  `SeriKey` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `MotorName` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '电机名称',
  `ConvertRatio` double(8, 3) NULL DEFAULT NULL COMMENT '转换数值',
  PRIMARY KEY (`SeriKey`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of motor_convert
-- ----------------------------
INSERT INTO `motor_convert` VALUES (1, 'AxisX', 4000.000);
INSERT INTO `motor_convert` VALUES (2, 'AxisY', 4000.000);
INSERT INTO `motor_convert` VALUES (3, 'AxisZ', 4000.000);

-- ----------------------------
-- Table structure for motor_move_status
-- ----------------------------
DROP TABLE IF EXISTS `motor_move_status`;
CREATE TABLE `motor_move_status`  (
  `SerialKey` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `MotorName` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '电机名称',
  `CurrentPosition` double(8, 3) NULL DEFAULT NULL COMMENT '当前位置',
  `Description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '描述',
  PRIMARY KEY (`SerialKey`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of motor_move_status
-- ----------------------------
INSERT INTO `motor_move_status` VALUES (1, 'AxisX', 300.000, 'X轴');
INSERT INTO `motor_move_status` VALUES (2, 'AxisY', 95.000, 'Y轴');
INSERT INTO `motor_move_status` VALUES (3, 'AxisZ', 0.000, 'Z轴');

-- ----------------------------
-- Table structure for motor_speed
-- ----------------------------
DROP TABLE IF EXISTS `motor_speed`;
CREATE TABLE `motor_speed`  (
  `SerialKey` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `DetailName` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '描述名称',
  `SystemName` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '系统名称',
  `Speed` int(0) NULL DEFAULT NULL COMMENT '速度',
  `AcSpeed` int(0) NULL DEFAULT NULL COMMENT '加速度',
  `DeSpeed` int(0) NULL DEFAULT NULL COMMENT '减速度',
  `ConnectAutoUpdate` int(0) NULL DEFAULT NULL COMMENT '连接成功后自动更新',
  PRIMARY KEY (`SerialKey`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of motor_speed
-- ----------------------------
INSERT INTO `motor_speed` VALUES (1, 'X轴', 'AxisX', 6, 420, 420, 1);
INSERT INTO `motor_speed` VALUES (2, 'Y轴', 'AxisY', 8, 420, 420, 1);
INSERT INTO `motor_speed` VALUES (3, 'Z轴', 'AxisZ', 8, 420, 420, 1);
INSERT INTO `motor_speed` VALUES (4, '草酸钠', 'SodiumOxalate', 2, 420, 420, 1);
INSERT INTO `motor_speed` VALUES (5, '加液位高锰酸钾', 'AddLiquidPotassiumPermanganate', 2, 420, 420, 1);
INSERT INTO `motor_speed` VALUES (6, '滴定位高锰酸钾', 'TitrationPotassiumPermanganate', 3, 420, 420, 1);

-- ----------------------------
-- Table structure for pid
-- ----------------------------
DROP TABLE IF EXISTS `pid`;
CREATE TABLE `pid`  (
  `SerialKey` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `TypeName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '类型名称',
  `Ratio` double(8, 3) NOT NULL COMMENT '比例',
  `Integral` int(0) NULL DEFAULT NULL COMMENT '积分',
  `Differential` int(0) NULL DEFAULT NULL COMMENT '微分',
  `IntegralDeafult` double(8, 3) NULL DEFAULT NULL COMMENT '积分默认值',
  `Description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '描述',
  PRIMARY KEY (`SerialKey`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of pid
-- ----------------------------
INSERT INTO `pid` VALUES (1, 'DissolveHeating', 15.500, 38, 9, 72.500, '消解加热');
INSERT INTO `pid` VALUES (2, 'TitrationHeating', 13.000, 12, 9, 72.500, '滴定加热');

-- ----------------------------
-- Table structure for position_hotlist
-- ----------------------------
DROP TABLE IF EXISTS `position_hotlist`;
CREATE TABLE `position_hotlist`  (
  `SerialKey` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `PositionName` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '位置名称',
  `CurrentOccupy` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '当前占位',
  `Enable` int(0) NULL DEFAULT NULL COMMENT '启用',
  PRIMARY KEY (`SerialKey`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of position_hotlist
-- ----------------------------
INSERT INTO `position_hotlist` VALUES (1, 'R1', '', 1);
INSERT INTO `position_hotlist` VALUES (2, 'R2', '', 1);
INSERT INTO `position_hotlist` VALUES (3, 'R3', '', 1);
INSERT INTO `position_hotlist` VALUES (4, 'R4', '', 1);
INSERT INTO `position_hotlist` VALUES (5, 'R5', '', 1);
INSERT INTO `position_hotlist` VALUES (6, 'R6', '', 1);
INSERT INTO `position_hotlist` VALUES (7, 'R7', '', 1);
INSERT INTO `position_hotlist` VALUES (8, 'R8', '', 1);
INSERT INTO `position_hotlist` VALUES (9, 'R9', '', 1);
INSERT INTO `position_hotlist` VALUES (10, 'C1', '', 1);
INSERT INTO `position_hotlist` VALUES (11, 'D1', '', 1);
INSERT INTO `position_hotlist` VALUES (12, 'L1', '', 1);

-- ----------------------------
-- Table structure for route
-- ----------------------------
DROP TABLE IF EXISTS `route`;
CREATE TABLE `route`  (
  `Serialkey` int(0) NOT NULL AUTO_INCREMENT,
  `TaskType` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `RouteID` int(0) NULL DEFAULT NULL,
  `RouteType` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '',
  `Description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '',
  PRIMARY KEY (`Serialkey`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of route
-- ----------------------------
INSERT INTO `route` VALUES (1, 'Sample', 1, 'AddLiquid', NULL);
INSERT INTO `route` VALUES (2, 'Sample', 2, 'Dissolve', NULL);
INSERT INTO `route` VALUES (3, 'Sample', 3, 'Titration', NULL);
INSERT INTO `route` VALUES (14, 'Wash', 4, 'Wash', '');

-- ----------------------------
-- Table structure for routecache
-- ----------------------------
DROP TABLE IF EXISTS `routecache`;
CREATE TABLE `routecache`  (
  `SerialKey` int(0) NOT NULL AUTO_INCREMENT,
  `CreateTime` datetime(0) NULL DEFAULT '0001-01-01 00:00:00',
  `Source` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `RouteID` int(0) NULL DEFAULT NULL,
  `RouteStep` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `Status` int(0) NULL DEFAULT NULL,
  PRIMARY KEY (`SerialKey`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 642 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of routecache
-- ----------------------------

-- ----------------------------
-- Table structure for routestep
-- ----------------------------
DROP TABLE IF EXISTS `routestep`;
CREATE TABLE `routestep`  (
  `SerialKey` int(0) NOT NULL AUTO_INCREMENT,
  `RouteID` int(0) NULL DEFAULT NULL,
  `Order` int(0) NULL DEFAULT NULL,
  `Step` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `From` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `To` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `Description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`SerialKey`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of routestep
-- ----------------------------
INSERT INTO `routestep` VALUES (1, 1, 1, 'AddLiquid', 'Source', 'AddLiquidPosition', NULL);
INSERT INTO `routestep` VALUES (2, 1, 2, 'Goback', 'AddLiquidPosition', 'Source', NULL);
INSERT INTO `routestep` VALUES (3, 2, 1, 'Dissolve', 'Source', 'DissolvePosition', NULL);
INSERT INTO `routestep` VALUES (4, 2, 2, 'DissolveGoback', 'DissolvePosition', 'DewaterPosition', NULL);
INSERT INTO `routestep` VALUES (5, 3, 1, 'Titration', 'DewaterPosition', 'TitrationPosition', NULL);
INSERT INTO `routestep` VALUES (6, 3, 2, 'Goback', 'TitrationPosition', 'Source', NULL);
INSERT INTO `routestep` VALUES (7, 4, 1, 'Wash', 'Source', 'Source', NULL);

-- ----------------------------
-- Table structure for sampledetails
-- ----------------------------
DROP TABLE IF EXISTS `sampledetails`;
CREATE TABLE `sampledetails`  (
  `Serialkey` int(0) NOT NULL AUTO_INCREMENT,
  `AreaPosition` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '区域位置',
  `NodeName` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '节点名称',
  `DetailInfo` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '详情信息',
  `SampleVolume` double(8, 3) NULL DEFAULT NULL COMMENT '取样体积',
  `SampleMultiple` double(8, 3) NULL DEFAULT NULL COMMENT '取样倍数',
  `SampleType` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '样品类型',
  `AcidBaseProp` int(0) NULL DEFAULT NULL COMMENT '酸碱性',
  `IsCalibration` int(0) NULL DEFAULT NULL COMMENT '是否标定',
  `QuicklyTitration` int(0) NULL DEFAULT NULL COMMENT '快速滴定',
  `TaskStatus` int(0) NULL DEFAULT NULL COMMENT '任务状态',
  PRIMARY KEY (`Serialkey`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 79 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sampledetails
-- ----------------------------
INSERT INTO `sampledetails` VALUES (1, 'Left', 'A1', '10161218', 100.000, 0.000, '样品', 1, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (2, 'Left', 'A2', '10141332', 0.200, 0.000, '样品', 1, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (3, 'Left', 'A3', '10151252', 10.000, 0.900, '样品', 1, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (4, 'Left', 'A4', '10155538', 0.200, 0.000, '样品', 1, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (5, 'Left', 'A5', '09140241', 0.200, 0.000, '样品', 2, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (6, 'Left', 'A6', '09100158', 0.200, 0.000, '酸性', NULL, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (7, 'Left', 'A7', '09231931', 0.200, 0.000, '样品', 1, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (8, 'Left', 'A8', '10134455', 0.200, 0.000, '样品', 1, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (9, 'Left', 'A9', '09260543', 0.200, 0.000, '样品', 1, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (10, 'Left', 'A10', '09145449', 0.200, 0.000, '样品', NULL, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (11, 'Left', 'A11', '09132445', 0.200, 0.000, '酸性', NULL, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (12, 'Left', 'A12', '09231935', 0.200, 0.000, '样品', 1, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (13, 'Left', 'A13', '09260545', 0.200, 0.000, '样品', 1, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (14, 'Left', 'A14', '09233257', 0.200, 0.000, '样品', 1, 1, 0, 0);
INSERT INTO `sampledetails` VALUES (15, 'Left', 'A15', '09101321', 0.200, 0.000, '酸性', NULL, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (16, 'Left', 'A16', '09101324', 0.200, 0.000, '酸性', NULL, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (17, 'Left', 'A17', '09101325', 0.200, 0.000, '酸性', NULL, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (18, 'Left', 'A18', '09231937', 0.200, 0.000, '样品', 1, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (19, 'Left', 'A19', '09101330', 0.200, 0.000, '酸性', NULL, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (20, 'Left', 'A20', '09092350', 0.200, 0.000, '酸性', NULL, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (21, 'Left', 'A21', '08195412', 10.000, 0.000, '土样', NULL, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (22, 'Left', 'A22', '09083526', 0.200, 0.000, '酸性', NULL, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (23, 'Left', 'A23', '08195416', 10.000, 0.000, '土样', NULL, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (24, 'Left', 'A24', '08195423', 10.000, 0.000, '土样', NULL, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (25, 'Left', 'A25', '08195427', 10.000, 0.000, '土样', NULL, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (26, 'Left', 'A26', '08195430', 10.000, 0.000, '土样', NULL, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (27, 'Left', 'A27', '08195433', 10.000, 0.000, '土样', NULL, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (28, 'Left', 'A28', '08195436', 10.000, 0.000, '土样', NULL, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (29, 'Left', 'A29', '08195439', 10.000, 0.000, '土样', NULL, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (30, 'Left', 'A30', '08195441', 10.000, 0.000, '土样', NULL, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (31, 'Left', 'A31', '08195444', 10.000, 0.000, '土样', NULL, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (32, 'Left', 'A32', '08195448', 10.000, 0.000, '土样', NULL, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (33, 'Left', 'A33', '08195454', 10.000, 0.000, '土样', NULL, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (34, 'Left', 'A34', '08195459', 10.000, 0.000, '土样', NULL, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (35, 'Left', 'A35', '08195506', 10.000, 0.000, '土样', NULL, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (36, 'Right', 'A36', '09104113', 0.200, 0.000, '酸性', NULL, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (37, 'Right', 'A37', '10151553', 10.000, 0.900, '样品', 1, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (38, 'Right', 'A38', '08195516', 10.000, 0.000, '土样', NULL, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (39, 'Right', 'A39', '08195521', 10.000, 0.000, '土样', NULL, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (40, 'Right', 'A40', '08195525', 10.000, 0.000, '土样', NULL, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (41, 'Right', 'A41', '09102853', 0.200, 0.000, '酸性', NULL, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (42, 'Right', 'A42', '08195534', 10.000, 0.000, '土样', NULL, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (43, 'Right', 'A43', '08195537', 10.000, 0.000, '土样', NULL, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (44, 'Right', 'A44', '08195540', 10.000, 0.000, '土样', NULL, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (45, 'Right', 'A45', '08195542', 10.000, 0.000, '土样', NULL, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (46, 'Right', 'A46', '08195545', 10.000, 0.000, '土样', NULL, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (47, 'Right', 'A47', '08195547', 10.000, 0.000, '土样', NULL, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (48, 'Right', 'A48', '08195550', 10.000, 0.000, '土样', NULL, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (49, 'Right', 'A49', '08195636', 10.000, 0.000, '土样', NULL, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (50, 'Right', 'A50', '08195640', 10.000, 0.000, '土样', NULL, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (51, 'Right', 'A51', '03185904', 10.000, 0.000, '土样', NULL, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (52, 'Right', 'A52', '03185915', 10.000, 0.000, '土样', NULL, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (53, 'Right', 'A53', '03185924', 10.000, 0.000, '土样', NULL, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (54, 'Right', 'A54', '03185933', 10.000, 0.000, '土样', NULL, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (55, 'Right', 'A55', '03185849', 10.000, 0.000, '土样', NULL, 0, 0, 0);

-- ----------------------------
-- Table structure for statemachine
-- ----------------------------
DROP TABLE IF EXISTS `statemachine`;
CREATE TABLE `statemachine`  (
  `SerialKey` int(0) NOT NULL AUTO_INCREMENT,
  `Name` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `Status` int(0) NULL DEFAULT NULL,
  PRIMARY KEY (`SerialKey`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of statemachine
-- ----------------------------
INSERT INTO `statemachine` VALUES (1, 'MotorLock', 0);

-- ----------------------------
-- Table structure for task_priority
-- ----------------------------
DROP TABLE IF EXISTS `task_priority`;
CREATE TABLE `task_priority`  (
  `SerialKey` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `Step` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '操作类型',
  `Priority` int(0) NULL DEFAULT NULL COMMENT '优先级',
  PRIMARY KEY (`SerialKey`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of task_priority
-- ----------------------------
INSERT INTO `task_priority` VALUES (1, 'Titration', 500);
INSERT INTO `task_priority` VALUES (2, 'DissolveGoback', 400);
INSERT INTO `task_priority` VALUES (3, 'Dissolve', 300);
INSERT INTO `task_priority` VALUES (7, 'Goback', 200);
INSERT INTO `task_priority` VALUES (8, 'AddLiquid', 100);

-- ----------------------------
-- Table structure for titration_value
-- ----------------------------
DROP TABLE IF EXISTS `titration_value`;
CREATE TABLE `titration_value`  (
  `SerialKey` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键自增',
  `TitrationType` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '滴定类型',
  `RangeValue` double(5, 2) NULL DEFAULT NULL COMMENT '阈值',
  `BeforeWaitTime` int(0) NULL DEFAULT NULL COMMENT '滴定前等待时间',
  `ArriveCheckCount` int(0) NULL DEFAULT NULL COMMENT '到达阈值后的检查次数',
  `MaxDropVolume` double(5, 3) NULL DEFAULT NULL COMMENT '最大滴定体积',
  `QuicklyTitrationValue` double(5, 3) NULL DEFAULT NULL COMMENT '快速滴定值',
  `Description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '描述',
  PRIMARY KEY (`SerialKey`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of titration_value
-- ----------------------------
INSERT INTO `titration_value` VALUES (1, 'Default', 50.00, 10, 10, 2.000, 15.000, '默认');

-- ----------------------------
-- Table structure for wavekey
-- ----------------------------
DROP TABLE IF EXISTS `wavekey`;
CREATE TABLE `wavekey`  (
  `SerialKey` int(0) NOT NULL AUTO_INCREMENT,
  `WaveKey` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '波次号',
  `FinishValue` int(0) NULL DEFAULT NULL COMMENT '完成值',
  `TotalValue` int(0) NULL DEFAULT NULL COMMENT '总数',
  `State` int(0) NULL DEFAULT NULL COMMENT '状态',
  PRIMARY KEY (`SerialKey`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 235 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of wavekey
-- ----------------------------
INSERT INTO `wavekey` VALUES (208, '20211010001', 0, 0, 0);
INSERT INTO `wavekey` VALUES (209, '20211012001', 0, 0, 0);
INSERT INTO `wavekey` VALUES (210, '20211012002', 0, 0, 0);
INSERT INTO `wavekey` VALUES (211, '20211012003', 0, 0, 0);
INSERT INTO `wavekey` VALUES (212, '20211013001', 0, 0, 0);
INSERT INTO `wavekey` VALUES (213, '20211013002', 0, 0, 0);
INSERT INTO `wavekey` VALUES (214, '20211013003', 0, 0, 0);
INSERT INTO `wavekey` VALUES (215, '20211013004', 0, 0, 0);
INSERT INTO `wavekey` VALUES (216, '20211013005', 0, 0, 0);
INSERT INTO `wavekey` VALUES (217, '20211013006', 0, 0, 0);
INSERT INTO `wavekey` VALUES (218, '20211013007', 0, 0, 0);
INSERT INTO `wavekey` VALUES (219, '20211013008', 0, 0, 0);
INSERT INTO `wavekey` VALUES (220, '20211013009', 0, 0, 0);
INSERT INTO `wavekey` VALUES (221, '20211013010', 0, 0, 0);
INSERT INTO `wavekey` VALUES (222, '20211013011', 0, 0, 0);
INSERT INTO `wavekey` VALUES (223, '20211013012', 0, 0, 0);
INSERT INTO `wavekey` VALUES (224, '20211013013', 0, 0, 0);
INSERT INTO `wavekey` VALUES (225, '20211013014', 0, 0, 0);
INSERT INTO `wavekey` VALUES (226, '20211013015', 0, 0, 0);
INSERT INTO `wavekey` VALUES (227, '20211013016', 0, 0, 0);
INSERT INTO `wavekey` VALUES (228, '20211014001', 0, 0, 0);
INSERT INTO `wavekey` VALUES (229, '20211014002', 0, 0, 0);
INSERT INTO `wavekey` VALUES (230, '20211014003', 0, 0, 0);
INSERT INTO `wavekey` VALUES (231, '20211014004', 0, 0, 0);
INSERT INTO `wavekey` VALUES (232, '20211014005', 0, 0, 0);
INSERT INTO `wavekey` VALUES (233, '20211014006', 0, 0, 0);
INSERT INTO `wavekey` VALUES (234, '20211014007', 0, 0, 0);
INSERT INTO `wavekey` VALUES (235, '20211016001', 0, 0, 0);

SET FOREIGN_KEY_CHECKS = 1;