from sqlalchemy import Column, Integer, String, Date, ForeignKey,Boolean
from sqlalchemy.orm import Relationship

from models.base import Base, TimestampMixin


class WaitingList(Base, TimestampMixin):
    __tablename__ = 'waiting_list'

    id = Column(Integer, primary_key=True, autoincrement=True)
    course_id = Column(Integer, ForeignKey('course.id'), nullable=True)
    participant_id = Column(Integer, ForeignKey('participants.id'), nullable=True)
    created_by = Column(Integer, nullable=False)
    user_type = Column(String(255), nullable=False)
    primary_contact_number = Column(String(20), nullable=True)
    is_enrolled = Column(Boolean, default=False)
    remarks = Column(String(500), nullable=True)


    course=Relationship("Course")
    participant=Relationship("Participant")