Adding Games ~ Checkers ERD

Entities

User (Existing)

• Name
• Email
• 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)