webapp/app/models/emails.py

from sqlalchemy import Column, BigInteger, String, Text, TIMESTAMP
from sqlalchemy.sql import func
from app.core.database import Base


class VasEmail(Base):
    __tablename__ = "emails"

    uid = Column(BigInteger, primary_key=True, comment="邮件UID")
    subject = Column(String(1024), comment="邮件标题")
    sender = Column(String(255), comment="发件人")
    recipient = Column(String(500), comment="收件人(别名)")
    receive_time = Column(String(100), comment="接收时间字符串")
    body_text = Column(Text, comment="邮件正文")
    created_at = Column(
        TIMESTAMP,
        server_default=func.current_timestamp(),
        comment="入库时间"
    )