261 lines
17 KiB
SQL
261 lines
17 KiB
SQL
/*
|
||
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;
|