emails.py 1.4 KB

1234567891011121314151617181920212223242526272829303132
  1. from sqlalchemy import Column, BigInteger, String, Text, TIMESTAMP
  2. from sqlalchemy.sql import func
  3. from app.core.database import Base
  4. class VasEmail(Base):
  5. __tablename__ = "emails"
  6. __ddl__ = """
  7. CREATE TABLE IF NOT EXISTS `emails` (
  8. `uid` BIGINT NOT NULL COMMENT '邮件UID',
  9. `subject` VARCHAR(1024) NULL COMMENT '邮件标题',
  10. `sender` VARCHAR(255) NULL COMMENT '发件人',
  11. `recipient` VARCHAR(500) NULL COMMENT '收件人(别名)',
  12. `receive_time` VARCHAR(100) NULL COMMENT '接收时间字符串',
  13. `body_text` LONGTEXT NULL COMMENT '邮件正文',
  14. `created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '入库时间',
  15. PRIMARY KEY (`uid`),
  16. KEY `idx_emails_recipient` (`recipient`)
  17. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='邮箱抓取原始邮件存证表';
  18. """
  19. uid = Column(BigInteger, primary_key=True, comment="邮件UID")
  20. subject = Column(String(1024), comment="邮件标题")
  21. sender = Column(String(255), comment="发件人")
  22. recipient = Column(String(500), comment="收件人(别名)")
  23. receive_time = Column(String(100), comment="接收时间字符串")
  24. body_text = Column(Text, comment="邮件正文")
  25. created_at = Column(
  26. TIMESTAMP,
  27. server_default=func.current_timestamp(),
  28. comment="入库时间"
  29. )