2017 lines
112 KiB
SQL
2017 lines
112 KiB
SQL
-- MySQL dump 10.13 Distrib 8.0.36, for Linux (x86_64)
|
||
--
|
||
-- Host: 144.7.97.70 Database: cmii
|
||
-- ------------------------------------------------------
|
||
-- Server version 8.1.0
|
||
|
||
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
|
||
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
|
||
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
|
||
/*!50503 SET NAMES utf8mb4 */;
|
||
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
|
||
/*!40103 SET TIME_ZONE='+00:00' */;
|
||
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
|
||
/*!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 */;
|
||
|
||
|
||
--
|
||
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `cmii_sky_converge` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_bin */ /*!80016 DEFAULT ENCRYPTION='N' */;
|
||
|
||
USE `cmii_sky_converge`;
|
||
|
||
--
|
||
-- Table structure for table `admin_demand_industry_type`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `admin_demand_industry_type`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `admin_demand_industry_type` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID',
|
||
`type_name` varchar(50) COLLATE utf8mb4_bin NOT NULL COMMENT '行业便签类型名称',
|
||
`type_path` varchar(100) COLLATE utf8mb4_bin NOT NULL COMMENT '行业大屏路径。通用行业大屏：/general-screen',
|
||
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
`deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除标识',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='需求单位行业类型';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `admin_demand_org`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `admin_demand_org`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `admin_demand_org` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID',
|
||
`org_id` bigint NOT NULL COMMENT '所属管理组织ID',
|
||
`name` varchar(100) COLLATE utf8mb4_bin NOT NULL COMMENT '需求端组织名称',
|
||
`platform_name` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '平台显示名称',
|
||
`logo` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '组织Logo',
|
||
`code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '需求端组织编码',
|
||
`description` varchar(500) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '描述',
|
||
`contact_person` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '联系人',
|
||
`contact_phone` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '联系电话',
|
||
`industry_type` bigint DEFAULT '1' COMMENT '行业类型',
|
||
`status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态：0-禁用，1-启用',
|
||
`screen_config` text COLLATE utf8mb4_bin COMMENT '大屏配置信息',
|
||
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
`deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除标识',
|
||
`enable_push` tinyint(1) DEFAULT '0' COMMENT '是否自动推送',
|
||
`map_center` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '组织地图定位中心',
|
||
PRIMARY KEY (`id`),
|
||
UNIQUE KEY `admin_demand_org_pk` (`org_id`,`code`),
|
||
KEY `admin_demand_org_code_index` (`code`),
|
||
KEY `admin_demand_org_status_index` (`status`),
|
||
CONSTRAINT `admin_demand_org_org_fk` FOREIGN KEY (`org_id`) REFERENCES `admin_organization` (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='需求端组织表';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `admin_demand_user_org`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `admin_demand_user_org`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `admin_demand_user_org` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID',
|
||
`user_id` bigint NOT NULL COMMENT '用户ID',
|
||
`demand_org_id` bigint NOT NULL COMMENT '需求组织ID',
|
||
`role` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '用户在组织中的角色',
|
||
`position` varchar(20) COLLATE utf8mb4_bin DEFAULT '' COMMENT '用户岗位',
|
||
`is_default` tinyint(1) DEFAULT '0' COMMENT '是否默认组织(0:否, 1:是)',
|
||
`join_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '加入组织时间',
|
||
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '记录创建时间',
|
||
`update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '记录最后更新时间',
|
||
`deleted` tinyint(1) DEFAULT '0' COMMENT '软删除标记(0:正常, 1:删除)',
|
||
PRIMARY KEY (`id`),
|
||
KEY `idx_default_org` (`user_id`,`is_default`),
|
||
KEY `idx_demand_org_id` (`demand_org_id`),
|
||
KEY `idx_user_id` (`user_id`),
|
||
KEY `idx_user_org` (`user_id`,`demand_org_id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=121 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='用户与需求组织关联表';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `admin_org_user`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `admin_org_user`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `admin_org_user` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
`org_id` bigint NOT NULL COMMENT '组织 ID',
|
||
`user_id` bigint NOT NULL COMMENT '用户 ID',
|
||
`user_type_id` bigint DEFAULT NULL COMMENT '用户类型ID（用于限制登录端）',
|
||
`default_org` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否为默认显示组织',
|
||
`role` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '组织角色',
|
||
`create_time` datetime DEFAULT (now()) COMMENT '创建时间',
|
||
`update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
PRIMARY KEY (`id`),
|
||
UNIQUE KEY `admin_org_user_pk` (`org_id`,`user_id`),
|
||
KEY `admin_org_user_role_index` (`role`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=201 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='组织用户表';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `admin_organization`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `admin_organization`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `admin_organization` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID',
|
||
`name` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '组织名称',
|
||
`platform_name` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '平台显示名称',
|
||
`logo` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '组织logo',
|
||
`bind_code` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '组织绑定码',
|
||
`file_expire_days` int DEFAULT '0' COMMENT '组织存储空间文件过期天数，<=0时不清理',
|
||
`total_storage` bigint DEFAULT '0' COMMENT '组织总存储空间',
|
||
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
`deleted` tinyint(1) DEFAULT '0' COMMENT '删除标识',
|
||
PRIMARY KEY (`id`),
|
||
UNIQUE KEY `admin_admin_organization_pk` (`name`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=10031 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='系统组织';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `admin_user`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `admin_user`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `admin_user` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '用户id',
|
||
`phone` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '手机号',
|
||
`name` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '用户昵称',
|
||
`password` varchar(155) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '密码',
|
||
`avatar` varchar(155) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '头像',
|
||
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
`password_expire_time` datetime DEFAULT NULL COMMENT '密码过期时间',
|
||
`last_login_time` datetime DEFAULT NULL COMMENT '最后登录时间',
|
||
`deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除标识',
|
||
PRIMARY KEY (`id`),
|
||
UNIQUE KEY `admin_user_pk` (`phone`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=188 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='系统用户';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
|
||
insert into admin_user (phone, name, password, password_expire_time, deleted)
|
||
values ('4A41D1D00E7E933684262977B4A84610', '2D0331B6AA1AD72EEE3EDDA852737D22', '5771a7060988f2718e4df310946c08d9', NOW() + INTERVAL 3 MONTH,FALSE);
|
||
--
|
||
-- Table structure for table `admin_user_type`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `admin_user_type`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `admin_user_type` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID',
|
||
`type_code` varchar(50) COLLATE utf8mb4_bin NOT NULL COMMENT '用户类型编码',
|
||
`type_name` varchar(50) COLLATE utf8mb4_bin NOT NULL COMMENT '用户类型名称',
|
||
`description` varchar(200) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '描述',
|
||
`sort_order` int DEFAULT '0' COMMENT '排序',
|
||
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
`deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除标识',
|
||
PRIMARY KEY (`id`),
|
||
UNIQUE KEY `admin_user_type_pk` (`type_code`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='用户类型表';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `admin_user_type_rel`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `admin_user_type_rel`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `admin_user_type_rel` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID',
|
||
`user_id` bigint NOT NULL COMMENT '用户ID',
|
||
`user_type_id` bigint NOT NULL COMMENT '用户类型ID',
|
||
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
`deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除标识',
|
||
PRIMARY KEY (`id`),
|
||
UNIQUE KEY `admin_user_type_rel_pk` (`user_id`,`user_type_id`),
|
||
KEY `admin_user_type_rel_type_index` (`user_type_id`),
|
||
CONSTRAINT `admin_user_type_rel_type_fk` FOREIGN KEY (`user_type_id`) REFERENCES `admin_user_type` (`id`),
|
||
CONSTRAINT `admin_user_type_rel_user_fk` FOREIGN KEY (`user_id`) REFERENCES `admin_user` (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='用户类型关联表';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `ai_chat_conversation`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `ai_chat_conversation`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `ai_chat_conversation` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增主键',
|
||
`conversation_id` varchar(64) NOT NULL COMMENT '会话编号',
|
||
`conversation_title` varchar(128) DEFAULT NULL COMMENT '会话标题',
|
||
`status` int NOT NULL DEFAULT '1' COMMENT '状态[0禁用1启用]',
|
||
`org_id` bigint DEFAULT NULL COMMENT '所属组织id',
|
||
`project_id` bigint DEFAULT NULL COMMENT '所属项目id',
|
||
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
|
||
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
|
||
`deleted` int DEFAULT '0' COMMENT '删除标识[0未删除1已删除]',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=1960625901138980866 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='会话历史表';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `ai_chat_conversation_history`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `ai_chat_conversation_history`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `ai_chat_conversation_history` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增主键',
|
||
`conversation_id` varchar(64) NOT NULL COMMENT '会话编号',
|
||
`message` json NOT NULL COMMENT '会话内容JSON格式',
|
||
`status` int NOT NULL DEFAULT '1' COMMENT '状态[0禁用1启用]',
|
||
`org_id` bigint DEFAULT NULL COMMENT '所属组织id',
|
||
`project_id` bigint DEFAULT NULL COMMENT '所属项目id',
|
||
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
|
||
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
|
||
`deleted` int DEFAULT '0' COMMENT '删除标识[0未删除1已删除]',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=1961366206997164034 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='会话历史表';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `ai_detection_config`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `ai_detection_config`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `ai_detection_config` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID',
|
||
`is_display_prompt` tinyint(1) DEFAULT NULL COMMENT '是否开启画面边缘提示',
|
||
`display_prompt_desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '画面边缘提示描述',
|
||
`is_audio_prompt` tinyint(1) DEFAULT NULL COMMENT '是否开启音频提示',
|
||
`audio_prompt_desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '音频提示描述',
|
||
`detection_interval_time` int DEFAULT NULL COMMENT '检测间隔时间，范围[1,10]整数',
|
||
`interval_time_desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '检测间隔时间描述',
|
||
`project_id` bigint DEFAULT NULL COMMENT '项目id',
|
||
`org_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '组织id',
|
||
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=235 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='ai检测设置表';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `ai_model_field`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `ai_model_field`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `ai_model_field` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
`model_id` bigint NOT NULL COMMENT '模型 ID',
|
||
`field_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '字段名称',
|
||
`field_label` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '显示名称',
|
||
`local_field` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '本地统一字段',
|
||
`field_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'NUMBER' COMMENT '字段类型，NUMBER：数字，STRING：字符串，IMG:图片字段',
|
||
`field_desc` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '字段描述',
|
||
`required` tinyint(1) DEFAULT '1' COMMENT '是否必须，默认 1',
|
||
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='AI识别结果字段配置';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `ai_model_info`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `ai_model_info`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `ai_model_info` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键 ID',
|
||
`ai_key` varchar(80) COLLATE utf8mb4_bin NOT NULL COMMENT 'AI标识，系统内唯一标识',
|
||
`provider_code` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '供应商编码',
|
||
`model_code` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '模型编码 - 调用时发送给AI',
|
||
`model_name` varchar(128) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '模型名称 - AI供应商提供，发送给AI',
|
||
`direction_type` varchar(20) COLLATE utf8mb4_bin NOT NULL COMMENT '识别类型，暂时只支持 COUNT:计数，ACCUMULATION:累计，LAAD：低空探测，PLAIN：仅识别、无业务',
|
||
`display_name` varchar(50) COLLATE utf8mb4_bin NOT NULL COMMENT 'AI名称，主要提供给前端显示',
|
||
`description` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'AI描述',
|
||
`prompt` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'AI模型参数',
|
||
`call_count` bigint DEFAULT '0' COMMENT '调用次数',
|
||
`call_type` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '调用类型，支持类型：MQ，HTTP（HTTPS），默认为 MQ',
|
||
`call_url` varchar(200) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '调用地址，使用 HTTP(HTTPS)方式时，需要提供调用地址供 AI 方调用',
|
||
`callback_url` varchar(150) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '回调地址，让使用 HTTP(HTTPS)方式时，需要提供回调地址供 AI 方上报数据',
|
||
`ai_icon` varchar(200) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'AI图标',
|
||
`formatter` text COLLATE utf8mb4_bin COMMENT '消息格式化脚本',
|
||
`formatter_code` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '前端映射代码',
|
||
`deleted` tinyint(1) DEFAULT '0' COMMENT '删除标识',
|
||
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
`model_type_code` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'AI模型类型编号',
|
||
PRIMARY KEY (`id`),
|
||
UNIQUE KEY `ai_model_info_ai_key_IDX` (`ai_key`),
|
||
KEY `uniq_model_code` (`model_code`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=1093 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='AI模型信息';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `ai_model_info_copy1`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `ai_model_info_copy1`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `ai_model_info_copy1` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键 ID',
|
||
`ai_key` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT 'AI标识，系统内唯一标识',
|
||
`provider_code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '供应商编码',
|
||
`model_code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '模型编码 - 调用时发送给AI',
|
||
`model_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '模型名称 - AI供应商提供，发送给AI',
|
||
`direction_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '识别类型，暂时只支持 COUNT:计数，ACCUMULATION:累计，LAAD：低空探测，PLAIN：仅识别、无业务',
|
||
`display_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT 'AI名称，主要提供给前端显示',
|
||
`description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'AI描述',
|
||
`prompt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'AI模型参数',
|
||
`call_count` bigint DEFAULT '0' COMMENT '调用次数',
|
||
`call_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '调用类型，支持类型：MQ，HTTP（HTTPS），默认为 MQ',
|
||
`call_url` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '调用地址，使用 HTTP(HTTPS)方式时，需要提供调用地址供 AI 方调用',
|
||
`callback_url` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '回调地址，让使用 HTTP(HTTPS)方式时，需要提供回调地址供 AI 方上报数据',
|
||
`ai_icon` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'AI图标',
|
||
`formatter` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin COMMENT '消息格式化脚本',
|
||
`formatter_code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '前端映射代码',
|
||
`deleted` tinyint(1) DEFAULT '0' COMMENT '删除标识',
|
||
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
`model_type_code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'AI模型类型编号',
|
||
PRIMARY KEY (`id`),
|
||
UNIQUE KEY `ai_model_info_ai_key_IDX` (`ai_key`),
|
||
KEY `uniq_model_code` (`model_code`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=1092 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='AI模型信息';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `ai_model_type`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `ai_model_type`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `ai_model_type` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID',
|
||
`type_code` varchar(100) COLLATE utf8mb4_bin NOT NULL COMMENT '类型编码',
|
||
`type_name` varchar(100) COLLATE utf8mb4_bin NOT NULL COMMENT '类型名称',
|
||
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
`deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除标识',
|
||
PRIMARY KEY (`id`),
|
||
KEY `ai_model_type_code` (`type_code`),
|
||
KEY `ai_model_type_name` (`type_name`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='AI类型';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `ai_result`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `ai_result`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `ai_result` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
`ai_result_code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '编号',
|
||
`model_key` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '模型 ID',
|
||
`drone_sn` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '无人机SN',
|
||
`project_id` bigint NOT NULL COMMENT '项目id',
|
||
`org_id` bigint DEFAULT NULL COMMENT '组织id',
|
||
`task_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '任务id',
|
||
`task_type` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'NUMBER' COMMENT '任务类型',
|
||
`result` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '识别结果',
|
||
`detection_time` datetime NOT NULL COMMENT '无人机识别到结果的东八区时间',
|
||
`type` int DEFAULT NULL COMMENT '人工处理或确认结果，如1:有效、0:无效、2:其他结果',
|
||
`remark` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '人工处理备注',
|
||
`flight_image_info_id` bigint unsigned NOT NULL COMMENT '关联flight_image_info表的id',
|
||
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
`status` tinyint DEFAULT '1' COMMENT '状态 1：未推送 2：待办结 3：已办结 4：已退回',
|
||
`requirement_id` bigint DEFAULT NULL COMMENT '需求表ID',
|
||
`plan_execute_code` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '计划执行情况编号',
|
||
`push_time` datetime DEFAULT NULL COMMENT '推送时间',
|
||
`push_type` tinyint DEFAULT NULL COMMENT '推送类型 1：二级需求单位 2：运管服单位',
|
||
`push_unit_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '推送单位ID；目前运管服只有一个默认为1',
|
||
`receive_rel_id` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '接收方内部关联ID',
|
||
`finish_time` datetime DEFAULT NULL COMMENT '办结时间',
|
||
`is_top` tinyint(1) DEFAULT '0' COMMENT '是否置顶',
|
||
`top_time` datetime DEFAULT NULL COMMENT '置顶时间',
|
||
`deleted` bigint DEFAULT '0' COMMENT '删除标识：非0 删除',
|
||
PRIMARY KEY (`id`),
|
||
KEY `ai_result_status_IDX` (`status`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=13399 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='AI识别结果';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `clue_order`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `clue_order`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `clue_order` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT,
|
||
`clue_id` bigint NOT NULL COMMENT '线索ID',
|
||
`order_number` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '工单编号',
|
||
`order_type` tinyint NOT NULL COMMENT '工单类型 1：内部工单 2：运管服工单',
|
||
`handler_user` bigint DEFAULT NULL COMMENT '内部工单处理人ID',
|
||
`handler_label` bigint DEFAULT NULL,
|
||
`category` varchar(32) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '运管服工单一级分类',
|
||
`sub_category` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '运管服工单二级分类',
|
||
`status` tinyint NOT NULL COMMENT '工单状态 1：待接单 2：处理中 3：已完成',
|
||
`create_user` bigint NOT NULL COMMENT '派单人ID',
|
||
`create_time` datetime NOT NULL COMMENT '派单时间',
|
||
`handle_time` datetime DEFAULT NULL COMMENT '内部工单接单时间',
|
||
`complete_time` datetime DEFAULT NULL COMMENT '内部工单完成时间',
|
||
`requirement_id` bigint DEFAULT NULL COMMENT '需求表ID',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=72 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `clue_order_category`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `clue_order_category`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `clue_order_category` (
|
||
`category_id` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT '一级分类ID',
|
||
`category_name` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT '一级分类名称',
|
||
`sub_category_id` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT '二级分类ID',
|
||
`sub_category_name` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT '二级分类名称',
|
||
`remote_id` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT '对应派单接口类型ID'
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `clue_order_result`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `clue_order_result`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `clue_order_result` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT,
|
||
`order_id` bigint NOT NULL COMMENT '线索工单ID',
|
||
`image_id` varchar(36) COLLATE utf8mb4_bin NOT NULL COMMENT '线索处理结果图片ID',
|
||
`remark` varchar(200) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '备注信息',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=69 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `clue_order_result_file`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `clue_order_result_file`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `clue_order_result_file` (
|
||
`id` varchar(36) COLLATE utf8mb4_bin NOT NULL,
|
||
`object_name` varchar(100) COLLATE utf8mb4_bin NOT NULL COMMENT '文件名',
|
||
`bucket_name` varchar(20) COLLATE utf8mb4_bin NOT NULL COMMENT '存储桶名',
|
||
`object_path` varchar(256) COLLATE utf8mb4_bin NOT NULL COMMENT '文件存储路径',
|
||
`upload_user` bigint NOT NULL COMMENT '上传用户ID',
|
||
`upload_time` datetime NOT NULL COMMENT '上传时间',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `construction_site_data_mapping`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `construction_site_data_mapping`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `construction_site_data_mapping` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID',
|
||
`project_id` bigint NOT NULL COMMENT '工地项目ID（三级项目）',
|
||
`data_type` tinyint NOT NULL COMMENT '数据类型：0-广角照片，1-变焦照片，2-红外照片，3-可见光照片，4-AI检测照片，5-视频，6-全景照片',
|
||
`drone_sn` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '无人机序列号（drone_sn，关联device_drone_info表获取无人机名称）',
|
||
`data_id` bigint NOT NULL COMMENT '数据ID（对应flight_image_info表的主键）',
|
||
`data_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '数据名称（冗余字段，便于查询）',
|
||
`org_id` bigint NOT NULL COMMENT '组织ID（数据权限隔离）',
|
||
`creator` bigint DEFAULT NULL COMMENT '创建人ID',
|
||
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
`deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除标识',
|
||
PRIMARY KEY (`id`),
|
||
KEY `idx_project_id` (`project_id`),
|
||
KEY `idx_data_type` (`data_type`),
|
||
KEY `idx_org_id` (`org_id`),
|
||
KEY `idx_data_id` (`data_id`),
|
||
KEY `idx_drone_sn` (`drone_sn`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=1249 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='工地数据关联表';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `construction_site_import_log`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `construction_site_import_log`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `construction_site_import_log` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID',
|
||
`batch_no` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '批次号',
|
||
`org_id` bigint NOT NULL COMMENT '组织ID',
|
||
`import_user` bigint NOT NULL COMMENT '导入人ID',
|
||
`total_count` int DEFAULT '0' COMMENT '总数量',
|
||
`success_count` int DEFAULT '0' COMMENT '成功数量',
|
||
`fail_count` int DEFAULT '0' COMMENT '失败数量',
|
||
`fail_file_url` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '失败数据文件下载地址',
|
||
`import_status` tinyint DEFAULT '0' COMMENT '导入状态：0-进行中，1-完成，2-失败',
|
||
`error_message` text COLLATE utf8mb4_unicode_ci COMMENT '错误信息',
|
||
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
`deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除标识',
|
||
PRIMARY KEY (`id`),
|
||
KEY `idx_batch_no` (`batch_no`),
|
||
KEY `idx_org_id` (`org_id`),
|
||
KEY `idx_import_user` (`import_user`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='工地导入记录表';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `construction_site_project`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `construction_site_project`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `construction_site_project` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID',
|
||
`project_code` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '项目编号（全局唯一）',
|
||
`project_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '项目名称',
|
||
`project_level` tinyint NOT NULL DEFAULT '3' COMMENT '项目层级：1-一级项目，2-二级项目，3-三级项目',
|
||
`parent_id` bigint DEFAULT NULL COMMENT '父项目ID（一级项目为空，二级项目指向一级项目，三级项目指向二级项目）',
|
||
`project_status` tinyint DEFAULT '1' COMMENT '项目状态：0-完工，1-在建（仅三级项目有效）',
|
||
`jurisdiction_area` text COLLATE utf8mb4_unicode_ci COMMENT '管辖范围区域（GeoJSON格式，仅三级项目有值）',
|
||
`jurisdiction_wkt` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '管辖范围区域（wkt格式，仅三级项目有值）',
|
||
`area_color` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT '#1890ff' COMMENT '区域颜色（仅三级项目有效）',
|
||
`construction_unit` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '建设单位（参建单位）',
|
||
`org_id` bigint NOT NULL COMMENT '组织ID（数据权限隔离）',
|
||
`creator` bigint NOT NULL COMMENT '创建人ID',
|
||
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
`deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除标识（逻辑删除）',
|
||
PRIMARY KEY (`id`),
|
||
UNIQUE KEY `uk_org_project_code` (`org_id`,`project_code`),
|
||
KEY `idx_org_id` (`org_id`),
|
||
KEY `idx_parent_id` (`parent_id`),
|
||
KEY `idx_project_level` (`project_level`),
|
||
KEY `idx_create_time` (`create_time`),
|
||
KEY `idx_construction_unit` (`construction_unit`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=750 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='工地项目表';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `device_dock_info`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `device_dock_info`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `device_dock_info` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID',
|
||
`sn` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '设备SN',
|
||
`name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '机库名称',
|
||
`manufacturer` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '生产厂家',
|
||
`model` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '机库型号',
|
||
`online_status` tinyint(1) DEFAULT '0' COMMENT '在线状态:0:在线；1:离线',
|
||
`auto_stream` tinyint(1) DEFAULT '1' COMMENT '是否自动开启视频流:0:不开启；1:开启',
|
||
`project_id` bigint DEFAULT NULL COMMENT '分配的项目',
|
||
`org_id` bigint DEFAULT NULL COMMENT '组织id',
|
||
`bind_type` tinyint(1) DEFAULT NULL COMMENT '绑定类型 1：新建无人机绑定 2：已建无人机绑定 3：不绑定',
|
||
`remark` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin COMMENT '备注',
|
||
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
`deleted` tinyint(1) DEFAULT '0' COMMENT '删除标识',
|
||
`xt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '预留扩展',
|
||
`sn_unique` bigint DEFAULT '0' COMMENT '和sn组合区别唯一校验，数据未删除时为0，删除后为id',
|
||
`power_on_time` datetime DEFAULT NULL COMMENT '机库开机时间',
|
||
`offline_gps` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin COMMENT '机库离线位置信息',
|
||
PRIMARY KEY (`id`),
|
||
UNIQUE KEY `dock_sn_unique` (`sn`,`sn_unique`) USING BTREE COMMENT '''机库sn唯一索引'''
|
||
) ENGINE=InnoDB AUTO_INCREMENT=10238 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='机库信息表';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `device_dock_video_info`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `device_dock_video_info`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `device_dock_video_info` (
|
||
`id` int NOT NULL AUTO_INCREMENT COMMENT '视频流ID',
|
||
`dock_sn` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '机库sn',
|
||
`video_index` int NOT NULL COMMENT '摄像头位置顺序对应序号',
|
||
`name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '摄像头名称',
|
||
`mode` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '视频流模式:MANUAL 手动,AUTO自动',
|
||
`push_url` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '推流地址（在手动必填，在自动实时获取）',
|
||
`pull_url` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '拉流地址（在手动必填，在自动实时获取）',
|
||
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=131 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='机库摄像头信息表';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `device_drone_dock`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `device_drone_dock`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `device_drone_dock` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`drone_sn` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '无人机sn',
|
||
`dock_sn` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '机库sn',
|
||
`remark` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin COMMENT '备注',
|
||
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
`extra` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '扩展字段',
|
||
PRIMARY KEY (`id`),
|
||
UNIQUE KEY `drone_dock_uniqe` (`drone_sn`,`dock_sn`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=2027198017286647811 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='无人机机库关联表;';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `device_drone_info`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `device_drone_info`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `device_drone_info` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID',
|
||
`sn` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '设备 SN',
|
||
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`manufacturer` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '厂家',
|
||
`model` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '无人机型号',
|
||
`online_status` tinyint(1) DEFAULT '0' COMMENT '在线状态:0:在线；1:离线',
|
||
`hub_sn` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '联网方式哈勃终端',
|
||
`rc_sn` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '联网方式遥控器sn',
|
||
`aviator_sn` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '联网方式飞行家APPsn',
|
||
`project_id` bigint DEFAULT NULL COMMENT '分配的项目id',
|
||
`org_id` bigint DEFAULT NULL COMMENT '组织id',
|
||
`remark` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin COMMENT '备注',
|
||
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
`deleted` tinyint(1) DEFAULT '0' COMMENT '删除标识',
|
||
`xt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '预留扩展',
|
||
`sn_unique` bigint DEFAULT '0' COMMENT '和sn组合区别唯一校验，数据未删除时为0，删除后为id',
|
||
`power_on_time` datetime DEFAULT NULL COMMENT '无人机开机时间',
|
||
`offline_gps` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin COMMENT '无人机离线位置信息',
|
||
PRIMARY KEY (`id`),
|
||
UNIQUE KEY `drone_sn_uniqe` (`sn`,`sn_unique`) USING BTREE COMMENT '''无人机sn唯一索引'''
|
||
) ENGINE=InnoDB AUTO_INCREMENT=10392 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='无人机信息表';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `device_log_manager`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `device_log_manager`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `device_log_manager` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
`file_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '文件在Storage里面的id',
|
||
`boot_index` int NOT NULL COMMENT '文件索引',
|
||
`device_sn` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '设备序列号',
|
||
`module` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '日志设备类型，0-飞行器，3-机场',
|
||
`device_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '设备类型：DOCK/DRONE',
|
||
`log_start_time` datetime NOT NULL COMMENT '日志开始时间',
|
||
`log_end_time` datetime NOT NULL COMMENT '日志结束时间',
|
||
`upload_finish_time` datetime DEFAULT NULL COMMENT '日志上传完成时间',
|
||
`log_size` bigint DEFAULT NULL COMMENT '日志文件大小（B）',
|
||
`file_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '日志文件名',
|
||
`status` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '日志上传状态',
|
||
`org_id` bigint DEFAULT NULL COMMENT '组织id',
|
||
`deleted` tinyint(1) DEFAULT '0' COMMENT '删除标识',
|
||
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=98 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='设备日志文件管理';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `device_payload_info`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `device_payload_info`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `device_payload_info` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '载荷ID',
|
||
`drone_sn` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '无人机sn',
|
||
`payload_index` int NOT NULL COMMENT '载荷位置,0=FRONT_LEFT,1=FRONT_RIGHT,2=TOP,7=FPV',
|
||
`payload_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '载荷类型:(Camera:摄像头、Megaphone:喊话器、GasDetector:气体检测仪)',
|
||
`payload_sn` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '载荷sn',
|
||
`payload_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '载荷名称',
|
||
`manufacturer` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '厂家',
|
||
`model` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '型号',
|
||
`video_mode` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '视频流模式:MANUAL 手动,AUTO自动',
|
||
`push_url` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '推流地址（在手动必填，在自动实时获取）',
|
||
`pull_url` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '拉流地址（在手动必填，在自动实时获取）',
|
||
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=602 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='载荷信息表';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `device_stream`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `device_stream`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `device_stream` (
|
||
`id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID',
|
||
`project_id` bigint DEFAULT NULL COMMENT '项目ID',
|
||
`stream_type` varchar(12) DEFAULT NULL COMMENT '流分类',
|
||
`device_sn` varchar(100) DEFAULT NULL COMMENT '设备SN',
|
||
`user_id` varchar(32) DEFAULT NULL COMMENT '用户ID',
|
||
`remark` varchar(64) DEFAULT NULL COMMENT '备注',
|
||
`stream_id` varchar(64) DEFAULT NULL COMMENT '视频流ID',
|
||
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
|
||
`update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新日期',
|
||
PRIMARY KEY (`id`),
|
||
UNIQUE KEY `uniq_device_sn` (`device_sn`),
|
||
KEY `idx_stream_id` (`stream_id`),
|
||
KEY `idx_device_sn_pid` (`device_sn`,`project_id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=6912 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='设备流信息表';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `drone_line_info`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `drone_line_info`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `drone_line_info` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID',
|
||
`multi_flight_item_id` bigint DEFAULT NULL COMMENT '多机飞行任务管理任务id',
|
||
`drone_id` bigint DEFAULT NULL COMMENT '无人机id',
|
||
`wayline_id` bigint DEFAULT NULL COMMENT '飞行航线id',
|
||
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
`project_id` bigint NOT NULL COMMENT '项目id',
|
||
`org_id` bigint NOT NULL COMMENT '组织id',
|
||
`deleted` tinyint(1) DEFAULT '0' COMMENT '删除标识',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=102 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='无人机航线信息表';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `fence_area`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `fence_area`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `fence_area` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增ID',
|
||
`org_id` bigint NOT NULL COMMENT '组织ID',
|
||
`fence_name` varchar(200) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '工作区名称',
|
||
`fence_type` int DEFAULT NULL COMMENT '工作区类型 1--AI工作区',
|
||
`state` int DEFAULT NULL COMMENT '启用状态 0--禁用 1--启用',
|
||
`ref_latitude` double(32,6) NOT NULL COMMENT '参考点纬度',
|
||
`ref_longitude` double(32,6) NOT NULL COMMENT '参考点经度',
|
||
`points` text COLLATE utf8mb4_bin NOT NULL COMMENT '工作区范围',
|
||
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`update_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
`deleted` tinyint(1) DEFAULT '0' COMMENT '删除标识',
|
||
`color_code` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '围栏颜色色号',
|
||
PRIMARY KEY (`id`),
|
||
KEY `fence_area_fence_name_index` (`fence_name`),
|
||
KEY `fence_area_org_id_index` (`org_id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=134 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='工作区主表（电子围栏）';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `fence_work_segment`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `fence_work_segment`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `fence_work_segment` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`fence_id` bigint NOT NULL COMMENT '工作区id',
|
||
`org_id` bigint DEFAULT NULL COMMENT '组织id',
|
||
`work_type` int NOT NULL DEFAULT '1' COMMENT '类型 1--全天 2--时间段',
|
||
`start_time` time NOT NULL COMMENT '开始时间',
|
||
`end_time` time NOT NULL COMMENT '结束时间',
|
||
`ai_keys` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'ai模型列表',
|
||
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
PRIMARY KEY (`id`),
|
||
KEY `fence_work_segment_fence_id_index` (`fence_id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=141 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='工作区工作段';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `firmware`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `firmware`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `firmware` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '固件id',
|
||
`model` varchar(150) NOT NULL COMMENT '固件型号',
|
||
`product_version` varchar(25) DEFAULT NULL COMMENT '固件版本',
|
||
`file_name` varchar(150) NOT NULL COMMENT '固件文件名称',
|
||
`file_id` varchar(50) NOT NULL DEFAULT '' COMMENT '固件文件ID',
|
||
`md5` varchar(60) DEFAULT NULL COMMENT '固件文件MD5',
|
||
`type` tinyint(1) DEFAULT '1' COMMENT '设备基本类型，0为无人机，1为机库',
|
||
`file_size` bigint DEFAULT '0' COMMENT '固件文件大小',
|
||
`create_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除标识',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='固件信息表';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `flight_image`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `flight_image`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `flight_image` (
|
||
`id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID',
|
||
`drone_sn` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '无人机sn',
|
||
`filename` varchar(1000) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '文件名',
|
||
`size` bigint DEFAULT NULL COMMENT '文件大小',
|
||
`project_id` bigint DEFAULT NULL COMMENT '项目ID',
|
||
`start_time` datetime DEFAULT NULL COMMENT '视频开始时间',
|
||
`end_time` datetime DEFAULT NULL COMMENT '视频结束时间',
|
||
`pinned` tinyint(1) DEFAULT '0',
|
||
`sort` int DEFAULT NULL COMMENT '排序',
|
||
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
|
||
`update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新日期',
|
||
`parent_id` bigint DEFAULT '0' COMMENT '父ID',
|
||
`path` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '路径',
|
||
`org_id` bigint DEFAULT NULL,
|
||
`deleted` bigint DEFAULT '0',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=13563 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='飞行影像表';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `flight_image_graffiti`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `flight_image_graffiti`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `flight_image_graffiti` (
|
||
`id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID',
|
||
`image_info_id` bigint DEFAULT NULL COMMENT '照片信息ID',
|
||
`color` varchar(30) DEFAULT NULL COMMENT '颜色',
|
||
`label_name` varchar(30) DEFAULT NULL COMMENT '标签名称',
|
||
`type` tinyint(1) DEFAULT '1' COMMENT '标签类型,1-矩形，2-圆形等',
|
||
`data` text COMMENT '标注坐标数据',
|
||
`project_id` bigint DEFAULT NULL COMMENT '项目ID',
|
||
`creator_id` bigint DEFAULT NULL COMMENT '创建者ID',
|
||
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
|
||
`update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新日期',
|
||
`deleted` bigint DEFAULT '0' COMMENT '删除标识：非0 删除',
|
||
PRIMARY KEY (`id`),
|
||
KEY `flight_image_graffiti_image_info_id_IDX` (`image_info_id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=217 DEFAULT CHARSET=utf8mb3 COMMENT='照片标注信息表';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `flight_image_info`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `flight_image_info`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `flight_image_info` (
|
||
`id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID',
|
||
`drone_sn` varchar(200) DEFAULT NULL COMMENT '无人机sn',
|
||
`filename` varchar(1000) DEFAULT NULL COMMENT '文件名',
|
||
`object_id` varchar(1000) DEFAULT NULL COMMENT '文件ID',
|
||
`flight_image_id` bigint DEFAULT NULL COMMENT '影像文件夹ID',
|
||
`size` bigint DEFAULT NULL COMMENT '文件大小',
|
||
`type` varchar(20) DEFAULT NULL COMMENT '文件类型',
|
||
`file_type` int DEFAULT NULL COMMENT '文件类型 (0-广角照片、1-变焦照片、2-红外照片、3-可见光照片、4-AI检测照片、5-视频)',
|
||
`media_type` tinyint DEFAULT '0' COMMENT '媒体类型 0-照片 1-视频',
|
||
`is_load` tinyint(1) DEFAULT '0' COMMENT '是否在地图上加载, 0 不加载, 1 加载',
|
||
`is_show` tinyint(1) DEFAULT '1' COMMENT '是否显示在地图上, 0 不显示, 1 显示',
|
||
`extra` text COMMENT '额外信息，type 类型为图片时，存放经纬度和位置信息，为视频时存放视频开始时间和结束时间',
|
||
`created_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '照片或视频实际创建时间',
|
||
`project_id` bigint DEFAULT NULL COMMENT '项目ID',
|
||
`thumbnail` varchar(200) DEFAULT NULL COMMENT '缩略图',
|
||
`org_id` bigint DEFAULT NULL COMMENT '组织ID',
|
||
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
|
||
`update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新日期',
|
||
`deleted` bigint DEFAULT '0' COMMENT '删除标识：非0 删除',
|
||
`description` varchar(255) DEFAULT NULL COMMENT '描述',
|
||
PRIMARY KEY (`id`),
|
||
KEY `idx_flight_image_id` (`flight_image_id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=15802 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='影像信息表';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
/*!50003 SET @saved_cs_client = @@character_set_client */ ;
|
||
/*!50003 SET @saved_cs_results = @@character_set_results */ ;
|
||
/*!50003 SET @saved_col_connection = @@collation_connection */ ;
|
||
/*!50003 SET character_set_client = utf8mb4 */ ;
|
||
/*!50003 SET character_set_results = utf8mb4 */ ;
|
||
/*!50003 SET collation_connection = utf8mb4_0900_ai_ci */ ;
|
||
/*!50003 SET @saved_sql_mode = @@sql_mode */ ;
|
||
/*!50003 SET sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' */ ;
|
||
DELIMITER ;;
|
||
/*!50003 CREATE*/ /*!50017 DEFINER=`k8s_admin`@`%`*/ /*!50003 TRIGGER `after_flight_image_info_update` AFTER UPDATE ON `flight_image_info` FOR EACH ROW BEGIN
|
||
-- 检查文件名是否变更（重命名）
|
||
IF NEW.filename <> OLD.filename THEN
|
||
UPDATE flight_image
|
||
SET update_time = NOW()
|
||
WHERE id = NEW.flight_image_id;
|
||
END IF;
|
||
END */;;
|
||
DELIMITER ;
|
||
/*!50003 SET sql_mode = @saved_sql_mode */ ;
|
||
/*!50003 SET character_set_client = @saved_cs_client */ ;
|
||
/*!50003 SET character_set_results = @saved_cs_results */ ;
|
||
/*!50003 SET collation_connection = @saved_col_connection */ ;
|
||
|
||
--
|
||
-- Table structure for table `flight_record`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `flight_record`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `flight_record` (
|
||
`id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID',
|
||
`drone_sn` varchar(200) DEFAULT NULL COMMENT '无人机sn',
|
||
`drone_name` varchar(1000) DEFAULT NULL COMMENT '无人机名称',
|
||
`image_count` bigint DEFAULT NULL COMMENT '影像张数',
|
||
`total_count` bigint DEFAULT '0' COMMENT '影像总张数',
|
||
`project_id` bigint DEFAULT NULL COMMENT '项目ID',
|
||
`status` tinyint(1) DEFAULT '0' COMMENT '状态 0-进行中 1-已完成',
|
||
`start_time` datetime DEFAULT NULL COMMENT '开始时间',
|
||
`end_time` datetime DEFAULT NULL COMMENT '结束时间',
|
||
`duration` bigint DEFAULT '0' COMMENT '视频时长',
|
||
`total_distance` bigint DEFAULT NULL COMMENT '飞行距离',
|
||
`flight_image_id` bigint DEFAULT NULL COMMENT '影像文件夹ID',
|
||
`extra` text COMMENT '开始及结束经纬度信息',
|
||
`video_id` varchar(32) DEFAULT NULL COMMENT '录制视频ID',
|
||
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
|
||
`update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新日期',
|
||
`deleted` bigint DEFAULT '0' COMMENT '删除标识：非0 删除',
|
||
`org_id` bigint DEFAULT NULL,
|
||
PRIMARY KEY (`id`),
|
||
KEY `idx_flight_image_id` (`flight_image_id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=13547 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='飞行记录表';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `flight_record_video`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `flight_record_video`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `flight_record_video` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID',
|
||
`flight_record_id` bigint NOT NULL COMMENT '飞行记录ID',
|
||
`flight_video_id` bigint NOT NULL COMMENT '回放视频 ID',
|
||
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=11975 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='飞行记录回放视频关联表';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `flight_record_way_line`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `flight_record_way_line`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `flight_record_way_line` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键 ID',
|
||
`flight_record_id` bigint NOT NULL COMMENT '飞行记录ID',
|
||
`way_line_id` bigint NOT NULL COMMENT '航线ID',
|
||
`flight_id` varchar(20) DEFAULT NULL COMMENT ' 任务ID',
|
||
`project_id` bigint NOT NULL COMMENT '项目ID',
|
||
`his_way_line_ver` varchar(50) DEFAULT NULL COMMENT '历史航线版本',
|
||
`status` tinyint(1) DEFAULT NULL COMMENT '航线执行状态 0-未执行 1-已执行',
|
||
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
|
||
`update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新日期',
|
||
`deleted` bigint DEFAULT '0' COMMENT '删除标识：非0 删除',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=3077 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='飞行记录关联航线表';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `flight_video`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `flight_video`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `flight_video` (
|
||
`id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID',
|
||
`drone_sn` varchar(200) DEFAULT NULL COMMENT '无人机sn',
|
||
`stream` varchar(100) DEFAULT NULL COMMENT '流名称',
|
||
`filename` varchar(1000) DEFAULT NULL COMMENT '文件名',
|
||
`type` int DEFAULT '0' COMMENT '视频类型 0-无人机回放视频 1-AI检测视频',
|
||
`object_id` varchar(1000) DEFAULT NULL COMMENT '文件ID',
|
||
`size` bigint DEFAULT NULL COMMENT '文件大小',
|
||
`start_time` datetime DEFAULT NULL COMMENT '视频开始时间',
|
||
`end_time` datetime DEFAULT NULL COMMENT '视频结束时间',
|
||
`video_time` bigint DEFAULT NULL COMMENT '视频时长',
|
||
`extra` varchar(200) DEFAULT NULL COMMENT '扩展字段',
|
||
`project_id` bigint DEFAULT NULL COMMENT '项目ID',
|
||
`org_id` bigint DEFAULT NULL COMMENT '组织ID',
|
||
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
|
||
`update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新日期',
|
||
`deleted` bigint DEFAULT '0' COMMENT '删除标识：非0 删除',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=12098 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='影像回放视频表';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `gis_model_info`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `gis_model_info`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `gis_model_info` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键 ID',
|
||
`name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '模型名称',
|
||
`type` int DEFAULT NULL COMMENT '模型类型， 2：二维，3：三维',
|
||
`format` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '模型格式',
|
||
`size` bigint DEFAULT NULL COMMENT '模型文件大小',
|
||
`bucket_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '桶名称',
|
||
`file_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '对象路径',
|
||
`expansion` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '二维模型的边界',
|
||
`published` tinyint NOT NULL DEFAULT '0' COMMENT '发布状态',
|
||
`display` tinyint NOT NULL DEFAULT '1' COMMENT '是否显示',
|
||
`org_id` bigint DEFAULT NULL COMMENT '组织 ID',
|
||
`project_id` bigint DEFAULT NULL COMMENT '项目 ID',
|
||
`sort` tinyint DEFAULT NULL COMMENT '排序',
|
||
`storage_type` int DEFAULT '1' COMMENT '存储类型， 1：原始上传文件，2：复制分享文件复制',
|
||
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
`deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除标识',
|
||
`status` tinyint DEFAULT '0' COMMENT '模型重建状态,0:导入成功 1:重建成功 2:重建中 3:等待中 4:重建失败 5:已取消',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=178 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='地理模型信息';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `gis_model_rebuild`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `gis_model_rebuild`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `gis_model_rebuild` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增ID',
|
||
`gis_id` bigint NOT NULL COMMENT 'gis ID',
|
||
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '文件名称',
|
||
`type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '模型类型',
|
||
`total` bigint DEFAULT NULL COMMENT '照片数量',
|
||
`photo_info` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '重建照片信息',
|
||
`rebuild_rate` bigint DEFAULT '0' COMMENT '重建比例',
|
||
`resolution` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '分辨率和速度 medium、high、ultra',
|
||
`simple_ratio` double(10,2) DEFAULT '0.20' COMMENT '模型简化率 ',
|
||
`task_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '任务id',
|
||
`project_id` bigint NOT NULL COMMENT '项目id',
|
||
`org_id` bigint NOT NULL COMMENT '组织id',
|
||
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`update_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=104 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='gis模型重建信息表';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `label`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `label`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `label` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT,
|
||
`label_name` varchar(20) COLLATE utf8mb4_bin NOT NULL,
|
||
`demand_org_id` bigint NOT NULL,
|
||
`deleted` tinyint NOT NULL DEFAULT '0',
|
||
`create_user` bigint NOT NULL,
|
||
`create_time` datetime NOT NULL,
|
||
`update_user` bigint DEFAULT NULL,
|
||
`update_time` datetime DEFAULT NULL,
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `label_user`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `label_user`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `label_user` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT,
|
||
`label_id` bigint NOT NULL,
|
||
`user_id` bigint NOT NULL,
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `mq_log`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `mq_log`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `mq_log` (
|
||
`id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID',
|
||
`topic` varchar(200) DEFAULT NULL COMMENT '主题',
|
||
`message` varchar(1000) DEFAULT NULL COMMENT '消息体',
|
||
`error_msg` varchar(1000) DEFAULT NULL COMMENT '异常消息',
|
||
`type` varchar(32) DEFAULT NULL COMMENT '消息类型',
|
||
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
|
||
`update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新日期',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='mq日志表';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `msg_send`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `msg_send`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `msg_send` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增主键',
|
||
`msg_tpl_id` bigint NOT NULL COMMENT '模板Id',
|
||
`level` varchar(10) NOT NULL COMMENT '层级：org-组织级，project-项目级，user-用户级',
|
||
`tpl_type` varchar(12) NOT NULL COMMENT '模板类型：sms-短信，webmsg-站内信，email-邮件',
|
||
`receiver_id` bigint NOT NULL COMMENT '接收方Id，与level关联，orgId或projectId或userId',
|
||
`msg_title` varchar(200) DEFAULT NULL COMMENT '标题（模板标题）',
|
||
`msg_content` text NOT NULL COMMENT '消息内容',
|
||
`remark` varchar(256) DEFAULT NULL COMMENT '消息备注',
|
||
`deleted` tinyint NOT NULL COMMENT '删除标志：0-存在，1-删除',
|
||
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='通知公告表';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `msg_send_user`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `msg_send_user`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `msg_send_user` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增主键',
|
||
`msg_tpl_id` bigint NOT NULL COMMENT '模板Id',
|
||
`msg_id` bigint NOT NULL COMMENT '消息Id',
|
||
`level` varchar(10) NOT NULL COMMENT '层级：org-组织级，project-项目级，user-用户级',
|
||
`tpl_type` varchar(12) NOT NULL COMMENT '模板类型：sms-短信，webmsg-站内信，email-邮件',
|
||
`user_id` bigint NOT NULL COMMENT '用户id',
|
||
`title` varchar(128) DEFAULT NULL COMMENT '消息标题',
|
||
`content` text NOT NULL COMMENT '消息内容',
|
||
`emergency` tinyint DEFAULT NULL COMMENT '紧急消息：0-普通消息，1-紧急消息',
|
||
`send_status` tinyint DEFAULT NULL COMMENT '是否发送，1-发送，0-未发送',
|
||
`read_status` tinyint(1) NOT NULL COMMENT '是否已读：1-已读，0-未读',
|
||
`read_time` datetime DEFAULT NULL COMMENT '用户查看时间',
|
||
`deleted` tinyint NOT NULL COMMENT '删除标志：0-存在，1-删除',
|
||
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='通知公告-推送-用户表';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `msg_template`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `msg_template`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `msg_template` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增主键',
|
||
`level` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '层级：org-组织级，project-项目级，user-用户级',
|
||
`tpl_type` varchar(12) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '模板类型：sms-短信，webmsg-站内信，email-邮件',
|
||
`tpl_name` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '模板名称',
|
||
`tpl_title` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL COMMENT '模板标题',
|
||
`tpl_content` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '模板内容',
|
||
`lang_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '语言类型：US-英文，CN-中文',
|
||
`notice_type` varchar(6) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT 'sys' COMMENT '通知类型：sys-系统通知，biz-业务通知',
|
||
`emergency` tinyint DEFAULT '1' COMMENT '紧急消息：0-普通消息，1-紧急消息',
|
||
`remark` varchar(256) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL COMMENT '模版备注',
|
||
`deleted` tinyint NOT NULL COMMENT '删除标志：0-存在，1-删除',
|
||
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='通知公告模板表';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `multi_flight_item`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `multi_flight_item`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `multi_flight_item` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID',
|
||
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '任务名称',
|
||
`project_id` bigint DEFAULT NULL COMMENT '项目id',
|
||
`org_id` bigint DEFAULT NULL COMMENT '组织id',
|
||
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
`deleted` tinyint DEFAULT NULL COMMENT '删除标志：0-存在，1-删除',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='多机飞行任务表';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `operation_log`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `operation_log`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `operation_log` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID',
|
||
`drone_sn` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '设备SN',
|
||
`gateway_sn` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '网关SN',
|
||
`device_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '设备类型：无人机，机库',
|
||
`code` int DEFAULT NULL COMMENT '日志编码：0为操作通用成功，其余问题日志编码按实际业务产生，不固定',
|
||
`type` int DEFAULT NULL COMMENT '日志信息类型：如HMS告警日志',
|
||
`source` int DEFAULT NULL COMMENT '来源，例：地面站，机库，蜂窝网',
|
||
`log_msg` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '具体业务消息',
|
||
`log_time` bigint DEFAULT NULL COMMENT '时间戳',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=283 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='单机监视日志信息表';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `password_history`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `password_history`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `password_history` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增id',
|
||
`phone` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '手机号',
|
||
`name` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '用户昵称',
|
||
`password` varchar(155) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '密码',
|
||
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='历史密码表';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `plan_execute_his`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `plan_execute_his`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `plan_execute_his` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID',
|
||
`plan_execute_code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '计划执行编号',
|
||
`plan_id` bigint NOT NULL COMMENT '计划ID',
|
||
`execute_time` datetime NOT NULL COMMENT '执行时间',
|
||
`state` int unsigned NOT NULL COMMENT '执行状态 1:执行中，2:完成，3:部分执行，4:失败',
|
||
`dock_sn` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '机场SN',
|
||
`drone_sn` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '无人机sn',
|
||
`flight_record_id` bigint DEFAULT NULL COMMENT '飞行记录 ID',
|
||
`pic_number` int unsigned DEFAULT NULL COMMENT '影像数量',
|
||
`reason` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '原因',
|
||
`order_id` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'order_id',
|
||
`requirement_id` bigint DEFAULT NULL COMMENT '需求表ID',
|
||
PRIMARY KEY (`id`),
|
||
KEY `fk_execute_plan_id` (`plan_id` DESC),
|
||
KEY `idx_execute_time` (`execute_time` DESC),
|
||
KEY `idx_flight_record_id` (`flight_record_id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=2370 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='计划执行情况';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `plan_info`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `plan_info`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `plan_info` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键 ID',
|
||
`requirement_id` bigint DEFAULT NULL COMMENT '需求表ID',
|
||
`name` varchar(30) COLLATE utf8mb4_bin NOT NULL COMMENT '计划名称',
|
||
`project_id` bigint NOT NULL COMMENT '项目id',
|
||
`org_id` bigint NOT NULL COMMENT '组织id',
|
||
`type` tinyint unsigned NOT NULL COMMENT '计划策略 1:立即执行 2:单次执行 3:重复执行',
|
||
`once_time` datetime DEFAULT NULL COMMENT '立即执行/单次执行的预计执行时间',
|
||
`start_time` date DEFAULT NULL COMMENT '计划开始日期',
|
||
`end_time` date DEFAULT NULL COMMENT '计划结束日期',
|
||
`execute_time` varchar(150) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '执行时间',
|
||
`repeat_frequency` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '重复频率',
|
||
`line_id` bigint NOT NULL COMMENT '航线 ID',
|
||
`version_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '航线版本 ID',
|
||
`dock_sn` varchar(150) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '机场 SN',
|
||
`drone_sn` varchar(150) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '无人机 SN',
|
||
`return_height` double unsigned DEFAULT NULL COMMENT '返航高度',
|
||
`ai_models` varchar(500) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'AI模型',
|
||
`enabled` tinyint NOT NULL DEFAULT '1' COMMENT '是否启用',
|
||
`task_num` int DEFAULT NULL COMMENT '任务总次数',
|
||
`last_execute_time` datetime DEFAULT NULL COMMENT '最后执行时间',
|
||
`finished` tinyint NOT NULL DEFAULT '0' COMMENT '是否已完成',
|
||
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
`deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除标识',
|
||
PRIMARY KEY (`id`),
|
||
KEY `idx_plan_create_time` (`create_time` DESC),
|
||
KEY `idx_plan_end_time` (`end_time`),
|
||
KEY `idx_plan_start_time` (`start_time`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=470 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='飞行计划';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `plan_repeat_info`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `plan_repeat_info`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `plan_repeat_info` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID',
|
||
`plan_id` bigint NOT NULL COMMENT '计划ID',
|
||
`weekday` tinyint unsigned NOT NULL COMMENT '执行时间 1:周一 2:周二 3:周三 4:周四 5:周五 6:周六 7:周天',
|
||
`execute_time` time NOT NULL COMMENT '执行时间',
|
||
`type` int DEFAULT '1' COMMENT '日期类型 --1:day of week,2:day of mouth',
|
||
PRIMARY KEY (`id`),
|
||
KEY `fk_repeat_plan_id` (`plan_id` DESC),
|
||
KEY `idx_repeat_week` (`weekday`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=2029391405917593603 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='计划重复信息';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `platform_info`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `platform_info`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `platform_info` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID',
|
||
`platform_name` varchar(150) COLLATE utf8mb4_bin NOT NULL COMMENT '应用名称',
|
||
`org_id` bigint NOT NULL COMMENT '归属组织',
|
||
`project_ids` varchar(200) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '项目列表',
|
||
`client_id` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '应用id',
|
||
`client_secret` varchar(150) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '应用密钥',
|
||
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
PRIMARY KEY (`id`),
|
||
UNIQUE KEY `uk_platform_info_client` (`client_id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='三方应用信息';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `poi_info`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `poi_info`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `poi_info` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`poi_type` bigint DEFAULT NULL COMMENT 'poi类型 poi_type的id',
|
||
`poi_name` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'POI名称',
|
||
`is_show` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否显示',
|
||
`poi_latitude` double NOT NULL COMMENT '标注纬度',
|
||
`poi_longitude` double NOT NULL COMMENT '标注经度',
|
||
`ref_address` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '参考地点（前端传递，没传不存）',
|
||
`remark` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '备注信息',
|
||
`org_id` bigint DEFAULT NULL COMMENT '组织id',
|
||
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
`deleted` tinyint(1) DEFAULT '0' COMMENT '删除标识',
|
||
PRIMARY KEY (`id`),
|
||
KEY `poi_info_poi_name_index` (`poi_name`),
|
||
KEY `poi_info_poi_type_index` (`poi_type`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=1635 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='poi地图标注';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `poi_type`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `poi_type`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `poi_type` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID',
|
||
`type_name` varchar(50) COLLATE utf8mb4_bin NOT NULL COMMENT '类型名称',
|
||
`poi_icon` varchar(150) COLLATE utf8mb4_bin NOT NULL COMMENT '类型图标',
|
||
`bucket` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '图标存放桶',
|
||
`org_id` bigint NOT NULL COMMENT '组织id',
|
||
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
`deleted` tinyint(1) DEFAULT '0' COMMENT '删除标识',
|
||
PRIMARY KEY (`id`),
|
||
KEY `poi_type_org_id_index` (`org_id`),
|
||
KEY `poi_type_type_name_index` (`type_name`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='poi标注类型';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `project_ai_model_info`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `project_ai_model_info`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `project_ai_model_info` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键 ID',
|
||
`project_id` bigint NOT NULL COMMENT '项目 ID',
|
||
`model` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '模型类型',
|
||
`model_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '模型名称',
|
||
`sort` int NOT NULL COMMENT '排序字段',
|
||
`extra` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '模型扩展信息，比如阈值等',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=6301 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='项目已添加模型信息';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `project_device_ai_setting`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `project_device_ai_setting`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `project_device_ai_setting` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键 ID',
|
||
`project_id` bigint NOT NULL COMMENT '项目 ID',
|
||
`sn` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '设备SN',
|
||
`model` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '模型',
|
||
`extra` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '模型扩展信息，比如阈值等',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='项目设备AI模型扩展参数';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `project_info`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `project_info`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `project_info` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID',
|
||
`project_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '项目名称',
|
||
`creator` bigint DEFAULT NULL COMMENT '创建人id',
|
||
`org_id` bigint DEFAULT NULL COMMENT '组织id',
|
||
`center_longitude` double(32,6) DEFAULT NULL COMMENT '中心点经度',
|
||
`center_latitude` double(32,6) DEFAULT NULL COMMENT '中心点纬度',
|
||
`zoom` int DEFAULT NULL COMMENT '地图放大倍数',
|
||
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
`deleted` tinyint(1) DEFAULT '0' COMMENT '删除标识',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=10127 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='项目管理表';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `project_member`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `project_member`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `project_member` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID',
|
||
`user_id` bigint NOT NULL COMMENT '用户id',
|
||
`user_permission` int NOT NULL COMMENT '0:可管理，1:可编辑，2：可查看',
|
||
`project_id` bigint DEFAULT NULL COMMENT '项目id',
|
||
`org_id` bigint DEFAULT NULL COMMENT '项目组织id',
|
||
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
`deleted` tinyint(1) DEFAULT '0' COMMENT '删除标识',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=10496 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='项目关联的成员表';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `requirement`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `requirement`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `requirement` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT,
|
||
`requirement_number` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT '需求编号',
|
||
`requirement_name` varchar(20) COLLATE utf8mb4_bin NOT NULL COMMENT '需求名称',
|
||
`requirement_type` tinyint NOT NULL COMMENT '需求类型 1：常规需求 2：紧急需求',
|
||
`task_strategy` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '任务策略，常规需求属性，immediately: 立即 single: 单次定时, repeat: 重复定时',
|
||
`execute_time` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '常规需求属性，单次定时任务执行时间',
|
||
`execute_start_time` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '常规需求属性，重复定时任务开始执行日期',
|
||
`execute_end_time` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '常规需求属性，重复定时任务截止执行日期',
|
||
`repeat_frequency` varchar(128) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '常规需求属性，重复定时任务执行频率，多个以“,”分隔',
|
||
`task_area_desc` varchar(200) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '常规需求任务区域描述',
|
||
`task_area` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '紧急需求属性，任务执行区域',
|
||
`longitude` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '紧急需求属性，任务执行区域经度',
|
||
`latitude` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '紧急需求属性，任务执行区域纬度',
|
||
`detection_target` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '''AI检测目标，多个目标以“,”分隔',
|
||
`remark` varchar(200) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '备注信息',
|
||
`contact_person` varchar(155) COLLATE utf8mb4_bin NOT NULL COMMENT '需求联系人',
|
||
`contact_mobile` varchar(155) COLLATE utf8mb4_bin NOT NULL COMMENT '需求联系人电话',
|
||
`affiliated_unit` bigint NOT NULL COMMENT '需求归属单位',
|
||
`status` tinyint NOT NULL COMMENT '需求状态，1：待受理 2：已受理 3：已完成 4：已退回',
|
||
`create_time` datetime NOT NULL COMMENT '创建时间',
|
||
`org_id` bigint DEFAULT NULL,
|
||
`alert_notice_realtime` tinyint DEFAULT '0' COMMENT '是否需要实时通知预警事件 0：否 1：是',
|
||
`airline_points` text COLLATE utf8mb4_bin COMMENT '航点坐标集',
|
||
PRIMARY KEY (`id`),
|
||
UNIQUE KEY `uni_requirement_number` (`requirement_number`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=142 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `requirement_process`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `requirement_process`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `requirement_process` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT,
|
||
`requirement_id` bigint NOT NULL COMMENT '需求ID',
|
||
`operate_type` varchar(10) COLLATE utf8mb4_bin NOT NULL COMMENT '操作类型，create：需求创建 modify：需求修改 accept：需求受理 complete：需求完成 back：需求退回',
|
||
`operate_user` bigint NOT NULL COMMENT '操作用户ID',
|
||
`operate_time` datetime NOT NULL COMMENT '操作时间',
|
||
`back_reason` varchar(200) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '退回原因',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=266 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `requirement_regular_task_area`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `requirement_regular_task_area`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `requirement_regular_task_area` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT,
|
||
`requirement_id` bigint NOT NULL COMMENT '需求ID',
|
||
`area_id` bigint NOT NULL COMMENT '任务区域ID',
|
||
`area_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '任务区域名称',
|
||
`detection_target` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT 'AI检测目标，多个目标以“,”分隔',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `speaker_his_info`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `speaker_his_info`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `speaker_his_info` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID',
|
||
`drone_sn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '无人机sn',
|
||
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '文件名',
|
||
`text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin COMMENT '文本内容',
|
||
`type` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '文字类型：HIS-最近历史喊话，SET-常用喊话设置',
|
||
`md5` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '文件内容的MD5校验和，用作唯一标识',
|
||
`sort` int DEFAULT NULL COMMENT '排序字段',
|
||
`project_id` bigint DEFAULT NULL COMMENT '项目ID',
|
||
`org_id` bigint DEFAULT NULL COMMENT '组织ID',
|
||
`deleted` tinyint NOT NULL COMMENT '删除标识',
|
||
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='无人机喊话历史信息表';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `storage_object`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `storage_object`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `storage_object` (
|
||
`id` varchar(32) NOT NULL COMMENT '文件UUID',
|
||
`drone_sn` varchar(150) NOT NULL COMMENT '设备sn',
|
||
`object_name` varchar(1000) NOT NULL COMMENT '文件名',
|
||
`type` int DEFAULT '0' COMMENT '文件类型 0--图片，1--视频，2--gis，3--日志，4--其他',
|
||
`object_size` bigint DEFAULT '0' COMMENT '大小，默认 单位为byte字节',
|
||
`object_format` varchar(10) DEFAULT NULL COMMENT '格式',
|
||
`bucket_name` varchar(255) DEFAULT NULL COMMENT '桶名称',
|
||
`object_path` varchar(1000) DEFAULT NULL COMMENT '对象路径 日期/项目/类型/对象ID.对象类型 20201104/234234/234/2234.jpg',
|
||
`object_md5` varchar(255) DEFAULT NULL COMMENT '文件md5',
|
||
`thumbnail_path` varchar(255) DEFAULT NULL COMMENT '缩略图路径',
|
||
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
|
||
`update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新日期',
|
||
`org_id` bigint DEFAULT NULL COMMENT '组织id',
|
||
`project_id` bigint DEFAULT NULL COMMENT '项目ID',
|
||
`extra` varchar(1000) DEFAULT NULL COMMENT '扩展 备注/时长 测试/150s',
|
||
`deleted` bigint DEFAULT '0' COMMENT '删除标识：非0 删除',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `idx_sn` (`drone_sn`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='文件信息表';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `storage_object_device`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `storage_object_device`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `storage_object_device` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID',
|
||
`object_id` varchar(150) NOT NULL COMMENT '文件ID',
|
||
`drone_model` varchar(150) DEFAULT NULL COMMENT '拍摄的无人机型号',
|
||
`payload_model` varchar(150) DEFAULT NULL COMMENT '拍摄的载荷型号',
|
||
`is_original` tinyint(1) DEFAULT '0' COMMENT '是否为原图 1 是',
|
||
`flight_id` varchar(100) DEFAULT NULL COMMENT '任务ID',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `object_id` (`object_id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=2197 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='文件额外设备信息表';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `storage_object_media`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `storage_object_media`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `storage_object_media` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID',
|
||
`object_id` varchar(150) NOT NULL COMMENT '文件ID',
|
||
`absolute_altitude` double DEFAULT NULL COMMENT '拍摄绝对高度',
|
||
`create_time` datetime DEFAULT NULL COMMENT '媒体拍摄时间',
|
||
`gimbal_yaw_degree` double DEFAULT NULL COMMENT '云台偏航角',
|
||
`latitude` double DEFAULT NULL COMMENT '拍摄经度',
|
||
`longitude` double DEFAULT NULL COMMENT '拍摄纬度',
|
||
`relative_altitude` double DEFAULT NULL COMMENT '拍摄相对高度',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `object_id` (`object_id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=15831 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='文件额外元信息表';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `storage_object_tus`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `storage_object_tus`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `storage_object_tus` (
|
||
`id` varchar(32) NOT NULL COMMENT '文件UUID',
|
||
`drone_sn` varchar(150) DEFAULT NULL COMMENT '设备sn',
|
||
`object_name` varchar(1000) NOT NULL COMMENT '文件名',
|
||
`object_size` mediumtext COMMENT '大小，默认 单位为byte字节',
|
||
`offset_size` mediumtext COMMENT '已上传文件大小，默认 单位为byte字节',
|
||
`object_format` varchar(10) DEFAULT NULL COMMENT '格式',
|
||
`temp_path` varchar(1000) DEFAULT NULL COMMENT '临时对象路径 日期/类型/对象ID.对象类型 20201104/234/22374.jpg',
|
||
`final_path` varchar(1000) DEFAULT NULL COMMENT '对象路径 日期/项目/类型/对象ID.对象类型 20201104/234234/234/2234.jpg',
|
||
`temp_path_prefix` varchar(1000) DEFAULT NULL COMMENT '临时对象路径前缀 20201104/234/',
|
||
`status` tinyint(1) DEFAULT '0' COMMENT '上传状态 0：上传中 1：上传成功 2：上传失败 3：取消上传',
|
||
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
|
||
`update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新日期',
|
||
`project_id` bigint DEFAULT NULL COMMENT '项目ID',
|
||
`extra` varchar(1000) DEFAULT NULL COMMENT '扩展 时长 150s',
|
||
`deleted` bigint DEFAULT '0' COMMENT '删除标识：非0 删除',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `idx_sn` (`drone_sn`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='tus文件信息表';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `storage_object_type`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `storage_object_type`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `storage_object_type` (
|
||
`id` int NOT NULL AUTO_INCREMENT,
|
||
`type` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '业务类型',
|
||
`max_size` int NOT NULL COMMENT '最大文件大小',
|
||
`type_limit` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '文件类型限制',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE KEY `idx_type` (`type`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='文件类型表';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Temporary view structure for view `storage_space_view`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `storage_space_view`;
|
||
/*!50001 DROP VIEW IF EXISTS `storage_space_view`*/;
|
||
SET @saved_cs_client = @@character_set_client;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
/*!50001 CREATE VIEW `storage_space_view` AS SELECT
|
||
1 AS `org_id`,
|
||
1 AS `project_id`,
|
||
1 AS `total_size`,
|
||
1 AS `type`*/;
|
||
SET character_set_client = @saved_cs_client;
|
||
|
||
--
|
||
-- Table structure for table `sur_speaker_record`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `sur_speaker_record`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `sur_speaker_record` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID',
|
||
`name` varchar(255) DEFAULT NULL COMMENT '录音记录名称',
|
||
`type` varchar(50) DEFAULT 'pcm' COMMENT '录音记录类型(pcm:default=音频pcm格式文件)',
|
||
`file_name` varchar(255) DEFAULT NULL COMMENT '录音文件名称',
|
||
`object_id` varchar(255) DEFAULT NULL COMMENT '录音文件id',
|
||
`duration` int DEFAULT NULL COMMENT '录音时长',
|
||
`project_id` bigint DEFAULT NULL COMMENT '分配项目',
|
||
`org_id` bigint DEFAULT NULL COMMENT '组织id',
|
||
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
`deleted` tinyint(1) DEFAULT '0' COMMENT '删除标识',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='说话人录音记录表';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `surveillance_log`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `surveillance_log`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `surveillance_log` (
|
||
`id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '日志ID',
|
||
`drone_id` bigint DEFAULT NULL COMMENT '无人机ID',
|
||
`dock_id` bigint DEFAULT NULL COMMENT '机库ID或网关ID',
|
||
`org_id` bigint NOT NULL COMMENT '组织ID',
|
||
`project_id` bigint DEFAULT NULL COMMENT '项目ID',
|
||
`user_id` bigint DEFAULT NULL COMMENT '用户ID',
|
||
`log_module` varchar(50) NOT NULL COMMENT '日志模块 surveillance',
|
||
`log_mark` varchar(20) NOT NULL COMMENT '日志标记',
|
||
`data` text COMMENT '日志数据(JSON格式)',
|
||
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=1246 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='飞行监视日志表';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `third_device_stream`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `third_device_stream`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `third_device_stream` (
|
||
`id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID',
|
||
`device_sn` varchar(50) DEFAULT NULL COMMENT '设备sn',
|
||
`device_name` varchar(50) DEFAULT NULL COMMENT '设备名称',
|
||
`status` tinyint(1) DEFAULT '0' COMMENT '视频流状态:1 有视频流,0 无视频流',
|
||
`mode` varchar(10) DEFAULT NULL COMMENT '视频流模式:MANUAL 手动,AUTO自动',
|
||
`push_url` varchar(1000) DEFAULT NULL COMMENT '推流地址（在手动必填，在自动实时获取）',
|
||
`pull_url` varchar(1000) DEFAULT NULL COMMENT '拉流地址（在手动必填，在自动实时获取）',
|
||
`project_id` bigint DEFAULT NULL COMMENT '项目ID',
|
||
`org_id` bigint DEFAULT NULL COMMENT '组织ID',
|
||
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
|
||
`update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新日期',
|
||
`deleted` bigint DEFAULT '0' COMMENT '删除标识：非0 删除',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=91 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='三方设备流信息表';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `way_line`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `way_line`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `way_line` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
|
||
`version_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '版本号,新建和更新的时候变更,使用uuid',
|
||
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '航线名称',
|
||
`description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '描述',
|
||
`project_id` bigint NOT NULL COMMENT '项目id',
|
||
`org_id` bigint NOT NULL COMMENT '组织id',
|
||
`drone_model` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '无人机型号',
|
||
`payload_models` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin COMMENT '载荷型号和位置信息列表',
|
||
`way_line_params` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin COMMENT '航线属性参数',
|
||
`one_way_line` mediumtext COLLATE utf8mb4_bin NOT NULL COMMENT '一条航线信息',
|
||
`kmz_file_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '文件id, 存储管理返回的',
|
||
`kmz_file_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '文件在minio的路径',
|
||
`kmz_file_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '文件名',
|
||
`deleted` tinyint NOT NULL COMMENT '删除标识',
|
||
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
`template_type` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '模板类型',
|
||
`start_point` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '航线的首点',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=1559 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `way_line_ai`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `way_line_ai`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `way_line_ai` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增主键',
|
||
`way_line_id` varchar(255) COLLATE utf8mb4_bin NOT NULL COMMENT '航线ID(历史ID）',
|
||
`ai_enable` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'AI检测开关状态',
|
||
`ai_segments` text COLLATE utf8mb4_bin COMMENT 'AI检测航段',
|
||
`deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除标识',
|
||
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=1458 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='航线AI配置信息';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `way_line_history`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `way_line_history`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `way_line_history` (
|
||
`version_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '版本号,新建和更新的时候变更,使用uuid',
|
||
`source_id` bigint NOT NULL COMMENT '源航线id',
|
||
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '航线名称',
|
||
`description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '描述',
|
||
`project_id` bigint NOT NULL COMMENT '项目id',
|
||
`org_id` bigint NOT NULL COMMENT '组织id',
|
||
`drone_model` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '无人机型号',
|
||
`payload_models` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin COMMENT '载荷型号和位置信息列表',
|
||
`way_line_params` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin COMMENT '航线属性参数',
|
||
`one_way_line` mediumtext COLLATE utf8mb4_bin NOT NULL COMMENT '一条航线信息',
|
||
`kmz_file_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '文件id, 存储管理返回的',
|
||
`kmz_file_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '文件在minio的路径',
|
||
`kmz_file_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '文件名',
|
||
`deleted` tinyint NOT NULL COMMENT '删除标识',
|
||
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
`template_type` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '模板类型',
|
||
`start_point` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '航线的首点',
|
||
PRIMARY KEY (`version_id`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `way_line_photo`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `way_line_photo`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `way_line_photo` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增ID',
|
||
`way_line_id` bigint NOT NULL COMMENT '航线ID',
|
||
`version_id` varchar(255) COLLATE utf8mb4_bin NOT NULL COMMENT '航线版本ID',
|
||
`template_type` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '航线类型',
|
||
`flight_id` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL COMMENT ' 任务ID',
|
||
`mapping_param` text COLLATE utf8mb4_bin COMMENT '航线正射/斜射参数',
|
||
`collection_time` datetime DEFAULT NULL COMMENT '照片采集时间',
|
||
`project_id` bigint NOT NULL COMMENT '项目id',
|
||
`org_id` bigint NOT NULL COMMENT '组织id',
|
||
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`update_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
`deleted` tinyint(1) DEFAULT '0' COMMENT '删除标识',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='航线任务照片表';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `way_line_top_sort`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `way_line_top_sort`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `way_line_top_sort` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
|
||
`way_line_id` bigint NOT NULL COMMENT '航线id',
|
||
`project_id` bigint NOT NULL COMMENT '项目id',
|
||
`org_id` bigint NOT NULL COMMENT '组织id',
|
||
`drone_id` bigint DEFAULT NULL COMMENT '无人机id',
|
||
`sorted` bigint NOT NULL COMMENT '排序字段',
|
||
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=1606 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='航线置顶数据中间表';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `weak_password`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `weak_password`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `weak_password` (
|
||
`id` int NOT NULL AUTO_INCREMENT COMMENT '自增id',
|
||
`password` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '弱密码',
|
||
`encode_password` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '加密后的密码',
|
||
`create_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`create_by` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '创建用户id',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE KEY `uniq_weak_password_password` (`password`) USING BTREE,
|
||
UNIQUE KEY `uniq_weak_password_encoder_passwprd` (`encode_password`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=10618 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='弱密码表';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `work_order_info`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `work_order_info`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!50503 SET character_set_client = utf8mb4 */;
|
||
CREATE TABLE `work_order_info` (
|
||
`id` bigint NOT NULL COMMENT '工单 ID',
|
||
`name` varchar(30) COLLATE utf8mb4_bin NOT NULL COMMENT '工单需求名称',
|
||
`priority` tinyint unsigned NOT NULL COMMENT '紧急程度：1-紧急 2-高 3-中 4-低',
|
||
`order_type` tinyint unsigned NOT NULL COMMENT '任务策略：1-立即 2-定时 3-重复定时',
|
||
`task_type` varchar(100) COLLATE utf8mb4_bin NOT NULL COMMENT '任务类型：0-拍照 1-视频 2-全景 3-正射 4-三维间',
|
||
`repeat_frequency` tinyint unsigned DEFAULT NULL COMMENT '重复频率：1-日 2-周 3-月（orderType=3时必填）期',
|
||
`days` varchar(500) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '重复执行日期• 周：1-7（周一至周日• 月：日期(1-31) 或 "周次,星期"（如"2,3"表示第2周周期',
|
||
`execute_time` char(150) COLLATE utf8mb4_bin NOT NULL COMMENT '执行时间',
|
||
`start_time` date NOT NULL COMMENT '开始日期',
|
||
`end_time` date DEFAULT NULL COMMENT '结束日期',
|
||
`execute_org_name` varchar(150) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '运营单位名称',
|
||
`ai_type_list` text COLLATE utf8mb4_bin COMMENT '算法选择列表',
|
||
`detection` text COLLATE utf8mb4_bin COMMENT '检测内容描述',
|
||
`remark` text COLLATE utf8mb4_bin COMMENT '工单备注',
|
||
`mark_info` varchar(500) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '航点信息(JSON字符)',
|
||
`type` varchar(500) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '地理类型：Point/LineString/Polygon',
|
||
`geo_data` varchar(500) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '区域信息(GeoJSON格式)',
|
||
`status` tinyint NOT NULL DEFAULT '1' COMMENT '工单状态：1-未接单 /2-未开始 /3-进行中/4- 已完成/-1-退回',
|
||
`plan_id` bigint DEFAULT NULL COMMENT '计划ID',
|
||
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
`deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除标识',
|
||
`source` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
|
||
PRIMARY KEY (`id`),
|
||
KEY `idx_plan_id` (`plan_id`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='工单需求';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
|
||
-- Dump completed on 2026-03-05 15:05:57
|