webapp/app/models/visafly_config.py

from sqlalchemy import Column, Integer, String
from app.core.database import Base

class VisaflyConfig(Base):
    __tablename__ = "visa_slot_queries"

    id = Column(Integer, primary_key=True, autoincrement=True)
    submission_country = Column(String(100), nullable=False)
    submission_country_code = Column(String(10), nullable=False)
    submission_city = Column(String(100), nullable=False)
    submission_city_code = Column(String(10), nullable=False)
    travel_country = Column(String(100), nullable=False)
    travel_country_code = Column(String(10), nullable=False)
    visa_type = Column(String(100), nullable=False)
    provider = Column(String(100), nullable=True)
    field_requirement_type = Column(String(100), nullable=True)