from sqlalchemy import Column, BigInteger, String, Text, TIMESTAMP from sqlalchemy.sql import func from app.core.database import Base class VasEmail(Base): __tablename__ = "emails" __ddl__ = """ CREATE TABLE IF NOT EXISTS `emails` ( `uid` BIGINT NOT NULL COMMENT '邮件UID', `subject` VARCHAR(1024) NULL COMMENT '邮件标题', `sender` VARCHAR(255) NULL COMMENT '发件人', `recipient` VARCHAR(500) NULL COMMENT '收件人(别名)', `receive_time` VARCHAR(100) NULL COMMENT '接收时间字符串', `body_text` LONGTEXT NULL COMMENT '邮件正文', `created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '入库时间', PRIMARY KEY (`uid`), KEY `idx_emails_recipient` (`recipient`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='邮箱抓取原始邮件存证表'; """ 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="入库时间" )