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;