119 lines
6.5 KiB
SQL
119 lines
6.5 KiB
SQL
/*
|
||
Navicat Premium Data Transfer
|
||
|
||
Source Server : localhost
|
||
Source Server Type : MySQL
|
||
Source Server Version : 80032 (8.0.32)
|
||
Source Host : localhost:3306
|
||
Source Schema : aoi_pcb
|
||
|
||
Target Server Type : MySQL
|
||
Target Server Version : 80032 (8.0.32)
|
||
File Encoding : 65001
|
||
|
||
Date: 30/07/2024 19:00:32
|
||
*/
|
||
|
||
SET NAMES utf8mb4;
|
||
SET FOREIGN_KEY_CHECKS = 0;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for defect
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `defect`;
|
||
CREATE TABLE `defect` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`cam_id` int NOT NULL COMMENT '相机编号',
|
||
`type` int NOT NULL COMMENT '缺陷类型',
|
||
`board_id` int NOT NULL COMMENT '板号',
|
||
`defect_id` int NOT NULL COMMENT '缺陷ID',
|
||
`defect_x` float NOT NULL COMMENT '缺陷中心在参考图的x轴坐标',
|
||
`defect_y` float NOT NULL COMMENT '缺陷中心在参考图的y轴坐标',
|
||
`defect_rect_x` float NULL DEFAULT NULL COMMENT '缺陷矩形左上角x轴坐标',
|
||
`defect_rect_y` float NULL DEFAULT NULL COMMENT '缺陷矩形左上角y轴坐标',
|
||
`defect_rect_w` float NULL DEFAULT NULL COMMENT '缺陷矩形宽度',
|
||
`defect_rect_h` float NULL DEFAULT NULL COMMENT '缺陷矩形高度',
|
||
`defect_pic_x` float NULL DEFAULT NULL COMMENT '缺陷中心在单个相机扫描图矩形的x轴坐标',
|
||
`defect_pic_y` float NULL DEFAULT NULL COMMENT '缺陷中心在单个相机扫描图矩形的y轴坐标',
|
||
`defect_pic_rect_x` float NULL DEFAULT NULL COMMENT '缺陷矩形在单个相机扫描图的x轴坐标',
|
||
`defect_pic_rect_y` float NULL DEFAULT NULL COMMENT '缺陷矩形在单个相机扫描图的y轴坐标',
|
||
`defect_pic_rect_w` float NULL DEFAULT NULL COMMENT '缺陷矩形在单个相机扫描图的宽度',
|
||
`defect_pic_rect_h` float NULL DEFAULT NULL COMMENT '缺陷矩形在单个相机扫描图的高度',
|
||
`defect_pic_path` varchar(300) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '缺陷图保存在主工位的路径',
|
||
`material` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '料号',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
INDEX `defect_defect_id_index`(`defect_id` ASC) USING BTREE INVISIBLE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 23476 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for detection_task
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `detection_task`;
|
||
CREATE TABLE `detection_task` (
|
||
`id` int NOT NULL AUTO_INCREMENT,
|
||
`status` int UNSIGNED NOT NULL DEFAULT 1 COMMENT '任务状态：0 新增 1进行中 2已结束',
|
||
`board_id` int UNSIGNED NOT NULL,
|
||
`priority` int NOT NULL COMMENT '是否优先：0.不优先，1.优先',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 3199 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for id_seq_tmp
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `id_seq_tmp`;
|
||
CREATE TABLE `id_seq_tmp` (
|
||
`id` int UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
`product_id` int UNSIGNED NOT NULL COMMENT '产品id',
|
||
`product_seq` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '产品编号',
|
||
`board_sum` int UNSIGNED NOT NULL COMMENT '板数量',
|
||
`board_id` int UNSIGNED NOT NULL COMMENT '板id',
|
||
`board_order` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '板序号：a，b，c，d',
|
||
`material` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '板物料号',
|
||
`cam_id` int NOT NULL COMMENT '相机编号',
|
||
`materials` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '所有料号',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 730 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for pcb
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `pcb`;
|
||
CREATE TABLE `pcb` (
|
||
`id` int NOT NULL AUTO_INCREMENT,
|
||
`product_id` int UNSIGNED NOT NULL COMMENT '产品id',
|
||
`product_seq` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '产品编号',
|
||
`board_id` int UNSIGNED NOT NULL COMMENT '板子id',
|
||
`board_sum` int UNSIGNED NOT NULL COMMENT '板子总数',
|
||
`board_order` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '板子序号：a,b,c,d',
|
||
`material` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '料号',
|
||
`cam_id` int UNSIGNED NOT NULL COMMENT '相机编号,也是分片编号',
|
||
`status` int NOT NULL COMMENT '10:扫描成功,11:扫描失败,20: 分析成功,21:分析失败,22:分析中',
|
||
`defect_count` int NULL DEFAULT NULL COMMENT '缺陷数',
|
||
`scan_end_time` datetime NULL DEFAULT NULL COMMENT '扫描结束时间',
|
||
`detection_end_time` datetime NULL DEFAULT NULL COMMENT '分析结束时间',
|
||
`materials` varchar(400) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '产品所有料号',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 92393 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for pcb_summary
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `pcb_summary`;
|
||
CREATE TABLE `pcb_summary` (
|
||
`id` int NOT NULL AUTO_INCREMENT,
|
||
`product_id` int NOT NULL COMMENT '产品id',
|
||
`product_seq` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '产品编号',
|
||
`board_id` int NOT NULL COMMENT '板子id',
|
||
`board_sum` int NOT NULL COMMENT '板子总数',
|
||
`board_order` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '板子序号：a,b,c,d',
|
||
`material` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '料号',
|
||
`status` int NOT NULL COMMENT '10:扫描成功11:扫描失败,20: 分析成功,21:分析失败,22:分析中',
|
||
`defect_count` int NULL DEFAULT NULL COMMENT '缺陷数',
|
||
`scan_summary_time` datetime NULL DEFAULT NULL COMMENT '扫描汇总时间',
|
||
`detection_summary_time` datetime NULL DEFAULT NULL COMMENT '分析汇总时间',
|
||
`materials` varchar(400) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '产品所有料号',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 92343 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic;
|
||
|
||
SET FOREIGN_KEY_CHECKS = 1;
|