"""
BUFF 饰品信息表模型（仅读：用于获取 steam_url 等信息）
"""
from sqlalchemy import Column, BigInteger, String
from app.database import Base


class BuffGoodsInfo(Base):
    """BUFF 饰品信息表，关联 buff_goods_info 表"""
    __tablename__ = "buff_goods_info"

    id = Column(BigInteger, primary_key=True, autoincrement=True, comment="自增ID")
    goods_id = Column(String(64), nullable=False, index=True, comment="BUFF饰品ID")
    name = Column(String(255), nullable=False, default="", comment="饰品名称")
    buff_url = Column(String(512), nullable=True, default=None, comment="BUFF饰品链接")
    steam_url = Column(String(512), nullable=True, default=None, comment="饰品STEAM链接")