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

class AutoBooking(Base):
    __tablename__ = "auto_booking"

    id = Column(BigInteger, primary_key=True, autoincrement=True)
    provider = Column(String(100))
    visa_center = Column(String(100))
    order_no = Column(String(100))
    social_account = Column(String(100))
    account = Column(String(100))
    password = Column(String(100))
    last_name = Column(String(100))
    first_name = Column(String(100))
    gender = Column(String(10))
    birthday = Column(Date)
    email = Column(String(150))
    alias_email = Column(String(150))
    phone_country_code = Column(String(20))
    phone_no = Column(String(50))
    passport_no = Column(String(50))
    nationality = Column(String(50))
    passport_expiry_date = Column(Date)
    address_line1 = Column(Text)
    address_line2 = Column(Text)
    state = Column(String(100))
    city = Column(String(100))
    postcode = Column(String(100))
    travel_date = Column(Date)
    cover_letter = Column(String(100))
    passport_image_url = Column(Text)
    selfie_image_url = Column(Text)
    application_form_url = Column(Text)
    priority = Column(Integer, default=0)
    expected_submit_start = Column(Date)
    expected_submit_end = Column(Date)
    rules = Column(Text)
    status = Column(Integer, default=0)
    placeholder = Column(Integer, default=0)
    appointment_datetime = Column(DateTime)
    appointment_letter_url = Column(Text)
    pnr_number = Column(String(100))
    payment_link = Column(Text)
    payment_help = Column(Integer, default=0)
    note = Column(Text)