V0cqx0n2

1DROP TABLE IF EXISTS activities;
2DROP TABLE IF EXISTS sports;
3DROP TABLE IF EXISTS routes;
4DROP TABLE IF EXISTS users;
5   
6CREATE TABLE users (
7    id serial PRIMARY KEY,
8    email varchar(80) UNIQUE NOT NULL,
9    NAME varchar(80) NOT NULL
10);
11   
12CREATE TABLE sports (
13    id serial PRIMARY KEY,
14    NAME varchar(80) NOT NULL,
15    description varchar(80) NOT NULL
16);
17   
18CREATE TABLE routes (
19    id serial PRIMARY KEY,
20    distance INT NOT NULL,
21    start_location varchar(80) NOT NULL,
22    end_location varchar(80) NOT NULL
23);
24   
25CREATE TABLE activities (
26    number serial PRIMARY KEY NOT NULL,
27    date_of DATE NOT NULL,
28    duration TIME NOT NULL,
29    participant INT REFERENCES users(id) NOT NULL,
30    sport INT REFERENCES sports(id) NOT NULL,
31    route INT REFERENCES routes(id),
32	was_deleted bool NOT NULL
33);