| 12345678910111213141516171819202122232425262728293031323334353637383940414243 |
- 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)
|