buff_goods_info.py 731 B

12345678910111213141516
  1. """
  2. BUFF 饰品信息表模型(仅读:用于获取 steam_url 等信息)
  3. """
  4. from sqlalchemy import Column, BigInteger, String
  5. from app.database import Base
  6. class BuffGoodsInfo(Base):
  7. """BUFF 饰品信息表,关联 buff_goods_info 表"""
  8. __tablename__ = "buff_goods_info"
  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. buff_url = Column(String(512), nullable=True, default=None, comment="BUFF饰品链接")
  13. steam_url = Column(String(512), nullable=True, default=None, comment="饰品STEAM链接")