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