import uuid
from django.db import models
from user.models import User

class SupervisorGroup(models.Model):
    id = models.UUIDField(primary_key=True, default=uuid.uuid4, editable=False)
    group = models.CharField(max_length=255)
    user = models.ForeignKey(User, on_delete=models.CASCADE, related_name='supervisor_groups')
    isprimary = models.BooleanField(default=False)
    created_at = models.DateTimeField(auto_now_add=True)
    updated_at = models.DateTimeField(auto_now=True)

    class Meta:
        db_table = 'supervisor_groups'
        ordering = ['-created_at']
        unique_together = ['group', 'user']

    def __str__(self):
        return f"{self.group} - {self.user.first_name} {self.user.last_name}"