| 1234567891011121314151617181920212223242526272829303132 |
- 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="入库时间"
- )
|