"""
Rating / Valoración Models

SQLAlchemy ORM models for player ratings and detailed evaluations.
"""

from sqlalchemy import Column, Integer, String, Text, ForeignKey
from .base import Base


class PlayerRating(Base):
    """Simple player rating by a docente"""
    __tablename__ = 'player_ratings'

    id = Column(Integer, primary_key=True, autoincrement=True)
    player_id = Column(Integer, ForeignKey('users.id'), nullable=False)
    docente_id = Column(Integer, ForeignKey('users.id'), nullable=False)
    score = Column(Integer, nullable=False)
    comment = Column(Text)
    created_at = Column(String)


class ValoracionJugador(Base):
    """Detailed player evaluation item"""
    __tablename__ = 'valoraciones_jugador'

    id = Column(Integer, primary_key=True, autoincrement=True)
    eval_id = Column(String, nullable=False)
    player_id = Column(Integer, ForeignKey('users.id'), nullable=False)
    docente_id = Column(Integer, ForeignKey('users.id'), nullable=False)
    area = Column(String, nullable=False)
    subescala = Column(String, nullable=False)
    indicador = Column(String, nullable=False)
    score = Column(Integer, nullable=False)
    observaciones = Column(Text)
    created_at = Column(String)