buff3.0/buff-api-bak/buff_tables.sql

-- ============================================================
-- BUFF饰品数据存储表 - MySQL 5.7
-- 创建时间: 2026-01-28
-- ============================================================

-- 设置字符集和存储引擎
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ============================================================
-- 1. 饰品总表
-- ============================================================
DROP TABLE IF EXISTS `buff_goods_info`;
CREATE TABLE `buff_goods_info` (
    `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增ID',
    `goods_id` VARCHAR(64) NOT NULL COMMENT 'BUFF饰品ID',
    `name` VARCHAR(255) NOT NULL COMMENT '饰品名称',
    `buff_url` VARCHAR(512) DEFAULT NULL COMMENT 'BUFF饰品链接',
    `min_price` DECIMAL(12,2) UNSIGNED DEFAULT 0.00 COMMENT '当前在售最低价格',
    `d7_avg_min_price` DECIMAL(12,2) UNSIGNED DEFAULT 0.00 COMMENT '7天在售最低价格平均价',
    `d30_avg_min_price` DECIMAL(12,2) UNSIGNED DEFAULT 0.00 COMMENT '30天在售最低价格平均价',
    `buy_max_price` DECIMAL(12,2) UNSIGNED DEFAULT 0.00 COMMENT '求购最高价格',
    `steam_url` VARCHAR(512) DEFAULT NULL COMMENT '饰品STEAM链接',
    `stat_time` DATETIME DEFAULT NULL COMMENT '统计时间',
    `create_time` DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_time` DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    PRIMARY KEY (`id`),
    KEY `uk_goods_id` (`goods_id`),
    KEY `idx_name` (`name`(100)),
    KEY `idx_stat_time` (`stat_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='BUFF饰品总表';

-- ============================================================
-- 2. 饰品总表中间表
-- ============================================================
DROP TABLE IF EXISTS `buff_goods_info_middle`;
CREATE TABLE `buff_goods_info_middle` (
    `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增ID',
    `goods_id` VARCHAR(64) NOT NULL COMMENT 'BUFF饰品ID',
    `name` VARCHAR(255) NOT NULL COMMENT '饰品名称',
    `buff_url` VARCHAR(512) DEFAULT NULL COMMENT 'BUFF饰品链接',
    `min_price` DECIMAL(12,2) UNSIGNED DEFAULT 0.00 COMMENT '当前在售最低价格',
    `d7_avg_min_price` DECIMAL(12,2) UNSIGNED DEFAULT 0.00 COMMENT '7天在售最低价格平均价',
    `d30_avg_min_price` DECIMAL(12,2) UNSIGNED DEFAULT 0.00 COMMENT '30天在售最低价格平均价',
    `buy_max_price` DECIMAL(12,2) UNSIGNED DEFAULT 0.00 COMMENT '求购最高价格',
    `steam_url` VARCHAR(512) DEFAULT NULL COMMENT '饰品STEAM链接',
    `stat_time` DATETIME DEFAULT NULL COMMENT '统计时间',
    `create_time` DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    PRIMARY KEY (`id`),
    KEY `idx_goods_id` (`goods_id`),
    KEY `idx_name` (`name`(100)),
    KEY `idx_stat_time` (`stat_time`),
    KEY `idx_create_time` (`create_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='BUFF饰品总表中间表';

DROP TABLE IF EXISTS `buff_goods_attr`;
CREATE TABLE `buff_goods_attr` (
    `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增ID',
    `goods_id` VARCHAR(64) NOT NULL COMMENT 'BUFF饰品ID',
    `name` VARCHAR(255) NOT NULL COMMENT '饰品名称',
    `icon_url` VARCHAR(512) DEFAULT NULL COMMENT '饰品图片URL地址',
    `type` VARCHAR(64) DEFAULT NULL COMMENT '类型',
    `type_name` VARCHAR(128) DEFAULT NULL COMMENT '类型中文名称',
    `category` VARCHAR(64) DEFAULT NULL COMMENT '分类',
    `category_name` VARCHAR(128) DEFAULT NULL COMMENT '分类中文名称',
    `category_group` VARCHAR(64) DEFAULT NULL COMMENT '分类组',
    `category_group_name` VARCHAR(128) DEFAULT NULL COMMENT '分类组中文名称',
    `rarity` VARCHAR(64) DEFAULT NULL COMMENT '品质',
    `rarity_name` VARCHAR(128) DEFAULT NULL COMMENT '品质中文名称',
    `quality` VARCHAR(64) DEFAULT NULL COMMENT '类别',
    `quality_name` VARCHAR(128) DEFAULT NULL COMMENT '类别中文名称',
    `exterior` VARCHAR(64) DEFAULT NULL COMMENT '外观',
    `exterior_name` VARCHAR(128) DEFAULT NULL COMMENT '外观中文名称',
    `weapon` VARCHAR(64) DEFAULT NULL COMMENT '武器',
    `weapon_name` VARCHAR(128) DEFAULT NULL COMMENT '武器中文名称',
    `series` VARCHAR(128) DEFAULT NULL COMMENT '热门皮肤',
    `series_name` VARCHAR(256) DEFAULT NULL COMMENT '热门皮肤中文名称',
    `custom` VARCHAR(64) DEFAULT NULL COMMENT '颜色',
    `custom_name` VARCHAR(128) DEFAULT NULL COMMENT '颜色中文名称',
    `itemset` VARCHAR(128) DEFAULT NULL COMMENT '收藏品',
    `itemset_name` VARCHAR(256) DEFAULT NULL COMMENT '收藏品中文名称',
    `extra_tag_ids` VARCHAR(256) DEFAULT NULL COMMENT '已贴印花',
    `extra_tag_ids_name` VARCHAR(512) DEFAULT NULL COMMENT '已贴印花中文名称',
    `custom_patch` VARCHAR(128) DEFAULT NULL COMMENT '已贴布章',
    `custom_patch_name` VARCHAR(256) DEFAULT NULL COMMENT '已贴布章中文名称',
    `custom_charm` VARCHAR(128) DEFAULT NULL COMMENT '已装挂件',
    `custom_charm_name` VARCHAR(256) DEFAULT NULL COMMENT '已装挂件中文名称',
    `stat_time` DATETIME DEFAULT NULL COMMENT '统计时间',
    `create_time` DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_time` DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    PRIMARY KEY (`id`),
    KEY `uk_goods_id` (`goods_id`),
    KEY `idx_name` (`name`(100)),
    KEY `idx_stat_time` (`stat_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='BUFF饰品属性表';

-- ============================================================
-- 2. BUFF饰品属性表中间表
-- ============================================================
DROP TABLE IF EXISTS `buff_goods_attr_middle`;
CREATE TABLE `buff_goods_attr_middle` (
    `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增ID',
    `goods_id` VARCHAR(64) NOT NULL COMMENT 'BUFF饰品ID',
    `name` VARCHAR(255) NOT NULL COMMENT '饰品名称',
    `icon_url` VARCHAR(512) DEFAULT NULL COMMENT '饰品图片URL地址',
    `type` VARCHAR(64) DEFAULT NULL COMMENT '类型',
    `type_name` VARCHAR(128) DEFAULT NULL COMMENT '类型中文名称',
    `category` VARCHAR(64) DEFAULT NULL COMMENT '分类',
    `category_name` VARCHAR(128) DEFAULT NULL COMMENT '分类中文名称',
    `category_group` VARCHAR(64) DEFAULT NULL COMMENT '分类组',
    `category_group_name` VARCHAR(128) DEFAULT NULL COMMENT '分类组中文名称',
    `rarity` VARCHAR(64) DEFAULT NULL COMMENT '品质',
    `rarity_name` VARCHAR(128) DEFAULT NULL COMMENT '品质中文名称',
    `quality` VARCHAR(64) DEFAULT NULL COMMENT '类别',
    `quality_name` VARCHAR(128) DEFAULT NULL COMMENT '类别中文名称',
    `exterior` VARCHAR(64) DEFAULT NULL COMMENT '外观',
    `exterior_name` VARCHAR(128) DEFAULT NULL COMMENT '外观中文名称',
    `weapon` VARCHAR(64) DEFAULT NULL COMMENT '武器',
    `weapon_name` VARCHAR(128) DEFAULT NULL COMMENT '武器中文名称',
    `series` VARCHAR(128) DEFAULT NULL COMMENT '热门皮肤',
    `series_name` VARCHAR(256) DEFAULT NULL COMMENT '热门皮肤中文名称',
    `custom` VARCHAR(64) DEFAULT NULL COMMENT '颜色',
    `custom_name` VARCHAR(128) DEFAULT NULL COMMENT '颜色中文名称',
    `itemset` VARCHAR(128) DEFAULT NULL COMMENT '收藏品',
    `itemset_name` VARCHAR(256) DEFAULT NULL COMMENT '收藏品中文名称',
    `extra_tag_ids` VARCHAR(256) DEFAULT NULL COMMENT '已贴印花',
    `extra_tag_ids_name` VARCHAR(512) DEFAULT NULL COMMENT '已贴印花中文名称',
    `custom_patch` VARCHAR(128) DEFAULT NULL COMMENT '已贴布章',
    `custom_patch_name` VARCHAR(256) DEFAULT NULL COMMENT '已贴布章中文名称',
    `custom_charm` VARCHAR(128) DEFAULT NULL COMMENT '已装挂件',
    `custom_charm_name` VARCHAR(256) DEFAULT NULL COMMENT '已装挂件中文名称',
    `stat_time` DATETIME DEFAULT NULL COMMENT '统计时间',
    `create_time` DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    PRIMARY KEY (`id`),
    KEY `idx_goods_id` (`goods_id`),
    KEY `idx_name` (`name`(100)),
    KEY `idx_stat_time` (`stat_time`),
    KEY `idx_create_time` (`create_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='BUFF饰品属性表中间表';

-- ============================================================
-- 3. 饰品每日销售价格表
-- ============================================================
DROP TABLE IF EXISTS `buff_goods_daily_price`;
CREATE TABLE `buff_goods_daily_price` (
    `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增ID',
    `goods_id` VARCHAR(64) NOT NULL COMMENT 'BUFF饰品ID',
    `name` VARCHAR(255) NOT NULL COMMENT '饰品名称',
    `min_price` DECIMAL(12,2) UNSIGNED DEFAULT 0.00 COMMENT '在售最低价格',
    `buy_max_price` DECIMAL(12,2) UNSIGNED DEFAULT 0.00 COMMENT '求购最高价格',
    `stat_time` DATETIME DEFAULT NULL COMMENT '统计时间',
    `create_time` DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_time` DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    PRIMARY KEY (`id`),
    KEY `uk_goods_id_stat_time` (`goods_id`, `stat_time`),
    KEY `idx_goods_id` (`goods_id`),
    KEY `idx_name` (`name`(100)),
    KEY `idx_stat_time` (`stat_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='BUFF饰品每日销售价格表';

-- ============================================================
-- 4. 饰品每日销售价格表中间表
-- ============================================================
DROP TABLE IF EXISTS `buff_goods_daily_price_middle`;
CREATE TABLE `buff_goods_daily_price_middle` (
    `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增ID',
    `goods_id` VARCHAR(64) NOT NULL COMMENT 'BUFF饰品ID',
    `name` VARCHAR(255) NOT NULL COMMENT '饰品名称',
    `min_price` DECIMAL(12,2) UNSIGNED DEFAULT 0.00 COMMENT '在售最低价格',
    `buy_max_price` DECIMAL(12,2) UNSIGNED DEFAULT 0.00 COMMENT '求购最高价格',
    `stat_time` DATETIME DEFAULT NULL COMMENT '统计时间',
    `create_time` DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    PRIMARY KEY (`id`),
    KEY `idx_goods_id` (`goods_id`),
    KEY `idx_name` (`name`(100)),
    KEY `idx_stat_time` (`stat_time`),
    KEY `idx_create_time` (`create_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='BUFF饰品每日销售价格表历史中间表';



DROP TABLE IF EXISTS `buff_goods_daily_tag_price`;
CREATE TABLE `buff_goods_daily_tag_price` (
    `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增ID',
    `goods_id` VARCHAR(64) NOT NULL COMMENT 'BUFF饰品ID',
    `name` VARCHAR(255) NOT NULL COMMENT '饰品名称',
    `min_price` DECIMAL(12,2) UNSIGNED DEFAULT 0.00 COMMENT '在售最低价格',
    `buy_max_price` DECIMAL(12,2) UNSIGNED DEFAULT 0.00 COMMENT '求购最高价格',
    `tag_id` VARCHAR(32) DEFAULT NULL COMMENT 'BUFF饰品款式ID',
    `tag_name` VARCHAR(128) DEFAULT NULL COMMENT 'BUFF饰品款式名称',
    `stat_time` DATETIME DEFAULT NULL COMMENT '统计时间',
    `create_time` DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_time` DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    PRIMARY KEY (`id`),
    KEY `uk_goods_id_stat_time` (`goods_id`, `stat_time`),
    KEY `idx_goods_id` (`goods_id`),
    KEY `idx_name` (`name`(100)),
    KEY `idx_stat_time` (`stat_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='BUFF饰品每日款式销售价格表';

-- ============================================================
-- 4. 饰品每日销售价格表中间表
-- ============================================================
DROP TABLE IF EXISTS `buff_goods_daily_tag_price_middle`;
CREATE TABLE `buff_goods_daily_tag_price_middle` (
    `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增ID',
    `goods_id` VARCHAR(64) NOT NULL COMMENT 'BUFF饰品ID',
    `name` VARCHAR(255) NOT NULL COMMENT '饰品名称',
    `min_price` DECIMAL(12,2) UNSIGNED DEFAULT 0.00 COMMENT '在售最低价格',
    `buy_max_price` DECIMAL(12,2) UNSIGNED DEFAULT 0.00 COMMENT '求购最高价格',
    `tag_id` VARCHAR(32) DEFAULT NULL COMMENT 'BUFF饰品款式ID',
    `tag_name` VARCHAR(128) DEFAULT NULL COMMENT 'BUFF饰品款式名称',
    `stat_time` DATETIME DEFAULT NULL COMMENT '统计时间',
    `create_time` DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    PRIMARY KEY (`id`),
    KEY `idx_goods_id` (`goods_id`),
    KEY `idx_name` (`name`(100)),
    KEY `idx_stat_time` (`stat_time`),
    KEY `idx_create_time` (`create_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='BUFF饰品每日款式销售价格表历史中间表';

-- ============================================================
-- 5. 饰品磨损区间价格表
-- ============================================================
DROP TABLE IF EXISTS `buff_goods_float_price`;
CREATE TABLE `buff_goods_float_price` (
    `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增ID',
    `goods_id` VARCHAR(64) NOT NULL COMMENT 'BUFF饰品ID',
    `name` VARCHAR(255) NOT NULL COMMENT '饰品名称',
    `qj_min_price` DECIMAL(12,2) UNSIGNED DEFAULT 0.00 COMMENT '区间底价',
    `qj_buy_max_price` DECIMAL(12,2) UNSIGNED DEFAULT 0.00 COMMENT '区间求购最高价',
    `qj_avg_min_price` DECIMAL(12,2) UNSIGNED DEFAULT 0.00 COMMENT '区间底价前十均价',
    `qj_sell_num` INT(11) UNSIGNED DEFAULT 0 COMMENT '区间在售数量',
    `qj_buy_order_num` INT(11) UNSIGNED DEFAULT 0 COMMENT '区间求购数量',
    `min_float` DECIMAL(10,6) UNSIGNED DEFAULT 0.000000 COMMENT '最小磨损值',
    `max_float` DECIMAL(10,6) UNSIGNED DEFAULT 0.000000 COMMENT '最大磨损值',
    `tag_id` VARCHAR(32) DEFAULT NULL COMMENT 'BUFF饰品款式ID',
    `tag_name` VARCHAR(128) DEFAULT NULL COMMENT 'BUFF饰品款式名称',
    `stat_time` DATETIME DEFAULT NULL COMMENT '统计时间',
    `create_time` DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_time` DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    PRIMARY KEY (`id`),
    KEY `uk_goods_id_tag_id_stat_time` (`goods_id`, `tag_id`, `stat_time`),
    KEY `idx_goods_id` (`goods_id`),
    KEY `idx_tag_id` (`tag_id`),
    KEY `idx_name` (`name`(100)),
    KEY `idx_stat_time` (`stat_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='BUFF饰品磨损区间价格表';

-- ============================================================
-- 6. 饰品磨损区间价格表中间表
-- ============================================================
DROP TABLE IF EXISTS `buff_goods_float_price_middle`;
CREATE TABLE `buff_goods_float_price_middle` (
    `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增ID',
    `goods_id` VARCHAR(64) NOT NULL COMMENT 'BUFF饰品ID',
    `name` VARCHAR(255) NOT NULL COMMENT '饰品名称',
    `qj_min_price` DECIMAL(12,2) UNSIGNED DEFAULT 0.00 COMMENT '区间底价',
    `qj_buy_max_price` DECIMAL(12,2) UNSIGNED DEFAULT 0.00 COMMENT '区间求购最高价',
    `qj_avg_min_price` DECIMAL(12,2) UNSIGNED DEFAULT 0.00 COMMENT '区间底价前十均价',
    `qj_sell_num` INT(11) UNSIGNED DEFAULT 0 COMMENT '区间在售数量',
    `qj_buy_order_num` INT(11) UNSIGNED DEFAULT 0 COMMENT '区间求购数量',
    `min_float` DECIMAL(10,6) UNSIGNED DEFAULT 0.000000 COMMENT '最小磨损值',
    `max_float` DECIMAL(10,6) UNSIGNED DEFAULT 0.000000 COMMENT '最大磨损值',
    `tag_id` VARCHAR(32) DEFAULT NULL COMMENT 'BUFF饰品款式ID',
    `tag_name` VARCHAR(128) DEFAULT NULL COMMENT 'BUFF饰品款式名称',
    `stat_time` DATETIME DEFAULT NULL COMMENT '统计时间',
    `create_time` DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    PRIMARY KEY (`id`),
    KEY `idx_goods_id` (`goods_id`),
    KEY `idx_tag_id` (`tag_id`),
    KEY `idx_name` (`name`(100)),
    KEY `idx_stat_time` (`stat_time`),
    KEY `idx_create_time` (`create_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='BUFF饰品磨损区间价格表中间表';


-- ============================================================
-- 5. 饰品磨损区间价格表
-- ============================================================
DROP TABLE IF EXISTS `buff_goods_float_price_attr`;
CREATE TABLE `buff_goods_float_price_attr` (
    `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增ID',
    `goods_id` VARCHAR(64) NOT NULL COMMENT 'BUFF饰品ID',
    `name` VARCHAR(255) NOT NULL COMMENT '饰品名称',
    `qj_min_price` DECIMAL(12,2) UNSIGNED DEFAULT 0.00 COMMENT '底价',
    `qj_buy_max_price` DECIMAL(12,2) UNSIGNED DEFAULT 0.00 COMMENT '求购最高价',
    `qj_avg_min_price` DECIMAL(12,2) UNSIGNED DEFAULT 0.00 COMMENT '底价前十均价',
    `qj_sell_num` INT(11) UNSIGNED DEFAULT 0 COMMENT '在售数量',
    `qj_buy_order_num` INT(11) UNSIGNED DEFAULT 0 COMMENT '求购数量',
    `stat_time` DATETIME DEFAULT NULL COMMENT '统计时间',
    `create_time` DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_time` DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    PRIMARY KEY (`id`),
    KEY `uk_goods_id_tag_id_stat_time` (`goods_id`, `stat_time`),
    KEY `idx_goods_id` (`goods_id`),
    KEY `idx_name` (`name`(100)),
    KEY `idx_stat_time` (`stat_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='BUFF饰品磨损区间价格属性表';

-- ============================================================
-- 6. 饰品磨损区间价格表中间表
-- ============================================================
DROP TABLE IF EXISTS `buff_goods_float_price_attr_middle`;
CREATE TABLE `buff_goods_float_price_attr_middle` (
    `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增ID',
    `goods_id` VARCHAR(64) NOT NULL COMMENT 'BUFF饰品ID',
    `name` VARCHAR(255) NOT NULL COMMENT '饰品名称',
    `qj_min_price` DECIMAL(12,2) UNSIGNED DEFAULT 0.00 COMMENT '底价',
    `qj_buy_max_price` DECIMAL(12,2) UNSIGNED DEFAULT 0.00 COMMENT '求购最高价',
    `qj_avg_min_price` DECIMAL(12,2) UNSIGNED DEFAULT 0.00 COMMENT '底价前十均价',
    `qj_sell_num` INT(11) UNSIGNED DEFAULT 0 COMMENT '在售数量',
    `qj_buy_order_num` INT(11) UNSIGNED DEFAULT 0 COMMENT '求购数量',
    `stat_time` DATETIME DEFAULT NULL COMMENT '统计时间',
    `create_time` DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    PRIMARY KEY (`id`),
    KEY `idx_goods_id` (`goods_id`),
    KEY `idx_name` (`name`(100)),
    KEY `idx_stat_time` (`stat_time`),
    KEY `idx_create_time` (`create_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='BUFF饰品磨损区间价格属性表中间表';

-- ============================================================
-- 7. 饰品流动性表
-- ============================================================
DROP TABLE IF EXISTS `buff_goods_liquidity`;
CREATE TABLE `buff_goods_liquidity` (
    `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增ID',
    `goods_id` VARCHAR(64) NOT NULL COMMENT 'BUFF饰品ID',
    `name` VARCHAR(255) NOT NULL COMMENT '饰品名称',
    `tag_id` VARCHAR(32) DEFAULT NULL COMMENT 'BUFF饰品款式ID',
    `tag_name` VARCHAR(128) DEFAULT NULL COMMENT 'BUFF饰品款式名称',
    `liquidity_rank` VARCHAR(16) DEFAULT NULL COMMENT '饰品流通性等级',
    `stat_time` DATETIME DEFAULT NULL COMMENT '统计时间',
    `create_time` DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_time` DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    PRIMARY KEY (`id`),
    KEY `uk_goods_id_tag_id_stat_time` (`goods_id`, `tag_id`, `stat_time`),
    KEY `idx_goods_id` (`goods_id`),
    KEY `idx_tag_id` (`tag_id`),
    KEY `idx_name` (`name`(100)),
    KEY `idx_liquidity_rank` (`liquidity_rank`),
    KEY `idx_stat_time` (`stat_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='BUFF饰品流动性表';

-- ============================================================
-- 8. 饰品流动性表中间表
-- ============================================================
DROP TABLE IF EXISTS `buff_goods_liquidity_middle`;
CREATE TABLE `buff_goods_liquidity_middle` (
    `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增ID',
    `goods_id` VARCHAR(64) NOT NULL COMMENT 'BUFF饰品ID',
    `name` VARCHAR(255) NOT NULL COMMENT '饰品名称',
    `tag_id` VARCHAR(32) DEFAULT NULL COMMENT 'BUFF饰品款式ID',
    `tag_name` VARCHAR(128) DEFAULT NULL COMMENT 'BUFF饰品款式名称',
    `liquidity_rank` VARCHAR(16) DEFAULT NULL COMMENT '饰品流通性等级',
    `stat_time` DATETIME DEFAULT NULL COMMENT '统计时间',
    `create_time` DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    PRIMARY KEY (`id`),
    KEY `idx_goods_id` (`goods_id`),
    KEY `idx_tag_id` (`tag_id`),
    KEY `idx_name` (`name`(100)),
    KEY `idx_liquidity_rank` (`liquidity_rank`),
    KEY `idx_stat_time` (`stat_time`),
    KEY `idx_create_time` (`create_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='BUFF饰品流动性表历史中间表';

SET FOREIGN_KEY_CHECKS = 1;