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.
- Esports Team Management
- Data model
The tables behind Esports Team Management
Esports Team Management ships with 11 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
- 11
- Features
- 6
- Change it
- Add fields and tables in Proto
How the model is organised
Team operations
Teams owns People and Venues; People links to Users.
Match operations
Fixtures references a responsible Teams, an owner in People and a host Venues. Team entries connects a participating Teams to its parent Fixtures. Match admissions belongs to Fixtures.
Review and evidence
Result reviews, match attachments and operation receipts each belong to Fixtures. A review or upload also points to a People record.
Payment records
Payout evidence belongs to Fixtures and carries provider event details.
Every table, by feature
- Teams
Operating organizations that own events, venues and team members.
- People
Staff membership linking a platform user to an organization and role.
Linked to Teams, Users - Users
Users
Linked to Users - Venues
Physical or virtual venues and resource providers used by events.
Linked to Teams - Fixtures
Programs, events and sessions with capacity, lifecycle and revision.
Linked to Teams, People, Venues - Team entries
Participant registration records submitted for review and completion.
Linked to Fixtures, Teams
- Fixtures
Programs, events and sessions with capacity, lifecycle and revision.
Linked to Teams, People, Venues - Teams
Operating organizations that own events, venues and team members.
- People
Staff membership linking a platform user to an organization and role.
Linked to Teams, Users - Venues
Physical or virtual venues and resource providers used by events.
Linked to Teams - Team entries
Participant registration records submitted for review and completion.
Linked to Fixtures, Teams - Match admissions
Reserved and admitted admission lines for an event.
Linked to Fixtures - Result reviews
Independent reviewer decisions recorded against a source revision.
Linked to Fixtures, People
- Team entries
Participant registration records submitted for review and completion.
Linked to Fixtures, Teams - Teams
Operating organizations that own events, venues and team members.
- Fixtures
Programs, events and sessions with capacity, lifecycle and revision.
Linked to Teams, People, Venues - Match admissions
Reserved and admitted admission lines for an event.
Linked to Fixtures - Result reviews
Independent reviewer decisions recorded against a source revision.
Linked to Fixtures, People - Payout evidence
Provider payment authorizations, captures, refunds and voids.
Linked to Fixtures
- Match admissions
Reserved and admitted admission lines for an event.
Linked to Fixtures - Fixtures
Programs, events and sessions with capacity, lifecycle and revision.
Linked to Teams, People, Venues - Team entries
Participant registration records submitted for review and completion.
Linked to Fixtures, Teams - Operation receipts
Idempotent receipts for guarded operations with expected revision and result state.
Linked to Fixtures - Payout evidence
Provider payment authorizations, captures, refunds and voids.
Linked to Fixtures
- Result reviews
Independent reviewer decisions recorded against a source revision.
Linked to Fixtures, People - Match attachments
Uploaded evidence files linked to an event with visibility scope.
Linked to Fixtures, People - Operation receipts
Idempotent receipts for guarded operations with expected revision and result state.
Linked to Fixtures - Fixtures
Programs, events and sessions with capacity, lifecycle and revision.
Linked to Teams, People, Venues - Match admissions
Reserved and admitted admission lines for an event.
Linked to Fixtures - Payout evidence
Provider payment authorizations, captures, refunds and voids.
Linked to Fixtures
- Payout evidence
Provider payment authorizations, captures, refunds and voids.
Linked to Fixtures - Operation receipts
Idempotent receipts for guarded operations with expected revision and result state.
Linked to Fixtures - Fixtures
Programs, events and sessions with capacity, lifecycle and revision.
Linked to Teams, People, Venues - Match admissions
Reserved and admitted admission lines for an event.
Linked to Fixtures - Team entries
Participant registration records submitted for review and completion.
Linked to Fixtures, Teams
Keys and references
Keep the fixture identity stable across its child records. A team entries parent is the fixture, while its team is the participant. The fixture’s own team is responsible for the event. Operation keys identify guarded attempts; provider event identifiers identify outside payment evidence. Source revisions and expected revisions tell reviewers which event state each decision or action addressed. Users links through People, and the published Users structure includes a self-reference that should be reviewed during migration.
Migration order
- Users and Teams. Establish user identities and operating teams.
- People and Venues. Link staff and host locations to teams.
- Fixtures. Import event identity, owner, venue, schedule, capacity and revision.
- Dependent operations. Add team entries and match admissions against their parent fixtures.
- Evidence and outcomes. Bring in match attachments, result reviews, operation receipts and payout evidence with source references.
Set up Esports Team Management your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.