game-scores/freedom

Freedom: The Underground Railroad

• Publisher Link
• Boardgamegeek

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.