from django.db import models


class EsExamRequirementSameLocation(models.Model):
    group = models.ForeignKey("api.EsExamRequirementSameLocationGroup", on_delete=models.CASCADE)
    exam_requirement = models.ForeignKey("api.EsExamRequirement", on_delete=models.CASCADE)
    exam_activity = models.ForeignKey("api.EsExamActivity", on_delete=models.CASCADE)

    class Meta:
        db_table = "es_exam_requirement_same_location"
        constraints = [
            models.UniqueConstraint(
                fields=["group", "exam_requirement", "exam_activity"],
                name="unique_exam_requirement_same_location",
            )
        ]