buff_goods_attr.py 662 B

123456789101112131415
  1. """
  2. BUFF 饰品属性表模型(仅读:用于选品页根据 goods_id 展示商品头像、名称)
  3. """
  4. from sqlalchemy import Column, BigInteger, String
  5. from app.database import Base
  6. class BuffGoodsAttr(Base):
  7. """BUFF 饰品属性表,关联 buff_goods_attr 表"""
  8. __tablename__ = "buff_goods_attr"
  9. id = Column(BigInteger, primary_key=True, autoincrement=True, comment="主键ID")
  10. goods_id = Column(String(64), nullable=False, index=True, comment="BUFF饰品ID")
  11. name = Column(String(255), nullable=False, default="", comment="饰品名称")
  12. icon_url = Column(String(512), nullable=True, default=None, comment="饰品图片URL")