from datetime import datetime from sqlalchemy import Column, Integer, String, DateTime, JSON from app.core.database import Base class NotificationOutbox(Base): __tablename__ = "notification_outbox" __ddl__ = """ CREATE TABLE IF NOT EXISTS `notification_outbox` ( `id` INT NOT NULL AUTO_INCREMENT, `msg_id` VARCHAR(64) NOT NULL, `channel` VARCHAR(32) NOT NULL, `payload` JSON NOT NULL, `priority` INT NOT NULL DEFAULT 10, `status` VARCHAR(16) NOT NULL DEFAULT 'pending', `attempts` INT NOT NULL DEFAULT 0, `next_retry_at` DATETIME NULL, `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `uq_notif_outbox_msg_id` (`msg_id`), KEY `idx_notif_outbox_status_next_retry` (`status`,`next_retry_at`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='通知发件箱/重试队列'; """ id = Column(Integer, primary_key=True, autoincrement=True) msg_id = Column(String(64), nullable=False, unique=True) channel = Column(String(32), nullable=False) payload = Column(JSON, nullable=False) priority = Column(Integer, default=10) status = Column(String(16), default="pending") attempts = Column(Integer, default=0) next_retry_at = Column(DateTime, nullable=True) created_at = Column(DateTime, default=datetime.utcnow) updated_at = Column(DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)