Shipment Tracking¶
Shipment tracking table stores information about container number & it's state between Senders port & receivers port.
Attributes¶
shipmentTrackingId: Primary key of the table.
shipmentId: Foreign key of Shipment table. This field stores the information of the shipment whose shipment is being tracked.
orgId: Foreign key of Organisation table. This field stores the information of the organisation whose shipment is being tracked.
shipmentTrackingUid: Unique Id of the shipment tracking generated by system.
containerNo: Container number of the ship who's shipment is being tracked.
provider: Provider of the shipment container like MSC, Mersk etc.
isTrackingEnabled: Boolean value indicating whether continuous shipment tracking is enabled or not.
shipmentTrackingETA: Expected Shipment Time arrival based on tracking information.
shipmentTrackingLocation: Current location of ship.
screenShotUrl: URL of the current tracking screenShot uploaded to S3 bucket.
shipmentETA:
shipmentTracking: JSON object to stores information about container tracking.
Associations¶
Organisation¶
Tracking always belongs any one organisation.
Shipment¶
Tracking always belongs any one Shipment.