"""Link between a player and a tryout-specific team."""

from app.extensions import db
from app.time_utils import utc_now_naive


class TeamMember(db.Model):
    """Link between a player and a tryout-specific team."""

    __tablename__ = 'team_members'
    id = db.Column(db.Integer, primary_key=True)
    team_id = db.Column(db.Integer, db.ForeignKey('teams.id'), nullable=False)
    player_id = db.Column(db.Integer, db.ForeignKey('users.id'), nullable=False)
    position = db.Column(db.String(50), nullable=True)
    added_at = db.Column(db.DateTime, default=utc_now_naive)

    player = db.relationship('User', overlaps="player_ref,team_assignments")