Backend "view" - evelinawahlstrom/game-project-client GitHub Wiki

MODELS https://www.vertabelo.com/blog/a-database-model-for-simple-board-games/

https://www.vertabelo.com/blog/tutorial-how-to-develop-a-simple-tic-tac-toe-game-with-spring-boot-and-angularjs/#the-move-table

A. SIMPLE VERSION - IMPLEMENT IN OUR GAME

1. User

• name (unique:
• password
• game_id

2. Game (lobby)

• id
• max nr of players
• start/endtime
• player start_id
• result

3. Moves

• Pieces (X, O)
• Row
• Column

B. COMPLEX VERSION

1. Player/user

• name: unique
• password

2. Participant

• id
• player_id
• game_id
• score

3. Game

• start
• id
• max nr players
• player started id
• move/game time limit
• result_id

4. MOVE

• id
• game_id
• piece_id
• participant_id
• move type id
• move order
• move notation (?)

5. Result - storing all possible endings of a game (win on either side, draw...)

• id
• description

6. LOBBY

• Store games, see if full or not (?)

Implement stream (or socket.io) on every endpoint (?)

• Count wins/loss for each player: https://github.com/hgmallar/TicTacToe/blob/master/models/users.js
• Updates a users score: https://github.com/hgmallar/TicTacToe/blob/master/routes/apiRoutes.js