Cargo

Cargo & Consignments

NOT CONNECTED — N/ANo TMS / booking / terminal / cargo feed connected· The cargo entity model and its links (Vessel ↔ Voyage Leg ↔ Origin/Destination Port) exist, but no quantity, TEU or delivery status is generated without a real source.

Cargo Records

Total TEU

N/A — no cargo feed

Weight (t)

N/A — no cargo feed

Delivered

Cargo Status Pipeline

Schema states — awaiting real feed

Booked

N/A

Booking / TMS feed (shipper reference, commodity, TEU)

Loaded

N/A

Terminal loading confirmation linked to a port call

In Transit

N/A

AIS voyage leg (available) + confirmed load event

Discharged

N/A

Terminal discharge confirmation at destination port call

Delivered

N/A

Final delivery / gate-out confirmation

Cargo Register

Loading cargo records…

Entity Linkage — AIS → Port Call → Voyage Leg → Voyage → Cargo

AIS vessels

LIVE

public.vessel_static / vessel_positions

Port calls

AIS-DERIVED

public.port_calls (AIS-derived events)

Voyage legs

AIS-DERIVED

public.voyage_legs (chained port calls)

Port register

VERIFIED

public.ports (UN/LOCODE reference)

Cargo attaches to this chain by mmsi and voyage_leg_id, plus origin/destination UN/LOCODE. The upstream links are real and AIS-derived today; only the cargo layer itself waits on an external booking/terminal source. ETA and delivery dates remain N/A until such a source provides them.