LQMypFKt

1CREATE TABLE IF NOT EXISTS fleets (
2  id SERIAL PRIMARY KEY NOT NULL,
3  name VARCHAR(225) NOT NULL
4);
5
6CREATE TABLE IF NOT EXISTS ships (
7  id SERIAL PRIMARY KEY NOT NULL,
8  fleet_id INTEGER NOT NULL,
9  name VARCHAR(225) NOT NULL,
10  date_bulit DATE NOT NULL
11);
12
13CREATE TABLE IF NOT EXISTS sailors (
14  name VARCHAR(225) NOT NULL,
15  date_of_birth DATE NOT NULL
16);
17
18CREATE TABLE IF NOT EXISTS duties (
19  id SERIAL PRIMARY KEY NOT NULL,
20  ship_id INTEGER NOT NULL,
21  sailor_id INTEGER NOT NULL,
22  start_date DATE,
23  end_date DATE,
24  duty_name VARCHAR(225),
25  rank VARCHAR(225)
26);