SHJX_GM/SHJX.Service.Shell/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: 12/02/2022 15:45:42
*/

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 = 20 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of batch
-- ----------------------------
INSERT INTO `batch` VALUES (20, '2022-01-11 13:02:44', 3);

-- ----------------------------
-- 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 '地址名称',
  `SampleSource` 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 = 9 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of dissolve_date
-- ----------------------------
INSERT INTO `dissolve_date` VALUES (1, 'R1', '', '2022-01-11 16:15:22', 0);
INSERT INTO `dissolve_date` VALUES (2, 'R2', '', '2022-01-11 16:28:53', 0);
INSERT INTO `dissolve_date` VALUES (3, 'R3', '', '2022-01-11 16:35:30', 0);
INSERT INTO `dissolve_date` VALUES (4, 'R4', '', '2021-11-29 16:02:22', 0);
INSERT INTO `dissolve_date` VALUES (5, 'R5', '', '2021-11-29 16:09:03', 0);
INSERT INTO `dissolve_date` VALUES (6, 'R6', '', '2021-10-25 18:10:25', 0);
INSERT INTO `dissolve_date` VALUES (7, 'R7', '', '2021-10-27 18:47:47', 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, '2022-01-11 16:35:30');

-- ----------------------------
-- 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', 2.500, 6.800, 205.000, 1);
INSERT INTO `equipment_area` VALUES (2, 'SamplePosition', 'A2', 30.900, 6.800, 205.000, 1);
INSERT INTO `equipment_area` VALUES (3, 'SamplePosition', 'A3', 59.700, 6.800, 205.000, 1);
INSERT INTO `equipment_area` VALUES (4, 'SamplePosition', 'A4', 88.100, 6.800, 205.000, 1);
INSERT INTO `equipment_area` VALUES (5, 'SamplePosition', 'A5', 116.500, 6.800, 205.000, 1);
INSERT INTO `equipment_area` VALUES (6, 'SamplePosition', 'A6', 2.500, 36.100, 205.000, 1);
INSERT INTO `equipment_area` VALUES (7, 'SamplePosition', 'A7', 31.000, 36.000, 205.000, 1);
INSERT INTO `equipment_area` VALUES (8, 'SamplePosition', 'A8', 59.700, 35.800, 205.000, 1);
INSERT INTO `equipment_area` VALUES (9, 'SamplePosition', 'A9', 88.100, 35.800, 205.000, 1);
INSERT INTO `equipment_area` VALUES (10, 'SamplePosition', 'A10', 116.500, 36.100, 205.000, 1);
INSERT INTO `equipment_area` VALUES (11, 'SamplePosition', 'A11', 2.500, 64.900, 205.000, 1);
INSERT INTO `equipment_area` VALUES (12, 'SamplePosition', 'A12', 30.900, 64.900, 205.000, 1);
INSERT INTO `equipment_area` VALUES (13, 'SamplePosition', 'A13', 59.700, 64.900, 205.000, 1);
INSERT INTO `equipment_area` VALUES (14, 'SamplePosition', 'A14', 88.100, 64.900, 205.000, 1);
INSERT INTO `equipment_area` VALUES (15, 'SamplePosition', 'A15', 116.500, 64.900, 205.000, 1);
INSERT INTO `equipment_area` VALUES (16, 'SamplePosition', 'A16', 2.500, 94.000, 205.000, 1);
INSERT INTO `equipment_area` VALUES (17, 'SamplePosition', 'A17', 30.900, 94.000, 205.000, 1);
INSERT INTO `equipment_area` VALUES (18, 'SamplePosition', 'A18', 59.700, 94.000, 205.000, 1);
INSERT INTO `equipment_area` VALUES (19, 'SamplePosition', 'A19', 88.100, 94.000, 205.000, 1);
INSERT INTO `equipment_area` VALUES (20, 'SamplePosition', 'A20', 116.500, 94.000, 205.000, 1);
INSERT INTO `equipment_area` VALUES (21, 'SamplePosition', 'A21', 2.500, 122.900, 180.000, 1);
INSERT INTO `equipment_area` VALUES (22, 'SamplePosition', 'A22', 30.900, 122.900, 180.000, 1);
INSERT INTO `equipment_area` VALUES (23, 'SamplePosition', 'A23', 59.700, 122.900, 180.000, 1);
INSERT INTO `equipment_area` VALUES (24, 'SamplePosition', 'A24', 88.100, 122.900, 180.000, 1);
INSERT INTO `equipment_area` VALUES (25, 'SamplePosition', 'A25', 116.500, 122.900, 180.000, 1);
INSERT INTO `equipment_area` VALUES (26, 'SamplePosition', 'A26', 2.500, 151.700, 180.000, 1);
INSERT INTO `equipment_area` VALUES (27, 'SamplePosition', 'A27', 30.900, 151.700, 180.000, 1);
INSERT INTO `equipment_area` VALUES (28, 'SamplePosition', 'A28', 59.700, 151.700, 180.000, 1);
INSERT INTO `equipment_area` VALUES (29, 'SamplePosition', 'A29', 88.100, 151.700, 180.000, 1);
INSERT INTO `equipment_area` VALUES (30, 'SamplePosition', 'A30', 116.500, 151.700, 180.000, 1);
INSERT INTO `equipment_area` VALUES (31, 'SamplePosition', 'A31', 1.200, 180.800, 180.000, 1);
INSERT INTO `equipment_area` VALUES (32, 'SamplePosition', 'A32', 30.200, 180.800, 180.000, 1);
INSERT INTO `equipment_area` VALUES (33, 'SamplePosition', 'A33', 59.000, 180.800, 180.000, 1);
INSERT INTO `equipment_area` VALUES (34, 'SamplePosition', 'A34', 87.400, 180.800, 180.000, 1);
INSERT INTO `equipment_area` VALUES (35, 'SamplePosition', 'A35', 115.800, 180.800, 180.000, 1);
INSERT INTO `equipment_area` VALUES (36, 'SamplePosition', 'A36', 153.600, 91.600, 180.000, 1);
INSERT INTO `equipment_area` VALUES (37, 'SamplePosition', 'A37', 182.100, 91.425, 180.000, 1);
INSERT INTO `equipment_area` VALUES (38, 'SamplePosition', 'A38', 210.600, 91.250, 180.000, 1);
INSERT INTO `equipment_area` VALUES (39, 'SamplePosition', 'A39', 239.100, 91.075, 180.000, 1);
INSERT INTO `equipment_area` VALUES (40, 'SamplePosition', 'A40', 267.600, 90.900, 180.000, 1);
INSERT INTO `equipment_area` VALUES (41, 'SamplePosition', 'A41', 153.567, 121.500, 180.000, 1);
INSERT INTO `equipment_area` VALUES (42, 'SamplePosition', 'A42', 182.017, 121.075, 180.000, 1);
INSERT INTO `equipment_area` VALUES (43, 'SamplePosition', 'A43', 210.467, 120.650, 180.000, 1);
INSERT INTO `equipment_area` VALUES (44, 'SamplePosition', 'A44', 238.917, 120.225, 180.000, 1);
INSERT INTO `equipment_area` VALUES (45, 'SamplePosition', 'A45', 267.367, 119.800, 180.000, 1);
INSERT INTO `equipment_area` VALUES (46, 'SamplePosition', 'A46', 153.533, 151.400, 180.000, 1);
INSERT INTO `equipment_area` VALUES (47, 'SamplePosition', 'A47', 181.933, 150.725, 180.000, 1);
INSERT INTO `equipment_area` VALUES (48, 'SamplePosition', 'A48', 210.333, 150.050, 180.000, 1);
INSERT INTO `equipment_area` VALUES (49, 'SamplePosition', 'A49', 238.733, 149.375, 180.000, 1);
INSERT INTO `equipment_area` VALUES (50, 'SamplePosition', 'A50', 267.133, 148.700, 180.000, 1);
INSERT INTO `equipment_area` VALUES (51, 'SamplePosition', 'A51', 153.500, 181.300, 180.000, 1);
INSERT INTO `equipment_area` VALUES (52, 'SamplePosition', 'A52', 181.850, 180.375, 180.000, 1);
INSERT INTO `equipment_area` VALUES (53, 'SamplePosition', 'A53', 210.200, 179.450, 180.000, 1);
INSERT INTO `equipment_area` VALUES (54, 'SamplePosition', 'A54', 238.550, 178.525, 180.000, 1);
INSERT INTO `equipment_area` VALUES (55, 'SamplePosition', 'A55', 266.900, 177.600, 180.000, 1);
INSERT INTO `equipment_area` VALUES (79, 'DissolvePosition', 'R1', 309.400, 48.000, 205.000, 1);
INSERT INTO `equipment_area` VALUES (80, 'DissolvePosition', 'R2', 309.400, 81.200, 202.000, 1);
INSERT INTO `equipment_area` VALUES (81, 'DissolvePosition', 'R3', 348.600, 80.475, 202.000, 1);
INSERT INTO `equipment_area` VALUES (82, 'DissolvePosition', 'R4', 309.000, 114.350, 202.000, 1);
INSERT INTO `equipment_area` VALUES (83, 'DissolvePosition', 'R5', 348.000, 114.050, 202.000, 1);
INSERT INTO `equipment_area` VALUES (84, 'DissolvePosition', 'R6', 309.000, 147.300, 202.000, 1);
INSERT INTO `equipment_area` VALUES (85, 'DissolvePosition', 'R7', 346.125, 144.725, 180.000, 1);
INSERT INTO `equipment_area` VALUES (86, 'DissolvePosition', 'R8', 350.075, 114.350, 180.000, 1);
INSERT INTO `equipment_area` VALUES (87, 'DissolvePosition', 'R9', 345.075, 81.475, 180.000, 1);
INSERT INTO `equipment_area` VALUES (88, 'DewaterPosition', 'C1', 349.000, 47.700, 190.000, 1);
INSERT INTO `equipment_area` VALUES (89, 'TitrationPosition', 'D1', 228.700, 45.000, 200.000, 1);
INSERT INTO `equipment_area` VALUES (90, 'AddLiquidPosition', 'L1', 169.700, 43.300, 207.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 '开启标定',
  `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 = 4249 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of equipment_task
-- ----------------------------
INSERT INTO `equipment_task` VALUES (4238, '20220111001', 'A3', '2022-01-11 13:02:44', 4, 'D1', 'A3', 'To', 0.660, 0.000, 0, 3, 'Goback', 'ReleaseAxis', 'Sample', '空白', 1, '空白', 100.000, 0.000, 0, NULL, NULL, NULL);
INSERT INTO `equipment_task` VALUES (4239, '20220111001', 'A4', '2022-01-11 13:02:44', 4, 'D1', 'A4', 'To', 0.462, 0.000, 0, 3, 'Goback', 'ReleaseAxis', 'Sample', '空白', 1, '空白', 100.000, 0.000, 0, NULL, NULL, NULL);
INSERT INTO `equipment_task` VALUES (4240, '20220111001', 'A5', '2022-01-11 13:02:44', 4, 'D1', 'A5', 'To', 0.462, 0.000, 1, 3, 'Goback', 'ReleaseAxis', 'Sample', '空白', 1, '空白', 100.000, 0.000, 0, NULL, NULL, NULL);
INSERT INTO `equipment_task` VALUES (4241, '20220111001', 'A5', '2022-01-11 14:12:53', 4, 'A5', 'A5', 'From', 10.277, 0.000, 0, 0, 'Titration', '', 'Sample', '标定', 0, '标定', 0.000, 0.000, 1, NULL, NULL, NULL);
INSERT INTO `equipment_task` VALUES (4242, '20220111002', 'A4', '2022-01-11 15:14:41', 4, 'D1', 'A4', 'To', 0.462, 0.000, 0, 3, 'Goback', 'ReleaseAxis', 'Sample', '空白', 1, '空白', 100.000, 0.000, 0, NULL, NULL, NULL);
INSERT INTO `equipment_task` VALUES (4243, '20220111002', 'A5', '2022-01-11 15:14:41', 4, 'D1', 'A5', 'To', 0.528, 0.000, 0, 3, 'Goback', 'ReleaseAxis', 'Sample', '空白', 1, '空白', 100.000, 0.000, 0, NULL, NULL, NULL);
INSERT INTO `equipment_task` VALUES (4244, '20220111002', 'A6', '2022-01-11 15:14:41', 4, 'D1', 'A6', 'To', 0.495, 0.000, 0, 3, 'Goback', 'ReleaseAxis', 'Sample', '空白', 1, '空白', 100.000, 0.000, 0, NULL, NULL, NULL);
INSERT INTO `equipment_task` VALUES (4245, '20220111002', 'A7', '2022-01-11 16:11:34', 4, 'D1', 'A7', 'To', 0.561, 0.000, 1, 3, 'Goback', 'ReleaseAxis', 'Sample', '空白', 1, '空白', 100.000, 0.000, 0, NULL, NULL, NULL);
INSERT INTO `equipment_task` VALUES (4246, '20220111002', 'A8', '2022-01-11 16:25:57', 4, 'D1', 'A8', 'To', 3.828, 2.054, 0, 3, 'Goback', 'ReleaseAxis', 'Sample', '样品', 1, '203195', 100.000, 0.000, 0, NULL, NULL, NULL);
INSERT INTO `equipment_task` VALUES (4247, '20220111002', 'A9', '2022-01-11 16:30:06', 4, 'D1', 'A9', 'To', 3.894, 2.102, 0, 3, 'Goback', 'ReleaseAxis', 'Sample', '样品', 1, '203195', 100.000, 0.000, 0, NULL, NULL, NULL);
INSERT INTO `equipment_task` VALUES (4248, '20220111002', 'A7', '2022-01-11 16:48:48', 4, 'A7', 'A7', 'From', 11.003, 0.000, 0, 0, 'Titration', '', 'Sample', '标定', 0, '标定', 0.000, 0.000, 1, NULL, NULL, NULL);
INSERT INTO `equipment_task` VALUES (4249, '20220111003', 'A3', '2022-01-11 17:15:47', 10, 'A3', 'L1', 'To', 0.000, 0.000, 1, 1, 'AddLiquid', 'AddLiquidH2SO4', 'Sample', '空白', 1, '空白', 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 = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of execute_time
-- ----------------------------
INSERT INTO `execute_time` VALUES (1, 'DissolveTime', 30.00, '消解时间（min）');
INSERT INTO `execute_time` VALUES (3, 'DissolveInterval', 6.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 = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of liquid_amount
-- ----------------------------
INSERT INTO `liquid_amount` VALUES (1, 'SodiumOxalate', 10.00000, 0.65060, 20000, '草酸钠');
INSERT INTO `liquid_amount` VALUES (2, 'AddLiquidPotassiumPermanganate', 5.00000, 0.33200, 20000, '高锰酸钾（加液）');
INSERT INTO `liquid_amount` VALUES (3, 'TitrationPotassiumPermanganate', 10.00000, 0.03300, 1000, '高锰酸钾（滴定）');
INSERT INTO `liquid_amount` VALUES (4, 'Titration2PotassiumPermanganate', 10.00000, 0.03300, 1000, '高锰酸钾（滴定2）');

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

-- ----------------------------
-- Records of liquid_record
-- ----------------------------

-- ----------------------------
-- 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 = 11 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of liquid_volume
-- ----------------------------
INSERT INTO `liquid_volume` VALUES (6, 'SodiumOxalate', 10.000, 10.000, 1, '草酸钠（ml）');
INSERT INTO `liquid_volume` VALUES (7, 'SodiumHydroxide', 30.000, 1.000, 1, '氢氧化钠（s）');
INSERT INTO `liquid_volume` VALUES (8, 'AddLiquidPotassiumPermanganate', 5.000, 10.000, 1, '加液位高锰酸钾（ml）');
INSERT INTO `liquid_volume` VALUES (9, 'AddLiquidVitriol', 30.000, 8.000, 1, '加液位硫酸（s）');
INSERT INTO `liquid_volume` VALUES (10, 'TitrationPotassiumPermanganate', 10.000, 10.000, 1, '滴定位高锰酸钾（ml）');
INSERT INTO `liquid_volume` VALUES (11, 'TitrationVitriol', 30.000, 10.800, 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 = 3 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 AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of motor_move_status
-- ----------------------------
INSERT INTO `motor_move_status` VALUES (1, 'AxisX', 169.700, 'X轴');
INSERT INTO `motor_move_status` VALUES (2, 'AxisY', 43.300, '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 = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of motor_speed
-- ----------------------------
INSERT INTO `motor_speed` VALUES (1, 'X轴', 'AxisX', 9, 100, 50, 1);
INSERT INTO `motor_speed` VALUES (2, 'Y轴', 'AxisY', 6, 100, 50, 1);
INSERT INTO `motor_speed` VALUES (3, 'Z轴', 'AxisZ', 7, 300, 300, 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', 2, 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 = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of pid
-- ----------------------------
INSERT INTO `pid` VALUES (1, 'DissolveHeating', 18.000, 10, 3, 50.000, '消解加热');
INSERT INTO `pid` VALUES (2, 'TitrationHeating', 18.000, 12, 3, 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 = 13 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, 'D2', '', 1);
INSERT INTO `position_hotlist` VALUES (13, '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 = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of route
-- ----------------------------
INSERT INTO `route` VALUES (1, 'Sample', 1, 'AddLiquid', '加液');
INSERT INTO `route` VALUES (2, 'Sample', 2, 'Dissolve', '消解');
INSERT INTO `route` VALUES (3, 'Sample', 3, 'Titration', '滴定');

-- ----------------------------
-- 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,
  `TaskKey` int(0) 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 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 = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of routestep
-- ----------------------------
INSERT INTO `routestep` VALUES (1, 1, 1, 'AddLiquid', 'Source', 'AddLiquidPosition', '加液');
INSERT INTO `routestep` VALUES (2, 1, 2, 'Goback', 'AddLiquidPosition', 'Source', '返回');
INSERT INTO `routestep` VALUES (3, 2, 1, 'Dissolve', 'Source', 'DissolvePosition', '消解');
INSERT INTO `routestep` VALUES (4, 2, 2, 'DissolveGoback', 'DissolvePosition', 'DewaterPosition', '消解返回');
INSERT INTO `routestep` VALUES (5, 3, 1, 'Titration', 'DewaterPosition', 'TitrationPosition', '滴定');
INSERT INTO `routestep` VALUES (6, 3, 2, 'Goback', 'TitrationPosition', 'Source', '返回');

-- ----------------------------
-- 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 = 55 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sampledetails
-- ----------------------------
INSERT INTO `sampledetails` VALUES (1, 'Left', 'A1', '01081844', 100.000, 0.000, '样品', 1, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (2, 'Left', 'A2', '空白', 100.000, 0.000, '空白', 1, 1, 0, 0);
INSERT INTO `sampledetails` VALUES (3, 'Left', 'A3', '空白', 100.000, 0.000, '空白', 1, 1, 0, 0);
INSERT INTO `sampledetails` VALUES (4, 'Left', 'A4', '空白', 100.000, 0.000, '空白', 1, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (5, 'Left', 'A5', '空白', 100.000, 0.000, '空白', 1, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (6, 'Left', 'A6', '空白', 100.000, 0.000, '空白', 1, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (7, 'Left', 'A7', '空白', 100.000, 0.000, '空白', 1, 1, 0, 0);
INSERT INTO `sampledetails` VALUES (8, 'Left', 'A8', '203195', 100.000, 0.000, '样品', 1, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (9, 'Left', 'A9', '203195', 100.000, 0.000, '样品', 1, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (10, 'Left', 'A10', '11134555', 100.000, 0.000, '样品', 1, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (11, 'Left', 'A11', '11134557', 100.000, 0.000, '样品', 2, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (12, 'Left', 'A12', '11134600', 100.000, 0.000, '样品', 2, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (13, 'Left', 'A13', '11134602', 100.000, 0.000, '样品', 2, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (14, 'Left', 'A14', '11134605', 100.000, 0.000, '样品', 2, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (15, 'Left', 'A15', '11134607', 100.000, 0.000, '样品', 2, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (16, 'Left', 'A16', '11134609', 100.000, 0.000, '样品', 2, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (17, 'Left', 'A17', '11134612', 100.000, 0.000, '样品', 2, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (18, 'Left', 'A18', '11134614', 100.000, 0.000, '样品', 2, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (19, 'Left', 'A19', '11134617', 100.000, 0.000, '样品', 2, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (20, 'Left', 'A20', '11134619', 100.000, 0.000, '样品', 2, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (21, 'Left', 'A21', '11134621', 100.000, 0.000, '样品', 2, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (22, 'Left', 'A22', '11134624', 100.000, 0.000, '样品', 2, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (23, 'Left', 'A23', '11134626', 100.000, 0.000, '样品', 2, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (24, 'Left', 'A24', '11134628', 100.000, 0.000, '样品', 2, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (25, 'Left', 'A25', '11134630', 100.000, 0.000, '样品', 2, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (26, 'Left', 'A26', '11134632', 100.000, 0.000, '样品', 1, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (27, 'Left', 'A27', '11134635', 100.000, 0.000, '样品', 1, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (28, 'Left', 'A28', '11134637', 100.000, 0.000, '样品', 1, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (29, 'Left', 'A29', '11134638', 100.000, 0.000, '样品', 1, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (30, 'Left', 'A30', '11134640', 100.000, 0.000, '样品', 1, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (31, 'Left', 'A31', '11134641', 100.000, 0.000, '样品', 1, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (32, 'Left', 'A32', '11134649', 100.000, 0.000, '样品', 1, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (33, 'Left', 'A33', '11134650', 100.000, 0.000, '样品', 1, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (34, 'Left', 'A34', '11134652', 100.000, 0.000, '样品', 1, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (35, 'Left', 'A35', '空白', 100.000, 0.000, '空白', 1, 1, 0, 0);
INSERT INTO `sampledetails` VALUES (36, 'Right', 'A36', '空白', 100.000, 0.000, '空白', 1, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (37, 'Right', 'A37', '空白', 100.000, 0.000, '空白', 2, 1, 0, 0);
INSERT INTO `sampledetails` VALUES (38, 'Right', 'A38', '11134702', 100.000, 0.000, '样品', 2, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (39, 'Right', 'A39', '11134704', 100.000, 0.000, '样品', 2, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (40, 'Right', 'A40', '11134706', 100.000, 0.000, '样品', 2, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (41, 'Right', 'A41', '11134710', 100.000, 0.000, '样品', 2, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (42, 'Right', 'A42', '11134713', 100.000, 0.000, '样品', 2, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (43, 'Right', 'A43', '11134715', 100.000, 0.000, '样品', 2, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (44, 'Right', 'A44', '11134717', 100.000, 0.000, '样品', 2, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (45, 'Right', 'A45', '11134720', 100.000, 0.000, '样品', 2, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (46, 'Right', 'A46', '11134723', 100.000, 0.000, '样品', 1, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (47, 'Right', 'A47', '11134725', 100.000, 0.000, '样品', 1, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (48, 'Right', 'A48', '11134727', 100.000, 0.000, '样品', 1, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (49, 'Right', 'A49', '11134729', 100.000, 0.000, '样品', 1, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (50, 'Right', 'A50', '11134730', 100.000, 0.000, '样品', 1, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (51, 'Right', 'A51', '11134732', 100.000, 0.000, '样品', 1, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (52, 'Right', 'A52', '11134734', 100.000, 0.000, '样品', 1, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (53, 'Right', 'A53', '11134736', 100.000, 0.000, '样品', 1, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (54, 'Right', 'A54', '空白', 100.000, 0.000, '空白', 1, 0, 0, 0);
INSERT INTO `sampledetails` VALUES (55, 'Right', 'A55', '空白', 100.000, 0.000, '空白', 1, 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 = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of statemachine
-- ----------------------------
INSERT INTO `statemachine` VALUES (1, 'MotorLock', 0);
INSERT INTO `statemachine` VALUES (2, 'SodiumOxalateLock', 0);
INSERT INTO `statemachine` VALUES (3, 'PotassiumPermanganateLock', 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 '到达阈值后的检查次数',
  `IntervalTime` int(0) NULL DEFAULT NULL COMMENT '间隔时间',
  `NormalMaxDropVolume` double(5, 3) NULL DEFAULT NULL COMMENT '正常最大滴定体积',
  `CalibrationMaxDropVolume` 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, 'Sample', 1.50, 5, 28, 300, 6.000, 11.000, 8.000, '样品');
INSERT INTO `titration_value` VALUES (2, 'Blank', 1.00, 5, 28, 300, 6.000, 11.000, 8.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 = 323 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of wavekey
-- ----------------------------
INSERT INTO `wavekey` VALUES (321, '20220111001', 0, 0, 0);
INSERT INTO `wavekey` VALUES (322, '20220111002', 0, 0, 0);
INSERT INTO `wavekey` VALUES (323, '20220111003', 0, 0, 0);

SET FOREIGN_KEY_CHECKS = 1;