> ## Documentation Index
> Fetch the complete documentation index at: https://terminal49.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# Tracking Requests Table

> Reference the Terminal49 DataSync tracking_requests table schema, including request status fields, retry-related columns, and carrier information.

The `tracking_requests` table contains 1 row per tracking request (`tracking_request_id`is 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` |