from sqlalchemy import Column, BigInteger, String, Text, DateTime, func from app.core.database import Base class VasOrderEvent(Base): __tablename__ = "vas_order_events" __ddl__ = """ CREATE TABLE IF NOT EXISTS `vas_order_events` ( `id` BIGINT NOT NULL AUTO_INCREMENT, `order_no` VARCHAR(100) NOT NULL, `event_title` VARCHAR(255) NOT NULL, `event_message` TEXT NULL, `email_uid` BIGINT NOT NULL, `event_time` DATETIME NULL, `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `uq_vas_order_events_email_uid` (`email_uid`), KEY `idx_vas_order_events_order_no` (`order_no`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='订单邮箱与外部追踪事件表'; """ id = Column(BigInteger, primary_key=True, autoincrement=True) order_no = Column(String(100), nullable=False) event_title = Column(String(255), nullable=False) event_message = Column(Text) email_uid = Column(BigInteger, nullable=False, unique=True) event_time = Column(DateTime) created_at = Column(DateTime, nullable=False, server_default=func.now())