from django.db import models


class LabFeedback(models.Model):
    email = models.EmailField()
    lab_code = models.CharField(max_length=20)
    rating_score = models.IntegerField()
    comment = models.CharField(max_length=1024, null=True, blank=True)
    created_at = models.DateTimeField(auto_now_add=True)
    updated_at = models.DateTimeField(auto_now=True)

    class Meta:
        db_table = "lab_feedbacks"
        unique_together = ("email", "lab_code")
        managed = False