232 lines
11 KiB
SQL
232 lines
11 KiB
SQL
/*
|
|
Navicat Premium Dump SQL
|
|
|
|
Source Server : 内网aicheck
|
|
Source Server Type : MySQL
|
|
Source Server Version : 80041 (8.0.41)
|
|
Source Host : 172.16.40.39:3306
|
|
Source Schema : aicheckv2
|
|
|
|
Target Server Type : MySQL
|
|
Target Server Version : 80041 (8.0.41)
|
|
File Encoding : 65001
|
|
|
|
Date: 05/06/2025 13:51:22
|
|
*/
|
|
|
|
SET NAMES utf8mb4;
|
|
SET FOREIGN_KEY_CHECKS = 0;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for base
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `base`;
|
|
CREATE TABLE `base` (
|
|
`id` int NOT NULL AUTO_INCREMENT,
|
|
`create_time` datetime NULL DEFAULT NULL,
|
|
`update_time` datetime NULL DEFAULT NULL,
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for project_detect
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `project_detect`;
|
|
CREATE TABLE `project_detect` (
|
|
`id` int NOT NULL AUTO_INCREMENT,
|
|
`create_time` datetime NULL DEFAULT NULL,
|
|
`update_time` datetime NULL DEFAULT NULL,
|
|
`project_id` int NULL DEFAULT NULL,
|
|
`detect_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
|
`detect_version` int NULL DEFAULT NULL,
|
|
`detect_no` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
|
`detect_status` int NULL DEFAULT NULL,
|
|
`file_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
|
`folder_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
|
`rtsp_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for project_detect_img
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `project_detect_img`;
|
|
CREATE TABLE `project_detect_img` (
|
|
`id` int NOT NULL AUTO_INCREMENT,
|
|
`create_time` datetime NULL DEFAULT NULL,
|
|
`update_time` datetime NULL DEFAULT NULL,
|
|
`detect_id` int NULL DEFAULT NULL,
|
|
`file_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
|
`image_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
|
`thumb_image_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 211 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for project_detect_log
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `project_detect_log`;
|
|
CREATE TABLE `project_detect_log` (
|
|
`id` int NOT NULL AUTO_INCREMENT,
|
|
`create_time` datetime NULL DEFAULT NULL,
|
|
`update_time` datetime NULL DEFAULT NULL,
|
|
`detect_id` int NULL DEFAULT NULL,
|
|
`detect_version` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
|
`train_id` int NULL DEFAULT NULL,
|
|
`train_version` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
|
`pt_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
|
`pt_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
|
`folder_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
|
`detect_folder_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
|
`detect_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 23 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for project_detect_log_img
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `project_detect_log_img`;
|
|
CREATE TABLE `project_detect_log_img` (
|
|
`id` int NOT NULL AUTO_INCREMENT,
|
|
`create_time` datetime NULL DEFAULT NULL,
|
|
`update_time` datetime NULL DEFAULT NULL,
|
|
`log_id` int NULL DEFAULT NULL,
|
|
`file_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
|
`image_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 955 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for project_image
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `project_image`;
|
|
CREATE TABLE `project_image` (
|
|
`id` int NOT NULL AUTO_INCREMENT,
|
|
`create_time` datetime NULL DEFAULT NULL,
|
|
`update_time` datetime NULL DEFAULT NULL,
|
|
`image_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
|
`thumb_image_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
|
`project_id` int NULL DEFAULT NULL,
|
|
`file_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
|
`img_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 557 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for project_img_label
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `project_img_label`;
|
|
CREATE TABLE `project_img_label` (
|
|
`id` int NOT NULL AUTO_INCREMENT,
|
|
`create_time` datetime NULL DEFAULT NULL,
|
|
`update_time` datetime NULL DEFAULT NULL,
|
|
`image_id` int NULL DEFAULT NULL,
|
|
`label_id` int NULL DEFAULT NULL,
|
|
`mark_center_x` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
|
`mark_center_y` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
|
`mark_width` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
|
`mark_height` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 3244 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for project_img_leafer
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `project_img_leafer`;
|
|
CREATE TABLE `project_img_leafer` (
|
|
`id` int NOT NULL AUTO_INCREMENT,
|
|
`create_time` datetime NULL DEFAULT NULL,
|
|
`update_time` datetime NULL DEFAULT NULL,
|
|
`image_id` int NULL DEFAULT NULL,
|
|
`leafer` json NULL,
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 971 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for project_info
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `project_info`;
|
|
CREATE TABLE `project_info` (
|
|
`id` int NOT NULL AUTO_INCREMENT,
|
|
`create_time` datetime NULL DEFAULT NULL,
|
|
`update_time` datetime NULL DEFAULT NULL,
|
|
`project_no` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
|
`project_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
|
`type_code` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
|
`description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
|
`project_status` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
|
`user_id` int NULL DEFAULT NULL,
|
|
`train_version` int NULL DEFAULT NULL,
|
|
`del_flag` int NULL DEFAULT NULL,
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for project_label
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `project_label`;
|
|
CREATE TABLE `project_label` (
|
|
`id` int NOT NULL AUTO_INCREMENT,
|
|
`create_time` datetime NULL DEFAULT NULL,
|
|
`update_time` datetime NULL DEFAULT NULL,
|
|
`label_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
|
`project_id` int NULL DEFAULT NULL,
|
|
`meta` json NULL,
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 23 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for project_train
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `project_train`;
|
|
CREATE TABLE `project_train` (
|
|
`id` int NOT NULL AUTO_INCREMENT,
|
|
`create_time` datetime NULL DEFAULT NULL,
|
|
`update_time` datetime NULL DEFAULT NULL,
|
|
`project_id` int NULL DEFAULT NULL,
|
|
`train_version` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
|
`best_pt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
|
`last_pt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
|
`weights_id` int NULL DEFAULT NULL,
|
|
`weights_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
|
`epochs` int NULL DEFAULT NULL,
|
|
`patience` int NULL DEFAULT NULL,
|
|
`train_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
|
`train_data` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 50 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for project_type
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `project_type`;
|
|
CREATE TABLE `project_type` (
|
|
`id` int NOT NULL AUTO_INCREMENT,
|
|
`type_code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
|
`type_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
|
`icon_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
|
`description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
|
`type_status` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
|
`create_time` datetime NULL DEFAULT NULL,
|
|
`update_time` datetime NULL DEFAULT NULL,
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for sys_user
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `sys_user`;
|
|
CREATE TABLE `sys_user` (
|
|
`id` int NOT NULL AUTO_INCREMENT,
|
|
`username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
|
`password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
|
`login_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
|
`avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
|
`create_time` datetime NULL DEFAULT NULL,
|
|
`update_time` datetime NULL DEFAULT NULL,
|
|
`user_status` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;
|
|
|
|
SET FOREIGN_KEY_CHECKS = 1;
|