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

from models.base import Base, TimestampMixin


class Attendance(Base, TimestampMixin):
    __tablename__ = 'attendance'
    id = Column(Integer, primary_key=True, autoincrement=True)
    participant_id = Column(Integer, ForeignKey('participants.id'), nullable=False)
    course_id = Column(Integer, ForeignKey('course.id'), nullable=False)
    staff_id = Column(Integer, ForeignKey('staff.id'), nullable=False)
    attendance_status = Column(String(255))
    remarks = Column(String(255),nullable=True)
    attendance_date = Column(Date)
    modified_by_admin = Column(Boolean,nullable=True,default=False)
    course =relationship("Course")
    participant=relationship("Participant")
    staff=relationship("Staff")