Data model - Lambda

The reporting model has two roots:

Root	Grain	Primary join key
`shipments`	One current shipment	`shipment_id`
`one_off_quotes`	One current one-off quote	`quote_id`

Detail ownership

A root can have many charges, dates, parties, milestones, packing lines, and other details. Each detail stays in its own view and carries its root ID. For example, several shipment_charges rows can share one shipment_id. They are separate charges, not duplicate shipments.

Relationship views

Analytics publishes a relationship only when the CargoWise source supports it.

View	Relationship
`shipment_consols`	Shipment to consol context
`quote_shipments`	Quote to shipment
`quote_bookings`	Quote to booking

There is no standalone reporting root for a consol or booking. The relationship views provide the supported link and context. A missing row means the source did not prove the relationship.

Collection updates

CargoWise content	Analytics behavior
Partial	Add or update the observed rows. Keep rows that were not sent.
Complete	Replace the current rows for that collection.

⌘I