261 lines
17 KiB
MySQL
261 lines
17 KiB
MySQL
|
|
/*
|
|||
|
|
Navicat Premium Dump SQL
|
|||
|
|
|
|||
|
|
Source Server : blv-rd.tech
|
|||
|
|
Source Server Type : MySQL
|
|||
|
|
Source Server Version : 80040 (8.0.40)
|
|||
|
|
Source Host : 10.8.8.212:16036
|
|||
|
|
Source Schema : cdr_library
|
|||
|
|
|
|||
|
|
Target Server Type : MySQL
|
|||
|
|
Target Server Version : 80040 (8.0.40)
|
|||
|
|
File Encoding : 65001
|
|||
|
|
|
|||
|
|
Date: 09/12/2025 09:41:14
|
|||
|
|
*/
|
|||
|
|
|
|||
|
|
SET NAMES utf8mb4;
|
|||
|
|
SET FOREIGN_KEY_CHECKS = 0;
|
|||
|
|
|
|||
|
|
-- ----------------------------
|
|||
|
|
-- Table structure for tbl_cdr_file
|
|||
|
|
-- ----------------------------
|
|||
|
|
DROP TABLE IF EXISTS `tbl_cdr_file`;
|
|||
|
|
CREATE TABLE `tbl_cdr_file` (
|
|||
|
|
`ID` int NOT NULL AUTO_INCREMENT,
|
|||
|
|
`Series` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '系列名称',
|
|||
|
|
`FileName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '文件名',
|
|||
|
|
`Version` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '版本',
|
|||
|
|
`Remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
|||
|
|
`User` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '上传用户',
|
|||
|
|
`UpdateTime` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '上传时间',
|
|||
|
|
`PreviewPath` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '预览路径',
|
|||
|
|
`Active` int NULL DEFAULT 1 COMMENT '启用状态1启用,0禁用',
|
|||
|
|
`Company` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '公司名称',
|
|||
|
|
PRIMARY KEY (`ID`) USING BTREE
|
|||
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 124 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
|||
|
|
|
|||
|
|
-- ----------------------------
|
|||
|
|
-- Table structure for tbl_font
|
|||
|
|
-- ----------------------------
|
|||
|
|
DROP TABLE IF EXISTS `tbl_font`;
|
|||
|
|
CREATE TABLE `tbl_font` (
|
|||
|
|
`ID` int NOT NULL AUTO_INCREMENT,
|
|||
|
|
`FontName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '字體名稱',
|
|||
|
|
`UserName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '上傳者',
|
|||
|
|
`UploadTime` datetime NULL DEFAULT NULL COMMENT '上傳時間',
|
|||
|
|
`Remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '備注',
|
|||
|
|
PRIMARY KEY (`ID`) USING BTREE
|
|||
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
|||
|
|
|
|||
|
|
-- ----------------------------
|
|||
|
|
-- Table structure for tbl_iconlibrary
|
|||
|
|
-- ----------------------------
|
|||
|
|
DROP TABLE IF EXISTS `tbl_iconlibrary`;
|
|||
|
|
CREATE TABLE `tbl_iconlibrary` (
|
|||
|
|
`ID` int NOT NULL AUTO_INCREMENT,
|
|||
|
|
`FID` int NULL DEFAULT NULL COMMENT 'cdr_file_id',
|
|||
|
|
`IconType` int NULL DEFAULT NULL COMMENT '素材类型(1 Icon 2 Txt 3 TxtEn 4 Logo)',
|
|||
|
|
`KeyName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '素材名称',
|
|||
|
|
`ShapeNumber` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '位置信息',
|
|||
|
|
`Remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注',
|
|||
|
|
`PreviewPath` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '预览路径',
|
|||
|
|
`NameCN` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '中文名',
|
|||
|
|
`NameEn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '英文名',
|
|||
|
|
PRIMARY KEY (`ID`) USING BTREE
|
|||
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 1901 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;
|
|||
|
|
|
|||
|
|
-- ----------------------------
|
|||
|
|
-- Table structure for tbl_location
|
|||
|
|
-- ----------------------------
|
|||
|
|
DROP TABLE IF EXISTS `tbl_location`;
|
|||
|
|
CREATE TABLE `tbl_location` (
|
|||
|
|
`ID` int NOT NULL AUTO_INCREMENT,
|
|||
|
|
`PID` int NULL DEFAULT NULL COMMENT 'pattern_id',
|
|||
|
|
`LocationName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '名称',
|
|||
|
|
`Type` int NULL DEFAULT NULL COMMENT '类型',
|
|||
|
|
`SizeH` double NULL DEFAULT NULL COMMENT '高度',
|
|||
|
|
`SizeW` double NULL DEFAULT NULL COMMENT '宽度',
|
|||
|
|
`IndexNum` int NULL DEFAULT NULL COMMENT '相对位置',
|
|||
|
|
`lineNumber` int NULL DEFAULT NULL COMMENT '行號',
|
|||
|
|
`Keygroup` int NULL DEFAULT NULL COMMENT '按键组号',
|
|||
|
|
PRIMARY KEY (`ID`) USING BTREE
|
|||
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 2495 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
|||
|
|
|
|||
|
|
-- ----------------------------
|
|||
|
|
-- Table structure for tbl_model
|
|||
|
|
-- ----------------------------
|
|||
|
|
DROP TABLE IF EXISTS `tbl_model`;
|
|||
|
|
CREATE TABLE `tbl_model` (
|
|||
|
|
`ID` int NOT NULL AUTO_INCREMENT,
|
|||
|
|
`FID` int NULL DEFAULT NULL COMMENT 'cdr_file_id',
|
|||
|
|
`ModelName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '模型名(几连体)',
|
|||
|
|
`Direction` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '方向',
|
|||
|
|
`SizeH` double NULL DEFAULT NULL COMMENT '高度',
|
|||
|
|
`SizeW` double NULL DEFAULT NULL COMMENT '宽度',
|
|||
|
|
`Color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '颜色',
|
|||
|
|
`PanelCount` int NULL DEFAULT NULL COMMENT '面板数',
|
|||
|
|
`ShapeNumber` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '位置信息',
|
|||
|
|
`PreviewPath` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '预览路径',
|
|||
|
|
`Remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注',
|
|||
|
|
`LOGO_L` int NULL DEFAULT NULL COMMENT '左下logo',
|
|||
|
|
`LOGO_R` int NULL DEFAULT NULL COMMENT '右下logo',
|
|||
|
|
`LOGO_L_W` int NULL DEFAULT NULL,
|
|||
|
|
`LOGO_L_H` int NULL DEFAULT NULL,
|
|||
|
|
`LOGO_R_W` int NULL DEFAULT NULL,
|
|||
|
|
`LOGO_R_H` int NULL DEFAULT NULL,
|
|||
|
|
PRIMARY KEY (`ID`) USING BTREE
|
|||
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 159 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
|||
|
|
|
|||
|
|
-- ----------------------------
|
|||
|
|
-- Table structure for tbl_pattern
|
|||
|
|
-- ----------------------------
|
|||
|
|
DROP TABLE IF EXISTS `tbl_pattern`;
|
|||
|
|
CREATE TABLE `tbl_pattern` (
|
|||
|
|
`ID` int NOT NULL AUTO_INCREMENT,
|
|||
|
|
`FID` int NULL DEFAULT NULL COMMENT 'cdr_file_id',
|
|||
|
|
`PatternName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '单体名称',
|
|||
|
|
`ShapeNumber` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '位置信息',
|
|||
|
|
`SizeH` double NULL DEFAULT NULL COMMENT '高度',
|
|||
|
|
`SizeW` double NULL DEFAULT NULL COMMENT '宽度',
|
|||
|
|
`PreviewPath` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '预览路径',
|
|||
|
|
`Remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注',
|
|||
|
|
PRIMARY KEY (`ID`) USING BTREE
|
|||
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 465 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
|||
|
|
|
|||
|
|
-- ----------------------------
|
|||
|
|
-- Table structure for tbl_trench
|
|||
|
|
-- ----------------------------
|
|||
|
|
DROP TABLE IF EXISTS `tbl_trench`;
|
|||
|
|
CREATE TABLE `tbl_trench` (
|
|||
|
|
`ID` int NOT NULL AUTO_INCREMENT,
|
|||
|
|
`MID` int NULL DEFAULT NULL,
|
|||
|
|
`TrenchName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
|||
|
|
`SizeW` double NULL DEFAULT NULL,
|
|||
|
|
`SizeH` double NULL DEFAULT NULL,
|
|||
|
|
`IndexNum` int NULL DEFAULT NULL,
|
|||
|
|
PRIMARY KEY (`ID`) USING BTREE
|
|||
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 285 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
|||
|
|
|
|||
|
|
-- ----------------------------
|
|||
|
|
-- Table structure for tbl_web_log
|
|||
|
|
-- ----------------------------
|
|||
|
|
DROP TABLE IF EXISTS `tbl_web_log`;
|
|||
|
|
CREATE TABLE `tbl_web_log` (
|
|||
|
|
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '日志ID',
|
|||
|
|
`username` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '用户名',
|
|||
|
|
`action_time` datetime(3) NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '操作时间',
|
|||
|
|
`action_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '行为:登录、切换酒店、编辑、保存、发布、登出、下载等',
|
|||
|
|
`hotel_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '操作时打开的酒店',
|
|||
|
|
`target_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '操作对象:面板组、面板',
|
|||
|
|
`method` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '操作方法:被调用的接口名称',
|
|||
|
|
`target_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '操作对象(如房型GUID、面板GUID等)',
|
|||
|
|
`operation` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '接口请求内容',
|
|||
|
|
`user_ip` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户IP地址',
|
|||
|
|
`user_location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户所在位置(通过IP解析)',
|
|||
|
|
`user_agent` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '用户浏览器信息',
|
|||
|
|
`is_valid` tinyint(1) NULL DEFAULT 1 COMMENT '有效状态:1=有效,0=删除',
|
|||
|
|
PRIMARY KEY (`id`) USING BTREE
|
|||
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '操作日志表' ROW_FORMAT = Dynamic;
|
|||
|
|
|
|||
|
|
-- ----------------------------
|
|||
|
|
-- Table structure for tbl_web_panel_list
|
|||
|
|
-- ----------------------------
|
|||
|
|
DROP TABLE IF EXISTS `tbl_web_panel_list`;
|
|||
|
|
CREATE TABLE `tbl_web_panel_list` (
|
|||
|
|
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '面板组ID',
|
|||
|
|
`panel_list_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '面板组名称',
|
|||
|
|
`gang_series` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '面板组系列',
|
|||
|
|
`model_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '面板类型(二联体 之类)',
|
|||
|
|
`panel_count` int NULL DEFAULT NULL COMMENT '面板数量',
|
|||
|
|
`gang_material_id` bigint NULL DEFAULT NULL COMMENT '面板组素材ID(关联tbl_dict_gang_panel.id)',
|
|||
|
|
`panel_info_json` json NULL COMMENT '面板单元GUID数组',
|
|||
|
|
`logo_json` json NULL,
|
|||
|
|
`cdr_filename` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '面板组CDR文件名',
|
|||
|
|
`thumbnail_large` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '大缩略图',
|
|||
|
|
`thumbnail_small` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '小缩略图',
|
|||
|
|
`erp_part_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'ERP料号',
|
|||
|
|
`remarks` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '备注说明',
|
|||
|
|
`created_at` datetime(3) NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '生成日期',
|
|||
|
|
`is_valid` tinyint(1) NULL DEFAULT 1 COMMENT '有效状态:1=有效,0=删除',
|
|||
|
|
`guid` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'GUID',
|
|||
|
|
`position` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '位置',
|
|||
|
|
`carving_quantity` int NULL DEFAULT NULL COMMENT '雕刻数量',
|
|||
|
|
`carving_filename` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '雕刻图',
|
|||
|
|
`design_status` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '设计状态',
|
|||
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|||
|
|
INDEX `GUID`(`guid` ASC) USING BTREE
|
|||
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 37 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '面板组列表' ROW_FORMAT = Dynamic;
|
|||
|
|
|
|||
|
|
-- ----------------------------
|
|||
|
|
-- Table structure for tbl_web_panel_unit
|
|||
|
|
-- ----------------------------
|
|||
|
|
DROP TABLE IF EXISTS `tbl_web_panel_unit`;
|
|||
|
|
CREATE TABLE `tbl_web_panel_unit` (
|
|||
|
|
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '单体面板ID',
|
|||
|
|
`panel_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '单体面板名称',
|
|||
|
|
`product_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '单体面板产品类型(从模型继承)',
|
|||
|
|
`element_count` int NULL DEFAULT 0 COMMENT '元素数量',
|
|||
|
|
`elements_json` json NULL COMMENT '元素数组(JSON格式)',
|
|||
|
|
`cdr_filename` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '单体面板CDR文件名',
|
|||
|
|
`thumbnail_large` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '大缩略图路径',
|
|||
|
|
`thumbnail_small` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '小缩略图路径',
|
|||
|
|
`remarks` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '备注说明',
|
|||
|
|
`erp_part_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'ERP料号',
|
|||
|
|
`design_status` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '设计状态',
|
|||
|
|
`owner` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '所有者(账户名)',
|
|||
|
|
`created_at` datetime(3) NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '生成日期',
|
|||
|
|
`published_at` datetime(3) NULL DEFAULT NULL COMMENT '发布日期',
|
|||
|
|
`share_type` enum('公共','私有','指定用户组','指定用户') CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '公共' COMMENT '分享类型',
|
|||
|
|
`series_id` int NULL DEFAULT NULL COMMENT '系列',
|
|||
|
|
`pattern_id` int NULL DEFAULT NULL COMMENT '面板类型',
|
|||
|
|
`direction` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '方向',
|
|||
|
|
`color` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '颜色',
|
|||
|
|
`is_valid` tinyint(1) NULL DEFAULT 1 COMMENT '有效状态:1=有效,0=删除',
|
|||
|
|
`guid` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'GUID',
|
|||
|
|
`project_guid` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '关联项目的GUID',
|
|||
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|||
|
|
INDEX `GUID`(`guid` ASC) USING BTREE,
|
|||
|
|
INDEX `idx_project_guid`(`project_guid` ASC) USING BTREE
|
|||
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 71 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '单体面板列表' ROW_FORMAT = Dynamic;
|
|||
|
|
|
|||
|
|
-- ----------------------------
|
|||
|
|
-- Table structure for tbl_web_project
|
|||
|
|
-- ----------------------------
|
|||
|
|
DROP TABLE IF EXISTS `tbl_web_project`;
|
|||
|
|
CREATE TABLE `tbl_web_project` (
|
|||
|
|
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '酒店项目ID',
|
|||
|
|
`report_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '报备ID(从报备平台装载)',
|
|||
|
|
`hotel_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '酒店名称',
|
|||
|
|
`room_type_count` int NULL DEFAULT 0 COMMENT '房型数量',
|
|||
|
|
`room_data_json` json NULL COMMENT '房型数据(JSON数组,包含房型ID等)',
|
|||
|
|
`remarks` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '备注说明',
|
|||
|
|
`creator` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '生成者',
|
|||
|
|
`created_at` datetime(3) NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '生成日期',
|
|||
|
|
`is_valid` tinyint(1) NULL DEFAULT 1 COMMENT '有效状态:1=有效,0=删除',
|
|||
|
|
`guid` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'GUID',
|
|||
|
|
`cdr_filename` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '酒店整体CDR路径',
|
|||
|
|
`edit_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '编辑状态',
|
|||
|
|
PRIMARY KEY (`id`) USING BTREE
|
|||
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 2913 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '酒店项目数据' ROW_FORMAT = Dynamic;
|
|||
|
|
|
|||
|
|
-- ----------------------------
|
|||
|
|
-- Table structure for tbl_web_room_type
|
|||
|
|
-- ----------------------------
|
|||
|
|
DROP TABLE IF EXISTS `tbl_web_room_type`;
|
|||
|
|
CREATE TABLE `tbl_web_room_type` (
|
|||
|
|
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '房型ID',
|
|||
|
|
`room_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '房型名称',
|
|||
|
|
`room_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '房型说明',
|
|||
|
|
`panel_group_count` varchar(225) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '0' COMMENT '面板组ID',
|
|||
|
|
`remarks` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '备注说明',
|
|||
|
|
`creator` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '生成者(账户名)',
|
|||
|
|
`created_at` datetime(3) NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '生成日期',
|
|||
|
|
`is_valid` tinyint(1) NULL DEFAULT 1 COMMENT '有效状态:1=有效,0=删除',
|
|||
|
|
`guid` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'GUID',
|
|||
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|||
|
|
INDEX `GUID`(`guid` ASC) USING BTREE
|
|||
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 75 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '房型数据表' ROW_FORMAT = Dynamic;
|
|||
|
|
|
|||
|
|
SET FOREIGN_KEY_CHECKS = 1;
|