Adding Games ~ Checkers ERD - uchicago-cs/chigame GitHub Wiki
Entities
User (Existing)
- Name
- Username
Checkers Game
Notes: A checkers game only needs to exist. All of the game logic should happen in JS, and the users playing it can be tracked through relations
- Start Timestamp (Time)
Board
Notes: Unsure of how to store a board state efficiently. However, they shouldn't be dynamically generated because there are a finite number of board states, but a theoretically infinite number of completed games that reference the same board state
- Squares (Array? Custom Class? 64-digit number?)
Bot
Notes: may be unneeded based on how the checkers bot is implemented
Relationships
(m) Bot and User play (n) Checkers Game
- Winner (Short Int) (nullable) (0-2 to represent draw, win, or loss)
(m) Checkers Game have (n) Board
- Turn Number (Short Int)