CREATE TABLE v_limits(v_limit TEXT PRIMARY KEY);
CREATE TABLE states(abbreviation TEXT PRIMARY KEY, state TEXT);
CREATE TABLE cities(city TEXT PRIMARY KEY);
CREATE TABLE games(game TEXT PRIMARY KEY);
CREATE TABLE hi_lows(hi_lo TEXT PRIMARY KEY);
CREATE TABLE kills(kill TEXT PRIMAY KEY);
CREATE TABLE stakes(stake TEXT PRIMARY KEY);
CREATE TABLE venues(venue TEXT PRIMAY KEY);

CREATE TABLE visits(id INT PRIMARY KEY, arrival_date DATE, departure_date DATE, arrival_time TIME, departure_time TIME, venue TEXT REFERENCES venues(venue), city TEXT REFERENCES cities(city), state TEXT REFERENCES states(abbreviation), game TEXT REFERENCES games(game), stake TEXT REFERENCES stakes(stake), kill TEXT REFERENCES kills(kill), hi_lo TEXT REFERENCES hi_lows(hi_lo), v_limit REFERENCES v_limits(v_limit), buy_in MONEY, cash_out MONEY);