from django.db import models


class EsStudentStudentGroup(models.Model):
    student = models.ForeignKey(
        "api.EsStudent",
        on_delete=models.CASCADE,
        related_name="student_group_links",
    )
    student_group = models.ForeignKey(
        "api.EsStudentGroup",
        on_delete=models.CASCADE,
        related_name="student_links",
    )

    class Meta:
        db_table = "es_student_student_group"
        unique_together = ("student", "student_group")

    def __str__(self) -> str:
        return f"StudentStudentGroup({self.student_id}->{self.student_group_id})"