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