Tracking Requests Table

The tracking_requests table contains 1 row per tracking request (tracking_request_idis the unique key). A tracking request can fail or succeed (status column). A successful tracking request will lead to the creation of a shipment (shipment_id). There can be multiple tracking requests for the same requested number (possibly failing before finally succeeding).

COLUMN NAME	DESCRIPTION	TYPE
`tracking_request_id`	Tracking request ID. This is the unique key of the table.	`text`
`request_number`	Number requested to be tracked	`text`
`reference_numbers`	Reference numbers associated to the tracking request, concatenated	`text`
`shipment_tags`	Tags added to the request, concatenated and separated by a comma	`text`
`status`	Status of the tracking request: created, pending, awaiting_manifest, failed, tracking_stopped	`text`
`failed_reason`	For tracking requests that failed, a description of the error	`text`
`request_type`	Type of tracking request: bill_of_lading, booking_number, or container	`text`
`scac`	Standard carrier alpha numeric code of the shipping line	`text`
`shipment_id`	If the tracking request succeeded, this is the ID of the shipment that was created	`text`
`created_at`	When the tracking was requested, as a UTC timestamp	`timestamp`
`updated_at`	When the tracking request was last updated, as a UTC timestamp	`timestamp`