webapp/app/models/troov_session.py

from datetime import datetime
from sqlalchemy import Column, String, DateTime, JSON, func
from app.core.database import Base


class TroovSession(Base):
    __tablename__ = "troov_session"

    session_id = Column(String(128), primary_key=True)
    slot_date = Column(String(64), nullable=False)
    slot_time = Column(String(64), nullable=False)
    source = Column(String(128), nullable=False)
    data = Column(JSON, nullable=True)
    status = Column(String(32), default="pending", comment="pending, booking, expired")
    
    created_at = Column(DateTime, default=datetime.utcnow)
    updated_at = Column(DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)