Fivetran documentation

Search the docs

/

Tive

Explore the interactive ERD

Table & Field Reference

location_collaborator

Column	Type	Keys
`index`	Unknown	PK
`account_id`	Unknown	PKFK
`location_id`	Unknown	PKFK
`email`	Unknown
`role_name`	Unknown

location

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	PKFK
`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	PKFK
`public_shipment_id`	Unknown	PKFK
`shipment_id`	Unknown	PKFK

shipment_leg

Column	Type	Keys
`index`	Unknown	PK
`public_shipment_id`	Unknown	PKFK
`shipment_id`	Unknown	PKFK
`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	PKFK
`alert_id`	Unknown	PKFK
`device_alert_detail_index`	Unknown	PKFK
`device_id`	Unknown	PKFK
`reason`	Unknown

device_alert_detail

Column	Type	Keys
`index`	Unknown	PK
`account_id`	Unknown	PKFK
`alert_id`	Unknown	PKFK
`device_id`	Unknown	PKFK
`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	PKFK
`device_id`	Unknown	PKFK
`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	PKFK
`carrier_id`	Unknown	PKFK
`email`	Unknown
`first_name`	Unknown
`languages`	Unknown
`last_name`	Unknown
`phone_number`	Unknown

carrier

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	PKFK
`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	PKFK

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	PKFK
`alert_preset_id`	Unknown	PKFK
`device_id`	Unknown	PKFK

device

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	PKFK
`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	PKFK
`public_shipment_id`	Unknown	PKFK
`shipment_id`	Unknown	PKFK
`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	PKFK
`shipment_id`	Unknown	PKFK
`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	PKFK
`public_shipment_id`	Unknown	PKFK
`shipment_alert_detail_index`	Unknown	PKFK
`shipment_id`	Unknown	PKFK
`reason`	Unknown

shipment_alert_detail

Column	Type	Keys
`index`	Unknown	PK
`alert_id`	Unknown	PKFK
`public_shipment_id`	Unknown	PKFK
`shipment_id`	Unknown	PKFK
`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	PKFK
`shipment_id`	Unknown	PKFK
`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	PKFK
`alert_preset_id`	Unknown	PKFK

alert_preset

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	PKFK
`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	PKFK
`alert_preset_id`	Unknown	PKFK
`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