186 lines
12 KiB
MySQL
186 lines
12 KiB
MySQL
|
/*
|
||
|
|
Navicat Premium Data Transfer
|
||
|
|
|
||
|
|
Source Server : 127.0.0.1
|
||
|
|
Source Server Type : MySQL
|
||
|
|
Source Server Version : 50743
|
||
|
|
Source Host : 127.0.0.1:3309
|
||
|
|
Source Schema : zero_v5
|
||
|
|
|
||
|
|
Target Server Type : MySQL
|
||
|
|
Target Server Version : 50743
|
||
|
|
File Encoding : 65001
|
||
|
|
|
||
|
|
Date: 10/07/2025 00:07:09
|
||
|
|
*/
|
||
|
|
|
||
|
|
SET NAMES utf8mb4;
|
||
|
|
SET FOREIGN_KEY_CHECKS = 0;
|
||
|
|
|
||
|
|
|
||
|
|
-- ----------------------------
|
||
|
|
-- Table structure for blade_visual
|
||
|
|
-- ----------------------------
|
||
|
|
DROP TABLE IF EXISTS `blade_visual`;
|
||
|
|
CREATE TABLE `blade_visual` (
|
||
|
|
`id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '主键',
|
||
|
|
`title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '大屏标题',
|
||
|
|
`background_url` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '大屏背景',
|
||
|
|
`category` int(11) NULL DEFAULT NULL COMMENT '大屏类型',
|
||
|
|
`password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '发布密码',
|
||
|
|
`create_user` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人',
|
||
|
|
`create_dept` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建部门',
|
||
|
|
`create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
||
|
|
`update_user` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '修改人',
|
||
|
|
`update_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
|
||
|
|
`status` int(11) NOT NULL COMMENT '状态',
|
||
|
|
`is_deleted` int(11) NOT NULL COMMENT '是否已删除',
|
||
|
|
`f_tenant_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '租户id',
|
||
|
|
PRIMARY KEY (`id`, `f_tenant_id`) USING BTREE
|
||
|
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '大屏信息' ROW_FORMAT = DYNAMIC;
|
||
|
|
|
||
|
|
|
||
|
|
-- ----------------------------
|
||
|
|
-- Table structure for blade_visual_assets
|
||
|
|
-- ----------------------------
|
||
|
|
DROP TABLE IF EXISTS `blade_visual_assets`;
|
||
|
|
CREATE TABLE `blade_visual_assets` (
|
||
|
|
`id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '主键',
|
||
|
|
`assetsName` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '资源名称',
|
||
|
|
`assetsSize` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '资源大小 1M',
|
||
|
|
`assetsTime` datetime NULL DEFAULT NULL COMMENT '资源上传时间',
|
||
|
|
`assetsType` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '资源后缀名',
|
||
|
|
`assetsUrl` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '资源地址',
|
||
|
|
`f_tenant_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '租户id',
|
||
|
|
PRIMARY KEY (`id`, `f_tenant_id`) USING BTREE
|
||
|
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '大屏静态资源' ROW_FORMAT = DYNAMIC;
|
||
|
|
|
||
|
|
|
||
|
|
-- ----------------------------
|
||
|
|
-- Table structure for blade_visual_category
|
||
|
|
-- ----------------------------
|
||
|
|
DROP TABLE IF EXISTS `blade_visual_category`;
|
||
|
|
CREATE TABLE `blade_visual_category` (
|
||
|
|
`id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '主键',
|
||
|
|
`category_key` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '分类键值',
|
||
|
|
`category_value` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '分类名称',
|
||
|
|
`is_deleted` int(11) NOT NULL DEFAULT 0 COMMENT '是否已删除',
|
||
|
|
`f_tenant_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '租户id',
|
||
|
|
PRIMARY KEY (`id`, `f_tenant_id`) USING BTREE
|
||
|
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '大屏分类' ROW_FORMAT = DYNAMIC;
|
||
|
|
|
||
|
|
-- ----------------------------
|
||
|
|
-- Table structure for blade_visual_component
|
||
|
|
-- ----------------------------
|
||
|
|
DROP TABLE IF EXISTS `blade_visual_component`;
|
||
|
|
CREATE TABLE `blade_visual_component` (
|
||
|
|
`id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '主键',
|
||
|
|
`name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '组件名称',
|
||
|
|
`content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '组件内容',
|
||
|
|
`type` int(11) NULL DEFAULT NULL,
|
||
|
|
`img` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
|
||
|
|
`f_tenant_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '租户id',
|
||
|
|
PRIMARY KEY (`id`, `f_tenant_id`) USING BTREE
|
||
|
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '大屏自定义组件' ROW_FORMAT = DYNAMIC;
|
||
|
|
|
||
|
|
|
||
|
|
-- ----------------------------
|
||
|
|
-- Table structure for blade_visual_config
|
||
|
|
-- ----------------------------
|
||
|
|
DROP TABLE IF EXISTS `blade_visual_config`;
|
||
|
|
CREATE TABLE `blade_visual_config` (
|
||
|
|
`id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '主键',
|
||
|
|
`visual_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '可视化表主键',
|
||
|
|
`detail` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '配置json',
|
||
|
|
`component` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '组件json',
|
||
|
|
`f_tenant_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '租户id',
|
||
|
|
PRIMARY KEY (`id`, `f_tenant_id`) USING BTREE
|
||
|
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '大屏信息配置' ROW_FORMAT = DYNAMIC;
|
||
|
|
|
||
|
|
|
||
|
|
-- ----------------------------
|
||
|
|
-- Table structure for blade_visual_db
|
||
|
|
-- ----------------------------
|
||
|
|
DROP TABLE IF EXISTS `blade_visual_db`;
|
||
|
|
CREATE TABLE `blade_visual_db` (
|
||
|
|
`id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '主键',
|
||
|
|
`name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '名称',
|
||
|
|
`driver_class` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '驱动类',
|
||
|
|
`url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '连接地址',
|
||
|
|
`username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户名',
|
||
|
|
`password` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '密码',
|
||
|
|
`remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
|
||
|
|
`create_user` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人',
|
||
|
|
`create_dept` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建部门',
|
||
|
|
`create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
||
|
|
`update_user` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '修改人',
|
||
|
|
`update_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
|
||
|
|
`status` int(11) NULL DEFAULT NULL COMMENT '状态',
|
||
|
|
`is_deleted` int(11) NULL DEFAULT NULL COMMENT '是否已删除',
|
||
|
|
`f_tenant_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '租户id',
|
||
|
|
PRIMARY KEY (`id`, `f_tenant_id`) USING BTREE
|
||
|
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '大屏数据源' ROW_FORMAT = DYNAMIC;
|
||
|
|
|
||
|
|
|
||
|
|
-- ----------------------------
|
||
|
|
-- Table structure for blade_visual_glob
|
||
|
|
-- ----------------------------
|
||
|
|
DROP TABLE IF EXISTS `blade_visual_glob`;
|
||
|
|
CREATE TABLE `blade_visual_glob` (
|
||
|
|
`id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '主键',
|
||
|
|
`globalName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '变量名称',
|
||
|
|
`globalKey` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '变量Key',
|
||
|
|
`globalValue` varchar(4000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '变量值',
|
||
|
|
`f_tenant_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '租户id',
|
||
|
|
PRIMARY KEY (`id`, `f_tenant_id`) USING BTREE
|
||
|
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '大屏全局变量' ROW_FORMAT = DYNAMIC;
|
||
|
|
|
||
|
|
-- ----------------------------
|
||
|
|
-- Records of blade_visual_glob
|
||
|
|
-- ----------------------------
|
||
|
|
|
||
|
|
-- ----------------------------
|
||
|
|
-- Table structure for blade_visual_map
|
||
|
|
-- ----------------------------
|
||
|
|
DROP TABLE IF EXISTS `blade_visual_map`;
|
||
|
|
CREATE TABLE `blade_visual_map` (
|
||
|
|
`id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '主键',
|
||
|
|
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '地图名称',
|
||
|
|
`data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '地图数据',
|
||
|
|
`code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '地图编码',
|
||
|
|
`map_level` int(11) NULL DEFAULT NULL COMMENT '地图级别 0:国家 1:省份 2:城市 3:区县',
|
||
|
|
`parent_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '上级ID',
|
||
|
|
`parent_code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '上级编码',
|
||
|
|
`ancestors` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '祖编码',
|
||
|
|
`f_tenant_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '租户id',
|
||
|
|
PRIMARY KEY (`id`, `f_tenant_id`) USING BTREE
|
||
|
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '大屏地图' ROW_FORMAT = DYNAMIC;
|
||
|
|
|
||
|
|
|
||
|
|
-- ----------------------------
|
||
|
|
-- Table structure for blade_visual_record
|
||
|
|
-- ----------------------------
|
||
|
|
DROP TABLE IF EXISTS `blade_visual_record`;
|
||
|
|
CREATE TABLE `blade_visual_record` (
|
||
|
|
`id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '主键',
|
||
|
|
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '名称',
|
||
|
|
`url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '请求地址',
|
||
|
|
`dataType` int(11) NULL DEFAULT NULL COMMENT '数据集类型',
|
||
|
|
`dataMethod` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '请求方法',
|
||
|
|
`dataHeader` varchar(4000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '请求头部',
|
||
|
|
`data` varchar(4000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '请求数据',
|
||
|
|
`dataQuery` varchar(4000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '请求参数',
|
||
|
|
`dataQueryType` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '请求参数类型',
|
||
|
|
`dataFormatter` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '过滤器',
|
||
|
|
`proxy` int(11) NULL DEFAULT NULL COMMENT '开启跨域',
|
||
|
|
`wsUrl` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'WebSocket地址',
|
||
|
|
`dbsql` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
|
||
|
|
`fsql` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
|
||
|
|
`result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
|
||
|
|
`mqttUrl` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'MQTT地址',
|
||
|
|
`mqttConfig` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT 'MQTT配置',
|
||
|
|
`f_tenant_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '租户id',
|
||
|
|
PRIMARY KEY (`id`, `f_tenant_id`) USING BTREE
|
||
|
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '大屏数据集' ROW_FORMAT = DYNAMIC;
|
||
|
|
|
||
|
|
SET FOREIGN_KEY_CHECKS = 1;
|