slot.py 812 B

1234567891011121314151617181920
  1. from sqlalchemy import Column, Integer, String, Date, DateTime, Text
  2. from app.core.database import Base
  3. from datetime import datetime
  4. class Slot(Base):
  5. __tablename__ = "visa_slot"
  6. id = Column(Integer, primary_key=True, autoincrement=True)
  7. submit_country = Column(String(100), nullable=False)
  8. submit_city = Column(String(100))
  9. travel_country = Column(String(100), nullable=False)
  10. visa_type = Column(String(100), nullable=False)
  11. lasted_slot_date = Column(Date)
  12. available_dates = Column(Text)
  13. available_times = Column(Text)
  14. slot_number = Column(Integer)
  15. website = Column(String(255))
  16. open_mode = Column(Integer, default=0)
  17. create_at = Column(DateTime, default=datetime.utcnow)
  18. update_at = Column(DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)