5pRBQDmf

1DROP TABLE IF EXISTS "car";
2DROP TABLE IF EXISTS "user";
3
4CREATE TABLE "user" (
5  id SERIAL PRIMARY KEY,
6  name VARCHAR(255) UNIQUE
7);
8
9CREATE TABLE "car" (
10  id SERIAL PRIMARY KEY,
11  model VARCHAR(255) NOT NULL,
12  user_id INTEGER NULL REFERENCES "user"(id)
13);
14
15INSERT INTO "user" (name) VALUES ('Dominic');
16INSERT INTO "user" (name) VALUES ('Hamilton');
17INSERT INTO "user" (name) VALUES ('Cassady');
18INSERT INTO "user" (name) VALUES ('Jacob');
19INSERT INTO "user" (name) VALUES ('Quinn');
20
21INSERT INTO "car" (model,user_id) VALUES ('Opel Corsa',1);
22INSERT INTO "car" (model,user_id) VALUES ('Opel Vectra',1);
23INSERT INTO "car" (model,user_id) VALUES ('Opel Astra',2);
24INSERT INTO "car" (model,user_id) VALUES ('Audi A3',3);
25INSERT INTO "car" (model,user_id) VALUES ('Audi A5',3);
26INSERT INTO "car" (model,user_id) VALUES ('Audi A8',3);
27INSERT INTO "car" (model,user_id) VALUES ('Seat Leon',5);