| 1234567891011121314151617181920212223242526272829 |
- """
- BUFF 扫货请求单表模型：用户每次发起扫货生成一条请求单，按 user_id 隔离。
- """
- from sqlalchemy import Column, BigInteger, Integer, String, DateTime, Boolean
- from app.database import Base
- from app.utils.timezone import beijing_now_naive
- class BuffSweepRequest(Base):
- """BUFF 扫货请求单表"""
- __tablename__ = "buff_sweep_request"
- id = Column(BigInteger, primary_key=True, autoincrement=True, comment="主键ID")
- user_id = Column(Integer, nullable=False, index=True, comment="用户ID，按用户隔离")
- selection_request_id = Column(
- BigInteger,
- nullable=False,
- index=True,
- comment="本次扫货基于的选品请求单ID（最新一次）",
- )
- status = Column(
- String(20),
- nullable=False,
- default="pending",
- comment="状态：pending/running/completed/failed/cancelled",
- )
- cancel_requested = Column(Boolean, nullable=False, default=False, comment="是否已请求停止")
- created_at = Column(DateTime, default=beijing_now_naive, comment="创建时间")
- updated_at = Column(DateTime, default=beijing_now_naive, onupdate=beijing_now_naive, comment="更新时间")
|
