webapp/app/models/email_authorizations.py

from sqlalchemy import Column, Integer, String, TIMESTAMP, func
from app.core.database import Base


class EmailAuthorization(Base):
    __tablename__ = "email_authorizations"

    id = Column(Integer, primary_key=True, autoincrement=True)
    email = Column(String(255), unique=True, nullable=False, comment="邮箱地址")
    authorization_code = Column(String(255), nullable=False, comment="授权码")
    imap_server = Column(String(255), nullable=True, comment="IMAP服务器地址")
    imap_port = Column(Integer, default=993, comment="IMAP端口")
    smtp_server = Column(String(255), nullable=True, comment="SMTP服务器地址")
    smtp_port = Column(Integer, default=465, comment="SMTP端口")
    proxy_host = Column(String(255), nullable=True, comment="代理主机")
    proxy_port = Column(Integer, default=0, comment="代理端口")
    proxy_username = Column(String(255), nullable=True, comment="代理用户名")
    proxy_password = Column(String(255), nullable=True, comment="代理密码")
    created_at = Column(TIMESTAMP, server_default=func.now(), comment="创建时间")
    updated_at = Column(TIMESTAMP, server_default=func.now(), onupdate=func.now(), comment="更新时间")