automateX

Tables (7)

Account (Untitled)

  • Key (id) — UUID — Primary key — NOT NULL
  • Field2 (name) — String
  • Field (email) — String
  • Field3 (password) — String
  • Field4 (role) — Role
  • Field

Operators (Untitled7)

  • Key (id) — Long — Primary key — NOT NULL
  • Field (name) — String
  • Field2
  • Field3
  • Field4

Piers (Untitled3)

  • Key (id) — Long — Primary key — NOT NULL
  • Key (port_id) — Long — Foreign key → Ports.Key — NOT NULL
  • Field (name) — String
  • Field3 (operator) — String
  • Field4

Ports (Untitled2)

  • Key (id) — Long — Primary key — NOT NULL
  • Field (name) — String
  • Field2
  • Field3
  • Field4

Ships (Untitled5)

  • Key (id) — Long — Primary key — NOT NULL
  • Key (pier_id) — Long — Foreign key → Piers.Key — NOT NULL
  • Field (name) — String
  • Field3
  • Field4

Significant (Untitled6)

  • Key (id) — Long — Primary key — NOT NULL
  • Field (expected_arrival_date) — String
  • Field2 (estimated_departure) — String
  • Field3 (call_sign) — String
  • Field4 (vessel_name) — String
  • Field5 (purpose_of_arrival) — String
  • Field (loader) — String
  • Field2 (cargo_name) — String
  • Field (total_cargo_quantity) — int

Violations (Untitled4)

  • Key (Id) — Long — Primary key — NOT NULL
  • Field (name) — String
  • Field2
  • Field3
  • Field4