from django.db import models

from management.models.gruppo import Gruppo
from management.models.utente import Utente

class Tag(models.Model):
    id = models.AutoField(primary_key=True)
    title = models.CharField(max_length=100)
    color = models.CharField(max_length=10)
    user = models.ForeignKey(Utente, on_delete=models.CASCADE, related_name="tag_user")
    creation_date = models.DateTimeField(auto_now=True)

    class Meta:
        db_table = "Tag"

class GruppiTag(models.Model):
    id = models.AutoField(primary_key=True)
    tag = models.ForeignKey(Tag, on_delete=models.CASCADE)
    gruppo = models.ForeignKey(Gruppo, on_delete=models.CASCADE, related_name="gruppi_tag")

    class Meta:
        db_table = "Gruppi_tag"