"""
BUFF 饰品属性表模型（仅读：用于选品页根据 goods_id 展示商品头像、名称）
"""
from sqlalchemy import Column, BigInteger, String
from app.database import Base


class BuffGoodsAttr(Base):
    """BUFF 饰品属性表，关联 buff_goods_attr 表"""
    __tablename__ = "buff_goods_attr"

    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="饰品名称")
    icon_url = Column(String(512), nullable=True, default=None, comment="饰品图片URL")