> ## 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.

# Transport Events Table

> Reference the Terminal49 DataSync transport_events table schema for shipment milestone timestamps, event type codes, and port or location data.

The `transport_events` table contains 1 row per event (`id`is the unique key).

An event is associated to a specific container (`container_id` is the foreign key).

An event is a specific milestone in the container lifecycle: for example, when the container was loaded at the Port of Lading, or when the vessel arrived at the Port of Discharge.

These events are provided as columns in the `containers` DataSync table, and as rows here in the `transport_events` table. You can use one or the other based on what is most practical for you.

The `transport_events` table includes the transshipment events, which are not part of the `containers` table columns.

This table does not provide any estimated future events.

*The `transport_events` table is currently only provided to DataSync customers who request it.*

*Rail events from the POD to the inland destination are only provided in the Intermodal Rail product : rail\_loaded, rail\_departed, rail\_arrived, arrived\_at\_inland\_destination, rail\_unloaded, pickup\_lfd.changed.*

| COLUMN NAME               | DESCRIPTION                                                                                       | TYPE        |
| ------------------------- | ------------------------------------------------------------------------------------------------- | ----------- |
| `id`                      | Transport Event ID. This is the unique key of the table.                                          | `text`      |
| `event`                   | Name of the transport event. For example: container.transport.vessel\_departed                    | `text`      |
| `event_timestamp`         | When the event happened, as a UTC timestamp                                                       | `timestamp` |
| `event_timestamp_local`   | When the event happened, as a string in the local time zone                                       | `text`      |
| `container_id`            | ID of the container the event is associated to                                                    | `text`      |
| `container_number`        | Number of the container the event is associated to                                                | `text`      |
| `shipment_id`             | ID of the shipment the event is associated to                                                     | `text`      |
| `shipment_number`         | Number of the shipment the event is associated to                                                 | `text`      |
| `port_metro_id`           | ID of the location where the event happened                                                       | `text`      |
| `port_metro_locode`       | Locode of the location where the event happened                                                   | `text`      |
| `port_metro_country_code` | Country code of the location where the event happened                                             | `text`      |
| `port_metro_city`         | Name of the location where the event happened                                                     | `text`      |
| `port_metro_time_zone`    | Name of the time zone where the event happened                                                    | `text`      |
| `facility_id`             | ID of the facility (terminal) where the event happened                                            | `text`      |
| `facility_firms_code`     | Firms code of the facility (terminal) where the event happened                                    | `text`      |
| `facility_nickname`       | Nickname of the facility (terminal) where the event happened                                      | `text`      |
| `facility_name`           | Name of the facility (terminal) where the event happened                                          | `text`      |
| `vessel_id`               | ID of the vessel associated to the event                                                          | `text`      |
| `vessel_name`             | Name of the vessel associated to the event                                                        | `text`      |
| `vessel_imo`              | IMO of the vessel associated to the event                                                         | `text`      |
| `vessel_mmsi`             | MMSI of the vessel associated to the event                                                        | `text`      |
| `voyage_number`           | Voyage number associated to the event                                                             | `text`      |
| `data_source_label`       | Data source of the event: shipping\_line, terminal, ais, rail, t49\_operations\_team, user\_input | `text`      |
| `invalidated_at`          | When the event was marked as invalid, as a UTC timestamp                                          | `timestamp` |
| `invalidation_reason`     | Reason why the event was marked as invalid                                                        | `text`      |
| `previous_version_id`     | If the event replaces an invalidated event, this is the ID of the invalidated event               | `text`      |
| `created_at`              | When the event was originally added, as a UTC timestamp                                           | `timestamp` |
| `updated_at`              | When the event was updated, as a UTC timestamp                                                    | `timestamp` |