4dkankan-fusion/doc/4dkankan_v4-init.sql

CREATE DATABASE IF NOT EXISTS `4dkankan_v4` CHARACTER SET 'utf8mb4' COLLATE 'utf8mb4_general_ci';
USE `4dkankan_v4`;

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for mq_camera_level
-- ----------------------------
DROP TABLE IF EXISTS `mq_camera_level`;
CREATE TABLE `mq_camera_level`  (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '计算优先级设置',
  `camera_id` int NULL DEFAULT NULL COMMENT '相机id',
  `queue_config_id` int NULL DEFAULT NULL COMMENT '计算优先级队列id',
  `rec_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'A',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of mq_camera_level
-- ----------------------------

-- ----------------------------
-- Table structure for mq_ecs
-- ----------------------------
DROP TABLE IF EXISTS `mq_ecs`;
CREATE TABLE `mq_ecs`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `ecs_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `queue_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `status` int NULL DEFAULT 0 COMMENT '0运行中未计算，1运行中计算中，2停止运行',
  `is_scaling` int NULL DEFAULT 1 COMMENT '是否是弹性伸缩0否1是',
  `rec_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'A',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 148 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of mq_ecs
-- ----------------------------
INSERT INTO `mq_ecs` VALUES (1, NULL, 'modeling-call-A', '2024-04-15 17:18:32', '2024-08-07 12:31:25', '常驻192.168.0.25', 0, 0, 'A');

-- ----------------------------
-- Table structure for mq_num_level
-- ----------------------------
DROP TABLE IF EXISTS `mq_num_level`;
CREATE TABLE `mq_num_level`  (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '计算优先级设置',
  `num` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '场景码',
  `queue_config_id` int NULL DEFAULT NULL COMMENT '计算优先级队列id',
  `rec_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'A',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 98 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of mq_num_level
-- ----------------------------

-- ----------------------------
-- Table structure for mq_queue_config
-- ----------------------------
DROP TABLE IF EXISTS `mq_queue_config`;
CREATE TABLE `mq_queue_config`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `queue_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'mq队列名称',
  `open_scaling` int NULL DEFAULT 0 COMMENT '是否开启弹性伸缩0否，1是',
  `scaling_threshold` int NULL DEFAULT 100 COMMENT '开启弹性伸缩阈值',
  `open_scaling_time` int NULL DEFAULT 5 COMMENT '检测是否需要开启间隔时间，单位分钟',
  `stop_scaling_time` int NULL DEFAULT 55 COMMENT '检测关闭弹性伸缩时间间隔，单位分钟',
  `scaling_config_id` int NULL DEFAULT NULL,
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `rec_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'A',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `level` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '计算优先等级',
  `is_default` int NULL DEFAULT 0 COMMENT '是否默认0否1是',
  `is_resident` int NULL DEFAULT 0 COMMENT '是否常驻队列',
  `is_special` int NULL DEFAULT 0 COMMENT '特殊处理队列0否，1是，例如128G',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of mq_queue_config
-- ----------------------------
INSERT INTO `mq_queue_config` VALUES (1, 'modeling-call-A', 0, 100, 5, 55, NULL, 'A 常驻队列', 'A', '2024-04-02 14:48:32', '2024-08-07 12:15:46', 'A', 1, 1, 0);

-- ----------------------------
-- Table structure for mq_scaling_config
-- ----------------------------
DROP TABLE IF EXISTS `mq_scaling_config`;
CREATE TABLE `mq_scaling_config`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `scaling_group_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '弹性伸缩Id',
  `scaling_rule_ari` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '规则',
  `access_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `secret` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `rec_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'A',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `endpoint` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of mq_scaling_config
-- ----------------------------

-- ----------------------------
-- Table structure for mq_send_log
-- ----------------------------
DROP TABLE IF EXISTS `mq_send_log`;
CREATE TABLE `mq_send_log`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `num` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `queue` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '发送的队列',
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '发送的mq消息',
  `status` int NULL DEFAULT 0 COMMENT '0未发送，1已发送',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `sort` int NULL DEFAULT 1,
  `rec_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'A',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2648 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;


-- ----------------------------
-- Table structure for sys_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_log`;
CREATE TABLE `sys_log`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NULL DEFAULT NULL,
  `user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `nick_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `request_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `uri` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `method` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `params` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `ip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `browser` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `operation_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `rec_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'A',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 37316 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of sys_log
-- ----------------------------

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu`  (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '系统菜单表',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '菜单名称',
  `perms` 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 '菜单路由',
  `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '菜单图标',
  `parent_id` int NULL DEFAULT NULL COMMENT '父id',
  `type` int NULL DEFAULT NULL COMMENT '类型0菜单，1按钮',
  `rec_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'A',
  `sort` int NULL DEFAULT 1 COMMENT '排序字段',
  `is_show` int NULL DEFAULT 1 COMMENT '是否显示 0 不显示，1显示',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `hide_menu` int NULL DEFAULT 0,
  `is_ext` int NULL DEFAULT 0,
  `component` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 311 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of sys_menu
-- ----------------------------

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role`  (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '角色表',
  `role_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '角色名称',
  `role_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '角色类型',
  `rec_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'A',
  `create_user_id` int NULL DEFAULT NULL COMMENT '创建者id',
  `status` int NULL DEFAULT 1 COMMENT '是否禁用 0禁用 1启用',
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '角色说明',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 47 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of sys_role
-- ----------------------------

-- ----------------------------
-- Table structure for sys_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_menu`;
CREATE TABLE `sys_role_menu`  (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '菜单角色关系表',
  `role_id` int NULL DEFAULT NULL,
  `menu_id` int NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 23789 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user`  (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '系统用户表',
  `user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '账号',
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '密码',
  `nick_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '昵称',
  `role_id` int NULL DEFAULT NULL COMMENT '角色id',
  `create_user_id` int NULL DEFAULT NULL COMMENT '创建者id',
  `status` int NULL DEFAULT 1 COMMENT '是否禁用 0禁用，1启用',
  `rec_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'A',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `manage_id` int NULL DEFAULT NULL,
  `ding_account` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 841 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of sys_user
-- ----------------------------

-- ----------------------------
-- Table structure for t_agent
-- ----------------------------
DROP TABLE IF EXISTS `t_agent`;
CREATE TABLE `t_agent`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `agent_id` varchar(15) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '代理商Id',
  `agent_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '代理商公司名称',
  `agent_password` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '代理商密码',
  `agent_area` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '代理商区域',
  `agent_email` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '代理商邮箱',
  `agent_phone` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '代理商电话',
  `state` tinyint NOT NULL DEFAULT 1 COMMENT '状态：1-正常，0-冻结',
  `agent_num` int NOT NULL DEFAULT 0 COMMENT '代理数量',
  `agent_country` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '中国' COMMENT '代理商所在的国家',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `rec_status` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT 'A' COMMENT '记录的状态，A: 生效，I: 禁用',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `agent_id`(`agent_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 17 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '代理商表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_agent
-- ----------------------------

-- ----------------------------
-- Table structure for t_agent_audit
-- ----------------------------
DROP TABLE IF EXISTS `t_agent_audit`;
CREATE TABLE `t_agent_audit`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '经销商公司名称',
  `country` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '国家',
  `region` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '地区',
  `address` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '地址',
  `type` int NULL DEFAULT 1 COMMENT '类型，1为线下，2为线上',
  `store_address` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '线下门店地址或线上网站',
  `sur_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '申请人的姓',
  `user_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '申请人的名字',
  `post` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '申请人职位',
  `area_code` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '区号',
  `phone` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '手机号',
  `email` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '邮箱地址',
  `state` int NULL DEFAULT 0 COMMENT '状态，0申请中，1审核通过，2审核失败',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `rec_status` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '记录的状态，A: 生效，I: 禁用',
  `note_type` int NULL DEFAULT NULL COMMENT '备注等级',
  `note_content` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '备注内容',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 65 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '代理商申请表' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of t_agent_audit
-- ----------------------------

-- ----------------------------
-- Table structure for t_agent_framework
-- ----------------------------
DROP TABLE IF EXISTS `t_agent_framework`;
CREATE TABLE `t_agent_framework`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `parent_id` bigint NULL DEFAULT NULL COMMENT '上级架构id',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '代理商名称',
  `rec_status` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'A',
  `create_time` datetime NULL DEFAULT NULL,
  `update_time` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '代理商架构管理' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_agent_framework
-- ----------------------------

-- ----------------------------
-- Table structure for t_agent_new
-- ----------------------------
DROP TABLE IF EXISTS `t_agent_new`;
CREATE TABLE `t_agent_new`  (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '经销商表',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '经销商名称',
  `nick_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '联系人名称',
  `user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户名称',
  `sys_user_id` int NULL DEFAULT NULL COMMENT '创建人id',
  `rec_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'A',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `down_total_num` int NULL DEFAULT 0 COMMENT '场景下载次数',
  `down_use_num` int NULL DEFAULT 0 COMMENT '场景使用次数',
  `high_total_num` int NULL DEFAULT 0 COMMENT '高级会员次数',
  `high_use_num` int NULL DEFAULT 0 COMMENT '高级会员使用次数',
  `major_total_num` int NULL DEFAULT 0 COMMENT '专业会员个数',
  `major_use_num` int NULL DEFAULT 0 COMMENT '专业会员个数',
  `parent_id` int NULL DEFAULT NULL,
  `status` int NULL DEFAULT 0 COMMENT '使用状态 0 正常，1禁用',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 48 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_agent_new
-- ----------------------------

-- ----------------------------
-- Table structure for t_agent_new_camera
-- ----------------------------
DROP TABLE IF EXISTS `t_agent_new_camera`;
CREATE TABLE `t_agent_new_camera`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `camera_id` int NULL DEFAULT NULL,
  `agent_id` int NULL DEFAULT NULL,
  `sub_agent_id` int NULL DEFAULT NULL,
  `rec_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'A',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 54 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_agent_new_camera
-- ----------------------------

-- ----------------------------
-- Table structure for t_agent_new_log
-- ----------------------------
DROP TABLE IF EXISTS `t_agent_new_log`;
CREATE TABLE `t_agent_new_log`  (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '代理商授权用户日志表',
  `agent_id` int NULL DEFAULT NULL,
  `type` int NULL DEFAULT NULL COMMENT '0专业会员，1高级会员，2场景下载',
  `user_id` int NULL DEFAULT NULL COMMENT '授权对象id',
  `count` int NULL DEFAULT NULL COMMENT '授权次数',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `give_type` int NULL DEFAULT 0 COMMENT '0 经销商授权，1经销商续费,2官网自购，3平台授权',
  `total_time` int NULL DEFAULT 1 COMMENT '授权时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 212 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_agent_new_log
-- ----------------------------

-- ----------------------------
-- Table structure for t_agent_notice
-- ----------------------------
DROP TABLE IF EXISTS `t_agent_notice`;
CREATE TABLE `t_agent_notice`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '标题',
  `content` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '公告内容',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `rec_status` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT 'A' COMMENT '记录的状态，A: 生效，I: 禁用',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '代理商公告表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_agent_notice
-- ----------------------------

-- ----------------------------
-- Table structure for t_app_camera_fail_log
-- ----------------------------
DROP TABLE IF EXISTS `t_app_camera_fail_log`;
CREATE TABLE `t_app_camera_fail_log`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `uuid` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `source` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '错误来源（app，camera）',
  `reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '错误原因',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 37 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = 'app错误上报' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_app_camera_fail_log
-- ----------------------------

-- ----------------------------
-- Table structure for t_app_file
-- ----------------------------
DROP TABLE IF EXISTS `t_app_file`;
CREATE TABLE `t_app_file`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `file_server_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `agent` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `app_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `md5` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `version` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `rec_status` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'A',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `t_app_file_id_uindex`(`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 26 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_app_file
-- ----------------------------

-- ----------------------------
-- Table structure for t_article
-- ----------------------------
DROP TABLE IF EXISTS `t_article`;
CREATE TABLE `t_article`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `create_time` timestamp NULL DEFAULT NULL,
  `update_time` timestamp NULL DEFAULT NULL,
  `rec_status` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `image_titles` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `t_article_id_uindex`(`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 33 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_article
-- ----------------------------

-- ----------------------------
-- Table structure for t_authorize_camera
-- ----------------------------
DROP TABLE IF EXISTS `t_authorize_camera`;
CREATE TABLE `t_authorize_camera`  (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '本地算法授权',
  `customer_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '客户名称',
  `customer_type` int NULL DEFAULT NULL COMMENT '客户类别0直销，1经销',
  `end_customer` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '终端客户',
  `use_type` int NULL DEFAULT NULL COMMENT '使用类型',
  `project_num` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '项目号',
  `remark` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '备注',
  `machine_code` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '机器码',
  `machine_uuid` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '机器UUID',
  `camera_num` int NULL DEFAULT NULL COMMENT '相机数量',
  `authorize_key` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '授权key',
  `sys_user_id` int NULL DEFAULT NULL COMMENT '创建人',
  `rec_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'A',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 219 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_authorize_camera
-- ----------------------------

-- ----------------------------
-- Table structure for t_authorize_camera_detail
-- ----------------------------
DROP TABLE IF EXISTS `t_authorize_camera_detail`;
CREATE TABLE `t_authorize_camera_detail`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `authorize_camera_id` int NULL DEFAULT NULL,
  `sn_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `camera_id` int NULL DEFAULT NULL,
  `camera_type` int NULL DEFAULT NULL,
  `rec_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'A',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 432 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_authorize_camera_detail
-- ----------------------------

-- ----------------------------
-- Table structure for t_authorize_camera_log
-- ----------------------------
DROP TABLE IF EXISTS `t_authorize_camera_log`;
CREATE TABLE `t_authorize_camera_log`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `authorize_camera_id` int NULL DEFAULT NULL,
  `detail_id` int NULL DEFAULT NULL,
  `old_sn_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `new_sn_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `update_authorize_key` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `rec_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'A',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 154 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_authorize_camera_log
-- ----------------------------

-- ----------------------------
-- Table structure for t_authorize_install
-- ----------------------------
DROP TABLE IF EXISTS `t_authorize_install`;
CREATE TABLE `t_authorize_install`  (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '本地算法授权',
  `customer_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '客户名称',
  `customer_type` int NULL DEFAULT NULL COMMENT '客户类别0直销，1经销',
  `end_customer` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '终端客户',
  `use_type` int NULL DEFAULT NULL COMMENT '使用类型',
  `project_num` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '项目号',
  `remark` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '备注',
  `machine_code` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '机器码',
  `machine_uuid` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '机器UUID',
  `authorize_key` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '授权key',
  `sys_user_id` int NULL DEFAULT NULL COMMENT '创建人',
  `rec_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'A',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 92 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_authorize_install
-- ----------------------------

-- ----------------------------
-- Table structure for t_authorize_modeling
-- ----------------------------
DROP TABLE IF EXISTS `t_authorize_modeling`;
CREATE TABLE `t_authorize_modeling`  (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '本地算法授权',
  `customer_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '客户名称',
  `customer_type` int NULL DEFAULT NULL COMMENT '客户类别0直销，1经销',
  `end_customer` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '终端客户',
  `use_type` int NULL DEFAULT NULL COMMENT '使用类型',
  `project_num` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '项目号',
  `remark` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '备注',
  `authorize_key` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '授权key',
  `authorize_time_unit` int NULL DEFAULT NULL COMMENT '授权期限单位0年，1月，2天',
  `authorize_time` int NULL DEFAULT NULL COMMENT '授权期限',
  `authorize_info` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '授权说明',
  `sys_user_id` int NULL DEFAULT NULL COMMENT '创建人',
  `rec_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'A',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 27 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_authorize_modeling
-- ----------------------------

-- ----------------------------
-- Table structure for t_bbs_comments
-- ----------------------------
DROP TABLE IF EXISTS `t_bbs_comments`;
CREATE TABLE `t_bbs_comments`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '标题',
  `theme` tinyint NOT NULL DEFAULT 0 COMMENT '主题',
  `content` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '公告内容',
  `type` tinyint NOT NULL DEFAULT 0 COMMENT '类型',
  `view_count` int NOT NULL DEFAULT 0 COMMENT '浏览次数',
  `like_count` int NOT NULL DEFAULT 0 COMMENT '赞',
  `step_count` int NOT NULL DEFAULT 0 COMMENT '踩',
  `top` tinyint NOT NULL DEFAULT 0 COMMENT '标识帖子是否置顶',
  `essence` tinyint NOT NULL DEFAULT 0 COMMENT '标识帖子，新=1，精=2，火=3，推=4',
  `admin_topic` tinyint NOT NULL DEFAULT 0 COMMENT '管理员帖',
  `user_id` bigint NULL DEFAULT NULL COMMENT '用户表t_user的id',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `rec_status` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT 'A' COMMENT '记录的状态，A: 生效，I: 禁用',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 454 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '论坛公告表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_bbs_comments
-- ----------------------------

-- ----------------------------
-- Table structure for t_bbs_likeorunlike
-- ----------------------------
DROP TABLE IF EXISTS `t_bbs_likeorunlike`;
CREATE TABLE `t_bbs_likeorunlike`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `address` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '' COMMENT '地址，如果是注册用户，则是用户名，如果是游客，则是IP地址',
  `comment_type` tinyint NULL DEFAULT NULL COMMENT '1表示赞，0表示踩',
  `bbs_comments_id` bigint NULL DEFAULT NULL COMMENT '论坛公告表t_bbs_comments的id',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `rec_status` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT 'A' COMMENT '记录的状态，A: 生效，I: 禁用',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '论坛留言踩赞表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_bbs_likeorunlike
-- ----------------------------

-- ----------------------------
-- Table structure for t_bbs_receive
-- ----------------------------
DROP TABLE IF EXISTS `t_bbs_receive`;
CREATE TABLE `t_bbs_receive`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `content` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL,
  `sender` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '' COMMENT '发送者',
  `user_id` bigint NULL DEFAULT NULL COMMENT '用户表t_user的id',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `rec_status` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT 'A' COMMENT '记录的状态，A: 生效，I: 禁用',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '论坛收到留言表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_bbs_receive
-- ----------------------------

-- ----------------------------
-- Table structure for t_bbs_reply
-- ----------------------------
DROP TABLE IF EXISTS `t_bbs_reply`;
CREATE TABLE `t_bbs_reply`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `content` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL,
  `admin_reply` tinyint NOT NULL DEFAULT 0 COMMENT '管理员回复',
  `theme` tinyint NOT NULL DEFAULT 0 COMMENT '主题',
  `title` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '帖子的标题',
  `user_id` bigint NULL DEFAULT NULL COMMENT '用户表t_user的id',
  `bbs_comments_id` bigint NULL DEFAULT NULL COMMENT '论坛公告表t_bbs_comments的id',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `rec_status` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT 'A' COMMENT '记录的状态，A: 生效，I: 禁用',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 345 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '论坛回复留言表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_bbs_reply
-- ----------------------------

-- ----------------------------
-- Table structure for t_build_log
-- ----------------------------
DROP TABLE IF EXISTS `t_build_log`;
CREATE TABLE `t_build_log`  (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scene_num` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '场景码',
  `data_source` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '资源路径',
  `queue_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '消息队列名称',
  `status` int NULL DEFAULT NULL COMMENT '-10:其他原因失败\n-3:重复计算\n-2:计算失败\n-1:计算超时\n0:计算中\n1:计算成功',
  `host_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '服务器名称',
  `build_type` int NULL DEFAULT NULL,
  `source` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `log_detail_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `duration` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `create_time` timestamp NULL DEFAULT NULL COMMENT '开始计算时间',
  `update_time` timestamp NULL DEFAULT NULL COMMENT '结束计算时间',
  `message_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `result_queue_name` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `content` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 12725 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;


-- ----------------------------
-- Table structure for t_bury_point
-- ----------------------------
DROP TABLE IF EXISTS `t_bury_point`;
CREATE TABLE `t_bury_point`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `application_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '应用名称',
  `application_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '应用key',
  `rec_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'A',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 19 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_bury_point
-- ----------------------------

-- ----------------------------
-- Table structure for t_camera
-- ----------------------------
DROP TABLE IF EXISTS `t_camera`;
CREATE TABLE `t_camera`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `child_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '相机的Mac地址',
  `activated_time` datetime NULL DEFAULT NULL COMMENT '激活时间',
  `child_password` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '4dkankan@4dage' COMMENT '相机密码',
  `sn_code` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT 'sn码',
  `wifi_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT 'wifi名称',
  `wifi_password` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT 'wifi密码',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `rec_status` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT 'A' COMMENT '记录的状态，A: 生效，I: 禁用',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 502078 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '相机主表' ROW_FORMAT = DYNAMIC;


-- ----------------------------
-- Table structure for t_camera_detail
-- ----------------------------
DROP TABLE IF EXISTS `t_camera_detail`;
CREATE TABLE `t_camera_detail`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `balance` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '0' COMMENT '余额',
  `user_id` bigint NULL DEFAULT NULL COMMENT '用户表t_user的id',
  `own` tinyint NULL DEFAULT NULL COMMENT '0表示客户，1表示员工，2表示赠送，3表示其他，4经销商销售',
  `order_sn` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '订单号',
  `country` tinyint NOT NULL DEFAULT 0 COMMENT '0表示本国，1表示国外',
  `agency` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '4dage' COMMENT '经销商',
  `type` tinyint NOT NULL DEFAULT 1 COMMENT '相机类型，0表示双目，1四维看看pro，2 四维看看lite，9 双目转台，10 激光转台',
  `total_space` bigint UNSIGNED NULL DEFAULT 0 COMMENT '总容量',
  `used_space` bigint UNSIGNED NULL DEFAULT 0 COMMENT '已使用容量',
  `camera_id` bigint NULL DEFAULT NULL COMMENT '相机主表t_camera的id',
  `goods_id` bigint NULL DEFAULT NULL COMMENT '商品表t_goods的id',
  `company_id` bigint NULL DEFAULT NULL COMMENT '企业表t_company的id',
  `agent_framework_id` bigint NULL DEFAULT NULL COMMENT '代理商架构管理t_agent_framework的id',
  `cooperation_user` bigint NULL DEFAULT NULL COMMENT '相机协作用户id',
  `address` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '设备地址（追溯管理后台）',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `rec_status` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT 'A' COMMENT '记录的状态，A: 生效，I: 禁用',
  `user_camera_version` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  `app_version` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  `last_request_time` timestamp NULL DEFAULT NULL,
  `out_time` timestamp NULL DEFAULT NULL,
  `agent_id` int NULL DEFAULT NULL COMMENT '代理商id',
  `buy_date` timestamp NULL DEFAULT NULL COMMENT '购买时间',
  `unit` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT 'GB' COMMENT '相机容量单位，GB ，SP',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `camera_id`(`camera_id`) USING BTREE,
  INDEX `user_id`(`user_id`) USING BTREE,
  CONSTRAINT `t_camera_detail_ibfk_1` FOREIGN KEY (`camera_id`) REFERENCES `t_camera` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 103174 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '相机子表' ROW_FORMAT = DYNAMIC;


-- ----------------------------
-- Table structure for t_camera_increment_log
-- ----------------------------
DROP TABLE IF EXISTS `t_camera_increment_log`;
CREATE TABLE `t_camera_increment_log`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `camera_id` int NULL DEFAULT NULL COMMENT '相机Id',
  `operation_type` int NULL DEFAULT NULL COMMENT '0 授权权益，1解除权益，2绑定相机，3解绑相机',
  `operation_user` int NULL DEFAULT NULL COMMENT '操作userId',
  `increment_id` int NULL DEFAULT NULL COMMENT '权益Id',
  `rec_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'A',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4834 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;


-- ----------------------------
-- Table structure for t_camera_out
-- ----------------------------
DROP TABLE IF EXISTS `t_camera_out`;
CREATE TABLE `t_camera_out`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `camera_id` bigint NULL DEFAULT NULL COMMENT '相机id',
  `order_id` bigint NULL DEFAULT NULL COMMENT '订单id',
  `agent_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '经销商',
  `type` int NULL DEFAULT NULL COMMENT '0:测试使用，1：线上出库，2：经销商出库',
  `create_time` datetime NULL DEFAULT NULL,
  `update_time` datetime NULL DEFAULT NULL,
  `rec_status` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT 'A',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '相机出库表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_camera_out
-- ----------------------------

-- ----------------------------
-- Table structure for t_camera_space
-- ----------------------------
DROP TABLE IF EXISTS `t_camera_space`;
CREATE TABLE `t_camera_space`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `user_id` bigint NULL DEFAULT NULL COMMENT '用户表t_user的id',
  `camera_id` bigint NULL DEFAULT NULL COMMENT '相机主表t_camera的id',
  `space` bigint UNSIGNED NULL DEFAULT 0 COMMENT '容量',
  `space_type` tinyint NULL DEFAULT -1 COMMENT '容量类型，0表示基础容量，1表示期限容量，2表示扩容容量',
  `space_start_time` datetime NULL DEFAULT NULL COMMENT '生效时间',
  `space_end_time` datetime NULL DEFAULT NULL COMMENT '结束时间',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `rec_status` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '记录的状态，A: 生效，I: 禁用',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `order_sn` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '扩容订单集合',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 135 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '相机容量表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_camera_space
-- ----------------------------

-- ----------------------------
-- Table structure for t_camera_type
-- ----------------------------
DROP TABLE IF EXISTS `t_camera_type`;
CREATE TABLE `t_camera_type`  (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '相机类型表',
  `camera_type` int NULL DEFAULT NULL COMMENT '0 旧双目相机，1思维看看pro八目相机（看看），2看看lite,5指房宝，9双目转台（看见），10激光转台（深时），11激光转台（深光）',
  `scene_prefix` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '场景码前缀',
  `wifi_name_prefix` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '相机WiFiname前缀',
  `rec_status` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'A',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `is_laser` int NULL DEFAULT 0 COMMENT '是否激光系统相机 0否，1是',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_camera_type
-- ----------------------------
INSERT INTO `t_camera_type` VALUES (1, 0, 'KK-', '4DKK_', 'A', '旧双目相机', '2023-04-11 14:27:45', '2023-11-01 11:04:37', '旧双目相机', 0);
INSERT INTO `t_camera_type` VALUES (2, 1, 'KK-', '4DKKPRO_', 'A', '四维看看', '2023-04-11 14:30:29', '2023-11-01 11:04:37', '四维看看', 0);
INSERT INTO `t_camera_type` VALUES (5, 9, 'KJ-', '4DKKMI_', 'A', '四维看见', '2023-04-11 14:31:31', '2023-11-01 11:04:37', '四维看见', 0);
INSERT INTO `t_camera_type` VALUES (6, 10, 'SS-', '4DSS_', 'A', '四维深时', '2023-04-11 14:31:49', '2024-04-30 15:31:25', '四维深时', 1);
INSERT INTO `t_camera_type` VALUES (7, 11, 'SG-', '4DSG_', 'A', '四维深光', '2023-04-11 14:32:06', '2024-04-30 15:31:25', '四维深光', 1);

-- ----------------------------
-- Table structure for t_camera_version
-- ----------------------------
DROP TABLE IF EXISTS `t_camera_version`;
CREATE TABLE `t_camera_version`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '名称',
  `file_url` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '文件rul',
  `file_md5` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '文件MD5',
  `description` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '描述',
  `version` varchar(40) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '相机版本',
  `type` int NULL DEFAULT 1 COMMENT '相机类型，1八目，2双目, 3转台双目, 4激光转台',
  `status` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT 'I' COMMENT '活动状态：A: 生效，I: 禁用',
  `rec_status` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT 'A' COMMENT '记录的状态，A: 生效，I: 禁用',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改日期',
  `min_version` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '相机版本(最小)',
  `sys_user_id` int NULL DEFAULT NULL COMMENT '创建人',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 763 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '相机版本表' ROW_FORMAT = COMPACT;


-- ----------------------------
-- Table structure for t_camera_version_app
-- ----------------------------
DROP TABLE IF EXISTS `t_camera_version_app`;
CREATE TABLE `t_camera_version_app`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '名称',
  `file_url` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '文件rul',
  `file_md5` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '文件MD5',
  `description` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '描述',
  `version` varchar(40) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '相机版本',
  `type` int NULL DEFAULT 0 COMMENT 'app 类型0安卓，1iOS',
  `status` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT 'I' COMMENT '活动状态：A: 生效，I: 禁用',
  `rec_status` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT 'A' COMMENT '记录的状态，A: 生效，I: 禁用',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改日期',
  `min_version` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '相机版本(最小)',
  `sys_user_id` int NULL DEFAULT NULL COMMENT '创建人',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 19 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '相机版本表' ROW_FORMAT = COMPACT;


-- ----------------------------
-- Table structure for t_camera_wifi_prefix
-- ----------------------------
DROP TABLE IF EXISTS `t_camera_wifi_prefix`;
CREATE TABLE `t_camera_wifi_prefix`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `wifi_name_prefix` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '相机 WiFiname_前缀',
  `camera_type` int NULL DEFAULT NULL COMMENT '相机类型',
  `rec_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'A',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_camera_wifi_prefix
-- ----------------------------
INSERT INTO `t_camera_wifi_prefix` VALUES (1, '4DKK_', 0, 'A', '2023-11-01 10:33:18', '2023-11-01 10:33:18');
INSERT INTO `t_camera_wifi_prefix` VALUES (2, '4DKKPRO_', 1, 'A', '2023-11-01 10:33:18', '2023-11-01 10:33:18');
INSERT INTO `t_camera_wifi_prefix` VALUES (5, '4DKKMI_', 9, 'A', '2023-11-01 10:33:18', '2023-11-01 10:33:18');
INSERT INTO `t_camera_wifi_prefix` VALUES (6, '4DSS_', 10, 'A', '2023-11-01 10:33:18', '2023-11-01 10:33:18');
INSERT INTO `t_camera_wifi_prefix` VALUES (7, '4DSG_', 11, 'A', '2023-11-01 10:33:18', '2023-11-01 10:33:18');
INSERT INTO `t_camera_wifi_prefix` VALUES (8, 'YUNPRO_', 1, 'A', '2023-11-01 10:33:18', '2023-11-01 10:33:18');



-- ----------------------------
-- Table structure for t_cart
-- ----------------------------
DROP TABLE IF EXISTS `t_cart`;
CREATE TABLE `t_cart`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `user_id` bigint NULL DEFAULT NULL COMMENT 't_user的id',
  `goods_id` bigint NULL DEFAULT NULL COMMENT 't_goods的id',
  `sku_sn` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'sku编号,唯一',
  `goods_count` int NULL DEFAULT 0 COMMENT '商品数量',
  `price` decimal(15, 2) NULL DEFAULT NULL COMMENT '价格',
  `amount` decimal(15, 2) NULL DEFAULT NULL COMMENT '合计',
  `pay_status` tinyint NULL DEFAULT 0 COMMENT '0表示未付，1表示已付',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `rec_status` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT 'A' COMMENT '记录的状态，A: 生效，I: 禁用',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `user_id`(`user_id`) USING BTREE,
  INDEX `goods_id`(`goods_id`) USING BTREE,
  CONSTRAINT `t_cart_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `t_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `t_cart_ibfk_2` FOREIGN KEY (`goods_id`) REFERENCES `t_goods` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1887 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '购物车' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_cart
-- ----------------------------

-- ----------------------------
-- Table structure for t_case
-- ----------------------------
DROP TABLE IF EXISTS `t_case`;
CREATE TABLE `t_case`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '案例标题',
  `introduction` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '引言，序言',
  `outside_link` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '外链',
  `sub_title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '案例文案',
  `type_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `icon_ids` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `sort` int NULL DEFAULT 1 COMMENT '排序字段',
  `logo` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '案例logo	',
  `detail_content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '详情内容',
  `cover_image_url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '详情图片',
  `rec_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'A',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `is_public` int NULL DEFAULT 0 COMMENT '是否发布，0否，1是',
  `public_time` timestamp NULL DEFAULT NULL COMMENT '发布时间',
  `language` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'cn',
  `is_show` int NULL DEFAULT 1 COMMENT '是否显示，0否，1是',
  `sys_user_id` int NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 330 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_case
-- ----------------------------

-- ----------------------------
-- Table structure for t_commerce_order
-- ----------------------------
DROP TABLE IF EXISTS `t_commerce_order`;
CREATE TABLE `t_commerce_order`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `order_sn` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '' COMMENT '订单号',
  `amount` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT '金额',
  `number` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '' COMMENT '支付宝的交易号或者微信支付订单号',
  `pay_type` tinyint NOT NULL DEFAULT -1 COMMENT '付款方式，0表示微信，1表示支付宝，2表示paypal，3表示其他',
  `pay_status` tinyint NULL DEFAULT 0 COMMENT '状态，0或-1表示未付款，1表示已付款',
  `trade_time` datetime NULL DEFAULT NULL COMMENT '交易时间',
  `user_id` bigint NULL DEFAULT NULL COMMENT '用户表t_user的id',
  `camera_id` bigint NULL DEFAULT NULL COMMENT '相机主表t_camera的id',
  `commerce_type` tinyint NOT NULL COMMENT '0表示年，1表示月',
  `count` tinyint NOT NULL COMMENT '数量',
  `abroad` tinyint NULL DEFAULT NULL COMMENT '0表示国内订单，1表示国外订单',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `rec_status` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '记录的状态，A: 生效，I: 禁用',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `order_sn`(`order_sn`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 211 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '商业订单表（八目相机）' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_commerce_order
-- ----------------------------

-- ----------------------------
-- Table structure for t_company
-- ----------------------------
DROP TABLE IF EXISTS `t_company`;
CREATE TABLE `t_company`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `company_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '公司名称',
  `top_logo` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '顶部logo',
  `floor_logo` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '地面logo',
  `marker_logo` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '地面点位logo',
  `qr_logo` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '二维码logo',
  `show_logo` int NULL DEFAULT 0 COMMENT '是否显示初始logo，0隐藏，1显示',
  `sys_user_id` bigint NULL DEFAULT NULL COMMENT 't_manager表的id',
  `camera_delete` int NULL DEFAULT 0 COMMENT '新增的相机是否注册，0否，1删',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `rec_status` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT 'A' COMMENT '记录的状态，A: 生效，I: 禁用',
  `calculate_flexibility` tinyint(1) NULL DEFAULT 1,
  `data_sync` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '数据同步类型',
  `company_desc` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  `manager_id` int NULL DEFAULT NULL,
  `scene_version` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT 'V4' COMMENT 'V3:计算为V3场景，V4:计算为V4场景，默认为V4场景',
  `call_queue_name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 29 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '客户企业logo信息' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_company
-- ----------------------------

-- ----------------------------
-- Table structure for t_download_order
-- ----------------------------
DROP TABLE IF EXISTS `t_download_order`;
CREATE TABLE `t_download_order`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `order_sn` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '' COMMENT '订单号',
  `amount` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT '金额',
  `number` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '' COMMENT '支付宝的交易号或者微信支付订单号',
  `pay_type` tinyint NOT NULL DEFAULT -1 COMMENT '付款方式，0表示微信，1表示支付宝，2表示paypal，3表示其他',
  `pay_status` tinyint NULL DEFAULT 0 COMMENT '状态，0或-1表示未付款，-2表示已退款,1表示已付款',
  `status` tinyint NULL DEFAULT 1 COMMENT '状态，1增加下载次数',
  `trade_time` datetime NULL DEFAULT NULL COMMENT '交易时间',
  `user_id` bigint NULL DEFAULT NULL COMMENT '用户表t_user的id',
  `count` tinyint NULL DEFAULT NULL COMMENT '购买数量',
  `abroad` tinyint NULL DEFAULT 0 COMMENT '0表示国内订单，1表示国外订单',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `rec_status` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '记录的状态，A: 生效，I: 禁用',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `scene_num` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '场景码',
  `scene_name` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '场景名',
  `time_zone_off` int NULL DEFAULT 0 COMMENT '时区差，单位分钟',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `order_sn`(`order_sn`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 943 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '下载次数订单表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_download_order
-- ----------------------------

-- ----------------------------
-- Table structure for t_download_order_mg
-- ----------------------------
DROP TABLE IF EXISTS `t_download_order_mg`;
CREATE TABLE `t_download_order_mg`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `order_sn` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '' COMMENT '订单号',
  `amount` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT '金额',
  `number` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '' COMMENT '支付宝的交易号或者微信支付订单号',
  `pay_type` tinyint NOT NULL DEFAULT -1 COMMENT '付款方式，0表示微信，1表示支付宝，2表示paypal，3表示其他',
  `pay_status` tinyint NULL DEFAULT 0 COMMENT '状态，0或-1表示未付款，-2表示已退款,1表示已付款',
  `status` tinyint NULL DEFAULT 1 COMMENT '状态，1增加下载次数',
  `trade_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '交易时间',
  `user_id` bigint NULL DEFAULT NULL COMMENT '用户表t_user的id',
  `count` tinyint NULL DEFAULT NULL COMMENT '购买数量',
  `abroad` tinyint NULL DEFAULT 0 COMMENT '0表示国内订单，1表示国外订单',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `rec_status` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT 'A' COMMENT '记录的状态，A: 生效，I: 禁用',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `scene_num` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '场景码',
  `scene_name` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '场景名',
  `time_zone_off` int NULL DEFAULT 0 COMMENT '时区差，单位分钟',
  `customer_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '客户名称',
  `customer_type` int NULL DEFAULT NULL COMMENT '客户类别0直销，1经销',
  `end_customer` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '终端客户',
  `use_type` int NULL DEFAULT NULL COMMENT '使用类型',
  `project_num` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '项目号',
  `remark` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '备注',
  `down_type` int NULL DEFAULT 0 COMMENT '0看看，1深时',
  `agent_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '经销商名称',
  `agent_id` int NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `order_sn`(`order_sn`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 956 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '下载次数订单表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_download_order_mg
-- ----------------------------

-- ----------------------------
-- Table structure for t_download_task_record
-- ----------------------------
DROP TABLE IF EXISTS `t_download_task_record`;
CREATE TABLE `t_download_task_record`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `task_id` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `task_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `total_file_nums` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `progress_status` int NULL DEFAULT NULL,
  `duration` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `download_url` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `create_time` timestamp NULL DEFAULT NULL,
  `download_time` timestamp NULL DEFAULT NULL,
  `update_time` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `t_download_task_record_id_uindex`(`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_download_task_record
-- ----------------------------

-- ----------------------------
-- Table structure for t_download_tour_video
-- ----------------------------
DROP TABLE IF EXISTS `t_download_tour_video`;
CREATE TABLE `t_download_tour_video`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `num` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '场景码',
  `state` tinyint NOT NULL DEFAULT 0 COMMENT '视频转换状态（0-等待中，1-成功，2-失败）',
  `reason` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '转换失败原因',
  `file_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '文件名称',
  `local_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '本地临时文件地址',
  `download_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '导览视频目录地址',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `rec_status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'A' COMMENT 'A-有效，I-无效',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `IDX_NUM`(`num`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 314 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '导览视频转换记录表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_download_tour_video
-- ----------------------------
INSERT INTO `t_download_tour_video` VALUES (313, 'KJ-xj-lL20pSiUeEU', 1, NULL, 'screencap.mp4', '/mnt/4Dkankan/scene_v4/KJ-xj-lL20pSiUeEU/tour/4e42e1a2-80e2-4d23-88fd-15c31c5144d8.mp4', 'downloads/scene/KJ-xj-lL20pSiUeEU/tour/screencap.mp4', '2024-07-26 09:38:42', '2024-07-26 09:38:46', 'A');

-- ----------------------------
-- Table structure for t_employ_note
-- ----------------------------
DROP TABLE IF EXISTS `t_employ_note`;
CREATE TABLE `t_employ_note`  (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '招聘表',
  `work_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '职位名称',
  `work_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工作地点',
  `salary` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '薪资待遇',
  `employ_num` int NULL DEFAULT NULL COMMENT '招聘人数',
  `is_push` tinyint(1) NULL DEFAULT 0 COMMENT '是否发布 0 否，1是',
  `is_top` tinyint(1) NULL DEFAULT 0 COMMENT '是否置顶 0否，1是',
  `work_content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '工作职责',
  `qualification` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '任职资格',
  `rec_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'A',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_employ_note
-- ----------------------------

-- ----------------------------
-- Table structure for t_exceed_space_scene
-- ----------------------------
DROP TABLE IF EXISTS `t_exceed_space_scene`;
CREATE TABLE `t_exceed_space_scene`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `num` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '场景码',
  `user_id` bigint NULL DEFAULT NULL COMMENT '初次上传用户id',
  `camera_id` bigint NOT NULL COMMENT '相机id',
  `file_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `unicode` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `version` varchar(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'V4' COMMENT '场景版本（V3|V4）',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `rec_status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'A' COMMENT 'A-有效,I-无效',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `IDX_COMBIN`(`num`, `camera_id`, `file_id`, `unicode`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '超出容量场景码表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_exceed_space_scene
-- ----------------------------

-- ----------------------------
-- Table structure for t_expansion_order
-- ----------------------------
DROP TABLE IF EXISTS `t_expansion_order`;
CREATE TABLE `t_expansion_order`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `order_sn` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '' COMMENT '订单号',
  `amount` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT '金额',
  `number` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '' COMMENT '支付宝的交易号或者微信支付订单号',
  `pay_type` tinyint NOT NULL DEFAULT -1 COMMENT '付款方式，0表示微信，1表示支付宝，2表示paypal，3表示其他',
  `pay_status` tinyint NULL DEFAULT 0 COMMENT '状态，0或-1表示未付款，-2表示已退款,1表示已付款',
  `status` tinyint NULL DEFAULT 2 COMMENT '状态，1表示充值，0表示系统赠送，2表示升级套餐',
  `trade_time` datetime NULL DEFAULT NULL COMMENT '交易时间',
  `user_id` bigint NULL DEFAULT NULL COMMENT '用户表t_user的id',
  `month` tinyint NULL DEFAULT NULL COMMENT '期限，月为单位',
  `years` tinyint NOT NULL COMMENT '期限，年为单位',
  `delay` int NULL DEFAULT NULL COMMENT '延期，天为单位',
  `unit_size` int NOT NULL COMMENT '容量大小',
  `unit` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '容量单位，\"GB\", \"TB\", \"PB\"',
  `camera_id` bigint NULL DEFAULT NULL COMMENT '相机主表t_camera的id',
  `abroad` tinyint NULL DEFAULT NULL COMMENT '0表示国内订单，1表示国外订单',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `rec_status` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '记录的状态，A: 生效，I: 禁用',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `order_sn`(`order_sn`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8242 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '扩容订单表（八目相机）' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_expansion_order
-- ----------------------------

-- ----------------------------
-- Table structure for t_feedback
-- ----------------------------
DROP TABLE IF EXISTS `t_feedback`;
CREATE TABLE `t_feedback`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `problem_desc` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '问题描述',
  `problem_desc_imgs` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `hardware_option_id` int NULL DEFAULT NULL COMMENT '硬件产品id',
  `software_option_id` int NULL DEFAULT NULL COMMENT '软件产品id',
  `industry_option_id` int NULL DEFAULT NULL COMMENT '所在行业id',
  `solution` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '解决方案',
  `solution_imgs` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `nick_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '姓名',
  `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '联系方式',
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '地址',
  `score` decimal(11, 1) NULL DEFAULT NULL COMMENT '评分',
  `score_reason` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '评分理由',
  `status` int NULL DEFAULT 0 COMMENT '处理状态 0未处理，1已处理',
  `result` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '处理结果',
  `rec_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'A',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 155 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_feedback
-- ----------------------------

-- ----------------------------
-- Table structure for t_feedback_option
-- ----------------------------
DROP TABLE IF EXISTS `t_feedback_option`;
CREATE TABLE `t_feedback_option`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `name_cn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `name_en` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `type_id` int NULL DEFAULT NULL,
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `is_system` int NULL DEFAULT 0 COMMENT '1系统预设，0自定义添加',
  `rec_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'A',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 45 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_feedback_option
-- ----------------------------

-- ----------------------------
-- Table structure for t_feedback_option_type
-- ----------------------------
DROP TABLE IF EXISTS `t_feedback_option_type`;
CREATE TABLE `t_feedback_option_type`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `rec_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'A',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_feedback_option_type
-- ----------------------------

-- ----------------------------
-- Table structure for t_folder
-- ----------------------------
DROP TABLE IF EXISTS `t_folder`;
CREATE TABLE `t_folder`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文件夹名称',
  `type` int NULL DEFAULT 0 COMMENT '文件夹类型，0看看我的场景，1看看协作场景，2看见我的场景，3看见协作场景',
  `parent_id` bigint NULL DEFAULT NULL COMMENT '上层文件夹id',
  `rec_status` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'A',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1131 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '文件夹表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_folder
-- ----------------------------

-- ----------------------------
-- Table structure for t_folder_scene
-- ----------------------------
DROP TABLE IF EXISTS `t_folder_scene`;
CREATE TABLE `t_folder_scene`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `folder_id` bigint NOT NULL,
  `scene_id` bigint NOT NULL,
  `rec_status` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'A',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 983 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '文件夹和场景关联表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_folder_scene
-- ----------------------------

-- ----------------------------
-- Table structure for t_goods
-- ----------------------------
DROP TABLE IF EXISTS `t_goods`;
CREATE TABLE `t_goods`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '商品名称',
  `name_en` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  `description` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '商品描述',
  `goods_sn` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '商品编号',
  `goods_status` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '商品状态，上架下架',
  `image_url` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '商品图片',
  `pic` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '商品图片2',
  `express_price` decimal(15, 2) NULL DEFAULT NULL COMMENT '快递价格',
  `sort` tinyint NULL DEFAULT NULL COMMENT '排序',
  `goods_price` decimal(15, 2) NOT NULL COMMENT '价格',
  `goods_dollar_price` decimal(15, 2) NOT NULL COMMENT '价格(美元)',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `rec_status` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT 'A' COMMENT '记录的状态，A: 生效，I: 禁用',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '商品主表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_goods
-- ----------------------------

-- ----------------------------
-- Table structure for t_goods_sku
-- ----------------------------
DROP TABLE IF EXISTS `t_goods_sku`;
CREATE TABLE `t_goods_sku`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `goods_id` bigint NULL DEFAULT NULL COMMENT '商品表t_goods的id',
  `sku_sn` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'sku编号,唯一',
  `description` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '规格描述',
  `stock` int NULL DEFAULT NULL COMMENT '库存,-1指充足',
  `price` decimal(15, 2) NULL DEFAULT NULL COMMENT '价格（RMB）',
  `dollar_price` decimal(15, 2) NULL DEFAULT NULL COMMENT '价格（美元）',
  `unit_size` int NULL DEFAULT NULL COMMENT '容量大小',
  `unit` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '容量单位，\"GB\", \"TB\", \"PB\"',
  `month` int NULL DEFAULT NULL COMMENT '容量时长',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `rec_status` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT 'A' COMMENT '记录的状态，A: 生效，I: 禁用',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 34 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '商品sku表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_goods_sku
-- ----------------------------

-- ----------------------------
-- Table structure for t_goods_spec
-- ----------------------------
DROP TABLE IF EXISTS `t_goods_spec`;
CREATE TABLE `t_goods_spec`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `spec_name` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '规格名称',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `rec_status` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT 'A' COMMENT '记录的状态，A: 生效，I: 禁用',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '商品规格表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_goods_spec
-- ----------------------------

-- ----------------------------
-- Table structure for t_goods_spec_value
-- ----------------------------
DROP TABLE IF EXISTS `t_goods_spec_value`;
CREATE TABLE `t_goods_spec_value`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `goods_spec_id` bigint NOT NULL COMMENT '规格id',
  `goods_spec_value` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '规格值',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `rec_status` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT 'A' COMMENT '记录的状态，A: 生效，I: 禁用',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '商品规格值表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_goods_spec_value
-- ----------------------------

-- ----------------------------
-- Table structure for t_goods_spu_spec
-- ----------------------------
DROP TABLE IF EXISTS `t_goods_spu_spec`;
CREATE TABLE `t_goods_spu_spec`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `goods_id` bigint NOT NULL COMMENT '商品表id',
  `goods_spec_id` bigint NOT NULL COMMENT '商品规格表id',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `rec_status` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT 'A' COMMENT '记录的状态，A: 生效，I: 禁用',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '商品规格关系表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_goods_spu_spec
-- ----------------------------

-- ----------------------------
-- Table structure for t_hot_shop
-- ----------------------------
DROP TABLE IF EXISTS `t_hot_shop`;
CREATE TABLE `t_hot_shop`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `hot_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '热点id',
  `good_id` bigint NOT NULL COMMENT '商品id',
  `scene_num` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '场景码',
  `page_sid` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '0' COMMENT '热点里卡夹的sid',
  `origin` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '起源的小程序',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `rec_status` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT 'A',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1609 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '热点与商品关联表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_hot_shop
-- ----------------------------

-- ----------------------------
-- Table structure for t_increment_auto_order
-- ----------------------------
DROP TABLE IF EXISTS `t_increment_auto_order`;
CREATE TABLE `t_increment_auto_order`  (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '自动订阅表',
  `user_id` int NULL DEFAULT NULL COMMENT '用户id',
  `increment_type_id` int NULL DEFAULT NULL COMMENT '权益类型id',
  `user_increment_id` int NULL DEFAULT NULL COMMENT '会员id',
  `subscription_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'paypal订阅id',
  `rec_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'A',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `order_sn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 116 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_increment_auto_order
-- ----------------------------

-- ----------------------------
-- Table structure for t_increment_order
-- ----------------------------
DROP TABLE IF EXISTS `t_increment_order`;
CREATE TABLE `t_increment_order`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `order_sn` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '' COMMENT '订单号',
  `amount` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT '金额',
  `number` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '' COMMENT '支付宝的交易号或者微信支付订单号',
  `pay_type` tinyint NOT NULL DEFAULT -1 COMMENT '付款方式，0表示微信，1表示支付宝，2表示paypal，3表示其他',
  `pay_status` tinyint NULL DEFAULT 0 COMMENT '状态，0或-1表示未付款，-2表示已退款,1表示已付款',
  `status` tinyint NULL DEFAULT 1 COMMENT '状态，1表示新增值权益，2表示续费增值权益  3表示增值权益1月',
  `trade_time` datetime NULL DEFAULT NULL COMMENT '交易时间',
  `user_id` bigint NULL DEFAULT NULL COMMENT '用户表t_user的id',
  `increment_id` bigint NULL DEFAULT NULL COMMENT '增值权益表t_user_increment的id,status为2时才有',
  `count` tinyint NULL DEFAULT NULL COMMENT '购买数量',
  `abroad` tinyint NULL DEFAULT 0 COMMENT '0表示国内订单，1表示国外订单',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `rec_status` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '记录的状态，A: 生效，I: 禁用',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `increment_type` int NULL DEFAULT NULL,
  `member_levels` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '权益级别  PR 年会员  SE 月会员',
  `month_qy` tinyint NULL DEFAULT 1,
  `time_zone_off` int NULL DEFAULT 0 COMMENT '时区差，单位分钟',
  `auto_pay` int NULL DEFAULT 0,
  `auto_order_id` int NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `order_sn`(`order_sn`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5314 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '增值权益订单表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_increment_order
-- ----------------------------

-- ----------------------------
-- Table structure for t_increment_order_mg
-- ----------------------------
DROP TABLE IF EXISTS `t_increment_order_mg`;
CREATE TABLE `t_increment_order_mg`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `order_sn` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '' COMMENT '订单号',
  `amount` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT '金额',
  `number` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '' COMMENT '支付宝的交易号或者微信支付订单号',
  `pay_type` tinyint NOT NULL DEFAULT -1 COMMENT '付款方式，0表示微信，1表示支付宝，2表示paypal，3表示其他',
  `pay_status` tinyint NULL DEFAULT 0 COMMENT '状态，0或-1表示未付款，-2表示已退款,1表示已付款',
  `status` tinyint NULL DEFAULT 1 COMMENT '状态，1表示新增值权益，2表示续费增值权益  3表示增值权益1月',
  `trade_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '交易时间',
  `user_id` bigint NULL DEFAULT NULL COMMENT '用户表t_user的id',
  `increment_id` bigint NULL DEFAULT NULL COMMENT '增值权益表t_user_increment的id,status为2时才有',
  `count` tinyint NULL DEFAULT NULL COMMENT '购买数量',
  `abroad` tinyint NULL DEFAULT 0 COMMENT '0表示国内订单，1表示国外订单',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `rec_status` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT 'A' COMMENT '记录的状态，A: 生效，I: 禁用',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `increment_type` int NULL DEFAULT NULL,
  `member_levels` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '权益级别  PR 年会员  SE 月会员',
  `month_qy` tinyint NULL DEFAULT 1,
  `time_zone_off` int NULL DEFAULT 0 COMMENT '时区差，单位分钟',
  `auto_pay` int NULL DEFAULT 0,
  `customer_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '客户名称',
  `customer_type` int NULL DEFAULT NULL COMMENT '客户类别0直销，1经销',
  `end_customer` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '终端客户',
  `use_type` int NULL DEFAULT NULL COMMENT '使用类型',
  `project_num` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '项目号',
  `remark` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '备注',
  `agent_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '经销商名称',
  `agent_id` int NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `order_sn`(`order_sn`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 23519 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '增值权益订单表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_increment_order_mg
-- ----------------------------

-- ----------------------------
-- Table structure for t_increment_type
-- ----------------------------
DROP TABLE IF EXISTS `t_increment_type`;
CREATE TABLE `t_increment_type`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '权益类型名称',
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'member会员,freeMember免费会员',
  `download_num` int NULL DEFAULT NULL COMMENT '下载次数，-1代表无限次',
  `download_price` decimal(10, 2) NULL DEFAULT NULL COMMENT '下载价格',
  `camera_capacity` int NULL DEFAULT NULL COMMENT '相机容量 单位 G -1表示无限容量',
  `camera_space` int NULL DEFAULT NULL COMMENT '相机容量 单位  SP 空间 -1表示无限空间',
  `valid_time` int NULL DEFAULT NULL COMMENT '购买之后，有效期天数，-1代表无限制',
  `valid_time_type` int NULL DEFAULT NULL COMMENT '0:年;1:月：2：日',
  `price` decimal(10, 2) NULL DEFAULT NULL COMMENT '权益价格',
  `symbol` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '价格符号',
  `custom_logo` int NULL DEFAULT NULL COMMENT '自定义logo 0不支持，1支持',
  `custom_style` int NULL DEFAULT NULL COMMENT '自定义热点样式 0不支持，1支持',
  `custom_image` int NULL DEFAULT NULL COMMENT '空间贴图 0不支持，1支持',
  `custom_model` int NULL DEFAULT NULL COMMENT '三维模型 0不支持，1支持',
  `custom_scene` int NULL DEFAULT NULL COMMENT '场景美化调节 0不支持，1支持',
  `custom_take_look` int NULL DEFAULT NULL COMMENT '是否有带看 0不支持，1支持',
  `custom_copy` int NULL DEFAULT NULL COMMENT '场景复制 0不支持，1支持',
  `custom_modeling` int NULL DEFAULT NULL COMMENT '场景计算 1免排队，0排队',
  `custom_down` int NULL DEFAULT NULL COMMENT '场景下载 1下载次数，0下载金额',
  `rec_status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'A',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '权益价格',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '会员权益类型' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of t_increment_type
-- ----------------------------
INSERT INTO `t_increment_type` VALUES (1, '会员权益', 'member', 10, 0.01, -1, -1, 1, 0, 0.01, 'RMB', 1, 1, 1, 1, 1, 1, 1, 1, 1, 'A', '2022-08-11 17:04:38', '2023-07-03 11:07:16');
INSERT INTO `t_increment_type` VALUES (2, '普通权益', 'freeMember', 0, 0.01, 10, 10, 1, 0, 0.00, 'RMB', 0, 0, 0, 0, 0, 0, 0, 0, 0, 'A', '2023-06-19 17:13:44', '2023-07-03 11:07:17');

-- ----------------------------
-- Table structure for t_increment_use_type
-- ----------------------------
DROP TABLE IF EXISTS `t_increment_use_type`;
CREATE TABLE `t_increment_use_type`  (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '权益使用类型',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '名称',
  `rec_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'A',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `type` int NULL DEFAULT 0 COMMENT '是否有项目号 0 无，1有',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_increment_use_type
-- ----------------------------

-- ----------------------------
-- Table structure for t_intercom_message
-- ----------------------------
DROP TABLE IF EXISTS `t_intercom_message`;
CREATE TABLE `t_intercom_message`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `email` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '邮箱',
  `content` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '内容',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `rec_status` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT 'A' COMMENT '记录的状态，A: 生效，I: 禁用',
  `phone` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '电话',
  `note_type` int NULL DEFAULT NULL COMMENT '备注等级',
  `note_content` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '备注内容',
  `state` int NULL DEFAULT NULL COMMENT '状态， 1：未处理，0已处理',
  `contact` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '联系方式：邮箱、电话……',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 516 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '咨询留言表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_intercom_message
-- ----------------------------

-- ----------------------------
-- Table structure for t_invoice
-- ----------------------------
DROP TABLE IF EXISTS `t_invoice`;
CREATE TABLE `t_invoice`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `order_id` bigint NULL DEFAULT NULL COMMENT '订单表t_order的id',
  `virtual_order_id` bigint NULL DEFAULT NULL COMMENT '订单表t_virtual_order的id  消费',
  `increment_order_id` bigint NULL DEFAULT NULL COMMENT '订单表t_increment_order的id  权益',
  `user_id` bigint NULL DEFAULT NULL COMMENT '用户表t_user的id',
  `type` tinyint NOT NULL DEFAULT 1 COMMENT '发票类型，1表示不需要发票，2表示增值税普通发票，3表示增值税专用发票',
  `title` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '发票抬头(个人还是公司)',
  `code` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '税号',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `organized_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '公司名称',
  `organized_address` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '公司地址',
  `register_phone` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '注册电话',
  `bank_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '开户银行',
  `bank_account` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '银行账户',
  `consume_type` tinyint NULL DEFAULT 0 COMMENT '0表示购买相机，1表示充值，2会员权益, 3下载订单',
  `money` decimal(15, 2) NULL DEFAULT NULL COMMENT '开票金额',
  `camera_id` bigint NULL DEFAULT NULL COMMENT '相机主表t_camera的id',
  `finish` tinyint NOT NULL DEFAULT 0 COMMENT '0：发票未开，1：发票已开,2:已发出',
  `email_address` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '电子发票收件邮箱',
  `rec_status` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT 'A' COMMENT '记录的状态，A: 生效，I: 禁用',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `ship_address` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '收货地址',
  `ship_area` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '收货地区',
  `ship_area_path` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '收货地区路径',
  `ship_mobile` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '收货手机',
  `ship_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '收货人姓名',
  `ship_phone` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '收货电话',
  `ship_zip_code` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '收货邮编',
  `send` tinyint NULL DEFAULT 0 COMMENT '发送状态：0未发送，1快递发送，2邮箱发送',
  `express_company` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '快递公司',
  `express_number` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '快递单号',
  `e_invoice` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '电子发票存放url',
  `remarks` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '备注',
  `download_order_id` bigint NULL DEFAULT NULL COMMENT '订单表t_download_order的id  权益',
  `invoiced` tinyint NULL DEFAULT 0 COMMENT '开票状态（0-否，1-是）',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `order_id`(`order_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 896 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '发票表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_invoice
-- ----------------------------

-- ----------------------------
-- Table structure for t_invoice_register
-- ----------------------------
DROP TABLE IF EXISTS `t_invoice_register`;
CREATE TABLE `t_invoice_register`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `invoice_id` bigint NOT NULL,
  `invoice_num` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '发票编号',
  `ship_num` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '快递单号',
  `invoice_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '电子发票url',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `creater_id` bigint NULL DEFAULT NULL COMMENT '创建人id',
  `updater_id` bigint NULL DEFAULT NULL COMMENT '修改人id',
  `tb_status` tinyint NOT NULL DEFAULT 0 COMMENT '0-有效，1-删除',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `IDX_INVOICE_ID`(`invoice_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 18 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '开票登记表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_invoice_register
-- ----------------------------

-- ----------------------------
-- Table structure for t_local_version_log
-- ----------------------------
DROP TABLE IF EXISTS `t_local_version_log`;
CREATE TABLE `t_local_version_log`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `camera` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '相机',
  `project_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '项目名称',
  `gps` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `rec_status` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '记录的状态，A: 生效，I: 禁用',
  `update_time` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '本地版本日志表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_local_version_log
-- ----------------------------

-- ----------------------------
-- Table structure for t_log
-- ----------------------------
DROP TABLE IF EXISTS `t_log`;
CREATE TABLE `t_log`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `description` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '描述',
  `exception_code` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '类名',
  `type` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '0:controller, 1:service',
  `exception_detail` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '错误描述',
  `method` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '方法',
  `params` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '参数',
  `request_ip` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `rec_status` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT 'A' COMMENT '记录的状态，A: 生效，I: 禁用',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `create_by` bigint NULL DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 246191 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '异常日志表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_log
-- ----------------------------

-- ----------------------------
-- Table structure for t_login_log
-- ----------------------------
DROP TABLE IF EXISTS `t_login_log`;
CREATE TABLE `t_login_log`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `ip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `rec_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'A',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4543 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;


-- ----------------------------
-- Table structure for t_look_space
-- ----------------------------
DROP TABLE IF EXISTS `t_look_space`;
CREATE TABLE `t_look_space`  (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '看看空间',
  `video_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '视频标题',
  `video_file` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '视频文件',
  `create_user_id` int NULL DEFAULT NULL COMMENT '创建者id',
  `is_show` tinyint(1) NULL DEFAULT 0 COMMENT '是否显示0否，1是',
  `sort` int NULL DEFAULT NULL COMMENT '排序',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NULL DEFAULT NULL COMMENT '修改时间',
  `push_time` timestamp NULL DEFAULT NULL COMMENT '发布时间',
  `rec_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'A',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_look_space
-- ----------------------------

-- ----------------------------
-- Table structure for t_mail_template
-- ----------------------------
DROP TABLE IF EXISTS `t_mail_template`;
CREATE TABLE `t_mail_template`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `send_mail` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '发件人邮箱',
  `send_password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '发件人邮箱密码',
  `send_host` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '发件人主机',
  `subject` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '收件主题',
  `msg` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '邮件内容',
  `rec_status` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'A',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
  `type` int NULL DEFAULT NULL COMMENT '0订单发票，1深时演示场景，2验证码，3权益会员过期',
  `lang` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'zh' COMMENT 'zh 中文，en英文',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 23 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_mail_template
-- ----------------------------

-- ----------------------------
-- Table structure for t_manager
-- ----------------------------
DROP TABLE IF EXISTS `t_manager`;
CREATE TABLE `t_manager`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键自增',
  `nickname` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '用户昵称',
  `username` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '用户名',
  `password` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '密码',
  `is_company` int NULL DEFAULT 0 COMMENT '是否企业用户（0否，1是）',
  `agent_framework_id` bigint NULL DEFAULT NULL COMMENT '代理商架构管理t_agent_framework的id',
  `manager_role_id` bigint NULL DEFAULT NULL COMMENT '管理后台角色t_manager_role表的id',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `rec_status` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT 'A' COMMENT '记录的状态，A: 生效，I: 禁用',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '管理员表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_manager
-- ----------------------------

-- ----------------------------
-- Table structure for t_manager_resource
-- ----------------------------
DROP TABLE IF EXISTS `t_manager_resource`;
CREATE TABLE `t_manager_resource`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键自增',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `rec_status` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'A' COMMENT '记录的状态，A: 生效，I: 禁用',
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '资源描述',
  `icon` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '图标',
  `name` varchar(50) 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 '资源地址',
  `parent_id` bigint NULL DEFAULT NULL COMMENT '父资源id',
  `resource_type` enum('menu','button') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '资源类型',
  `resource_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '资源key',
  `sort` int NULL DEFAULT NULL COMMENT '排序',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `parent_id`(`parent_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '管理后台角资源表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_manager_resource
-- ----------------------------

-- ----------------------------
-- Table structure for t_manager_role
-- ----------------------------
DROP TABLE IF EXISTS `t_manager_role`;
CREATE TABLE `t_manager_role`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键自增',
  `role_desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '角色描述',
  `role_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '角色名',
  `role_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '角色key',
  `sort` int NULL DEFAULT NULL COMMENT '排序',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `rec_status` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'A' COMMENT '记录的状态，A: 生效，I: 禁用',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '管理后台角色表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_manager_role
-- ----------------------------

-- ----------------------------
-- Table structure for t_manager_role_resource
-- ----------------------------
DROP TABLE IF EXISTS `t_manager_role_resource`;
CREATE TABLE `t_manager_role_resource`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键自增',
  `manager_role_id` bigint NOT NULL COMMENT '管理后台角色表id',
  `manager_resource_id` bigint NOT NULL COMMENT '管理后台资源表id',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `rec_status` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'A' COMMENT '记录的状态，A: 生效，I: 禁用',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '管理后台角色资源关系表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_manager_role_resource
-- ----------------------------

-- ----------------------------
-- Table structure for t_modeling_camera_level
-- ----------------------------
DROP TABLE IF EXISTS `t_modeling_camera_level`;
CREATE TABLE `t_modeling_camera_level`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `camera_id` int NULL DEFAULT NULL,
  `sn_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `level` int NULL DEFAULT 0 COMMENT '0',
  `rec_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'A',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_modeling_camera_level
-- ----------------------------

-- ----------------------------
-- Table structure for t_modeling_config
-- ----------------------------
DROP TABLE IF EXISTS `t_modeling_config`;
CREATE TABLE `t_modeling_config`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `camera_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '相机类型',
  `camera_type` int NULL DEFAULT NULL COMMENT '1看看，9看见，10深时，11深光',
  `scene_source` int NULL DEFAULT NULL COMMENT '1看看，3看见，4深时，5深光',
  `modelkind` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `scene_resolution` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `scene_from` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `scene_kind` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `split_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `skybox_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `app_obj_split_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `pc_obj_split_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `rec_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'A',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_modeling_config
-- ----------------------------

-- ----------------------------
-- Table structure for t_mq_backup
-- ----------------------------
DROP TABLE IF EXISTS `t_mq_backup`;
CREATE TABLE `t_mq_backup`  (
  `id` bigint NOT NULL,
  `queue` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '队列名',
  `msg` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '消息体',
  `need_requeue` int NOT NULL DEFAULT 1 COMMENT '是否重新需要回队（0-否，1-是）',
  `requeue` int NOT NULL DEFAULT 0 COMMENT '是否已重新回队（0-否，1-是）',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `rec_status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'A' COMMENT 'A-有效，I-无效',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_mq_backup
-- ----------------------------

-- ----------------------------
-- Table structure for t_news
-- ----------------------------
DROP TABLE IF EXISTS `t_news`;
CREATE TABLE `t_news`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `source` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '来源',
  `new_type` tinyint NULL DEFAULT 1 COMMENT '新闻类型(1-链接，2-图文)',
  `display` tinyint NULL DEFAULT 1 COMMENT '是否显示(0-否，1-是)',
  `is_top` tinyint NULL DEFAULT 0 COMMENT '是否置顶(0-否，1-是)',
  `is_public` tinyint NULL DEFAULT 0 COMMENT '是否发布(0-否，1-是)',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '标题',
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '新闻内容',
  `cover_image_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '封面图url',
  `public_time` timestamp NULL DEFAULT NULL COMMENT '发布时间',
  `top_time` timestamp NULL DEFAULT NULL COMMENT '置顶时间',
  `sys_user_id` bigint NOT NULL COMMENT '创建人',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updater_id` bigint NULL DEFAULT NULL COMMENT '修改人',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
  `tb_status` tinyint NOT NULL DEFAULT 0 COMMENT '0-有效，1-删除',
  `language` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'cn',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 28 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_news
-- ----------------------------

-- ----------------------------
-- Table structure for t_order
-- ----------------------------
DROP TABLE IF EXISTS `t_order`;
CREATE TABLE `t_order`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `order_sn` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '订单号',
  `order_time` datetime NULL DEFAULT NULL COMMENT '下单时间',
  `trade_num` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '交易号',
  `user_id` bigint NULL DEFAULT NULL COMMENT '用户表t_user的id',
  `goods_total_count` int NOT NULL COMMENT '商品总数',
  `goods_amount` decimal(15, 2) NOT NULL COMMENT '商品总额',
  `total_amount` decimal(15, 2) NOT NULL COMMENT '订单总额',
  `order_status` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '订单状态（未处理unprocessed、已确认processed、已完成completed、已取消invalid、过期expire）',
  `payment_status` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '付款状态（未付款unpaid、已付款paid、已取消cancel, 部分支付partPayment, 部分退款partRefund, 全额退款refunded）',
  `shipping_status` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '配送状态（未发货unshipped、部分发货partShipped、已发货shipped、部分退货partReshiped、已退货reshiped、已收货received）',
  `paid_amount` decimal(15, 2) NOT NULL COMMENT '已付金额',
  `payment_type_name` tinyint NULL DEFAULT -1 COMMENT '付款方式，0表示微信，1表示支付宝，2表示paypal，3表示其他，4表示货到付款',
  `express_amount` decimal(15, 2) NOT NULL COMMENT '快递费',
  `delivery_type_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '配送方式：快递运输、自提、同城速递',
  `ship_address` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '收货地址',
  `ship_area` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '收货地区',
  `ship_area_path` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '收货地区路径',
  `ship_mobile` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '收货手机',
  `ship_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '收货人姓名',
  `ship_phone` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '收货电话',
  `ship_zip_code` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '收货邮编',
  `finish_time` datetime NULL DEFAULT NULL COMMENT '完成时间',
  `memo` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '买家附言',
  `comment` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '商家备注',
  `abroad` tinyint NULL DEFAULT NULL COMMENT '0表示国内订单，1表示国外订单',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `rec_status` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT 'A' COMMENT '记录的状态，A: 生效，I: 禁用',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `order_sn`(`order_sn`) USING BTREE,
  INDEX `user_id`(`user_id`) USING BTREE,
  CONSTRAINT `t_order_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `t_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1666 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '订单表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_order
-- ----------------------------

-- ----------------------------
-- Table structure for t_order_item
-- ----------------------------
DROP TABLE IF EXISTS `t_order_item`;
CREATE TABLE `t_order_item`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `goods_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '商品名称',
  `goods_price` decimal(15, 2) NOT NULL COMMENT '商品价格',
  `goods_count` int NOT NULL COMMENT '商品数量',
  `goods_sn` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '商品编码',
  `sku_sn` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'sku编号,唯一',
  `goods_id` bigint NULL DEFAULT NULL COMMENT '商品表t_goods的id',
  `order_id` bigint NULL DEFAULT NULL COMMENT '订单表t_order的id',
  `express_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '快递公司',
  `express_num` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '快递单号',
  `shipping_status` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '配送状态',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `rec_status` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '记录的状态，A: 生效，I: 禁用',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `goods_id`(`goods_id`) USING BTREE,
  INDEX `order_id`(`order_id`) USING BTREE,
  CONSTRAINT `t_order_item_ibfk_1` FOREIGN KEY (`order_id`) REFERENCES `t_order` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `t_order_item_ibfk_2` FOREIGN KEY (`goods_id`) REFERENCES `t_goods` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 2389 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '订单项表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_order_item
-- ----------------------------

-- ----------------------------
-- Table structure for t_pic_scene_progress
-- ----------------------------
DROP TABLE IF EXISTS `t_pic_scene_progress`;
CREATE TABLE `t_pic_scene_progress`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `scene_code` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '大场景序号',
  `rebuild_queue_start_time` datetime NULL DEFAULT NULL COMMENT '重算开始时间（进入队列）',
  `rebuild_start_time` datetime NULL DEFAULT NULL COMMENT '重算开始时间',
  `rebuild_end_time` datetime NULL DEFAULT NULL COMMENT '重算结束时间',
  `video_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '视频名称',
  `data_source` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '原场景路径',
  `rebuild_result` smallint NULL DEFAULT NULL COMMENT '重算结果  0:失败，1：成功 2：等待 3:重算中  9：成功且轮询过',
  `rebuild_param` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '重算参数',
  `hdr_param` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT 'videos_hdr_param 参数',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `rec_status` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '记录的状态，A: 生效，I: 禁用',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `is_delete` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `scene_code`(`scene_code`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 32 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '视频重算进度' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_pic_scene_progress
-- ----------------------------

-- ----------------------------
-- Table structure for t_pre_sale
-- ----------------------------
DROP TABLE IF EXISTS `t_pre_sale`;
CREATE TABLE `t_pre_sale`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `user_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '用户姓名',
  `phone` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '电话',
  `scene_index` tinyint NULL DEFAULT NULL COMMENT '应用场景',
  `description` tinytext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '描述',
  `weixin` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '微信号',
  `enterprise_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '企业名称',
  `count` int NOT NULL DEFAULT 1 COMMENT '数量',
  `order_time` datetime NULL DEFAULT NULL COMMENT '下单时间',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `rec_status` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '记录的状态，A: 生效，I: 禁用',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 112 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '预售表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_pre_sale
-- ----------------------------

-- ----------------------------
-- Table structure for t_province
-- ----------------------------
DROP TABLE IF EXISTS `t_province`;
CREATE TABLE `t_province`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '中国省份名称',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `rec_status` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '记录的状态，A: 生效，I: 禁用',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 32 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '中国省份表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_province
-- ----------------------------

-- ----------------------------
-- Table structure for t_receiver_info
-- ----------------------------
DROP TABLE IF EXISTS `t_receiver_info`;
CREATE TABLE `t_receiver_info`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `user_id` bigint NULL DEFAULT NULL COMMENT '用户表t_user的id',
  `ship_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '收货人姓名',
  `ship_mobile` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '收货人的电话号码',
  `ship_area` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '所在地区',
  `ship_address` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '收货的详细地址',
  `set_default` tinyint NULL DEFAULT 0 COMMENT '1表示默认地址，0表示不是默认地址',
  `country` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '中国',
  `ship_area_path` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '收货地区路径',
  `ship_phone` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '收货电话',
  `ship_zip_code` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '收货邮编',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `rec_status` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT 'A' COMMENT '记录的状态，A: 生效，I: 禁用',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 996 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '收货人信息表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_receiver_info
-- ----------------------------

-- ----------------------------
-- Table structure for t_resource
-- ----------------------------
DROP TABLE IF EXISTS `t_resource`;
CREATE TABLE `t_resource`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `rec_status` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '记录的状态，A: 生效，I: 禁用',
  `description` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '资源描述',
  `icon` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '图标',
  `name` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '资源名称',
  `url` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '资源地址',
  `parent_id` bigint NULL DEFAULT NULL COMMENT '父资源id',
  `resource_type` enum('menu','button') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '资源类型',
  `resource_key` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '资源key',
  `sort` tinyint NULL DEFAULT NULL COMMENT '排序',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `parent_id`(`parent_id`) USING BTREE,
  CONSTRAINT `fk_resource_1` FOREIGN KEY (`parent_id`) REFERENCES `t_resource` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '资源表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_resource
-- ----------------------------

-- ----------------------------
-- Table structure for t_role
-- ----------------------------
DROP TABLE IF EXISTS `t_role`;
CREATE TABLE `t_role`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `role_desc` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '角色描述',
  `role_name` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '角色名',
  `role_key` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '角色key',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `rec_status` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '记录的状态，A: 生效，I: 禁用',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '角色表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_role
-- ----------------------------

-- ----------------------------
-- Table structure for t_role_resource
-- ----------------------------
DROP TABLE IF EXISTS `t_role_resource`;
CREATE TABLE `t_role_resource`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `role_id` bigint NOT NULL COMMENT '角色表id',
  `resource_id` bigint NOT NULL COMMENT '资源表id',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `rec_status` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '记录的状态，A: 生效，I: 禁用',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `resource_id`(`resource_id`) USING BTREE,
  INDEX `fk_role_id_1`(`role_id`) USING BTREE,
  CONSTRAINT `fk_resource_id_2` FOREIGN KEY (`resource_id`) REFERENCES `t_resource` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `fk_role_id_1` FOREIGN KEY (`role_id`) REFERENCES `t_role` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '角色资源关系表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_role_resource
-- ----------------------------

-- ----------------------------
-- Table structure for t_rtk_account
-- ----------------------------
DROP TABLE IF EXISTS `t_rtk_account`;
CREATE TABLE `t_rtk_account`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `ip_addr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `mount_point` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `port` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '0移动',
  `operator` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '运营商',
  `status` int NULL DEFAULT 0 COMMENT '使用状态0初始状态未激活，1未使用，2正在使用，3已停用',
  `rec_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'A',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `create_user_id` int NULL DEFAULT NULL,
  `update_user_id` int NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_rtk_account
-- ----------------------------

-- ----------------------------
-- Table structure for t_rtk_code
-- ----------------------------
DROP TABLE IF EXISTS `t_rtk_code`;
CREATE TABLE `t_rtk_code`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `rtk_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'A表示千寻，B表示移动',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `rtk_code`(`rtk_code`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 201 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_rtk_code
-- ----------------------------

-- ----------------------------
-- Table structure for t_rtk_device
-- ----------------------------
DROP TABLE IF EXISTS `t_rtk_device`;
CREATE TABLE `t_rtk_device`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `rtk_sn_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `camera_sn_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `sg_rtk_sn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `type` int NULL DEFAULT 0,
  `rec_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'A',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `create_user_id` int NULL DEFAULT NULL,
  `update_user_id` int NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_rtk_device
-- ----------------------------

-- ----------------------------
-- Table structure for t_rtk_info
-- ----------------------------
DROP TABLE IF EXISTS `t_rtk_info`;
CREATE TABLE `t_rtk_info`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `ip_addr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'ip地址',
  `mount_point` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '挂载点',
  `port` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '端口',
  `user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户名称',
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '密码',
  `rtk_sn_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '板卡sn',
  `camera_sn_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '相机sn',
  `sg_rtk_sn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '深光rtk插件sn',
  `operator` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '运营商',
  `rtk_type` int NULL DEFAULT NULL COMMENT '0千寻板卡千寻账号，1千寻板卡移动账号，2北云板卡移动账号',
  `status` int NULL DEFAULT 0 COMMENT '使用状态',
  `rec_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'A',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `create_user_id` int NULL DEFAULT NULL,
  `update_user_id` int NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `rtk_sn_code`(`rtk_sn_code`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 350 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_rtk_info
-- ----------------------------

-- ----------------------------
-- Table structure for t_rtk_use_log
-- ----------------------------
DROP TABLE IF EXISTS `t_rtk_use_log`;
CREATE TABLE `t_rtk_use_log`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `rtk_sn_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `ip_addr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `mount_point` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `port` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `type` int NULL DEFAULT NULL,
  `status` int NULL DEFAULT NULL,
  `visit_ip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `rec_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'A',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_rtk_use_log
-- ----------------------------

-- ----------------------------
-- Table structure for t_scene
-- ----------------------------
DROP TABLE IF EXISTS `t_scene`;
CREATE TABLE `t_scene`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `scene_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '场景名称',
  `scene_dec` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '场景描述',
  `web_site` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '场景的链接地址',
  `thumb` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT 'http://scene3d.4dage.com/loading/thumb.jpg' COMMENT '场景缩略图',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `status` tinyint NULL DEFAULT 0 COMMENT '0表示未建好，1表示建好，-1表示出错，-2表示不要在官网上显示',
  `data_source` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '原始的大场景数据（七牛）',
  `user_id` bigint NULL DEFAULT NULL COMMENT '用户表t_user的id',
  `pay_status` tinyint NULL DEFAULT 0 COMMENT '0表示未付款，1表示付款了，-1表示欠费',
  `camera_id` bigint NULL DEFAULT NULL COMMENT '相机主表t_camera的id',
  `phone_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '手机id',
  `num` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '大场景序号',
  `scene_key` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '大场景的密钥',
  `scene_type` tinyint NOT NULL DEFAULT 0 COMMENT '0表示其他，1表示文博，2表示地产，3表示电商，4表示餐饮，5表示家居',
  `recommend` tinyint NULL DEFAULT 0 COMMENT '1表示推荐，0表示正常',
  `view_count` int NULL DEFAULT 0 COMMENT '浏览次数',
  `version` int NOT NULL DEFAULT 0 COMMENT '版本',
  `thumb_status` tinyint NOT NULL DEFAULT 0 COMMENT '表示缩略图是否存在',
  `floor_logo` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '0' COMMENT '0表示默认，1表示自己上传',
  `floor_logo_size` int NULL DEFAULT 50 COMMENT '标记大小',
  `hots_ids` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '要上传的热点的id集合，用逗号隔开',
  `entry` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '表示初始点信息',
  `shoot_count` int NULL DEFAULT NULL COMMENT '拍摄数量',
  `style` tinyint NULL DEFAULT 0 COMMENT '风格',
  `gps` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '要gps定位',
  `scene_scheme` tinyint NULL DEFAULT 1 COMMENT '方案：1是双目，2是转台，3是六目,4是八目',
  `bg_music` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '0' COMMENT '背景音乐名称',
  `rec_status` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '记录的状态，A: 生效，I: 禁用',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `screencap_voice_src` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '普通录屏文件地址',
  `screencap_music` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '旧版录屏数据地址',
  `screencap_len` tinyint NULL DEFAULT 0 COMMENT '录屏文件个数',
  `screencap_voice_sound` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '录音文件地址',
  `screencap_voice_type` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '选择的类型，sound为screencapVoiceSound，file为screencapVoiceSrc',
  `play_data` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '录屏文件地址',
  `algorithm` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT 'slam' COMMENT '算法类型',
  `oss` varchar(25) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT 'aliyun' COMMENT 'oss服务商',
  `floor_edit_ver` int NULL DEFAULT 0 COMMENT '重新建模的版本',
  `floor_publish_ver` int NULL DEFAULT 0 COMMENT '正式发布重新建模的版本',
  `space` bigint UNSIGNED NULL DEFAULT 0 COMMENT '使用容量',
  `screencap_thumb` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '录屏图片存放文件',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `num`(`num`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3464 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '场景表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_scene
-- ----------------------------

-- ----------------------------
-- Table structure for t_scene_3d_num
-- ----------------------------
DROP TABLE IF EXISTS `t_scene_3d_num`;
CREATE TABLE `t_scene_3d_num`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `used` tinyint NULL DEFAULT 0,
  `folder_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  `code` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  `rec_status` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT 'A' COMMENT '记录的状态，A 生效，I 禁用',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `IDX_CODE`(`code`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 18001 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '场景编码表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_scene_3d_num
-- ----------------------------

-- ----------------------------
-- Table structure for t_scene_3d_num_matter_pro
-- ----------------------------
DROP TABLE IF EXISTS `t_scene_3d_num_matter_pro`;
CREATE TABLE `t_scene_3d_num_matter_pro`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `used` tinyint NULL DEFAULT 0,
  `folder_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  `code` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  `rec_status` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT 'A' COMMENT '记录的状态，A: 生效，I: 禁用',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `code`(`code`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 50101 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = 'matter_pro场景码' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_scene_3d_num_matter_pro
-- ----------------------------

-- ----------------------------
-- Table structure for t_scene_3d_num_new
-- ----------------------------
DROP TABLE IF EXISTS `t_scene_3d_num_new`;
CREATE TABLE `t_scene_3d_num_new`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `used` tinyint NULL DEFAULT 0,
  `folder_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  `code` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  `rec_status` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT 'A' COMMENT '记录的状态，A: 生效，I: 禁用',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `code`(`code`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 201933 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '八目场景编码表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_scene_3d_num_new
-- ----------------------------

-- ----------------------------
-- Table structure for t_scene_3d_num_sk
-- ----------------------------
DROP TABLE IF EXISTS `t_scene_3d_num_sk`;
CREATE TABLE `t_scene_3d_num_sk`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `used` tinyint NULL DEFAULT 0,
  `folder_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  `code` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  `rec_status` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT 'A' COMMENT '记录的状态，A: 生效，I: 禁用',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `code`(`code`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 50001 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '八目场景编码表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_scene_3d_num_sk
-- ----------------------------

-- ----------------------------
-- Table structure for t_scene_3dfamily
-- ----------------------------
DROP TABLE IF EXISTS `t_scene_3dfamily`;
CREATE TABLE `t_scene_3dfamily`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `scene_num` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '场景码',
  `zip_link` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT 'zip包存放路径',
  `status` int NULL DEFAULT NULL COMMENT '状态 1 - 打包完成  0 - 打包中',
  `zip_start_time` datetime NULL DEFAULT NULL COMMENT '打包开始时间',
  `zip_end_time` datetime NULL DEFAULT NULL COMMENT '打包结束时间',
  `create_uesr` bigint NULL DEFAULT NULL COMMENT '创建人',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_uesr` bigint NULL DEFAULT NULL COMMENT '更新人',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `rec_status` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT 'A' COMMENT '记录的状态，A: 生效，I: 禁用',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 122 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '三维家表' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of t_scene_3dfamily
-- ----------------------------

-- ----------------------------
-- Table structure for t_scene_apply
-- ----------------------------
DROP TABLE IF EXISTS `t_scene_apply`;
CREATE TABLE `t_scene_apply`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '姓名',
  `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '手机号码',
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '邮箱地址',
  `company` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '公司',
  `job` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '行业',
  `continent` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '大洲',
  `country` varchar(255) 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_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `rec_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'A',
  `state` int NULL DEFAULT 0 COMMENT '邮件发送状态 0 待发送，1发送成功,2发送失败',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 67 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_scene_apply
-- ----------------------------

-- ----------------------------
-- Table structure for t_scene_asyn_oper_log
-- ----------------------------
DROP TABLE IF EXISTS `t_scene_asyn_oper_log`;
CREATE TABLE `t_scene_asyn_oper_log`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `num` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '场景码',
  `oper_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '操作类型（upload-上传,download-下载）',
  `module` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '模块名称',
  `func` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '功能',
  `version` int NULL DEFAULT NULL COMMENT '版本号',
  `state` int NOT NULL DEFAULT 0 COMMENT '状态(0-处理中，1-处理完成，2-处理失败)',
  `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '下载链接',
  `pop` int NOT NULL DEFAULT 1 COMMENT '是否需要弹窗（0-否，1-是）',
  `ext_data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '扩展信息',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `rec_status` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'A' COMMENT '状态（A-有效，I-无效）',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `IDX_NUM`(`num`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 727 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '场景异步操作记录表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_scene_asyn_oper_log
-- ----------------------------

-- ----------------------------
-- Table structure for t_scene_build_process_log
-- ----------------------------
DROP TABLE IF EXISTS `t_scene_build_process_log`;
CREATE TABLE `t_scene_build_process_log`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `num` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '场景码',
  `process` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '计算流程（pre-前置处理，call-计算，post-后置处）\r\n失败原因  PRE_ERROR(\"pre\",\"场景计算资源准备错误\"),CALL_ERROR(\"call\",\"算法计算错误\"),POST_ERROR(\"post\",\"场景计算结果处理错误\"),\r\n  NOT_KNOW_ERROR(\"not_know\",\"未知原因错误\")\r\n',
  `queue_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'mq消息队列名称',
  `state` int NOT NULL DEFAULT 0 COMMENT '处理状态（0-处理中，1-成功，-1-失败）',
  `reason` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '失败原因',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `rec_status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'A' COMMENT 'A-有效，I-无效',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `IDX_NUM`(`num`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 24044 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '场景计算流程状态表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_scene_build_process_log
-- ----------------------------

-- ----------------------------
-- Table structure for t_scene_build_record
-- ----------------------------
DROP TABLE IF EXISTS `t_scene_build_record`;
CREATE TABLE `t_scene_build_record`  (
  `id` int NULL DEFAULT NULL,
  `scene_num` varchar(9) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '场景码',
  `build_params` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '构建参数',
  `build_status` int NULL DEFAULT NULL COMMENT '构建状态',
  `build_machine_name` int NULL DEFAULT NULL COMMENT '构建机器名称',
  `build_start_time` datetime NULL DEFAULT NULL,
  `build_end_time` datetime NULL DEFAULT NULL COMMENT '构建开始时间',
  `data_source` int NULL DEFAULT NULL COMMENT '构建服务器目录',
  `create_time` datetime NULL DEFAULT NULL COMMENT '构建结束时间',
  `update_time` datetime NULL DEFAULT NULL,
  `rec_status` int NULL DEFAULT NULL COMMENT '记录状态：A可用；I不可用'
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_scene_build_record
-- ----------------------------

-- ----------------------------
-- Table structure for t_scene_clean
-- ----------------------------
DROP TABLE IF EXISTS `t_scene_clean`;
CREATE TABLE `t_scene_clean`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `num` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '场景码',
  `state` tinyint NOT NULL DEFAULT 1 COMMENT '是否已清除资源（0-否，1-是）',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `rec_status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'A' COMMENT 'A-有效，I-无效',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `IDX_NUM`(`num`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 23562 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_scene_clean
-- ----------------------------

-- ----------------------------
-- Table structure for t_scene_clean_orig
-- ----------------------------
DROP TABLE IF EXISTS `t_scene_clean_orig`;
CREATE TABLE `t_scene_clean_orig`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `num` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `type` tinyint NULL DEFAULT NULL COMMENT '类型(1-删除正常场景的原始资源,2-删除已删除场景的原始资源和caches,3-删除测试相机的原始和caches)',
  `state` tinyint NOT NULL COMMENT '0-处理中，1-成功，-1失败',
  `reason` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '失败原因',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `rec_status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'A' COMMENT 'A-有效，I-删除',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `IDX_NUM`(`num`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 21588 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '删除oss原始资源记录' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_scene_clean_orig
-- ----------------------------

-- ----------------------------
-- Table structure for t_scene_cold_storage
-- ----------------------------
DROP TABLE IF EXISTS `t_scene_cold_storage`;
CREATE TABLE `t_scene_cold_storage`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `num` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '场景码',
  `state` tinyint NOT NULL COMMENT '1-冻结，2-解冻',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `rec_status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'A',
  `cold_bucket` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '4dkk-bak' COMMENT '冷存储bucket',
  `bucket` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '4dkankan' COMMENT '正常使用bucket',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `IDX_NUM`(`num`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4587 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '场景封存状态表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_scene_cold_storage
-- ----------------------------

-- ----------------------------
-- Table structure for t_scene_cold_storage_log
-- ----------------------------
DROP TABLE IF EXISTS `t_scene_cold_storage_log`;
CREATE TABLE `t_scene_cold_storage_log`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `num` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '场景码',
  `path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '封存地址',
  `type` tinyint NOT NULL DEFAULT 1 COMMENT '操作类型（1-封存，2-解封存）',
  `state` tinyint NULL DEFAULT NULL COMMENT '0-处理中，1-成功，-1-失败',
  `reason` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '失败原因',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `rec_status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'A' COMMENT 'A-有效，I-无效',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `IDX_NUM`(`num`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 779420 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '场景冷归档日志表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_scene_cold_storage_log
-- ----------------------------

-- ----------------------------
-- Table structure for t_scene_cooperation
-- ----------------------------
DROP TABLE IF EXISTS `t_scene_cooperation`;
CREATE TABLE `t_scene_cooperation`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `scene_num` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '场景码',
  `user_id` bigint NULL DEFAULT NULL COMMENT '协作的用户id',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `rec_status` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'A',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 78047 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_scene_cooperation
-- ----------------------------

-- ----------------------------
-- Table structure for t_scene_copy_distinct_env
-- ----------------------------
DROP TABLE IF EXISTS `t_scene_copy_distinct_env`;
CREATE TABLE `t_scene_copy_distinct_env`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `num` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '场景码',
  `src_data_source` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '原资源路径',
  `target_data_source` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '目标资源路径',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `rec_status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'A' COMMENT '状态（A-有效，I-无效）',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 255 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_scene_copy_distinct_env
-- ----------------------------

-- ----------------------------
-- Table structure for t_scene_copy_log
-- ----------------------------
DROP TABLE IF EXISTS `t_scene_copy_log`;
CREATE TABLE `t_scene_copy_log`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `old_num` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `new_num` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `copy_user_id` int NULL DEFAULT NULL,
  `rec_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'A',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1269 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;


-- ----------------------------
-- Table structure for t_scene_data_download
-- ----------------------------
DROP TABLE IF EXISTS `t_scene_data_download`;
CREATE TABLE `t_scene_data_download`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `scene_num` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '场景码',
  `file_md5` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文件md5',
  `download_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文件下载地址',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `rec_status` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'A',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 89 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '安居客场景数据下载' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_scene_data_download
-- ----------------------------

-- ----------------------------
-- Table structure for t_scene_del_log
-- ----------------------------
DROP TABLE IF EXISTS `t_scene_del_log`;
CREATE TABLE `t_scene_del_log`  (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '场景删除日志',
  `folder_id` int NULL DEFAULT NULL COMMENT '文件夹Id',
  `num` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '场景码',
  `user_id` int NULL DEFAULT NULL COMMENT '操作人Id',
  `sys_user_id` int NULL DEFAULT NULL COMMENT '操作人Id',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 911 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;


-- ----------------------------
-- Table structure for t_scene_download_log
-- ----------------------------
DROP TABLE IF EXISTS `t_scene_download_log`;
CREATE TABLE `t_scene_download_log`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
  `scene_num` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '场景码',
  `scene_version` int NULL DEFAULT NULL COMMENT '场景版本',
  `download_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '场景打包之后的连接',
  `status` int NULL DEFAULT 0 COMMENT '0下载中，1下载成功，2下载失败',
  `sys_version` char(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'v3' COMMENT '下载版本v3,v4',
  `rec_status` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'A',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2082 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_scene_download_log
-- ----------------------------

-- ----------------------------
-- Table structure for t_scene_dynamic_panel
-- ----------------------------
DROP TABLE IF EXISTS `t_scene_dynamic_panel`;
CREATE TABLE `t_scene_dynamic_panel`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `num` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '场景码',
  `sid` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'sid',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `rec_status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'A' COMMENT '删除状态（A-可用，I删除）',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 539 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '场景动态面板' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_scene_dynamic_panel
-- ----------------------------

-- ----------------------------
-- Table structure for t_scene_edit_controls
-- ----------------------------
DROP TABLE IF EXISTS `t_scene_edit_controls`;
CREATE TABLE `t_scene_edit_controls`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',
  `edit_info_id` bigint NOT NULL COMMENT 't_scene_edit_info表id',
  `show_map` tinyint NOT NULL DEFAULT 1 COMMENT '是否展示小地图（0-不展示，1-展示）',
  `show_lock` tinyint NOT NULL DEFAULT 0 COMMENT '是否需要密码（0-不需要，1-需要）',
  `show_title` tinyint NOT NULL DEFAULT 1 COMMENT '是否展示标题（0-不需要，1-需要）',
  `show_panorama` tinyint NOT NULL DEFAULT 1 COMMENT '是否展示漫游按钮（0-不需要，1-需要）',
  `show_dollhouse` tinyint NOT NULL DEFAULT 1 COMMENT '是否展示3D按钮（0-不需要，1-需要）',
  `show_floorplan` tinyint NOT NULL DEFAULT 1 COMMENT '是否展示2D按钮（0-不需要，1-需要）',
  `show_VR` tinyint NOT NULL DEFAULT 1 COMMENT '是否展示VR（0-不需要，1-需要）',
  `show_tour` tinyint NOT NULL DEFAULT 1 COMMENT '是否展示自动导览（0-不需要，1-需要）',
  `show_rule` tinyint NOT NULL DEFAULT 1 COMMENT '是否展示测量线（0-不需要，1-需要）',
  `show_scale` tinyint NOT NULL DEFAULT 0 COMMENT '是否展示标尺（0-不需要，1-需要）',
  `show_share` tinyint NOT NULL DEFAULT 1 COMMENT '是否展示分享场景（0-不需要，1-需要）',
  `show_tagshare` tinyint NOT NULL DEFAULT 1 COMMENT '是否展示分享热点（0-不需要，1-需要）',
  `show_capture` tinyint NOT NULL DEFAULT 1 COMMENT '是否显示合照开关（0-不需要，1-需要）',
  `show_tag_title` tinyint NOT NULL DEFAULT 0 COMMENT '是否显示多媒体标签标题（0-否，1-是）',
  `show_billboard_title` tinyint NOT NULL DEFAULT 1 COMMENT '是否显示指示牌标签标题（0-否，1-是）',
  `show_camera_title` tinyint NOT NULL DEFAULT 0 COMMENT '是否显示视频监控标签标题（0-否，1-是）',
  `show_link_title` tinyint NOT NULL DEFAULT 0 COMMENT '是否显示场景关联标签标题（0-否，1-是）',
  `show_draw_title` tinyint NOT NULL DEFAULT 1 COMMENT '是否显示空间绘制标题',
  `show_all_model` tinyint NOT NULL DEFAULT 0 COMMENT '是否显示全部模型',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  `rec_status` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'A' COMMENT 'A-有效，I-无效',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_editInfoId`(`edit_info_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2008623 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_scene_edit_controls
-- ----------------------------

-- ----------------------------
-- Table structure for t_scene_edit_info
-- ----------------------------
DROP TABLE IF EXISTS `t_scene_edit_info`;
CREATE TABLE `t_scene_edit_info`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',
  `scene_pro_id` bigint NULL DEFAULT NULL,
  `scene_plus_id` bigint NULL DEFAULT NULL,
  `floor_logo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '地面logo名称',
  `floor_logo_size` int NULL DEFAULT NULL COMMENT '地面logo大小',
  `floor_logo_file` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '地面logo文件名称',
  `music` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '背景音乐名称',
  `music_file` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '背景音乐文件名称',
  `scene_password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '浏览密码',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '场景标题',
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '场景描述',
  `floor_plan_user` tinyint NULL DEFAULT 0 COMMENT '用户是否上传户型图（0-否，1-是）',
  `tags` tinyint NULL DEFAULT 0 COMMENT '是否有热点数据（0-否，1-是）',
  `version` int NOT NULL DEFAULT 1 COMMENT '版本',
  `img_version` int NOT NULL DEFAULT 0 COMMENT '图片版本',
  `link_version` int NOT NULL DEFAULT 0 COMMENT '场景关联版本',
  `is_upload_obj` tinyint NULL DEFAULT 0 COMMENT '是否上传模型',
  `floor_edit_ver` int NULL DEFAULT 0 COMMENT '重新建模的版本',
  `floor_publish_ver` int NULL DEFAULT 0 COMMENT '正式发布重新建模的版本',
  `box_videos` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '空间视频数据',
  `box_photos` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '空间贴图数据',
  `box_models` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '空间模型数据',
  `build_video_status` tinyint NOT NULL DEFAULT 0 COMMENT '是否需要处理球幕视频',
  `entry` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '初始点信息',
  `loading_logo` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '加载logo名',
  `loading_logo_file` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '加载logo文件名',
  `floor_plan_upload` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '用户上传自定义平面图数据',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `rec_status` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'A' COMMENT 'A-有效，I-无效',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_plusId`(`scene_plus_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2008624 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_scene_edit_info
-- ----------------------------

-- ----------------------------
-- Table structure for t_scene_edit_info_ext
-- ----------------------------
DROP TABLE IF EXISTS `t_scene_edit_info_ext`;
CREATE TABLE `t_scene_edit_info_ext`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `scene_pro_id` bigint NULL DEFAULT NULL,
  `scene_plus_id` bigint NULL DEFAULT NULL,
  `edit_info_id` bigint NULL DEFAULT NULL,
  `floor_plan_angle` float NULL DEFAULT 0 COMMENT '户型角度',
  `floor_plan_compass` float NULL DEFAULT 0 COMMENT '指南针角度',
  `vr_num` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '大场景序号(随心装场景码)  原pro_edit表中的字段',
  `tours` tinyint NULL DEFAULT 0 COMMENT '是否有保存导览（0-否，1-是）',
  `mosaics` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '马赛克数据',
  `mosaic` tinyint NOT NULL DEFAULT 0 COMMENT '是否有马赛克',
  `water_mark` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '水印文件名',
  `links` tinyint NOT NULL DEFAULT 0 COMMENT '是否有场景关联(0-否，1-是)',
  `filters` tinyint NOT NULL DEFAULT 0 COMMENT '是否有滤镜（0-否，1-是）',
  `roi_filter` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '风格滤镜数据',
  `surveillances` tinyint NOT NULL DEFAULT 0 COMMENT '是否有监控摄像头（0-否，1-是）',
  `share_logo_img` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '二维码logo路径（oss相对路径）',
  `billboards` tinyint NOT NULL DEFAULT 0 COMMENT '是否有指示牌（0-否，1-是）',
  `cut_model` tinyint NOT NULL DEFAULT 0 COMMENT '是否有裁剪模型（0-否，1-是）',
  `sns_info` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '分享配置',
  `started` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '启动页信息',
  `scene_draw` tinyint NOT NULL DEFAULT 0 COMMENT '是否有空间绘制',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `rec_status` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'A' COMMENT 'A-有效，I-无效',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_plusId_editInfoId`(`scene_plus_id`, `edit_info_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2008606 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_scene_edit_info_ext
-- ----------------------------

-- ----------------------------
-- Table structure for t_scene_feedback
-- ----------------------------
DROP TABLE IF EXISTS `t_scene_feedback`;
CREATE TABLE `t_scene_feedback`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `scene_code` varchar(36) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '大场景序号',
  `phone` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '联系电话',
  `message` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '留言',
  `submit_time` datetime NULL DEFAULT NULL COMMENT '提交时间',
  `solve` tinyint NULL DEFAULT 0 COMMENT '0表示未解决，1表示解决',
  `solve_time` datetime NULL DEFAULT NULL COMMENT '解决时间',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `rec_status` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '记录的状态，A: 生效，I: 禁用',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `scene_code`(`scene_code`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 58 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '大场景反馈信息表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_scene_feedback
-- ----------------------------

-- ----------------------------
-- Table structure for t_scene_file_build
-- ----------------------------
DROP TABLE IF EXISTS `t_scene_file_build`;
CREATE TABLE `t_scene_file_build`  (
  `Id` int NOT NULL AUTO_INCREMENT,
  `child_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '相机的Mac地址',
  `file_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '文件id',
  `unicode` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT 'unicode',
  `upload_status` tinyint NULL DEFAULT 0 COMMENT '状态，0-上传中，1-上传成功，-1-上传失败',
  `build_status` tinyint NULL DEFAULT 0 COMMENT '状态，0-未建模，1-请求建模，2-等待建模（队列中），3-建模成功，-1-建模失败',
  `total_pic_num` int NOT NULL DEFAULT 0 COMMENT '照片总张数',
  `chunks` smallint UNSIGNED NULL DEFAULT NULL,
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `rec_status` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '记录的状态，A: 生效，I: 禁用',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`Id`) USING BTREE,
  INDEX `file_id`(`file_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 23724 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '场景文件建模表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_scene_file_build
-- ----------------------------

-- ----------------------------
-- Table structure for t_scene_file_upload
-- ----------------------------
DROP TABLE IF EXISTS `t_scene_file_upload`;
CREATE TABLE `t_scene_file_upload`  (
  `Id` int NOT NULL AUTO_INCREMENT,
  `file_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '文件id',
  `file_source_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '' COMMENT '文件原名称',
  `file_path` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '' COMMENT '文件存放路径',
  `upload_status` tinyint NULL DEFAULT 0 COMMENT '状态，0-上传中，1-上传成功，-1-上传失败',
  `size` int NOT NULL DEFAULT 0 COMMENT '文件大小',
  `md5` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '' COMMENT '文件MD5值',
  `chunk` smallint UNSIGNED NULL DEFAULT NULL,
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `rec_status` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '记录的状态，A: 生效，I: 禁用',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`Id`) USING BTREE,
  INDEX `file_id`(`file_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 30138 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '场景文件上传表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_scene_file_upload
-- ----------------------------

-- ----------------------------
-- Table structure for t_scene_info_sync_mq_config
-- ----------------------------
DROP TABLE IF EXISTS `t_scene_info_sync_mq_config`;
CREATE TABLE `t_scene_info_sync_mq_config`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `info_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '需要同步的消息类型',
  `queue_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '队列名',
  `app_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '需要同步信息的应用名',
  `rec_status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'A',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '场景信息变更需要发送mq信息队列配置表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_scene_info_sync_mq_config
-- ----------------------------

-- ----------------------------
-- Table structure for t_scene_mark_shape
-- ----------------------------
DROP TABLE IF EXISTS `t_scene_mark_shape`;
CREATE TABLE `t_scene_mark_shape`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `flag` json NULL,
  `shapes` json NULL,
  `image_path` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '图片名称',
  `image_height` int NULL DEFAULT NULL COMMENT '高',
  `image_width` int NULL DEFAULT NULL COMMENT '宽度',
  `num` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '场景码',
  `version` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '版本号',
  `rec_status` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT 'A' COMMENT '记录的状态，A: 生效，I: 禁用',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `re_train` int NULL DEFAULT 0 COMMENT '重新训练 0不需要 1需要',
  `to_train` int NULL DEFAULT 0 COMMENT '0没训练 1训练过',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 10739 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '场景标记多边形识别数据表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_scene_mark_shape
-- ----------------------------

-- ----------------------------
-- Table structure for t_scene_mark_shape_box
-- ----------------------------
DROP TABLE IF EXISTS `t_scene_mark_shape_box`;
CREATE TABLE `t_scene_mark_shape_box`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `boxes` json NULL,
  `bounding_Box` json NULL,
  `external_boxes` json NULL,
  `scene_num` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '场景码',
  `rec_status` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT 'A' COMMENT '记录的状态，A: 生效，I: 禁用',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 96 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '场景标记box数据表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_scene_mark_shape_box
-- ----------------------------

-- ----------------------------
-- Table structure for t_scene_module_video
-- ----------------------------
DROP TABLE IF EXISTS `t_scene_module_video`;
CREATE TABLE `t_scene_module_video`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `scene_num` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '场景码',
  `module_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '模块名称',
  `video_url` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '视频地址',
  `images` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '缩略图地址',
  `create_time` datetime NULL DEFAULT NULL,
  `update_time` datetime NULL DEFAULT NULL,
  `rec_status` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '记录的状态，A: 生效，I: 禁用',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '场景模块视频' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_scene_module_video
-- ----------------------------

-- ----------------------------
-- Table structure for t_scene_move_log
-- ----------------------------
DROP TABLE IF EXISTS `t_scene_move_log`;
CREATE TABLE `t_scene_move_log`  (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '相机迁移日志表',
  `num` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '场景码',
  `old_sn_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '旧相机sn',
  `new_sn_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '新相机sn',
  `old_data_source` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `new_data_source` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `data_source_bak` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 854 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_scene_move_log
-- ----------------------------

-- ----------------------------
-- Table structure for t_scene_plus
-- ----------------------------
DROP TABLE IF EXISTS `t_scene_plus`;
CREATE TABLE `t_scene_plus`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `num` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '场景码',
  `user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
  `camera_id` bigint NULL DEFAULT NULL COMMENT '相机id',
  `phone_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '手机id',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '场景名称',
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '场景描述',
  `scene_status` tinyint NOT NULL DEFAULT 0 COMMENT '场景状态：0-未建好，1--已建好，-1-计算出错，-2--不在官网显示',
  `scene_source` int NULL DEFAULT NULL COMMENT '场景来源：相机拍摄10以内表示，1看看，2看看，3看见，4 深时 5 深光 6全景看看 其他来源10以上，11：一键换装，12：123看房，13文通虚拟场景',
  `pay_status` tinyint NULL DEFAULT 0 COMMENT '支付状态：0表示未付款，1表示付款了，-1表示欠费，-2表示容量不足',
  `scene_type` int NULL DEFAULT NULL COMMENT '场景类型  0-其他，1-文博，2-地产，3-电商，4-餐饮，5-家居,99-一件换装虚拟房源',
  `recommend` tinyint NOT NULL DEFAULT 0 COMMENT '是否推荐：0-否，1-是',
  `house_type` tinyint NOT NULL DEFAULT 0 COMMENT '是否有housetype文件（0-否，1-是）',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `rec_status` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'A' COMMENT 'A-有效，I-无效',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `idx_num`(`num`) USING BTREE,
  INDEX `camera_id`(`camera_id`) USING BTREE,
  INDEX `user_id`(`user_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3008051 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '场景主表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_scene_plus
-- ----------------------------

-- ----------------------------
-- Table structure for t_scene_plus_ext
-- ----------------------------
DROP TABLE IF EXISTS `t_scene_plus_ext`;
CREATE TABLE `t_scene_plus_ext`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `plus_id` bigint NOT NULL COMMENT 't_scene_plus主键',
  `data_source` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '场景数据目录',
  `web_site` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '场景链接',
  `thumb` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '缩略图链接',
  `scene_scheme` tinyint NULL DEFAULT NULL COMMENT '方案：1-双目，2-转台，3-六目,4-八目,10-获取4k图，11-获取2k，12-获取1k',
  `space` bigint NULL DEFAULT NULL COMMENT '使用用量',
  `orig_space` bigint NULL DEFAULT NULL COMMENT '原始文件容量',
  `ecs` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'aliyun' COMMENT '云服务器类型',
  `shoot_count` int UNSIGNED NULL DEFAULT NULL COMMENT '点位数量',
  `view_count` int NULL DEFAULT 0 COMMENT '浏览次数',
  `gps` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'gps定位',
  `algorithm` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'slam' COMMENT '算法类型(slam、sfm)',
  `firmware_version` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '固件版本',
  `build_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '算法类型（V2,V3）',
  `scene_resolution` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '分辨率（2k,4k）',
  `scene_from` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '场景来源，lite：双目lite相机，pro：八目相机，minion：双面转台相机，laser：激光相机，virtual：虚拟场景，sketch：图片建模场景',
  `scene_kind` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '切图方式（tiles：瓦片图，face：切片图，pano：全景图 ，local：本地切片，cube：立体图）',
  `model_kind` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'dam' COMMENT '算法生成模型类型（dam,3dtiles）',
  `videos` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '点位视频',
  `yun_file_bucket` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '4dkankan' COMMENT 'oss桶名',
  `algorithm_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '算法计算完成时间',
  `compute_time` bigint NULL DEFAULT 0 COMMENT '计算耗时',
  `location` int NULL DEFAULT NULL COMMENT '拍摄模式:3(SFM架站式-看看场景), \n \n4(SFM架站式-看见/深时/深光场景),\n5(SLAM移动定位模式) , \n6(SLAM移动定位模式-有点位)',
  `mixture` int NOT NULL DEFAULT 0 COMMENT '是否为混合类型',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `rec_status` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'A' COMMENT 'A-有效，I-无效',
  `is_obj` int NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_plusId_dataSource`(`plus_id`, `data_source`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8995 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_scene_plus_ext
-- ----------------------------

-- ----------------------------
-- Table structure for t_scene_plus_void
-- ----------------------------
DROP TABLE IF EXISTS `t_scene_plus_void`;
CREATE TABLE `t_scene_plus_void`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `plus_id` int NULL DEFAULT NULL,
  `status` int NULL DEFAULT 0 COMMENT '0计算中，1计算完成，2计算失败',
  `user_id` int NULL DEFAULT NULL,
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_scene_plus_void
-- ----------------------------

-- ----------------------------
-- Table structure for t_scene_pro
-- ----------------------------
DROP TABLE IF EXISTS `t_scene_pro`;
CREATE TABLE `t_scene_pro`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `scene_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '场景名称',
  `scene_dec` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '场景描述',
  `web_site` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '场景的链接地址',
  `thumb` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT 'https://4dkk.4dage.com/loading/thumb.jpg' COMMENT '场景缩略图',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `status` int NOT NULL DEFAULT 0 COMMENT '0表示未建好，1表示建好，-1表示出错，-2表示不要在官网上显示',
  `data_source` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '原始的大场景数据（七牛）',
  `user_id` bigint NULL DEFAULT NULL COMMENT '用户表t_user的id',
  `pay_status` tinyint NULL DEFAULT 0 COMMENT '0表示未付款，1表示付款了，-1表示欠费，-2表示容量不足',
  `camera_id` bigint NULL DEFAULT NULL COMMENT '相机主表t_camera的id',
  `phone_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '手机id',
  `scene_logo` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '场景logo',
  `num` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '大场景序号',
  `scene_type` tinyint NOT NULL DEFAULT 0 COMMENT '0表示其他，1表示文博，2表示地产，3表示电商，4表示餐饮，5表示家居,99一件换装虚拟房源',
  `recommend` tinyint NULL DEFAULT 0 COMMENT '1表示推荐，0表示正常',
  `view_count` int NULL DEFAULT 0 COMMENT '浏览次数',
  `shoot_count` int NULL DEFAULT 0 COMMENT '拍摄数量 ps:点位数量',
  `files_name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '所有资源文件名',
  `videos` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '点位视频',
  `gps` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '要gps定位',
  `scene_scheme` tinyint NULL DEFAULT 1 COMMENT '方案：1是双目，2是转台，3是六目,4是八目,10获取4k图，11获取2k，12获取1k',
  `rec_status` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT 'A' COMMENT '记录的状态，A: 生效，I: 禁用',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `algorithm` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT 'slam' COMMENT '算法类型',
  `ecs` varchar(25) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT 'aliyun' COMMENT '服务器的服务商',
  `space` bigint UNSIGNED NULL DEFAULT 0 COMMENT '使用容量',
  `firmware_version` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '固件版本',
  `build_type` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT 'V2' COMMENT '调用V2还是V3的算法',
  `compute_time` bigint NULL DEFAULT 0 COMMENT '计算时间（秒为单位）',
  `scene_source` int NULL DEFAULT 1 COMMENT '场景来源，相机拍摄10以内表示，1表示八目，2双目，3转台，4 激光  其他来源10以上，11：一键换装，12：123看房，13文通虚拟场景,14上传的matterport场景',
  `vrnum` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '大场景序号(随心装场景码)',
  `unicode` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  `mosaics` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL,
  `is_upgrade` tinyint NULL DEFAULT 0 COMMENT '是否已升级v4（0-否，1-是）',
  `is_obj` tinyint NULL DEFAULT 0 COMMENT '是否是obj场景',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `t_scene_pro_num_uindex`(`num`) USING BTREE,
  INDEX `test`(`data_source`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 110934 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = 'pro场景表' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of t_scene_pro
-- ----------------------------

-- ----------------------------
-- Table structure for t_scene_pro_edit
-- ----------------------------
DROP TABLE IF EXISTS `t_scene_pro_edit`;
CREATE TABLE `t_scene_pro_edit`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `pro_id` bigint NOT NULL COMMENT 'pro场景id',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `scene_key` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '大场景的密钥',
  `need_key` int NULL DEFAULT 0 COMMENT '展示页面密码，0不需要，1需要',
  `version` int NULL DEFAULT 0 COMMENT '版本',
  `thumb_status` tinyint NULL DEFAULT 0 COMMENT '表示缩略图是否存在',
  `marker_logo` varchar(11) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '0' COMMENT '地面点位标志',
  `floor_logo` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '0' COMMENT '0表示默认，1表示自己上传',
  `floor_logo_size` int NULL DEFAULT 100 COMMENT '标记大小',
  `hots_ids` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '要上传的热点的id集合，用逗号隔开',
  `entry` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '表示初始点信息',
  `bg_music` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '0' COMMENT '背景音乐名称',
  `rec_status` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT 'A' COMMENT '记录的状态，A: 生效，I: 禁用',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `screencap_voice_src` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '普通录屏文件地址',
  `screencap_voice_sound` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '录音文件地址',
  `screencap_voice_soundsync` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '同步录音地址',
  `screencap_voice_type` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '选择的类型，sound为screencapVoiceSound，file为screencapVoiceSrc，soundsync为screencap_voice_soundsync',
  `play_data` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '录屏文件地址',
  `floor_edit_ver` int NULL DEFAULT 0 COMMENT '重新建模的版本',
  `floor_publish_ver` int NULL DEFAULT 0 COMMENT '正式发布重新建模的版本',
  `screencap_thumb` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '录屏图片存放文件',
  `share_logo` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '分享的logo和生成二维码的logo',
  `map_visi` int NULL DEFAULT 1 COMMENT '小地图浏览',
  `tour_visi` int NULL DEFAULT 1 COMMENT '自动导览',
  `vr_visi` int NULL DEFAULT 1 COMMENT 'vr模式',
  `ruler_visi` int NULL DEFAULT 1 COMMENT '展示页面是否显示标尺',
  `cad_img_visi` int NULL DEFAULT 1 COMMENT '展示页面cad图在平面图是否显示',
  `floor_plan_png` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT 'cad平面图',
  `cad_info` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT 'cad平面图参数',
  `pano_visi` int NULL DEFAULT 1,
  `m2d_visi` int NULL DEFAULT 1,
  `m3d_visi` int NULL DEFAULT 1,
  `measure_visi` int NULL DEFAULT 1,
  `link_scene` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '肖安需求，场景于场景之间的关联',
  `overlay` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL,
  `show_logo_bottom` tinyint(1) NULL DEFAULT 1 COMMENT '是否显示底部logo，1显示，0不显示',
  `images_version` int NULL DEFAULT 0 COMMENT '全景图版本号',
  `bg_music_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '上传的背景音乐',
  `jump_scene` tinyint(1) NULL DEFAULT 0,
  `floor_plan_angle` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '旋转角度',
  `download_num` int NULL DEFAULT 0 COMMENT '场景下载次数',
  `videos_user` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '绿幕抠图json数据',
  `vr_num` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '大场景序号(随心装场景码)',
  `vr_thumb` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '随心装封面图',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `pro_id`(`pro_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 20913 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = 'pro场景编辑数据表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_scene_pro_edit
-- ----------------------------

-- ----------------------------
-- Table structure for t_scene_pro_re
-- ----------------------------
DROP TABLE IF EXISTS `t_scene_pro_re`;
CREATE TABLE `t_scene_pro_re`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `scene_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '场景名称',
  `scene_dec` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '场景描述',
  `web_site` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '场景的链接地址',
  `thumb` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT 'https://4dkk.4dage.com/loading/thumb.jpg' COMMENT '场景缩略图',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `status` int NULL DEFAULT 0 COMMENT '0表示未建好，1表示建好，-1表示出错，-2表示不要在官网上显示',
  `data_source` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '原始的大场景数据（七牛）',
  `user_id` bigint NULL DEFAULT NULL COMMENT '用户表t_user的id',
  `pay_status` tinyint NULL DEFAULT 0 COMMENT '0表示未付款，1表示付款了，-1表示欠费，-2表示容量不足，保留30天',
  `camera_id` bigint NULL DEFAULT NULL COMMENT '相机主表t_camera的id',
  `phone_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '手机id',
  `scene_logo` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '场景logo',
  `num` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '大场景序号',
  `scene_type` tinyint NOT NULL DEFAULT 0 COMMENT '0表示其他，1表示文博，2表示地产，3表示电商，4表示餐饮，5表示家居',
  `recommend` tinyint NULL DEFAULT 0 COMMENT '1表示推荐，0表示正常',
  `view_count` int NULL DEFAULT 0 COMMENT '浏览次数',
  `shoot_count` int NULL DEFAULT NULL COMMENT '拍摄数量',
  `gps` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '要gps定位',
  `scene_scheme` tinyint NULL DEFAULT 1 COMMENT '方案：1是双目，2是转台，3是瓦片图,4是八目，10是4k图，11是2k贴图，12是1k贴图',
  `files_name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '所有资源文件名',
  `videos` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '点位视频',
  `rec_status` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT 'A' COMMENT '记录的状态，A: 生效，I: 禁用',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `algorithm` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT 'slam' COMMENT '算法类型',
  `ecs` varchar(25) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT 'aliyun' COMMENT 'oss服务商',
  `space` bigint UNSIGNED NULL DEFAULT 0 COMMENT '使用容量',
  `firmware_version` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '固件版本',
  `build_type` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT 'V2' COMMENT '调用V2还是V3的算法',
  `compute_time` bigint NULL DEFAULT 0 COMMENT '计算时间（秒为单位）',
  `scene_source` int NULL DEFAULT 1 COMMENT '场景来源，相机拍摄10以内表示，1表示八目，2表示双目，其他来源10以上，11：一键换装，12：123看房，13文通虚拟场景，14上传的matterport场景',
  `vrnum` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '大场景序号(随心装场景码)',
  `unicode` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  `mosaics` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL,
  `is_upgrade` tinyint NULL DEFAULT 0 COMMENT '是否已升级v4（0-否，1-是）',
  `is_obj` int NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_userId`(`user_id`) USING BTREE,
  INDEX `idx_num`(`num`) USING BTREE,
  INDEX `idx_cameraId`(`camera_id`) USING BTREE,
  INDEX `idx_index`(`user_id`, `num`, `camera_id`) USING BTREE,
  INDEX `idx_userId_sceneSource`(`user_id`, `scene_source`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 152590 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = 'pro场景表' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of t_scene_pro_re
-- ----------------------------

-- ----------------------------
-- Table structure for t_scene_rebuild_log
-- ----------------------------
DROP TABLE IF EXISTS `t_scene_rebuild_log`;
CREATE TABLE `t_scene_rebuild_log`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `num` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '场景码',
  `source` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '调用来源（api-接口调用，manage-管理后台调用，laser-点位校准调用）',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 108 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '场景重算接口调用日志表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_scene_rebuild_log
-- ----------------------------

-- ----------------------------
-- Table structure for t_scene_record
-- ----------------------------
DROP TABLE IF EXISTS `t_scene_record`;
CREATE TABLE `t_scene_record`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `scene_code` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '大场景序号',
  `publish_time` datetime NULL DEFAULT NULL COMMENT '发布时间',
  `hots_count` tinyint NULL DEFAULT NULL COMMENT '热点个数',
  `pay` tinyint NULL DEFAULT NULL COMMENT '消费',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `rec_status` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '记录的状态，A: 生效，I: 禁用',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `scene_code`(`scene_code`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '大场景编辑记录表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_scene_record
-- ----------------------------

-- ----------------------------
-- Table structure for t_scene_repair_log
-- ----------------------------
DROP TABLE IF EXISTS `t_scene_repair_log`;
CREATE TABLE `t_scene_repair_log`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `num` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '场景码',
  `state` tinyint NULL DEFAULT 0 COMMENT '0-迁移中，1-成功，2-失败',
  `reason` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '失败原因',
  `consum_time` bigint NULL DEFAULT NULL COMMENT '迁移耗时',
  `is_rollback` tinyint NOT NULL DEFAULT 0 COMMENT '是否已回滚(0-否，1-是)',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `rec_status` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'A' COMMENT 'A-有效，I-无效',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2000871 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '场景数据迁移日志--V4版本稳定后可删除' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_scene_repair_log
-- ----------------------------

-- ----------------------------
-- Table structure for t_scene_resource
-- ----------------------------
DROP TABLE IF EXISTS `t_scene_resource`;
CREATE TABLE `t_scene_resource`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '权限名称',
  `en_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '英文名',
  `key_word` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '权限key',
  `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '权限图标',
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '资源描述',
  `version` char(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '版本(v3,v4)',
  `create_time` datetime NULL DEFAULT NULL,
  `update_time` datetime NULL DEFAULT NULL,
  `rec_status` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 38 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '场景资源表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_scene_resource
-- ----------------------------

-- ----------------------------
-- Table structure for t_scene_resource_camera
-- ----------------------------
DROP TABLE IF EXISTS `t_scene_resource_camera`;
CREATE TABLE `t_scene_resource_camera`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `scene_resource_id` bigint NULL DEFAULT NULL COMMENT '场景资源id',
  `camera_id` bigint NULL DEFAULT NULL COMMENT '协作相机的id',
  `create_time` datetime NULL DEFAULT NULL,
  `update_time` datetime NULL DEFAULT NULL,
  `rec_status` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 10768 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '场景资源和相机关联表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_scene_resource_camera
-- ----------------------------

-- ----------------------------
-- Table structure for t_scene_resource_cooperation
-- ----------------------------
DROP TABLE IF EXISTS `t_scene_resource_cooperation`;
CREATE TABLE `t_scene_resource_cooperation`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `scene_resource_id` bigint NULL DEFAULT NULL COMMENT '场景资源id',
  `scene_cooperation_id` bigint NULL DEFAULT NULL COMMENT '协作用户的id',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `rec_status` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'A',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 814936 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '场景资源和协作用户关联表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_scene_resource_cooperation
-- ----------------------------

-- ----------------------------
-- Table structure for t_scene_result_upload_log
-- ----------------------------
DROP TABLE IF EXISTS `t_scene_result_upload_log`;
CREATE TABLE `t_scene_result_upload_log`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `num` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `state` int NOT NULL DEFAULT 0,
  `reason` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `IDX_NUM`(`num`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '场景计算结果上传日志' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_scene_result_upload_log
-- ----------------------------

-- ----------------------------
-- Table structure for t_scene_shape_enum
-- ----------------------------
DROP TABLE IF EXISTS `t_scene_shape_enum`;
CREATE TABLE `t_scene_shape_enum`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `name` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '属性名',
  `class_name` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '类名',
  `resource_id` int NULL DEFAULT NULL COMMENT '资源类型ID',
  `type_id` int NULL DEFAULT NULL COMMENT '设备类型ID',
  `rec_status` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT 'A' COMMENT '记录的状态，A: 生效，I: 禁用',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 18 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '标注框模型表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_scene_shape_enum
-- ----------------------------

-- ----------------------------
-- Table structure for t_scene_statistics
-- ----------------------------
DROP TABLE IF EXISTS `t_scene_statistics`;
CREATE TABLE `t_scene_statistics`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `scene_num` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '场景码',
  `pv_count` int NULL DEFAULT NULL COMMENT '浏览量(PV)',
  `visitor_count` int NULL DEFAULT NULL COMMENT '访客数(UV)',
  `ip_count` int NULL DEFAULT NULL COMMENT 'IP 数',
  `visit1_count` int NULL DEFAULT NULL COMMENT '入口页次数',
  `outward_count` int NULL DEFAULT NULL COMMENT '贡献下游浏览量',
  `exit_count` int NULL DEFAULT NULL COMMENT '退出页次数',
  `average_stay_time` int NULL DEFAULT NULL COMMENT '平均停留时长， 秒',
  `exit_ratio` decimal(15, 2) NULL DEFAULT NULL COMMENT '退出率，%',
  `type` int NULL DEFAULT 1 COMMENT '1:场景，2:热点，3:视频',
  `date_str` datetime NULL DEFAULT NULL COMMENT '日期（年月日）',
  `create_time` datetime NULL DEFAULT NULL,
  `update_time` datetime NULL DEFAULT NULL,
  `rec_status` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 493982 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '百度统计场景流量量表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_scene_statistics
-- ----------------------------

-- ----------------------------
-- Table structure for t_scene_upload
-- ----------------------------
DROP TABLE IF EXISTS `t_scene_upload`;
CREATE TABLE `t_scene_upload`  (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '文件上传资源记录表',
  `num` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '场景码',
  `file_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '上传文件路径',
  `biz_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '业务类型',
  `upload_user` bigint NULL DEFAULT NULL COMMENT '上传用户id',
  `rec_status` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'A' COMMENT 'A-有效，I-无效',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2038996 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_scene_upload
-- ----------------------------

-- ----------------------------
-- Table structure for t_scene_upload_count
-- ----------------------------
DROP TABLE IF EXISTS `t_scene_upload_count`;
CREATE TABLE `t_scene_upload_count`  (
  `id` bigint NOT NULL,
  `uuid` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `sn_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '相机码',
  `count` int NULL DEFAULT 0 COMMENT '触发上传次数',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `IDX_UUID`(`uuid`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = 'app触发场景上传统计表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_scene_upload_count
-- ----------------------------

-- ----------------------------
-- Table structure for t_service_up_tip
-- ----------------------------
DROP TABLE IF EXISTS `t_service_up_tip`;
CREATE TABLE `t_service_up_tip`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `version` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '版本号',
  `type` int NULL DEFAULT NULL COMMENT '类型，0看看，1深时，2全景，3带看',
  `tip_start_time` timestamp NULL DEFAULT NULL,
  `tip_end_time` timestamp NULL DEFAULT NULL,
  `title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '标题',
  `title_en` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `image_url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '图片，视频url',
  `image_url_en` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '说明',
  `description_en` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `info_url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '详情链接',
  `info_url_en` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `ban_status` int NULL DEFAULT 1 COMMENT '0启用，1禁用',
  `rec_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'A',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `sys_user_id` int NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 20 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_service_up_tip
-- ----------------------------

-- ----------------------------
-- Table structure for t_sn_code
-- ----------------------------
DROP TABLE IF EXISTS `t_sn_code`;
CREATE TABLE `t_sn_code`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `sn_code` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 821 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '相机sn记录表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_sn_code
-- ----------------------------

-- ----------------------------
-- Table structure for t_space_sdk
-- ----------------------------
DROP TABLE IF EXISTS `t_space_sdk`;
CREATE TABLE `t_space_sdk`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `version` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '版本',
  `imprint_ch` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '版本说明(中文)',
  `imprint_en` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '版本说明(英文)',
  `publish_time` datetime NULL DEFAULT NULL COMMENT '发布时间',
  `is_top` int NULL DEFAULT NULL COMMENT '是否置顶 1 -置顶  0-不置顶',
  `status` int NULL DEFAULT NULL COMMENT '状态 0 - 未发布 1 -发布  2-下架',
  `platform_type` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '1 : Unity  2： UE4',
  `file_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '文件名',
  `file_url` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '文件路径',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `rec_status` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT 'A' COMMENT '记录的状态，A: 生效，I: 禁用',
  `sys_user_id` int NULL DEFAULT NULL COMMENT '创建人id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 112 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = 'space sdk表' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of t_space_sdk
-- ----------------------------

-- ----------------------------
-- Table structure for t_surveillance
-- ----------------------------
DROP TABLE IF EXISTS `t_surveillance`;
CREATE TABLE `t_surveillance`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `num` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '场景码',
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '监控名称',
  `sid` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '监控唯一标识',
  `pano_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'ponoId',
  `data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '摄像头设置信息',
  `play_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '播放地址',
  `url_type` int NOT NULL DEFAULT 1 COMMENT '类型（1-监控，2-视频）',
  `poster` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '视频类型时，封面图文件名',
  `file_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '视频文件名',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `rec_status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'A',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `IDX_NUM_SID`(`num`, `sid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1154 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '监控推拉流信息' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_surveillance
-- ----------------------------

-- ----------------------------
-- Table structure for t_trade_log
-- ----------------------------
DROP TABLE IF EXISTS `t_trade_log`;
CREATE TABLE `t_trade_log`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `number` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '支付宝的交易号或者微信支付订单号',
  `order_sn` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '订单号',
  `amount` decimal(15, 2) NOT NULL COMMENT '付款金额',
  `trade_time` datetime NULL DEFAULT NULL COMMENT '交易时间',
  `pay_type` tinyint NULL DEFAULT -1 COMMENT '付款方式，0表示微信，1表示支付宝，2表示paypal，3表示其他',
  `pay_status` tinyint NULL DEFAULT 0 COMMENT '交易状态，0表示未付，1表示付款成功',
  `openid` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '微信的openid，paypal的email',
  `user_id` bigint NULL DEFAULT NULL COMMENT '用户表t_user的id',
  `abroad` tinyint NULL DEFAULT NULL COMMENT '0表示国内订单，1表示国外订单',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `rec_status` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '记录的状态，A: 生效，I: 禁用',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `order_sn`(`order_sn`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 120 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '交易成功记录表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_trade_log
-- ----------------------------

-- ----------------------------
-- Table structure for t_ucenter_system
-- ----------------------------
DROP TABLE IF EXISTS `t_ucenter_system`;
CREATE TABLE `t_ucenter_system`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `lang` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `rec_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'A',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_ucenter_system
-- ----------------------------

-- ----------------------------
-- Table structure for t_user
-- ----------------------------
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `head` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '头像对应的链接地址',
  `password` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '' COMMENT '用户密码',
  `email` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '用户邮箱',
  `register_time` datetime NULL DEFAULT NULL COMMENT '注册时间',
  `user_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '用户名',
  `nick_name` varchar(55) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '' COMMENT '昵称',
  `status` tinyint NULL DEFAULT 1 COMMENT '0表示禁言（bbs）',
  `is_notice` tinyint NULL DEFAULT 1 COMMENT '0表示拒绝通知，1表示接受通知',
  `organization_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '机构名称',
  `main_page` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '主页链接',
  `country` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '86' COMMENT '所在国家，默认是86',
  `province` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '所在省份',
  `city` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '所在城市',
  `download_num_total` int NULL DEFAULT 0 COMMENT '可下载场景总数',
  `download_num` int NULL DEFAULT 0 COMMENT '已下载场景总数',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `rec_status` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '记录的状态，A: 生效，I: 禁用',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `sys_user_id` int NULL DEFAULT NULL,
  `ss_download_num_total` int NULL DEFAULT 10 COMMENT '深时场景下载总次数',
  `ss_download_num` int NULL DEFAULT 0 COMMENT '深时场景已下载次数',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `user_name`(`user_name`) USING BTREE,
  INDEX `nick_name`(`nick_name`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 957 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '用户信息表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_user
-- ----------------------------
INSERT INTO `t_user` VALUES (226, 'http://scene3d.4dage.com/head.png', 'FFFFFFFFFF', NULL, '2018-10-12 11:31:11', '88888888888', '123131231231', 1, 1, NULL, NULL, '86', NULL, NULL, 1, 1, '2018-10-12 11:31:11', 'A', '2022-01-06 15:43:33', NULL, 10, 0);
INSERT INTO `t_user` VALUES (938, 'https://4dkk.4dage.com/newHead.png', ',EFG@ABCL', NULL, NULL, '13866666666', '13866666666', 1, 1, NULL, NULL, '86', NULL, NULL, 0, 0, '2024-07-25 15:07:33', 'A', '2024-07-25 15:07:33', NULL, 10, 0);
INSERT INTO `t_user` VALUES (939, 'https://4dkk.4dage.com/newHead.png', ',EFG@AB', NULL, NULL, '13888888888', '13888888888', 1, 1, NULL, NULL, '86', NULL, NULL, 0, 0, '2024-07-25 15:08:04', 'A', '2024-07-25 15:08:04', NULL, 10, 0);

-- ----------------------------
-- Table structure for t_user_increment
-- ----------------------------
DROP TABLE IF EXISTS `t_user_increment`;
CREATE TABLE `t_user_increment`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `key_word` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '权益包标识',
  `user_id` bigint NULL DEFAULT NULL COMMENT '用户表t_user的id',
  `camera_id` bigint NULL DEFAULT NULL COMMENT '相机主表t_camera的id',
  `increment_type_id` int NULL DEFAULT NULL COMMENT '会员权益类型Id',
  `increment_end_time` datetime NULL DEFAULT NULL COMMENT '结束时间',
  `is_expired` int NULL DEFAULT 0 COMMENT '是否过期（1过期，0未过期）',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `rec_status` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT 'A' COMMENT '记录的状态，A: 生效，I: 禁用',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `order_sn` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '扩容订单集合',
  `increment_start_time` datetime NULL DEFAULT NULL COMMENT '生效时间',
  `member_levels` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT 'PR' COMMENT '权益级别  PR 年会员  SE 月会员',
  `month_qy` tinyint NULL DEFAULT 1,
  `download_num` int NULL DEFAULT NULL,
  `agent_id` int NULL DEFAULT NULL COMMENT '代理商id',
  `subscription_order` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `IDX_CAMERAID`(`camera_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 23556 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '用户增值权益表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_user_increment
-- ----------------------------

-- ----------------------------
-- Table structure for t_user_role
-- ----------------------------
DROP TABLE IF EXISTS `t_user_role`;
CREATE TABLE `t_user_role`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `user_id` bigint NOT NULL COMMENT '用户表id',
  `role_id` bigint NOT NULL COMMENT '角色表id',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `rec_status` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '记录的状态，A: 生效，I: 禁用',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `role_id`(`role_id`) USING BTREE,
  INDEX `fk_user_id_1`(`user_id`) USING BTREE,
  CONSTRAINT `fk_role_id_2` FOREIGN KEY (`role_id`) REFERENCES `t_role` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `fk_user_id_1` FOREIGN KEY (`user_id`) REFERENCES `t_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '用户角色关系表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_user_role
-- ----------------------------

-- ----------------------------
-- Table structure for t_vaild_cameras
-- ----------------------------
DROP TABLE IF EXISTS `t_vaild_cameras`;
CREATE TABLE `t_vaild_cameras`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `company_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '公司名称',
  `file_path` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '相机文件地址',
  `wifi_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '文件名称',
  `devicemac` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '设备macId',
  `rec_status` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT 'A',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 23 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '代理商可用相机表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_vaild_cameras
-- ----------------------------

-- ----------------------------
-- Table structure for t_video_scene_progress
-- ----------------------------
DROP TABLE IF EXISTS `t_video_scene_progress`;
CREATE TABLE `t_video_scene_progress`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `scene_code` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '大场景序号',
  `rebuild_queue_start_time` datetime NULL DEFAULT NULL COMMENT '重算开始时间（进入队列）',
  `rebuild_start_time` datetime NULL DEFAULT NULL COMMENT '重算开始时间',
  `rebuild_end_time` datetime NULL DEFAULT NULL COMMENT '重算结束时间',
  `video_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '视频名称',
  `data_source` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '原场景路径',
  `rebuild_result` smallint NULL DEFAULT NULL COMMENT '重算结果  0:失败，1：成功 2：等待 3:重算中  9：成功且轮询过',
  `rebuild_param` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '重算参数',
  `hdr_param` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT 'videos_hdr_param 参数',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `rec_status` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '记录的状态，A: 生效，I: 禁用',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `is_delete` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `scene_code`(`scene_code`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 297 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '视频重算进度' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of t_video_scene_progress
-- ----------------------------

-- ----------------------------
-- Table structure for t_virtual_order
-- ----------------------------
DROP TABLE IF EXISTS `t_virtual_order`;
CREATE TABLE `t_virtual_order`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `order_sn` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '' COMMENT '订单号',
  `amount` decimal(15, 2) NOT NULL DEFAULT 0.00 COMMENT '金额',
  `points` int NOT NULL DEFAULT 0 COMMENT '点数',
  `number` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '' COMMENT '支付宝的交易号或者微信支付订单号',
  `pay_type` tinyint NOT NULL DEFAULT -1 COMMENT '付款方式，0表示微信，1表示支付宝，2表示paypal，3表示其他',
  `pay_status` tinyint NULL DEFAULT 0 COMMENT '状态，0或-1表示消费失败，1表示成功',
  `trade_time` datetime NULL DEFAULT NULL COMMENT '交易时间',
  `status` tinyint NULL DEFAULT NULL COMMENT '状态，-1表示支出，1表示充值，0表示系统赠送，-2表示系统退充值',
  `body` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '目的',
  `scene_num` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '场景序号',
  `user_id` bigint NULL DEFAULT NULL COMMENT '用户表t_user的id',
  `camera_id` bigint NULL DEFAULT NULL COMMENT '相机主表t_camera的id',
  `abroad` tinyint NULL DEFAULT NULL COMMENT '0表示国内订单，1表示国外订单',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `rec_status` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '记录的状态，A: 生效，I: 禁用',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `order_sn`(`order_sn`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6129 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '充值订单表（双目相机点数充值、消费）' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_virtual_order
-- ----------------------------

-- ----------------------------
-- Table structure for tm_increment_log
-- ----------------------------
DROP TABLE IF EXISTS `tm_increment_log`;
CREATE TABLE `tm_increment_log`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
  `user_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '用户名',
  `type` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '状态，1-下载，2-添加权益',
  `increment_num` int NULL DEFAULT NULL COMMENT '增加权益次数',
  `download_num` int NULL DEFAULT NULL COMMENT '增加下载次数',
  `increment_endtime` datetime NULL DEFAULT NULL COMMENT '新增会员权益结束时间',
  `scene_num` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '场景码',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `rec_status` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '记录的状态，A: 生效，I: 禁用',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `operate_uesr` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '操作人',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 31081 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of tm_increment_log
-- ----------------------------

-- ----------------------------
-- Triggers structure for table t_scene_plus
-- ----------------------------
DROP TRIGGER IF EXISTS `check_pro_num_repeat`;
delimiter ;;
CREATE TRIGGER `check_pro_num_repeat` BEFORE INSERT ON `t_scene_plus` FOR EACH ROW BEGIN
        declare pNum varchar(50);
        set pNum = (select num from `4dkankan_v4`.t_scene_pro where num = new.num and scene_name != new.title);
        if(pNum is not null) then
        insert into `4dkankan_v4`.t_scene_pro (num) value (new.num);
        end if;
    END
;;
delimiter ;

-- ----------------------------
-- Triggers structure for table t_scene_pro
-- ----------------------------
DROP TRIGGER IF EXISTS `num`;
delimiter ;;
CREATE TRIGGER `num` BEFORE INSERT ON `t_scene_pro` FOR EACH ROW BEGIN
        declare pNum varchar(50);
        set pNum = (select num from `4dkankan_v4`.t_scene_plus where num = new.num);
        if(pNum is not null) then
        insert into `4dkankan_v4`.t_scene_plus (num) value (new.num);
        end if;
    END
;;
delimiter ;

SET FOREIGN_KEY_CHECKS = 1;