This application is for both admins and players at the Board Game Olympics.
Add a category [Categories] and a list of games to each category [Category-Games]
Add a participant [Participants] and link to the current event ][Event-Participants]
Lookup an existing participant and register them at the door [Event-Participants].Active
Choose Category, assign round number [Categories]
List current active participants
Assign each participant to a Category-Game until it is full [Category-Game-Players]
Lookup Game [Category-Games]
Display Details including players [Category-Game-Players]
Add score for each player [Category-Game-Players].Score, [Category-Game-Players].Points
Group by player [Category-Game-Players] and sum the Points.
Pivot games into table columns [Category-Game-Players]
Display all games for a player order by category [Category-Game-Players] [Categories] [Games]
Printing
Searching and importing game from BGG
Choose Random Active Participant
Live game selection during start round
Calculating Game Times
Signout/Re-signin
See Stats
Choose First Player
Game Details and link to BGG
erDiagram
Event }|..|{ Event-Participants : has
Event-Participants }|..|{ Participants : links
Event ||--o{ Categories : has
Categories ||--o{ Category-Games : links
Category-Games ||--|{ Games : links
Event ||--|{ Rounds : has
Rounds ||--|{ Categories : "has a"
Category-Games ||--|{ Event-Participants : links
Category-Game-Players ||--|{ Category-Games : "players for round"
Category-Game-Players ||--|{ Event-Participants : links