/* 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;