order_event.py 1.2 KB

123456789101112131415161718192021222324252627
  1. from sqlalchemy import Column, BigInteger, String, Text, DateTime, func
  2. from app.core.database import Base
  3. class VasOrderEvent(Base):
  4. __tablename__ = "vas_order_events"
  5. __ddl__ = """
  6. CREATE TABLE IF NOT EXISTS `vas_order_events` (
  7. `id` BIGINT NOT NULL AUTO_INCREMENT,
  8. `order_no` VARCHAR(100) NOT NULL,
  9. `event_title` VARCHAR(255) NOT NULL,
  10. `event_message` TEXT NULL,
  11. `email_uid` BIGINT NOT NULL,
  12. `event_time` DATETIME NULL,
  13. `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  14. PRIMARY KEY (`id`),
  15. UNIQUE KEY `uq_vas_order_events_email_uid` (`email_uid`),
  16. KEY `idx_vas_order_events_order_no` (`order_no`)
  17. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='订单邮箱与外部追踪事件表';
  18. """
  19. id = Column(BigInteger, primary_key=True, autoincrement=True)
  20. order_no = Column(String(100), nullable=False)
  21. event_title = Column(String(255), nullable=False)
  22. event_message = Column(Text)
  23. email_uid = Column(BigInteger, nullable=False, unique=True)
  24. event_time = Column(DateTime)
  25. created_at = Column(DateTime, nullable=False, server_default=func.now())