These cookies are required for the website to function properly. They ensure security, enable basic features like page navigation, and store user session data. You cannot disable these cookies.
- Sports Club / League Mgmt
- Data model and import order
The tables behind Sports Club / League Mgmt
Sports Club / League Mgmt ships with 10 tables, grouped here by the feature that uses them. Every record your team works with lives in one of them, and you can add fields and tables in Proto.
- Tables
- 10
- Features
- 6, plus shared settings
- Change it
- Add fields and tables in Proto
How the model is organised
Seasons and Teams:
League seasons and Teams. A season holds dates and scoring policy; each team names its coach.
Team Rosters:
Team members link People to Teams with role and dates.
Fixtures:
Fixtures link a home and an away team with venue and times.
Match Officials:
Match officials link People to Fixtures by role.
Results and Standings:
Results belong to a fixture with scores, submitter and approver.
Training:
Training sessions belong to a team and coach; training attendance links People to sessions.
Access:
People link to platform users in Users.
Every table, by feature
- Seasons and Teams3
- Team Rosters3
- Fixtures3
- Match Officials3
- Results and Standings4
- Training4
- Shared and settings1
- League seasons
League season configuration with scoring policy and date window for an operational fixture record.
Linked to Fixtures - Teams
Registered teams with season, coach and registration status.
Linked to People - People
People registry for Sports Club League Mgmt: players, coaches, officials and coordinators linked to platform users.
Linked to Users
- Team members
Team roster membership linking a person to a team with role and join/leave dates.
Linked to Teams, People - People
People registry for Sports Club League Mgmt: players, coaches, officials and coordinators linked to platform users.
Linked to Users - Teams
Registered teams with season, coach and registration status.
Linked to People
- Fixtures
Scheduled matches between a home and away team at a venue with lifecycle status.
Linked to Teams - Teams
Registered teams with season, coach and registration status.
Linked to People - League seasons
League season configuration with scoring policy and date window for an operational fixture record.
Linked to Fixtures
- Match officials
Official assignment to a fixture with role and confirmation state.
Linked to Fixtures, People - Fixtures
Scheduled matches between a home and away team at a venue with lifecycle status.
Linked to Teams - People
People registry for Sports Club League Mgmt: players, coaches, officials and coordinators linked to platform users.
Linked to Users
- Results
Match results submitted by officials and confirmed by an independent reviewer.
Linked to Fixtures, People - Fixtures
Scheduled matches between a home and away team at a venue with lifecycle status.
Linked to Teams - League seasons
League season configuration with scoring policy and date window for an operational fixture record.
Linked to Fixtures - People
People registry for Sports Club League Mgmt: players, coaches, officials and coordinators linked to platform users.
Linked to Users
- Training sessions
Team training sessions with coach, location and scheduled window.
Linked to Teams, People - Training attendance
Per-person attendance status for a training session.
Linked to Training sessions, People - Teams
Registered teams with season, coach and registration status.
Linked to People - People
People registry for Sports Club League Mgmt: players, coaches, officials and coordinators linked to platform users.
Linked to Users
Keys and references
Every person is held once in People. Import rosters, officials and attendance by person and team, never by display name alone. Keep fixture names and venues consistent so clash checks work.
The app holds 10 tables and 17 relationships.
Migration order
- Load Users and People.
- Load league seasons and Teams.
- Load team members.
- Load Fixtures, then match officials.
- Load Results for played fixtures, then training sessions and training attendance.
- Reconcile rosters and the table with the source before scheduling new fixtures.
Set up Sports Club / League Mgmt your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.