from sqlalchemy import Column, Integer, String, Date, DateTime, Text
from app.core.database import Base
from datetime import datetime

class Slot(Base):
    __tablename__ = "visa_slot"

    id = Column(Integer, primary_key=True, autoincrement=True)
    submit_country = Column(String(100), nullable=False)
    submit_city = Column(String(100))
    travel_country = Column(String(100), nullable=False)
    visa_type = Column(String(100), nullable=False)
    lasted_slot_date = Column(Date)
    available_dates = Column(Text)
    available_times = Column(Text)
    slot_number = Column(Integer)
    website = Column(String(255))
    open_mode = Column(Integer, default=0)
    create_at = Column(DateTime, default=datetime.utcnow)
    update_at = Column(DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)