from django.db import models


class EsSession(models.Model):
    name = models.CharField(max_length=150)
    location = models.ForeignKey("api.EsLocation", on_delete=models.SET_NULL, null=True)
    description = models.TextField(null=True)
    start_time = models.DateTimeField()
    duration = models.TimeField()
    students_enrolled = models.IntegerField()
    invigilators_required = models.IntegerField()
    invigilator = models.ManyToManyField("api.EsInvigilator", through="api.EsSessionInvigilator")
    created_by = models.BigIntegerField(null=True)
    created_at = models.DateTimeField(auto_now_add=True)
    updated_by = models.BigIntegerField(null=True)
    updated_at = models.DateTimeField(auto_now=True)

    class Meta:
        db_table = "es_session"

    def __str__(self):
        return self.name