# Tive schema ERD

Table and field reference for the Fivetran Tive connector.

## Table & Field Reference

### location_collaborator

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| account_id | Unknown | PK, FK |
| location_id | Unknown | PK, FK |
| email | Unknown |  |
| role_name | Unknown |  |

### location

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | PK, FK |
| country | Unknown |  |
| formatted_address | Unknown |  |
| latitude | Unknown |  |
| locality | Unknown |  |
| longitude | Unknown |  |
| name | Unknown |  |
| number_of_shipments_using | Unknown |  |
| postal_code | Unknown |  |
| radius_value | Unknown |  |
| selected_radius_unit | Unknown |  |
| state | Unknown |  |
| street | Unknown |  |
| sublocality | Unknown |  |

### shipment_device

| Column | Type | Keys |
| --- | --- | --- |
| device_id | Unknown | PK, FK |
| public_shipment_id | Unknown | PK, FK |
| shipment_id | Unknown | PK, FK |

### shipment_leg

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| public_shipment_id | Unknown | PK, FK |
| shipment_id | Unknown | PK, FK |
| carrier_id | Unknown | FK |
| airway_bill | Unknown |  |
| container_id | Unknown |  |
| current_eta_utc | Unknown |  |
| distance_left_km | Unknown |  |
| eta_date | Unknown |  |
| from_country | Unknown |  |
| from_latitude | Unknown |  |
| from_locality | Unknown |  |
| from_longitude | Unknown |  |
| from_postalcode | Unknown |  |
| from_state | Unknown |  |
| from_street | Unknown |  |
| is_active_leg_of_shipment | Unknown |  |
| leg_label | Unknown |  |
| mode | Unknown |  |
| order_no | Unknown |  |
| ship_from_date | Unknown |  |
| start_date_time_utc | Unknown |  |
| to_country | Unknown |  |
| to_latitude | Unknown |  |
| to_locality | Unknown |  |
| to_longitude | Unknown |  |
| to_postalcode | Unknown |  |
| to_state | Unknown |  |
| to_street | Unknown |  |

### shipment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| public_shipment_id | Unknown | PK |
| account_id | Unknown | FK |
| auto_complete | Unknown |  |
| auto_complete_minutes_delay | Unknown |  |
| eta_date | Unknown |  |
| is_completed | Unknown |  |
| is_departed | Unknown |  |
| is_shared | Unknown |  |
| is_started | Unknown |  |
| shared_url | Unknown |  |
| ship_from_date | Unknown |  |
| custom_** |  |  |

### device_alert_reason

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| account_id | Unknown | PK, FK |
| alert_id | Unknown | PK, FK |
| device_alert_detail_index | Unknown | PK, FK |
| device_id | Unknown | PK, FK |
| reason | Unknown |  |

### device_alert_detail

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| account_id | Unknown | PK, FK |
| alert_id | Unknown | PK, FK |
| device_id | Unknown | PK, FK |
| country | Unknown |  |
| date_time | Unknown |  |
| formatted_address | Unknown |  |
| latitude | Unknown |  |
| locality | Unknown |  |
| location_method | Unknown |  |
| location_name | Unknown |  |
| longitude | Unknown |  |
| postalcode | Unknown |  |
| state | Unknown |  |
| street | Unknown |  |
| sublocality | Unknown |  |
| type | Unknown |  |

### device_alert

| Column | Type | Keys |
| --- | --- | --- |
| alert_id | Unknown | PK |
| account_id | Unknown | PK, FK |
| device_id | Unknown | PK, FK |
| alert_preset_id | Unknown | FK |
| public_shipment_id | Unknown | FK |
| shipment_id | Unknown | FK |
| alert_on | Unknown |  |
| interval_delay | Unknown |  |
| interval_delay_unit | Unknown |  |
| is_active_at_destination | Unknown |  |
| is_active_at_origin | Unknown |  |
| is_active_in_transit | Unknown |  |
| is_closed | Unknown |  |
| is_enabled | Unknown |  |
| trigger_unit | Unknown |  |
| trigger_value | Unknown |  |
| type | Unknown |  |

### carrier_contact

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | PK, FK |
| carrier_id | Unknown | PK, FK |
| email | Unknown |  |
| first_name | Unknown |  |
| languages | Unknown |  |
| last_name | Unknown |  |
| phone_number | Unknown |  |

### carrier

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | PK, FK |
| mode | Unknown |  |
| name | Unknown |  |
| standardized_carrier_id | Unknown |  |
| standardized_carrier_name | Unknown |  |

### account_user_id

| Column | Type | Keys |
| --- | --- | --- |
| user_id | Unknown | PK |
| account_id | Unknown | PK, FK |

### account

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_name | Unknown |  |
| autocomplete_shipment_delay_minute | Unknown |  |
| disabled | Unknown |  |
| webhook_id | Json |  |

### device_alert_preset_id

| Column | Type | Keys |
| --- | --- | --- |
| account_id | Unknown | PK, FK |
| alert_preset_id | Unknown | PK, FK |
| device_id | Unknown | PK, FK |

### device

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | PK, FK |
| battery_percent | Unknown |  |
| device_name | Unknown |  |
| device_owner | Unknown |  |
| estimated_battery_life_minutes | Unknown |  |
| gps_enabled | Unknown |  |
| measurement_interval | Unknown |  |
| power_button_enabled | Unknown |  |
| transmission_interval | Unknown |  |
| wifi_enabled | Unknown |  |

### shipment_tracker_data

| Column | Type | Keys |
| --- | --- | --- |
| measurement_time | Unknown | PK |
| device_id | Unknown | PK, FK |
| public_shipment_id | Unknown | PK, FK |
| shipment_id | Unknown | PK, FK |
| account_id | Unknown | FK |
| acceleration_g | Unknown |  |
| acceleration_x | Unknown |  |
| acceleration_y | Unknown |  |
| acceleration_z | Unknown |  |
| battery | Unknown |  |
| coordinates_latitude | Unknown |  |
| coordinates_longitude | Unknown |  |
| humidity | Unknown |  |
| light | Unknown |  |
| location | Unknown |  |
| location_method | Unknown |  |
| motion | Unknown |  |
| pressure | Unknown |  |
| probe_temperature | Unknown |  |
| process_time | Unknown |  |
| temperature | Unknown |  |

### shipment_status

| Column | Type | Keys |
| --- | --- | --- |
| public_shipment_id | Unknown | PK, FK |
| shipment_id | Unknown | PK, FK |
| account_id | Unknown | FK |
| completed_at | Unknown |  |
| completed_by_user | Unknown |  |
| country | Unknown |  |
| current_humidity | Unknown |  |
| current_light | Unknown |  |
| current_locationformatted_address | Unknown |  |
| current_locationlocation_method | Unknown |  |
| current_locationname | Unknown |  |
| current_pressure | Unknown |  |
| current_probe_temperature | Unknown |  |
| current_temperature | Unknown |  |
| degree_minutes_temperature | Unknown |  |
| delivered_at | Unknown |  |
| departed_at | Unknown |  |
| distance_remaining | Unknown |  |
| distance_travelled | Unknown |  |
| last_updated_at | Unknown |  |
| latitude | Unknown |  |
| locality | Unknown |  |
| longitude | Unknown |  |
| mean_kinetic_temperature | Unknown |  |
| postal_code | Unknown |  |
| standard_deviation_temperature | Unknown |  |
| started_at | Unknown |  |
| started_by_user | Unknown |  |
| state | Unknown |  |
| street | Unknown |  |
| total_distance | Unknown |  |

### shipment_alert_reason

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| alert_id | Unknown | PK, FK |
| public_shipment_id | Unknown | PK, FK |
| shipment_alert_detail_index | Unknown | PK, FK |
| shipment_id | Unknown | PK, FK |
| reason | Unknown |  |

### shipment_alert_detail

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| alert_id | Unknown | PK, FK |
| public_shipment_id | Unknown | PK, FK |
| shipment_id | Unknown | PK, FK |
| celsius | Unknown |  |
| date_time | Unknown |  |
| fahrenheit | Unknown |  |
| location_coordinates_latitude | Unknown |  |
| location_coordinates_longitude | Unknown |  |
| location_formatted_address | Unknown |  |
| location_location_method | Unknown |  |
| type | Unknown |  |

### shipment_alert

| Column | Type | Keys |
| --- | --- | --- |
| alert_id | Unknown | PK |
| public_shipment_id | Unknown | PK, FK |
| shipment_id | Unknown | PK, FK |
| account_id | Unknown | FK |
| alert_preset_id | Unknown | FK |
| device_id | Unknown | FK |
| alert_on | Unknown |  |
| interval_delay | Unknown |  |
| interval_delay_unit | Unknown |  |
| is_active_at_destination | Unknown |  |
| is_active_at_origin | Unknown |  |
| is_active_in_transit | Unknown |  |
| is_closed | Unknown |  |
| is_enabled | Unknown |  |
| trigger_unit | Unknown |  |
| trigger_value | Unknown |  |
| type | Unknown |  |

### alert_preset_assignee

| Column | Type | Keys |
| --- | --- | --- |
| assignee | Unknown | PK |
| account_id | Unknown | PK, FK |
| alert_preset_id | Unknown | PK, FK |

### alert_preset

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | PK, FK |
| description | Unknown |  |
| name | Unknown |  |
| notify_all_collaborators | Unknown |  |
| notify_when_active | Unknown |  |

### alert_preset_trigger

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| trigger_type | Unknown | PK |
| account_id | Unknown | PK, FK |
| alert_preset_id | Unknown | PK, FK |
| interval_delay | Unknown |  |
| interval_delay_unit | Unknown |  |
| is_active_at_destination | Unknown |  |
| is_active_at_origin | Unknown |  |
| is_active_in_transit | Unknown |  |
| trigger_unit | Unknown |  |
| trigger_value | Unknown |  |
| type | Unknown |  |

## Relationships

- location_collaborator(account_id) → location(account_id)
- location_collaborator(location_id) → location(id)
- location(account_id) → account(id)
- shipment_device(device_id) → device(id)
- shipment_device(shipment_id) → shipment(id)
- shipment_device(public_shipment_id) → shipment(public_shipment_id)
- shipment_leg(carrier_id) → carrier(id)
- shipment_leg(shipment_id) → shipment(id)
- shipment_leg(public_shipment_id) → shipment(public_shipment_id)
- shipment(account_id) → account(id)
- device_alert_reason(device_alert_detail_index) → device_alert_detail(index)
- device_alert_reason(account_id) → device_alert(account_id)
- device_alert_reason(device_id) → device_alert(device_id)
- device_alert_reason(alert_id) → device_alert(alert_id)
- device_alert_detail(account_id) → device_alert(account_id)
- device_alert_detail(device_id) → device_alert(device_id)
- device_alert_detail(alert_id) → device_alert(alert_id)
- device_alert(device_id) → device(id)
- device_alert(account_id) → account(id)
- device_alert(shipment_id) → shipment(id)
- device_alert(public_shipment_id) → shipment(public_shipment_id)
- device_alert(alert_preset_id) → alert_preset(id)
- carrier_contact(carrier_id) → carrier(id)
- carrier_contact(account_id) → carrier(account_id)
- carrier(account_id) → account(id)
- account_user_id(account_id) → account(id)
- device_alert_preset_id(alert_preset_id) → alert_preset(id)
- device_alert_preset_id(device_id) → device(id)
- device_alert_preset_id(account_id) → device(account_id)
- device(account_id) → account(id)
- shipment_tracker_data(device_id) → device(id)
- shipment_tracker_data(account_id) → account(id)
- shipment_tracker_data(public_shipment_id) → shipment(public_shipment_id)
- shipment_tracker_data(shipment_id) → shipment(id)
- shipment_status(public_shipment_id) → shipment(public_shipment_id)
- shipment_status(shipment_id) → shipment(id)
- shipment_status(account_id) → account(id)
- shipment_alert_reason(shipment_alert_detail_index) → shipment_alert_detail(index)
- shipment_alert_reason(alert_id) → shipment_alert(alert_id)
- shipment_alert_reason(shipment_id) → shipment_alert(shipment_id)
- shipment_alert_reason(public_shipment_id) → shipment_alert(public_shipment_id)
- shipment_alert_detail(alert_id) → shipment_alert(alert_id)
- shipment_alert_detail(shipment_id) → shipment_alert(shipment_id)
- shipment_alert_detail(public_shipment_id) → shipment_alert(public_shipment_id)
- shipment_alert(shipment_id) → shipment(id)
- shipment_alert(public_shipment_id) → shipment(public_shipment_id)
- shipment_alert(account_id) → account(id)
- shipment_alert(device_id) → device(id)
- shipment_alert(alert_preset_id) → alert_preset(id)
- alert_preset_assignee(account_id) → alert_preset(account_id)
- alert_preset_assignee(alert_preset_id) → alert_preset(id)
- alert_preset(account_id) → account(id)
- alert_preset_trigger(account_id) → alert_preset(account_id)
- alert_preset_trigger(alert_preset_id) → alert_preset(id)