# Freedom: The Underground Railroad

- [Publisher Link](https://www.academygames.com/pages/freedom)
- [Boardgamegeek](https://boardgamegeek.com/boardgame/119506/freedom-underground-railroad)

This is a SQLite3 schema for comparing different plays of this game.
It follows the recommended scoring on page 10 of the game instructions.

## SQLite3 Schema

```
CREATE TABLE games (gameID INTEGER PRIMARY KEY NOT NULL,
                    date TEXT NOT NULL DEFAULT CURRENT_DATE,
                    players TEXT NOT NULL DEFAULT "",
                    location TEXT NOT NULL DEFAULT "",
                    difficulty TEXT NOT NULL DEFAULT "Normal",
                    n_freed INTEGER NOT NULL DEFAULT 0,
                    n_lost INTEGER NOT NULL DEFAULT 0,
                    req_freed INTEGER NOT NULL DEFAULT 0,
                    supp_tokens INTEGER NOT NULL DEFAULT 0,
                    n_market_cards INTEGER NOT NULL DEFAULT 0,
                    won INTEGER NOT NULL DEFAULT 0,
                    score INTEGER GENERATED ALWAYS AS (2*n_freed - n_lost + 10 * req_freed + 10 * supp_tokens + 5 * iif(won, n_market_cards, 0)) STORED);
```

## Notes

- The `difficulty` column be one of the following:
    - "Normal": default difficulty for the game
    - "Easy": The "easier play" option described on page 10 of the instructions.
    - "Difficult": The "more difficult" option described on page 10 of the instructions.
- The following columns should be set to `1` or `0` depending on whether the objective was met or not, respectively:
    - `req_freed`: were the required number of slaves freed?
    - `supp_tokens`: Were all of the required support tokens purchased?
    - `won`: Was the game won?
- The `players` and `location` columns can be filled in as desired by the user.