| 123456789101112131415161718192021222324252627 |
- """
- BUFF 扫货请求单-扫货成功明细模型：每条记录为一次成功扫货结果，按 user_id 隔离。
- """
- from sqlalchemy import Column, BigInteger, Integer, String, DateTime, Numeric
- from app.database import Base
- from app.utils.timezone import beijing_now_naive
- class BuffSweepRequestItem(Base):
- """BUFF 扫货请求单-扫货成功明细表"""
- __tablename__ = "buff_sweep_request_item"
- id = Column(BigInteger, primary_key=True, autoincrement=True, comment="主键ID")
- sweep_request_id = Column(BigInteger, nullable=False, index=True, comment="扫货请求单ID")
- user_id = Column(Integer, nullable=False, index=True, comment="用户ID，按用户隔离")
- selection_request_id = Column(BigInteger, nullable=False, index=True, comment="选品请求单ID")
- selection_item_id = Column(BigInteger, nullable=False, index=True, comment="选品明细ID")
- goods_id = Column(String(64), nullable=False, index=True, comment="BUFF饰品ID")
- goods_name = Column(String(256), nullable=True, comment="饰品名称")
- icon_url = Column(String(512), nullable=True, comment="饰品图片URL")
- wear_range = Column(String(64), nullable=True, comment="磨损区间")
- purchase_wear = Column(Numeric(20, 18), nullable=True, comment="已购饰品磨损值")
- target_price_usd = Column(Numeric(12, 2), nullable=True, comment="目标扫货价（美元）")
- purchase_price_usd = Column(Numeric(12, 2), nullable=True, comment="实际购买价（美元）")
- purchase_price_cny = Column(Numeric(12, 2), nullable=True, comment="实际购买价（人民币）")
- steam_account = Column(String(128), nullable=True, comment="购买使用的Steam账号")
- created_at = Column(DateTime, default=beijing_now_naive, comment="创建时间")
|
