"""Many-to-many association tables for OrgTeam ↔ User relationships."""

from app.extensions import db

org_team_coaches = db.Table(
    'org_team_coaches',
    db.Column(
        'org_team_id',
        db.Integer,
        db.ForeignKey('org_teams.id', ondelete='CASCADE'),
        primary_key=True,
    ),
    db.Column(
        'coach_id', db.Integer, db.ForeignKey('users.id', ondelete='CASCADE'), primary_key=True
    ),
)

org_team_managers = db.Table(
    'org_team_managers',
    db.Column(
        'org_team_id',
        db.Integer,
        db.ForeignKey('org_teams.id', ondelete='CASCADE'),
        primary_key=True,
    ),
    db.Column(
        'manager_id', db.Integer, db.ForeignKey('users.id', ondelete='CASCADE'), primary_key=True
    ),
)

tryout_coaches = db.Table(
    'tryout_coaches',
    db.Column(
        'tryout_id', db.Integer, db.ForeignKey('tryouts.id', ondelete='CASCADE'), primary_key=True
    ),
    db.Column(
        'coach_id', db.Integer, db.ForeignKey('users.id', ondelete='CASCADE'), primary_key=True
    ),
)

tryout_managers = db.Table(
    'tryout_managers',
    db.Column(
        'tryout_id', db.Integer, db.ForeignKey('tryouts.id', ondelete='CASCADE'), primary_key=True
    ),
    db.Column(
        'manager_id', db.Integer, db.ForeignKey('users.id', ondelete='CASCADE'), primary_key=True
    ),
)