from sqlalchemy import Column, Integer, String, DateTime, Enum, Text from datetime import datetime from app.core.database import Base class VasSlotRefreshStatus(Base): __tablename__ = "vas_slot_refresh_status" __ddl__ = """ CREATE TABLE IF NOT EXISTS `vas_slot_refresh_status` ( `id` INT NOT NULL AUTO_INCREMENT, `routing_key` VARCHAR(255) NOT NULL, `snapshot_source` ENUM('worker','manual','sync') NOT NULL, `country` VARCHAR(100) NOT NULL, `city` VARCHAR(100) NOT NULL, `visa_type` VARCHAR(100) NOT NULL, `last_refresh_at` DATETIME NOT NULL, `last_success_at` DATETIME NULL, `last_error` TEXT NULL, `updated_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `uq_vas_slot_refresh_routing` (`routing_key`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='签证考位刷新监控汇总表'; """ id = Column(Integer, primary_key=True, autoincrement=True) routing_key = Column(String(255), nullable=False, unique=True) snapshot_source = Column( Enum('worker', 'manual', 'sync'), nullable=False ) country = Column(String(100), nullable=False) city = Column(String(100), nullable=False) visa_type = Column(String(100), nullable=False) last_refresh_at = Column(DateTime, nullable=False) last_success_at = Column(DateTime) last_error = Column(Text) updated_at = Column( DateTime, nullable=False, default=datetime.utcnow, onupdate=datetime.utcnow )