Craft Beers

CREATE TABLE beers (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "count_x" BIGINT,
  "abv" DOUBLE,
  "ibu" DOUBLE,
  "id" BIGINT,
  "beer" VARCHAR,
  "style" VARCHAR,
  "brewery_id" BIGINT,
  "ounces" DOUBLE,
  "style2" VARCHAR,
  "count_y" BIGINT,
  "brewery" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "label" VARCHAR
);

CREATE TABLE breweries (
  "id" BIGINT,
  "name" VARCHAR,
  "address1" VARCHAR,
  "address2" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "code" VARCHAR,
  "country" VARCHAR,
  "phone" VARCHAR,
  "website" VARCHAR,
  "filepath" VARCHAR,
  "descript" VARCHAR,
  "last_mod" TIMESTAMP
);

CREATE TABLE breweries_geocode (
  "id" BIGINT,
  "brewery_id" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "accuracy" VARCHAR
);

CREATE TABLE categories (
  "id" BIGINT,
  "cat_name" VARCHAR,
  "last_mod" TIMESTAMP
);

CREATE TABLE styles (
  "id" BIGINT,
  "cat_id" BIGINT,
  "style_name" VARCHAR,
  "last_mod" TIMESTAMP
);