| 123456789101112131415161718192021 |
- from sqlalchemy import Column, BigInteger, String, Text, TIMESTAMP
- from sqlalchemy.sql import func
- from sqlalchemy.ext.declarative import declarative_base
- Base = declarative_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="入库时间"
- )
|
