Data Collection / Tables - games in progress

[LaustinSpayce]

I think pocketbase is ideal to keep the list of current games in progress.

In php, when the game is closed/deleted/completed, the record should be removed from this pocketbase table.

It's much easier to query one small table for games currently in progress than for php to scan everything.

Suggested data structure:

gameID num
playerA user
playerB user
heroA string
heroB string
currentGameTurn number
format string

[LaustinSpayce]

We'll also get the "games list" as a gimme yay - have the end point be public.