SoftwareGroup/MassSpectrometer
5
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
master
MassSpectrometer/数据库/largesquareone.sql
T
lq 40a6cb3baf 初始化提交
2026-09-09 18:42:38 +08:00

225 lines
15 KiB
SQL
Raw Permalink Blame History

-- --------------------------------------------------------
-- 主机: 127.0.0.1
-- 服务器版本: 8.0.40 - MySQL Community Server - GPL
-- 服务器操作系统: Win64
-- HeidiSQL 版本: 12.8.0.6908
-- --------------------------------------------------------
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
-- 导出 largesquareone 的数据库结构
CREATE DATABASE IF NOT EXISTS `largesquareone` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */;
USE `largesquareone`;
-- 导出 表 largesquareone.agearentity 结构
CREATE TABLE IF NOT EXISTS `agearentity` (
`ID` int NOT NULL AUTO_INCREMENT,
`ChannelNo` varchar(10) DEFAULT NULL,
`TestTime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`RFID` varchar(50) DEFAULT NULL,
`BarCode` varchar(50) DEFAULT NULL,
`Result` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
`Remark` text,
`Flag` varchar(10) DEFAULT NULL,
PRIMARY KEY (`ID`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=205 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='agearentity 表';
-- 正在导出表 largesquareone.agearentity 的数据：~184 rows (大约)
INSERT INTO `agearentity` (`ID`, `ChannelNo`, `TestTime`, `RFID`, `BarCode`, `Result`, `Remark`, `Flag`) VALUES
(5, '1', '2026-09-05 10:12:26', '13319126', 'ERROR', 'NG', '进站失败', '2'),
(6, '2', '2026-09-03 10:12:26', '13310088', 'ERROR', 'NG', '进站失败', '2'),
(7, '3', '2026-09-03 10:12:26', '13310124', 'ERROR', 'NG', '进站失败', '2'),
(8, '4', '2026-09-03 10:12:26', '13310026', 'ERROR', 'NG', '进站失败', '2'),
(9, '5', '2026-09-03 10:12:26', '13311190', 'ERROR', 'NG', '进站失败', '2'),
(10, '6', '2026-09-03 10:12:26', '13313040', 'ERROR', 'NG', '进站失败', '2'),
(11, '7', '2026-09-03 10:12:26', '13310050', 'ERROR', 'NG', '进站失败', '2'),
(12, '8', '2026-09-03 10:12:26', '13312050', 'ERROR', 'NG', '进站失败', '2'),
(13, '1', '2026-09-05 10:16:06', '31131962', '0ZZCE11431B00SG430001823', 'OK,MES NG', '进站失败', '2'),
(14, '2', '2026-09-05 10:16:06', '31130088', '0ZZCE11431B00SG430001772', 'OK,MES NG', '进站失败', '2'),
(15, '3', '2026-09-05 10:16:06', '31131042', '0ZZCE11431B00SG450000385', 'OK,MES NG', '进站失败', '2'),
(16, '4', '2026-09-03 10:16:06', '31130062', '0ZZCE11431B00SG3L0001861', 'OK,MES NG', 'MES断连', '2'),
(17, '5', '2026-09-03 10:16:06', '31131109', '0ZZCE11431B00SG3L0002970', 'OK,MES NG', 'MES断连', '2'),
(18, '6', '2026-09-03 10:16:06', '31130304', '0ZZCE11431B00SG460001136', 'OK,MES NG', 'MES断连', '2'),
(19, '7', '2026-09-03 10:16:06', '31130005', '0ZZCE11431B00SG4A0003170', 'OK,MES NG', 'MES断连', '2'),
(20, '8', '2026-09-03 10:16:06', '31130205', '0ZZCE11431B00SG4A0005430', 'OK,MES NG', 'MES断连', '2'),
(21, '1', '2026-09-03 10:19:42', '31131962', 'ERROR', 'NG', '进站失败', '2');
-- 导出 表 largesquareone.alarmcountentry 结构
CREATE TABLE IF NOT EXISTS `alarmcountentry` (
`ID` int NOT NULL AUTO_INCREMENT,
`PLCAdress` char(10) DEFAULT NULL,
`AlarmContent` longtext,
`AlarmCount` int DEFAULT NULL,
`Class` char(10) DEFAULT NULL,
`AlarmTime` datetime DEFAULT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='AlarmCountEntry 表';
-- 正在导出表 largesquareone.alarmcountentry 的数据：~3 rows (大约)
INSERT INTO `alarmcountentry` (`ID`, `PLCAdress`, `AlarmContent`, `AlarmCount`, `Class`, `AlarmTime`) VALUES
(1, 'D10010.46', '1#包膜外拉膜杆切刀寿命预警', 2, '白班', '2025-02-11 09:00:01'),
(2, 'D10022.33', '上料6动子左压紧气缸到位异常i20.12', 3, '白班', '2025-02-11 09:00:11'),
(3, 'D10022.39', '上料4动子上下轴不在安全位 横移轴或者旋转轴不许动作', 6, '白班', '2025-02-11 09:01:11');
-- 导出 表 largesquareone.bgearentity 结构
CREATE TABLE IF NOT EXISTS `bgearentity` (
`ID` int NOT NULL AUTO_INCREMENT,
`ChannelNo` varchar(10) DEFAULT NULL COMMENT '通道号',
`TestTime` datetime DEFAULT NULL COMMENT '时间',
`MaterialCode` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '物料编码',
`RFID` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT 'RFID托杯码',
`BarCode` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '电芯码',
`CavityLeakageRateSetValue` varchar(50) DEFAULT NULL COMMENT '腔体漏率设定值',
`ProductLeakageRateSetValue` varchar(50) DEFAULT NULL COMMENT '产品漏率设定值',
`LeakPressureSetValue` varchar(50) DEFAULT NULL COMMENT '检漏口压力设定值',
`CavityLeakageRateActualValue` varchar(50) DEFAULT NULL COMMENT '腔体漏率实际值',
`ProductLeakageRateActualValue` varchar(50) DEFAULT NULL COMMENT '产品漏率实际值',
`LeakPressureActualValue` varchar(50) DEFAULT NULL COMMENT '检漏口压力实际值',
`PalletNumber` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '托盘号',
`Result` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '综合结果',
`Info` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT 'NG详情',
`Remark` text COMMENT '备注',
`Flag` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '出站是否上传MES',
`Flag1` varchar(10) DEFAULT NULL COMMENT '结果数据是否上传MES',
PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=143 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='BGearEntity 表';
-- 正在导出表 largesquareone.bgearentity 的数据：~134 rows (大约)
INSERT INTO `bgearentity` (`ID`, `ChannelNo`, `TestTime`, `MaterialCode`, `RFID`, `BarCode`, `CavityLeakageRateSetValue`, `ProductLeakageRateSetValue`, `LeakPressureSetValue`, `CavityLeakageRateActualValue`, `ProductLeakageRateActualValue`, `LeakPressureActualValue`, `PalletNumber`, `Result`, `Info`, `Remark`, `Flag`, `Flag1`) VALUES
(1, '1', '2026-09-05 08:10:10', '1', 'asd123', 'fhhg1241', '000000000000000.500', '1.000', '2.000', NULL, NULL, NULL, '1', 'OK', NULL, NULL, '1', NULL),
(2, '1', '2026-09-05 10:00:01', '1', 'asd123', 'fhhg1241', '000000000000000.500', '1.000', '2.000', NULL, NULL, NULL, '2', 'NG', NULL, '质谱捡漏结果NG', '1', NULL),
(3, '1', '2026-09-05 10:21:01', '1', 'asd123', 'fh2d1241', '000000000000000.500', '1.000', '2.000', NULL, NULL, NULL, '3', 'OK', NULL, 'OK; MES失败:出站失败; MES失败:产品结果加工参数接口发生异常：An error occurred while sending the request.', '2', '2'),
(4, '2', '2026-09-05 09:01:43', '1', 'ssss', 'dffffff', '000000000000000.500', '1.000', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1'),
(5, '3', '2026-09-03 09:02:18', '1', NULL, 'ggggg', NULL, NULL, NULL, NULL, NULL, NULL, '3', NULL, NULL, 'OK', '2', '2'),
(6, '5', '2026-09-03 09:02:42', '1', NULL, 'hhhhhh', NULL, NULL, NULL, NULL, NULL, NULL, '2', NULL, NULL, 'NG', '1', '2'),
(7, '1', '2026-09-05 10:51:11', '81028375', '', 'Z0CZ1E41130BS04G0F007788', '0', '0', '0', '0', '0', '0', 'ERROR', 'NG,数据异常', '数据异常', 'MES断连,数据异常', '2', '2');
-- 导出 表 largesquareone.hourprod 结构
CREATE TABLE IF NOT EXISTS `hourprod` (
`FDate` varchar(50) NOT NULL,
`FHour` int NOT NULL,
`ProdIn` int DEFAULT NULL,
`ProdOut` int DEFAULT NULL,
`TestTime` datetime DEFAULT NULL,
`Ppm` int DEFAULT NULL,
`JiaDL` decimal(20,6) DEFAULT NULL,
PRIMARY KEY (`FDate`,`FHour`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='存储每日产能';
-- 正在导出表 largesquareone.hourprod 的数据：~24 rows (大约)
INSERT INTO `hourprod` (`FDate`, `FHour`, `ProdIn`, `ProdOut`, `TestTime`, `Ppm`, `JiaDL`) VALUES
('2026-09-07', 23, 0, 0, '2026-09-08 00:29:56', 0, 0.000000),
('2026-09-08', 0, 0, 0, '2026-09-08 01:29:55', 0, 0.000000),
('2026-09-08', 1, 0, 0, '2026-09-08 02:29:55', 0, 0.000000),
('2026-09-08', 2, 0, 0, '2026-09-08 02:45:00', 0, 0.000000),
('2026-09-08', 3, 0, 0, '2026-09-08 04:15:40', 0, 0.000000),
('2026-09-08', 15, 0, 0, '2026-09-08 16:14:14', 0, 0.000000),
('2026-09-09', 13, 0, 0, '2026-09-09 14:30:00', 0, 0.000000),
('2026-09-09', 14, 0, 0, '2026-09-09 14:46:21', 0, 0.000000);
-- 导出 表 largesquareone.parambase 结构
CREATE TABLE IF NOT EXISTS `parambase` (
`fNo` int NOT NULL,
`Type` int NOT NULL,
`ParaName` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`Uint` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`Remark` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
PRIMARY KEY (`ParaName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-- 正在导出表 largesquareone.parambase 的数据：~0 rows (大约)
INSERT INTO `parambase` (`fNo`, `Type`, `ParaName`, `Uint`, `Remark`) VALUES
(1, 11, 'VOL', 'mV', '电压');
-- 导出 表 largesquareone.paramlist 结构
CREATE TABLE IF NOT EXISTS `paramlist` (
`ModelName` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`Type` int DEFAULT NULL,
`IsCheck` tinyint(1) DEFAULT NULL,
`ParaName` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`ParaValueMin` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`ParaValueMax` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`Uint` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`Remark` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`UpdateTime` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-- 正在导出表 largesquareone.paramlist 的数据：~0 rows (大约)
-- 导出 表 largesquareone.productmodel 结构
CREATE TABLE IF NOT EXISTS `productmodel` (
`ModelName` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`MaterialCode` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`Remark` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
PRIMARY KEY (`ModelName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-- 正在导出表 largesquareone.productmodel 的数据：~0 rows (大约)
INSERT INTO `productmodel` (`ModelName`, `MaterialCode`, `Remark`) VALUES
('MB56', '81028375', 'MB56');
-- 导出 表 largesquareone.sysadmin 结构
CREATE TABLE IF NOT EXISTS `sysadmin` (
`LoginId` int NOT NULL AUTO_INCREMENT,
`LoginName` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`LoginPwd` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`LoginUid` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`LoginLevel` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`SystemLog` int DEFAULT NULL,
`CPKData` int DEFAULT NULL,
`HistoryData` int DEFAULT NULL,
`ParamSet` int DEFAULT NULL,
`SystemSet` int DEFAULT NULL,
`UserManage` int DEFAULT NULL,
PRIMARY KEY (`LoginId`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-- 正在导出表 largesquareone.sysadmin 的数据：~2 rows (大约)
INSERT INTO `sysadmin` (`LoginId`, `LoginName`, `LoginPwd`, `LoginUid`, `LoginLevel`, `SystemLog`, `CPKData`, `HistoryData`, `ParamSet`, `SystemSet`, `UserManage`) VALUES
(1, 'admin', 'SLVQ4eqoJVM=', '123456', '管理员', 1, 1, 1, 1, 1, 1),
(2, '1', 'TdyBM6uGeJI=', '1', '管理员', 1, 1, 1, 1, 1, 1);
-- 导出 表 largesquareone.syslog 结构
CREATE TABLE IF NOT EXISTS `syslog` (
`Id` int NOT NULL AUTO_INCREMENT,
`InsertTime` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`Note` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`LogType` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`Operater` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`VarName` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`AlarmSet` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`AlarmValue` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`AlarmType` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=797 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='存储记录日志';
-- 正在导出表 largesquareone.syslog 的数据：~233 rows (大约)
INSERT INTO `syslog` (`Id`, `InsertTime`, `Note`, `LogType`, `Operater`, `VarName`, `AlarmSet`, `AlarmValue`, `AlarmType`) VALUES
(785, '2026-09-09 13:39:42', '连接PLC', '操作日志', 'admin', NULL, NULL, NULL, '信息'),
(786, '2026-09-09 13:39:45', 'PC写入PLC时间成功！', '系统日志', 'admin', NULL, NULL, NULL, '信息'),
(787, '2026-09-09 13:39:45', 'PC写入PLC时间成功！', '系统日志', 'admin', NULL, NULL, NULL, '信息'),
(788, '2026-09-09 13:59:40', '登录成功，登录用户：admin,权限：管理员', '操作日志', 'admin', NULL, NULL, NULL, '信息'),
(789, '2026-09-09 13:59:40', '加载系统配置成功', '系统日志', 'admin', NULL, NULL, NULL, '信息'),
(790, '2026-09-09 13:59:41', '更新12小时数据异常：Sequence contains no elements', '系统日志', 'admin', NULL, NULL, NULL, '错误'),
(791, '2026-09-09 13:59:41', '更新12小时数据异常：Sequence contains no elements', '系统日志', 'admin', NULL, NULL, NULL, '错误'),
(792, '2026-09-09 13:59:43', '更新12小时数据异常：Sequence contains no elements', '系统日志', 'admin', NULL, NULL, NULL, '错误'),
(793, '2026-09-09 13:59:44', '连接PLC', '操作日志', 'admin', NULL, NULL, NULL, '信息'),
(794, '2026-09-09 13:59:45', '更新12小时数据异常：Sequence contains no elements', '系统日志', 'admin', NULL, NULL, NULL, '错误'),
(795, '2026-09-09 13:59:48', 'PC写入PLC时间成功！', '系统日志', 'admin', NULL, NULL, NULL, '信息'),
(796, '2026-09-09 13:59:48', 'PC写入PLC时间成功！', '系统日志', 'admin', NULL, NULL, NULL, '信息');
/*!40103 SET TIME_ZONE=IFNULL(@OLD_TIME_ZONE, 'system') */;
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */;
Reference in New Issue View Git Blame Copy Permalink