50 lines
1.3 KiB
Python
50 lines
1.3 KiB
Python
"""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
|
|
),
|
|
)
|