# FourKites schema ERD

Table and field reference for the Fivetran FourKites connector.

## Table & Field Reference

### shipment_purchase_order_number

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| shipment_id | Unknown | PK, FK |
| purchase_order_number | Unknown |  |

### shipment_reference_number

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| shipment_id | Unknown | PK, FK |
| reference_number | Unknown |  |

### shipment_stop

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| shipment_id | Unknown | PK, FK |
| arrival_time | Unknown |  |
| city | Unknown |  |
| country | Unknown |  |
| customer_id | Unknown |  |
| customer_name | Unknown |  |
| departure_time | Unknown |  |
| external_address_id | Unknown |  |
| latitude | Unknown |  |
| longitude | Unknown |  |
| schedule_appointment_time | Unknown |  |
| schedule_appointment_window_end | Unknown |  |
| schedule_appointment_window_start | Unknown |  |
| schedule_want_time | Unknown |  |
| sequence | Unknown |  |
| state | Unknown |  |
| status | Unknown |  |
| stop_name | Unknown |  |
| stop_type | Unknown |  |
| timezone | Unknown |  |

### shipment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| four_kites_eta | Unknown |  |
| identifiers_consignment_number | Unknown |  |
| identifiers_consignment_sequence | Unknown |  |
| identifiers_pro_number | Unknown |  |
| latest_location_latitude | Unknown |  |
| latest_location_longitude | Unknown |  |
| latest_location_name | Unknown |  |
| latest_location_timezone | Unknown |  |
| latest_location_updated_time | Unknown |  |
| load_number | Unknown |  |
| number_of_delivery_stop | Unknown |  |
| remaining_distance_in_meter | Unknown |  |
| scac | Unknown |  |
| stakeholder_carrier | Unknown |  |
| stakeholder_shipper | Unknown |  |
| stakeholder_third_party_logistics | Unknown |  |
| status | Unknown |  |
| timezone | Unknown |  |
| total_distance_in_meter | Unknown |  |

### shipment_e_url

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| shipment_id | Unknown | PK, FK |
| data | Unknown |  |

### shipment_stop_e_url

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| shipment_id | Unknown | PK, FK |
| shipment_stop_id | Unknown | PK, FK |
| data | Unknown |  |

## Relationships

- shipment_purchase_order_number(shipment_id) → shipment(id)
- shipment_reference_number(shipment_id) → shipment(id)
- shipment_stop(shipment_id) → shipment(id)
- shipment_e_url(shipment_id) → shipment(id)
- shipment_stop_e_url(shipment_id) → shipment(id)
- shipment_stop_e_url(shipment_stop_id) → shipment_stop(id)