from sqlalchemy import Column, Integer, String, DateTime, Enum, JSON, Text from datetime import datetime from app.core.database import Base class VasSlotSnapshot(Base): __tablename__ = "vas_slot_snapshot" __ddl__ = """ CREATE TABLE IF NOT EXISTS `vas_slot_snapshot` ( `id` INT NOT NULL AUTO_INCREMENT, `country` VARCHAR(100) NOT NULL, `city` VARCHAR(100) NOT NULL, `visa_type` VARCHAR(100) NOT NULL, `routing_key` VARCHAR(255) NOT NULL, `availability_status` ENUM('None','Available','Waitlist') NOT NULL, `website` TEXT NOT NULL, `earliest_date` DATETIME NULL, `availability` JSON NOT NULL, `snapshot_source` ENUM('worker','manual','sync') NOT NULL, `snapshot_at` DATETIME NOT NULL, PRIMARY KEY (`id`), KEY `idx_vas_slot_snap_routing` (`routing_key`), KEY `idx_vas_slot_snap_snapshot_at` (`snapshot_at`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='考位可用状态历史快照表'; """ id = Column(Integer, primary_key=True, autoincrement=True) country = Column(String(100), nullable=False) city = Column(String(100), nullable=False) visa_type = Column(String(100), nullable=False) routing_key = Column(String(255), nullable=False) availability_status = Column( Enum('None','Available','Waitlist'), nullable=False ) website = Column(Text, nullable=False) earliest_date = Column(DateTime) availability = Column(JSON, nullable=False) snapshot_source = Column(Enum('worker','manual','sync'), nullable=False) snapshot_at = Column(DateTime, nullable=False)