x9kJ6Hg2

1  CREATE TABLE IF NOT EXISTS place_suggestions(
2    event_id int4 NOT NULL,
3    place_id int4 NOT NULL,
4    place_name VARCHAR (50) NOT NULL,
5    created_on TIMESTAMP NOT NULL,
6    primary key (event_id, place_id)
7  );
8
9  CREATE TABLE IF NOT EXISTS place_votes(
10    user_id int4 NOT NULL,
11    event_id int4 NOT NULL,
12    place_id int4 NOT NULL,
13    created_on TIMESTAMP NOT NULL,
14    primary key (user_id, event_id, place_id)
15  );