| 12345678910111213141516171819202122232425 |
- """
- 找回密码工单模型
- """
- from datetime import datetime
- from sqlalchemy import Column, Integer, String, DateTime, ForeignKey
- from app.database import Base
- from app.utils.timezone import beijing_now_naive
- class PasswordResetRequest(Base):
- """找回密码工单表"""
- __tablename__ = "password_reset_requests"
- id = Column(Integer, primary_key=True, autoincrement=True, comment="主键ID")
- user_id = Column(Integer, ForeignKey("users.id"), nullable=False, comment="用户ID")
- username = Column(String(100), nullable=False, comment="用户名")
- email = Column(String(255), nullable=False, comment="用户邮箱")
- status = Column(String(20), nullable=False, default="pending",
- comment="状态: pending-待处理, processing-处理中, sent-已发送, failed-失败")
- error_message = Column(String(500), nullable=True, comment="失败时错误信息")
- created_at = Column(DateTime, default=beijing_now_naive, nullable=False, comment="申请时间")
- processed_at = Column(DateTime, nullable=True, comment="处理完成时间")
- def __repr__(self):
- return f"<PasswordResetRequest(id={self.id}, username='{self.username}', status='{self.status}')>"
|
