This application serves an API to read and store game scores for different games. A simple front-end web interface displays the scores table for each game.
At this moment, we will focus on developing an API with the following calls:
Fetch single game's data by its ID.
Post a new game score.
Parameters:
- game_id: numeric
- score: numeric
- player_name: alphanumeric
- meta: text
Fetch game scores.
Fetch game challenges.
Table: scores score_id, game_id, player_name, meta, post_timestamp, update_timestamp
Table: games game_id, title, code, description, levels, creation_timestamp, update_timestamp
Table: challenges challenge_id, game_id, challenge, level, group, creation_timestamp, update_timestamp