Class BindCardTask

src/database/models.py:129–158

绑卡任务表

class BindCardTask(Base):
    """绑卡任务表"""
    __tablename__ = "bind_card_tasks"

    id = Column(Integer, primary_key=True, autoincrement=True)
    # 允许账号删除后保留任务记录：删除账号时将 account_id 置空，邮箱使用快照字段展示
    account_id = Column(Integer, ForeignKey("accounts.id", ondelete="SET NULL"), nullable=True, index=True)
    account_email = Column(String(255))  # 账号邮箱快照（历史记录展示用）
    plan_type = Column(String(20), nullable=False)  # plus / team
    workspace_name = Column(String(255))
    price_interval = Column(String(20))
    seat_quantity = Column(Integer)
    country = Column(String(10), default="US")
    currency = Column(String(10), default="USD")
    checkout_url = Column(Text, nullable=False)
    checkout_session_id = Column(String(120))
    publishable_key = Column(String(255))
    client_secret = Column(Text)
    checkout_source = Column(String(50))  # openai_checkout / aimizy_fallback
    bind_mode = Column(String(30), default="semi_auto")  # semi_auto / third_party / local_auto
    status = Column(String(20), default="link_ready")  # link_ready / opened / waiting_user_action / verifying / completed / failed
    last_error = Column(Text)
    opened_at = Column(DateTime)
    last_checked_at = Column(DateTime)
    completed_at = Column(DateTime)
    created_at = Column(DateTime, default=utcnow_naive)
    updated_at = Column(DateTime, default=utcnow_naive, onupdate=utcnow_naive)

    # 关系
    account = relationship("Account", back_populates="bind_card_tasks")


class AppLog(Base):