A6aqcwcA

1DROP TABLE IF EXISTS ships CASCADES;
2DROP TABLE IF EXISTS fleet CASCADES;
3DROP TABLE IF EXISTS sailors CASCADES;
4DROP TABLE IF EXISTS duties CASCADES;
5DROP TABLE IF EXISTS ranks CASCADES;
6DROP TABLE IF EXISTS assignments CASCADES;
7
8CREATE TABLE fleet (
9  id SERIAL PRIMARY KEY NOT NULL,
10  name VARCHAR(225) NOT NULl
11);
12
13CREATE TABLE ships (
14  id SERIAL PRIMARY KEY NOT NULL,
15  name VARCHAR(225) NOT NULl,
16  date_build DATE NOT NULL,
17  fleet_id INTEGER NOT NULL
18);
19
20CREATE TABLE salors (
21  id SERIAL PRIMARY KEY NOT NULL,
22  name VARCHAR(225) NOT NULL,
23  date_of_built DATE NOT NULL
24);
25
26CREATE TABLE duties (
27  id SERIAL PRIMARY KEY NOT NULL,
28  title VARCHAR(225) NOT NULL
29);
30
31
32CREATE TABLE  ranks (
33  id SERIAL PRIMARY KEY NOT NULL,
34  ranking VARCHAR(80) NOT NULL
35);
36
37CREATE TABLE  assignments (
38  id SERIAL PRIMARY KEY NOT NULL,
39  salor_id INTEGER NOT NULL,
40  ship_id INTEGER NOT NULL,
41  rank_assigned INTEGER NOT NULL,
42  duty_assigned INTEGER NOT NULL,
43  start_date DATE NOT NULL,
44  end_date DATE NOT NULL
45);