CREATE TABLE details (
  "num" BIGINT,
  "id" BIGINT,
  "primary" VARCHAR,
  "description" VARCHAR,
  "yearpublished" BIGINT,
  "minplayers" BIGINT,
  "maxplayers" BIGINT,
  "playingtime" BIGINT,
  "minplaytime" BIGINT,
  "maxplaytime" BIGINT,
  "minage" BIGINT,
  "boardgamecategory" VARCHAR,
  "boardgamemechanic" VARCHAR,
  "boardgamefamily" VARCHAR,
  "boardgameexpansion" VARCHAR,
  "boardgameimplementation" VARCHAR,
  "boardgamedesigner" VARCHAR,
  "boardgameartist" VARCHAR,
  "boardgamepublisher" VARCHAR,
  "owned" BIGINT,
  "trading" BIGINT,
  "wanting" BIGINT,
  "wishing" BIGINT
);

CREATE TABLE ratings (
  "num" BIGINT,
  "id" BIGINT,
  "name" VARCHAR,
  "year" BIGINT,
  "rank" BIGINT,
  "average" DOUBLE,
  "bayes_average" DOUBLE,
  "users_rated" BIGINT,
  "url" VARCHAR,
  "thumbnail" VARCHAR
);