Untitled

from sqlalchemy import Column, Integer, String, DateTime
from datetime import datetime, timezone
from db import Base

class Booking(Base):
    __tablename__ = "bookings"

    id = Column (Integer, primary_key=True, index=True)
    customer_name = Column (String, nullable=False)
    customer_email = Column (String, nullable=False, index=True)
    
    date = Column (String, nullable=False, index=True)
    start_min = Column (Integer, nullable=False)
    end_min = Column (Integer, nullable=False)

    cancel_token = Column (String, unique=True, index=True, nullable=True)

    status = Column (String, nullable=False, default="BOOKED", index=True)
    
    created_at = Column (DateTime(timezone=True), nullable=False, default=lambda: datetime.now(timezone.utc))
    canceled_at = Column (DateTime(timezone=True), nullable=True)