# router_analytics/models.py

from django.db import models

class ProcessedMatchTeamMetrics(models.Model):
    match_id = models.IntegerField()
    team_id = models.IntegerField()
    metric_id = models.IntegerField()
    metric_value = models.FloatField()
    status = models.CharField(max_length=20)
    calculated_at = models.DateTimeField()
    updated_at = models.DateTimeField()
    notes = models.TextField(blank=True)

    class Meta:
        managed = False
        db_table = 'analytics_processedmatchteammetrics'
        app_label = 'analytics'  # Para que funcione con el router
        unique_together = (('match_id', 'team_id', 'metric_id'),)


class ProcessedMatchPlayerMetrics(models.Model):
    match_id = models.IntegerField()
    player_id = models.IntegerField()
    metric_id = models.IntegerField()
    minutes_played = models.FloatField()
    metric_value = models.FloatField()
    status = models.CharField(max_length=20)
    calculated_at = models.DateTimeField()
    updated_at = models.DateTimeField()
    notes = models.TextField(blank=True)

    class Meta:
        managed = False
        db_table = 'analytics_processedmatchplayermetrics'
        app_label = 'analytics'
        unique_together = (('match_id', 'player_id', 'metric_id'),)