Visualizing the Navy Database

navy_schema.sql

CREATE TABLE IF NOT EXISTS fleets (
  id SERIAL PRIMARY KEY NOT NULL,
  name VARCHAR(225) NOT NULL
);

CREATE TABLE IF NOT EXISTS ships (
  id SERIAL PRIMARY KEY NOT NULL,
  fleet_id INTEGER NOT NULL,
  name VARCHAR(225) NOT NULL,
  date_bulit DATE NOT NULL
);

CREATE TABLE IF NOT EXISTS sailors (
  name VARCHAR(225) NOT NULL,
  date_of_birth DATE NOT NULL
);

CREATE TABLE IF NOT EXISTS duties (
  id SERIAL PRIMARY KEY NOT NULL,
  ship_id INTEGER NOT NULL,
  sailor_id INTEGER NOT NULL,
  start_date DATE,
  end_date DATE,
  duty_name VARCHAR(225),
  rank VARCHAR(225)
);