# Samsara schema ERD

Table and field reference for the Fivetran Samsara connector.

## Table & Field Reference

### driver

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| peer_group_tag_id | String | FK |
| static_assigned_vehicle_id | String | FK |
| vehicle_group_tag_id | String | FK |
| carrier_settings_carrier_name | String |  |
| carrier_settings_dot_number | Long |  |
| carrier_settings_home_terminal_address | String |  |
| carrier_settings_home_terminal_name | String |  |
| carrier_settings_main_office_address | String |  |
| created_at_time | Unknown |  |
| current_id_card_code | String |  |
| driver_activation_status | String |  |
| eld_adverse_weather_exemption_enabled | Boolean |  |
| eld_big_day_exemption_enabled | Boolean |  |
| eld_day_start_hour | Long |  |
| eld_exempt | Boolean |  |
| eld_exempt_reason | String |  |
| eld_pc_enabled | Boolean |  |
| eld_ym_enabled | Boolean |  |
| external_id | Json |  |
| has_driving_features_hidden | Boolean |  |
| has_vehicle_unpinning_enabled | Boolean |  |
| heavy_haul_exemption_toggle_enabled | Boolean |  |
| license_number | String |  |
| license_state | String |  |
| locale | String |  |
| name | String |  |
| notes | String |  |
| phone_number | Unknown |  |
| tachograph_card_number | String |  |
| timezone | String |  |
| updated_at_time | Unknown |  |
| us_driver_ruleset_override_break | String |  |
| us_driver_ruleset_override_cycle | String |  |
| us_driver_ruleset_override_restart | String |  |
| us_driver_ruleset_override_us_state_to_override | String |  |
| username | String |  |
| waiting_time_duty_status_enabled | Boolean |  |

### tag_driver

| Column | Type | Keys |
| --- | --- | --- |
| driver_id | String | PK |
| index | Unknown | PK |
| tag_id | String | FK |

### driver_attribute

| Column | Type | Keys |
| --- | --- | --- |
| driver_id | String | PK |
| index | Unknown | PK |
| id | Unknown |  |
| name | Unknown |  |
| number_values | Json |  |
| string_values | Json |  |

### driver_ruleset

| Column | Type | Keys |
| --- | --- | --- |
| driver_id | String | PK |
| index | Unknown | PK |
| break | Unknown |  |
| cycle | Unknown |  |
| jurisdiction | Unknown |  |
| restart | Unknown |  |
| shift | Unknown |  |

### tags

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| parent_tag_id | String | FK |
| external_id | Json |  |
| name | String |  |

### hos_daily_log

| Column | Type | Keys |
| --- | --- | --- |
| end_time | Unknown | PK |
| start_time | Unknown | PK |
| driver_id | Unknown | PK, FK |
| active_duration_ms | Unknown |  |
| adverse_driving_claimed | Unknown |  |
| big_day_claimed | Unknown |  |
| carrier_formatted_address | Unknown |  |
| carrier_name | Unknown |  |
| carrier_us_dot_number | Unknown |  |
| certified_at_time | Unknown |  |
| drive_distance_meters | Unknown |  |
| drive_duration_ms | Unknown |  |
| home_terminal_formatted_address | Unknown |  |
| home_terminal_name | Unknown |  |
| is_certified | Unknown |  |
| is_us_short_haul_active | Unknown |  |
| off_duty_duration_ms | Unknown |  |
| on_duty_duration_ms | Unknown |  |
| pending_active_duration_ms | Unknown |  |
| pending_drive_duration_ms | Unknown |  |
| pending_off_duty_duration_ms | Unknown |  |
| pending_on_duty_duration_ms | Unknown |  |
| pending_personal_conveyance_duration_ms | Unknown |  |
| pending_sleeper_berth_duration_ms | Unknown |  |
| pending_waiting_time_duration_ms | Unknown |  |
| pending_yard_move_duration_ms | Unknown |  |
| personal_conveyance_distance_meters | Unknown |  |
| personal_conveyance_duration_ms | Unknown |  |
| shipping_docs | Unknown |  |
| sleeper_berth_duration_ms | Unknown |  |
| waiting_time_duration_ms | Unknown |  |
| yard_move_distance_meters | Unknown |  |
| yard_move_duration_ms | Unknown |  |

### route_stop

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| address_id | String | FK |
| route_id | String | FK |
| actual_arrival_time | Unknown |  |
| actual_departure_time | Unknown |  |
| en_route_time | Unknown |  |
| eta | Instant |  |
| external_id | Json |  |
| live_sharing_url | String |  |
| name | String |  |
| notes | String |  |
| scheduled_arrival_time | Unknown |  |
| scheduled_departure_time | Unknown |  |
| single_use_location_address | String |  |
| single_use_location_latitude | Double |  |
| single_use_location_longitude | Double |  |
| skipped_time | Unknown |  |
| state | String |  |

### route

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| driver_id | String | FK |
| vehicle_id | String | FK |
| actual_route_end_time | Unknown |  |
| actual_route_start_time | Unknown |  |
| completion_condition | String |  |
| external_id | Json |  |
| name | String |  |
| notes | String |  |
| scheduled_route_end_time | Unknown |  |
| scheduled_route_start_time | Unknown |  |
| starting_condition | String |  |

### hub_location_service_window

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| hub_location_id | String | PK, FK |
| days_of_week | Json |  |
| end_time | String |  |
| start_time | String |  |

### hub_location_skill_required

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| hub_location_id | String | PK, FK |
| name | String |  |
| skill_id | String |  |

### hub_location

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| address | String |  |
| created_at | Unknown |  |
| customer_location_id | String |  |
| driver_instructions | String |  |
| hub_id | String |  |
| is_depot | Boolean |  |
| latitude | Double |  |
| longitude | Double |  |
| name | String |  |
| planner_notes | String |  |
| service_time_seconds | Long |  |
| updated_at | Unknown |  |

### conditional_field_section

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| document_id | String | FK |
| conditional_field_first_index | Long |  |
| conditional_field_last_index | Long |  |
| triggering_field_index | Long |  |
| triggering_field_value | String |  |

### document_field

| Column | Type | Keys |
| --- | --- | --- |
| label | String | PK |
| document_id | String | PK, FK |
| type | String |  |
| value_** |  |  |

### document

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| driver_id | String | FK |
| route_id | String | FK |
| route_stop_id | String | FK |
| vehicle_id | String | FK |
| created_at_time | Unknown |  |
| document_type_id | String |  |
| document_type_name | String |  |
| name | String |  |
| notes | String |  |
| state | String |  |
| updated_at_time | Unknown |  |

### alert_incident_conditions

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| configuration_id | Unknown | PK, FK |
| updated_at_time | Unknown | PK, FK |
| description | Unknown |  |
| details | Json |  |
| trigger_id | Unknown |  |

### alert_incident

| Column | Type | Keys |
| --- | --- | --- |
| configuration_id | Unknown | PK |
| updated_at_time | Unknown | PK |
| happened_at_time | Unknown |  |
| incident_url | Unknown |  |
| is_resolved | Unknown |  |
| resolved_at_time | Unknown |  |

### tag_vehicle

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| vehicle_id | String | PK, FK |
| tag_id | String | FK |

### vehicle

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| gateway_serial | String | FK |
| aux_input_1 | String |  |
| aux_input_10 | String |  |
| aux_input_11 | String |  |
| aux_input_12 | String |  |
| aux_input_13 | String |  |
| aux_input_2 | String |  |
| aux_input_3 | String |  |
| aux_input_4 | String |  |
| aux_input_5 | String |  |
| aux_input_6 | String |  |
| aux_input_7 | String |  |
| aux_input_8 | String |  |
| aux_input_9 | String |  |
| created_at_time | Unknown |  |
| engine_serial_number | String |  |
| external_id | Json |  |
| harsh_acceleration_setting | String |  |
| license_plate | String |  |
| make | String |  |
| model | String |  |
| name | String |  |
| notes | String |  |
| updated_at_time | Unknown |  |
| vehicle_regulation_mode | String |  |
| vin | String |  |
| year | String |  |

### tag_trailer

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| trailer_id | String | PK, FK |
| tag_id | String | FK |

### trailer

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| gateway_serial | String | FK |
| enabled_for_mobile | Boolean |  |
| external_id | Json |  |
| license_plate | String |  |
| name | String |  |
| notes | String |  |
| trailer_serial_number | String |  |

### vehicle_trip_asset

| Column | Type | Keys |
| --- | --- | --- |
| trailer_id | Long | PK |
| vehicle_trip_end_ms | Unknown | FK |
| vehicle_trip_start_ms | Unknown | FK |
| vehicle_trip_vehicle_id | String | FK |

### vehicle_trip_codriver

| Column | Type | Keys |
| --- | --- | --- |
| codriver_id | Long | PK, FK |
| vehicle_trip_end_ms | Unknown | FK |
| vehicle_trip_start_ms | Unknown | FK |
| vehicle_trip_vehicle_id | String | FK |

### vehicle_trip

| Column | Type | Keys |
| --- | --- | --- |
| end_ms | Unknown | PK |
| start_ms | Unknown | PK |
| vehicle_id | String | PK, FK |
| driver_id | Long | FK |
| end_address_id | String | FK |
| start_address_id | Long | FK |
| distance_meters | Long |  |
| end_coordinates_latitude | Double |  |
| end_coordinates_longitude | Double |  |
| end_location | String |  |
| end_odometer | Long |  |
| fuel_consumed_ml | Long |  |
| start_coordinates_latitude | Double |  |
| start_coordinates_longitude | Double |  |
| start_location | String |  |
| start_odometer | Long |  |
| toll_meters | Long |  |

### tag_address

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| address_id | String | PK, FK |
| tag_id | String | FK |

### address

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| created_at_time | Unknown |  |
| external_id | Json |  |
| formatted_address | String |  |
| latitude | Double |  |
| longitude | Double |  |
| name | String |  |
| notes | String |  |
| settings_show_address | Boolean |  |
| type | Json |  |

### form_template_field_option

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| form_template_field_id | Unknown | PK, FK |
| form_template_id | Unknown | PK, FK |
| ignore_question_from_score_if_selected | Unknown |  |
| label | Unknown |  |
| option_score_weight | Unknown |  |

### form_template_field_conditional_action

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| form_template_field_id | Unknown | PK, FK |
| form_template_id | Unknown | PK, FK |
| actions | Json |  |
| condition_selected_option_id | Json |  |
| condition_type | Unknown |  |

### form_template_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| form_template_id | Unknown | PK, FK |
| allow_manual_entry | Unknown |  |
| allowed_asset_type | Json |  |
| allowed_data_time_value_type | Unknown |  |
| auto_fill_form_id | Unknown |  |
| filter_by_role_id | Json |  |
| included_driver | Unknown |  |
| included_user | Unknown |  |
| is_auto_fill_source | Unknown |  |
| is_required | Unknown |  |
| label | Unknown |  |
| num_decimal_places | Unknown |  |
| question_weight | Unknown |  |
| type | Unknown |  |

### form_template_section

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| form_template_id | Unknown | PK, FK |
| field_index_first_inclusive | Unknown |  |
| field_index_last_inclusive | Unknown |  |
| label | Unknown |  |

### form_template

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| approval_config_allow_manual_approver_selection | Unknown |  |
| approval_config_requirement_role_id | Json |  |
| approval_config_type | Unknown |  |
| created_at_time | Unknown |  |
| created_by_id | Unknown |  |
| created_by_type | Unknown |  |
| description | Unknown |  |
| form_category | Unknown |  |
| revision_id | Unknown |  |
| title | Unknown |  |
| updated_at_time | Unknown |  |
| updated_by_id | Unknown |  |
| updated_by_type | Unknown |  |

### tag_equipment

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| equipment_id | String | PK, FK |
| tag_id | String | FK |

### equipment

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| gateway_serial | String | FK |
| equipment_serial_number | String |  |
| name | String |  |
| notes | String |  |

### user_role

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| users_id | String | PK, FK |
| tag_id | String | FK |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| auth_type | String |  |
| email | String |  |
| name | String |  |

### reading_history_feed

| Column | Type | Keys |
| --- | --- | --- |
| happened_at_time | Unknown | PK |
| id | Unknown | PK |
| reading_definition_id | Unknown | PK, FK |
| entity_type | Unknown |  |
| external_id | Json |  |
| value | Unknown |  |

### reading_snapshot

| Column | Type | Keys |
| --- | --- | --- |
| happened_at_time | Unknown | PK |
| id | Unknown | PK |
| reading_definition_id | Unknown | PK, FK |
| entity_type | Unknown |  |
| external_id | Json |  |
| value | Unknown |  |

### equipment_stats

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| gateway_engine_seconds_time | Unknown |  |
| gateway_engine_seconds_value | Unknown |  |
| gps_odometer_meters_time | Unknown |  |
| gps_odometer_meters_value | Unknown |  |
| obd_engine_seconds_time | Unknown |  |
| obd_engine_seconds_value | Unknown |  |

### reading_definition_enum_value

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| reading_definition_id | Unknown | PK, FK |
| label | Unknown |  |
| symbol | Unknown |  |

### reading_definition

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| category | Unknown |  |
| description | Unknown |  |
| entity_type | Unknown |  |
| ingestion_enabled | Unknown |  |
| label | Unknown |  |
| type | Unknown |  |

### accessory_device

| Column | Type | Keys |
| --- | --- | --- |
| serial | String | PK |
| gateway_id | String | FK |
| model | String |  |

### gateway

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| connection_status_health_status | String |  |
| connection_status_last_connected | Unknown |  |
| model | String |  |
| serial | String |  |
| thirty_day_data_usage_bytes | Long |  |
| thirty_day_hotspot_usage_bytes | Long |  |

### engine_rpm

| Column | Type | Keys |
| --- | --- | --- |
| time | Unknown | PK |
| vehicle_id | String | PK, FK |
| value | Unknown |  |

### ambient_air_temperature_milli_c

| Column | Type | Keys |
| --- | --- | --- |
| time | Unknown | PK |
| vehicle_id | String | PK, FK |
| value | Unknown |  |

### barometric_pressure_pa

| Column | Type | Keys |
| --- | --- | --- |
| time | Unknown | PK |
| vehicle_id | String | PK, FK |
| value | Unknown |  |

### defect_photo

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| defect_id | Unknown | PK, FK |
| created_at_time | Unknown |  |
| url | Unknown |  |

### defect

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| dvir_id | Unknown | FK |
| resolved_by_id | Unknown | FK |
| trailer_id | Unknown | FK |
| vehicle_id | Unknown | FK |
| comment | Unknown |  |
| created_at_time | Unknown |  |
| defect_safety_status | Unknown |  |
| defect_type_id | Unknown |  |
| is_resolved | Unknown |  |
| mechanic_note | Unknown |  |
| resolved_at_time | Unknown |  |
| updated_at_time | Instant |  |

### dvir_trailer_defect

| Column | Type | Keys |
| --- | --- | --- |
| dvir_id | String | PK, FK |
| trailer_defect_id | Unknown | PK, FK |

### dvir_vehicle_defect

| Column | Type | Keys |
| --- | --- | --- |
| dvir_id | String | PK, FK |
| vechile_defect_id | Unknown | PK, FK |

### dvir

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| author_signature_signatory_user_id | String | FK |
| second_signature_signatory_user_id | String | FK |
| third_signature_signatory_user_id | String | FK |
| trailer_id | String | FK |
| vehicle_id | String | FK |
| author_signature_signatory_user_name | String |  |
| author_signature_signed_at_time | Unknown |  |
| author_signature_type | String |  |
| end_time | Unknown |  |
| location | String |  |
| mechanic_notes | String |  |
| odometer_meters | Long |  |
| safety_status | String |  |
| second_signature_signatory_user_name | String |  |
| second_signature_signed_at_time | Unknown |  |
| second_signature_type | String |  |
| start_time | Unknown |  |
| third_signature_signatory_user_name | String |  |
| third_signature_signed_at_time | Unknown |  |
| third_signature_type | String |  |
| type | String |  |

### hos_log_codriver

| Column | Type | Keys |
| --- | --- | --- |
| codriver_id | String | PK, FK |
| hos_log_log_end_time | Unknown | PK, FK |
| hos_log_log_start_time | Unknown | PK, FK |
| hos_log_vehicle_id | String | PK, FK |

### hos_log

| Column | Type | Keys |
| --- | --- | --- |
| log_end_time | Unknown | PK |
| log_start_time | Unknown | PK |
| vehicle_id | String | PK, FK |
| driver_id | String | FK |
| hos_status_type | String |  |
| log_recorded_location_latitude | Double |  |
| log_recorded_location_longitude | Double |  |
| remark | String |  |

### vehicle_idling_report

| Column | Type | Keys |
| --- | --- | --- |
| event_uuid | Unknown | PK |
| address_id | Unknown | FK |
| driver_id | Unknown | FK |
| vehicle_id | Unknown | FK |
| air_temperature_millicelsius | Unknown |  |
| duration_milliseconds | Unknown |  |
| fuel_consumed_milliliters | Unknown |  |
| fuel_cost_amount | Unknown |  |
| fuel_cost_currency | Unknown |  |
| gaseous_fuel_consumed_grams | Unknown |  |
| gaseous_fuel_cost_amount | Unknown |  |
| gaseous_fuel_cost_currency | Unknown |  |
| latitude | Unknown |  |
| longitude | Unknown |  |
| pto_state | Unknown |  |
| start_time | Unknown |  |

### j_1939_diagnostic_trouble_code

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| fault_code_time | Unknown | FK |
| fault_code_vehicle_id | String | FK |
| fmi_description | String |  |
| fmi_id | Long |  |
| mil_status | Long |  |
| occurrence_count | Long |  |
| source_address_name | String |  |
| spn_description | String |  |
| spn_id | Long |  |
| tx_id | Long |  |
| vendor_specific_fields_dtc_description | String |  |
| vendor_specific_fields_repair_instructions_url | String |  |

### obdii_diagnostic_trouble_code

| Column | Type | Keys |
| --- | --- | --- |
| tx_id | Long | PK |
| fault_code_time | Unknown | FK |
| fault_code_vehicle_id | String | FK |
| ignition_type | String |  |
| mil_status | Boolean |  |
| monitor_status_catalyst | String |  |
| monitor_status_comprehensive | String |  |
| monitor_status_egr | String |  |
| monitor_status_evap_system | String |  |
| monitor_status_fuel | String |  |
| monitor_status_heated_catalyst | String |  |
| monitor_status_heated_o_2_sensor | String |  |
| monitor_status_iso_sae_reserved | String |  |
| monitor_status_misfire | String |  |
| monitor_status_not_ready_count | Long |  |
| monitor_status_o_2_sensor | String |  |
| monitor_status_secondary_air | String |  |

### oem_diagnostic_trouble_code

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| fault_code_time | Unknown | FK |
| fault_code_vehicle_id | String | FK |
| code_description | String |  |
| code_identifier | String |  |
| code_severity | String |  |
| code_source | String |  |

### fault_code

| Column | Type | Keys |
| --- | --- | --- |
| time | Unknown | PK |
| vehicle_id | String | PK, FK |
| can_bus_type | String |  |
| j_1939_check_engine_lights_emissions_is_on | Boolean |  |
| j_1939_check_engine_lights_protect_is_on | Boolean |  |
| j_1939_check_engine_lights_stop_is_on | Boolean |  |
| j_1939_check_engine_lights_warning_is_on | Boolean |  |
| obdii_check_engine_light_is_on | Boolean |  |

### fuel_percent

| Column | Type | Keys |
| --- | --- | --- |
| time | Unknown | PK |
| vehicle_id | String | PK, FK |
| value | Long |  |

### battery_milli_volt

| Column | Type | Keys |
| --- | --- | --- |
| time | Unknown | PK |
| vehicle_id | String | PK, FK |
| value | Long |  |

### dtc

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| tx_id | Long | FK |
| dtc_description | String |  |
| dtc_id | Long |  |
| dtc_short_code | String |  |
| dtc_type | Unknown |  |

### aux_input

| Column | Type | Keys |
| --- | --- | --- |
| time | Unknown | PK |
| vehicle_id | String | PK |
| name | String |  |
| type | Unknown |  |
| value | Boolean |  |

### fuel_energy_by_driver_report

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| distance_traveled_meters | Unknown |  |
| efficiency_mpge | Unknown |  |
| energy_used_kwh | Unknown |  |
| engine_idle_time_duration_milli_seconds | Unknown |  |
| engine_runtime_duration_milli_seconds | Unknown |  |
| est_carbon_emission_kg | Unknown |  |
| est_fuel_energy_cost_amount | Unknown |  |
| est_fuel_energy_cost_currency_code | Unknown |  |
| fuel_consumed_ml | Unknown |  |

### gps

| Column | Type | Keys |
| --- | --- | --- |
| time | Unknown | PK |
| vehicle_id | String | PK, FK |
| address_id | String | FK |
| heading_degrees | Double |  |
| is_ecu_speed | Boolean |  |
| latitude | Double |  |
| longitude | Double |  |
| reverse_geo_formatted_location | String |  |
| speed_miles_per_hour | Double |  |

### driver_hos_violation

| Column | Type | Keys |
| --- | --- | --- |
| day_start_time | Unknown | PK |
| type | String | PK |
| driver_id | String | PK, FK |
| day_end_time | Unknown |  |
| description | String |  |
| duration_ms | Unknown |  |
| violation_start_time | Unknown |  |

### stream_dvir_defect

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| stream_dvir_id | Unknown | PK, FK |
| defect_id | Unknown | FK |

### stream_dvir

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| author_signature_signatory_user_id | String | FK |
| second_signature_signatory_user_id | String | FK |
| third_signature_signatory_user_id | String | FK |
| trailer_id | String | FK |
| vehicle_id | String | FK |
| author_signature_signed_at_time | Unknown |  |
| author_signature_type | String |  |
| dvir_submission_begin_time | Unknown |  |
| dvir_submission_time | Unknown |  |
| formatted_address | Unknown |  |
| mechanic_notes | Unknown |  |
| odometer_meters | Unknown |  |
| safety_status | Unknown |  |
| second_signature_signed_at_time | Unknown |  |
| second_signature_type | String |  |
| third_signature_signed_at_time | Unknown |  |
| third_signature_type | String |  |
| type | Unknown |  |
| updated_at_time | Unknown |  |

### gps_distance_meter

| Column | Type | Keys |
| --- | --- | --- |
| time | Unknown | PK |
| vehicle_id | String | PK, FK |
| value | Double |  |

### gps_odometer

| Column | Type | Keys |
| --- | --- | --- |
| time | Unknown | PK |
| vehicle_id | String | PK, FK |
| value | Long |  |

### obd_odometer

| Column | Type | Keys |
| --- | --- | --- |
| time | Unknown | PK |
| vehicle_id | String | PK, FK |
| value | Long |  |

### ecu_speed_mph

| Column | Type | Keys |
| --- | --- | --- |
| time | Unknown | PK |
| vehicle_id | String | PK, FK |
| value | Unknown |  |

### engine_coolant_temperature_milli_c

| Column | Type | Keys |
| --- | --- | --- |
| time | Unknown | PK |
| vehicle_id | String | PK, FK |
| value | Unknown |  |

### engine_load_percent

| Column | Type | Keys |
| --- | --- | --- |
| time | Unknown | PK |
| vehicle_id | String | PK, FK |
| value | Unknown |  |

### intake_manifold_temperature_milli_c

| Column | Type | Keys |
| --- | --- | --- |
| time | Unknown | PK |
| vehicle_id | String | PK, FK |
| value | Unknown |  |

### safety_event_asset_attribute

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| safety_event_id | Unknown | PK, FK |
| date_values | Json |  |
| id | Unknown |  |
| name | Unknown |  |
| number_values | Json |  |
| string_values | Json |  |

### safety_event_asset_tag

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| safety_event_id | Unknown | PK, FK |
| parent_tag_id | Unknown | FK |

### safety_event_behavior_label

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| safety_event_id | Unknown | PK, FK |
| label | Unknown |  |
| source | Unknown |  |

### safety_event_context_label

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| safety_event_id | Unknown | PK, FK |
| created_at_time | Unknown |  |
| id | Unknown |  |
| name | Unknown |  |

### safety_event_detected_stream

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| safety_event_id | Unknown | PK, FK |
| auxcam_serial | Unknown |  |
| camera_role | Unknown |  |
| input | Unknown |  |
| url | Unknown |  |

### safety_event_media

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| safety_event_id | Unknown | PK, FK |
| auxcam_serial | Unknown |  |
| camera_role | Unknown |  |
| input | Unknown |  |
| url | Unknown |  |

### safety_event

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| driver_id | Unknown | FK |
| updated_by_user_id | Unknown | FK |
| asset_external_id | Json |  |
| asset_id | Unknown |  |
| asset_name | Unknown |  |
| asset_type | Unknown |  |
| asset_vin | Unknown |  |
| assigned_coach | Unknown |  |
| created_time | Unknown |  |
| dismissal_reason_code | Unknown |  |
| dismissal_reason_comment | Unknown |  |
| end_ms | Unknown |  |
| event_state | Unknown |  |
| inbox_event_url | Unknown |  |
| incident_report_url | Unknown |  |
| location_accuracy_meters | Unknown |  |
| location_city | Unknown |  |
| location_country | Unknown |  |
| location_external_ids | Json |  |
| location_geofence_id | Unknown |  |
| location_heading_degrees | Unknown |  |
| location_latitude | Unknown |  |
| location_longitude | Unknown |  |
| location_neighborhood | Unknown |  |
| location_point_of_interest | Unknown |  |
| location_postal_code | Unknown |  |
| location_state | Unknown |  |
| location_street | Unknown |  |
| location_street_number | Unknown |  |
| max_acceleration_g_force | Unknown |  |
| name | Unknown |  |
| speeding_metadata_max_speed_kilometers_per_hour | Unknown |  |
| speeding_metadata_posted_speed_limit_kilometers_per_hour | Unknown |  |
| start_ms | Unknown |  |
| trip_end_time | Unknown |  |
| trip_start_time | Unknown |  |
| updated_at_time | Unknown |  |

### fuel_energy_by_vehicle_report

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| distance_traveled_meters | Unknown |  |
| efficiency_mpge | Unknown |  |
| energy_type | Unknown |  |
| energy_used_kwh | Unknown |  |
| engine_idle_time_duration_milli_seconds | Unknown |  |
| engine_runtime_duration_milli_seconds | Unknown |  |
| est_carbon_emission_kg | Unknown |  |
| est_fuel_energy_cost_amount | Unknown |  |
| est_fuel_energy_cost_currency_code | Unknown |  |
| fuel_consumed_ml | Unknown |  |

### obd_engine_second

| Column | Type | Keys |
| --- | --- | --- |
| time | Unknown | PK |
| vehicle_id | String | PK, FK |
| value | Long |  |

### synthetic_engine_second

| Column | Type | Keys |
| --- | --- | --- |
| time | Unknown | PK |
| vehicle_id | String | PK, FK |
| value | Long |  |

### engine_state

| Column | Type | Keys |
| --- | --- | --- |
| time | Unknown | PK |
| vehicle_id | String | PK, FK |
| value | String |  |

### form_submission_stream_field_media_list

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| form_submission_stream_field_id | Unknown | PK, FK |
| form_submission_stream_id | Unknown | PK, FK |
| processing_status | Unknown |  |
| url | Unknown |  |
| url_expires_at | Instant |  |

### form_submission_stream_field_table_volume_column

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| form_submission_stream_field_id | Unknown | PK, FK |
| form_submission_stream_id | Unknown | PK, FK |
| label | Unknown |  |
| type | Unknown |  |

### form_submission_stream_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| form_submission_stream_id | Unknown | PK, FK |
| asset_value_entry_type | Unknown |  |
| asset_value_external_id | Json |  |
| asset_value_id | Unknown |  |
| asset_value_name | Unknown |  |
| check_boxes_value | Json |  |
| data_time_value | Unknown |  |
| data_time_value_type | Unknown |  |
| geofence_value_address | Unknown |  |
| geofence_value_entry_type | Unknown |  |
| geofence_value_external_id | Json |  |
| geofence_value_id | Unknown |  |
| geofence_value_name | Unknown |  |
| issue_external_id | Json |  |
| issue_id | Unknown |  |
| label | Unknown |  |
| multiple_choice_value | Unknown |  |
| multiple_choice_value_id | Unknown |  |
| note | Unknown |  |
| number_value | Unknown |  |
| person_value_entry_type | Unknown |  |
| person_value_name | Unknown |  |
| person_value_polymorphic_user_id | Unknown |  |
| person_value_polymorphic_user_type | Unknown |  |
| signature_value_media_id | Unknown |  |
| signature_value_media_processing_status | Unknown |  |
| signature_value_media_url | Unknown |  |
| signature_value_media_url_expires_at | Instant |  |
| table_value_rows | Json |  |
| text_value | Unknown |  |
| type | Unknown |  |

### form_submission_stream

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| form_template_id | Unknown | FK |
| route_id | Unknown | FK |
| route_stop_id | Unknown | FK |
| approval_detail_comment | Unknown |  |
| asset_entry_type | Unknown |  |
| asset_external_id | Json |  |
| asset_id | Unknown |  |
| asset_name | Unknown |  |
| assigned_to_id | Unknown |  |
| assigned_to_type | Unknown |  |
| created_at_time | Instant |  |
| due_at_time | Instant |  |
| external_id | Json |  |
| form_template_revision_id | Unknown |  |
| geofence_address | Unknown |  |
| geofence_entry_type | Unknown |  |
| geofence_external_id | Json |  |
| geofence_id | Unknown |  |
| geofence_name | Unknown |  |
| is_required | Unknown |  |
| latitude | Unknown |  |
| longitude | Unknown |  |
| score_max_points | Unknown |  |
| score_score_percent | Unknown |  |
| score_score_points | Unknown |  |
| status | Unknown |  |
| submitted_at_time | Instant |  |
| submitted_by_id | Unknown |  |
| submitted_by_type | Unknown |  |
| title | Unknown |  |
| updated_at_time | Instant |  |

### def_level_milli_percent

| Column | Type | Keys |
| --- | --- | --- |
| time | Unknown | PK |
| vehicle_id | String | PK, FK |
| value | Unknown |  |

### driver_vehicle_assignment

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| driver_id | String | FK |
| vehicle_id | String | FK |
| assigned_at_time | String |  |
| assignment_type | String |  |
| end_time | Unknown |  |
| is_passenger | Boolean |  |
| metadata_source_name | String |  |
| start_time | Unknown |  |

## Relationships

- driver(peer_group_tag_id) → tags(id)
- driver(static_assigned_vehicle_id) → vehicle(id)
- driver(vehicle_group_tag_id) → tags(id)
- tag_driver(tag_id) → tags(id)
- tags(parent_tag_id) → tags(id)
- hos_daily_log(driver_id) → driver(id)
- route_stop(address_id) → address(id)
- route_stop(route_id) → route(id)
- route(driver_id) → driver(id)
- route(vehicle_id) → vehicle(id)
- hub_location_service_window(hub_location_id) → hub_location(id)
- hub_location_skill_required(hub_location_id) → hub_location(id)
- conditional_field_section(document_id) → document(id)
- document_field(document_id) → document(id)
- document(route_id) → route(id)
- document(driver_id) → driver(id)
- document(route_stop_id) → route_stop(id)
- document(vehicle_id) → vehicle(id)
- alert_incident_conditions(configuration_id) → alert_incident(configuration_id)
- alert_incident_conditions(updated_at_time) → alert_incident(updated_at_time)
- tag_vehicle(tag_id) → tags(id)
- tag_vehicle(vehicle_id) → vehicle(id)
- vehicle(gateway_serial) → gateway(serial)
- tag_trailer(tag_id) → tags(id)
- tag_trailer(trailer_id) → trailer(id)
- trailer(gateway_serial) → gateway(serial)
- vehicle_trip_asset(vehicle_trip_vehicle_id) → vehicle_trip(vehicle_id)
- vehicle_trip_asset(vehicle_trip_start_ms) → vehicle_trip(start_ms)
- vehicle_trip_asset(vehicle_trip_end_ms) → vehicle_trip(end_ms)
- vehicle_trip_codriver(codriver_id) → driver(id)
- vehicle_trip_codriver(vehicle_trip_vehicle_id) → vehicle_trip(vehicle_id)
- vehicle_trip_codriver(vehicle_trip_start_ms) → vehicle_trip(start_ms)
- vehicle_trip_codriver(vehicle_trip_end_ms) → vehicle_trip(end_ms)
- vehicle_trip(end_address_id) → address(id)
- vehicle_trip(start_address_id) → address(id)
- vehicle_trip(driver_id) → driver(id)
- vehicle_trip(vehicle_id) → vehicle(id)
- tag_address(tag_id) → tags(id)
- tag_address(address_id) → address(id)
- form_template_field_option(form_template_id) → form_template_field(form_template_id)
- form_template_field_option(form_template_field_id) → form_template_field(id)
- form_template_field_conditional_action(form_template_id) → form_template_field(form_template_id)
- form_template_field_conditional_action(form_template_field_id) → form_template_field(id)
- form_template_field(form_template_id) → form_template(id)
- form_template_section(form_template_id) → form_template(id)
- tag_equipment(tag_id) → tags(id)
- tag_equipment(equipment_id) → equipment(id)
- equipment(gateway_serial) → gateway(serial)
- user_role(tag_id) → tags(id)
- user_role(users_id) → users(id)
- reading_history_feed(reading_definition_id) → reading_definition(id)
- reading_snapshot(reading_definition_id) → reading_definition(id)
- equipment_stats(id) → equipment(id)
- reading_definition_enum_value(reading_definition_id) → reading_definition(id)
- accessory_device(gateway_id) → gateway(id)
- engine_rpm(vehicle_id) → vehicle(id)
- ambient_air_temperature_milli_c(vehicle_id) → vehicle(id)
- barometric_pressure_pa(vehicle_id) → vehicle(id)
- defect_photo(defect_id) → defect(id)
- defect(resolved_by_id) → users(id)
- defect(dvir_id) → dvir(id)
- defect(trailer_id) → trailer(id)
- defect(vehicle_id) → vehicle(id)
- dvir_trailer_defect(trailer_defect_id) → defect(id)
- dvir_trailer_defect(dvir_id) → dvir(id)
- dvir_vehicle_defect(vechile_defect_id) → defect(id)
- dvir_vehicle_defect(dvir_id) → dvir(id)
- dvir(third_signature_signatory_user_id) → users(id)
- dvir(author_signature_signatory_user_id) → users(id)
- dvir(second_signature_signatory_user_id) → users(id)
- dvir(trailer_id) → trailer(id)
- dvir(vehicle_id) → vehicle(id)
- hos_log_codriver(codriver_id) → driver(id)
- hos_log_codriver(hos_log_vehicle_id) → hos_log(vehicle_id)
- hos_log_codriver(hos_log_log_start_time) → hos_log(log_start_time)
- hos_log_codriver(hos_log_log_end_time) → hos_log(log_end_time)
- hos_log(vehicle_id) → vehicle(id)
- hos_log(driver_id) → driver(id)
- vehicle_idling_report(address_id) → address(id)
- vehicle_idling_report(driver_id) → driver(id)
- vehicle_idling_report(vehicle_id) → vehicle(id)
- j_1939_diagnostic_trouble_code(fault_code_time) → fault_code(time)
- j_1939_diagnostic_trouble_code(fault_code_vehicle_id) → fault_code(vehicle_id)
- obdii_diagnostic_trouble_code(fault_code_time) → fault_code(time)
- obdii_diagnostic_trouble_code(fault_code_vehicle_id) → fault_code(vehicle_id)
- oem_diagnostic_trouble_code(fault_code_time) → fault_code(time)
- oem_diagnostic_trouble_code(fault_code_vehicle_id) → fault_code(vehicle_id)
- fault_code(vehicle_id) → vehicle(id)
- fuel_percent(vehicle_id) → vehicle(id)
- battery_milli_volt(vehicle_id) → vehicle(id)
- dtc(tx_id) → obdii_diagnostic_trouble_code(tx_id)
- fuel_energy_by_driver_report(id) → driver(id)
- gps(address_id) → address(id)
- gps(vehicle_id) → vehicle(id)
- driver_hos_violation(driver_id) → driver(id)
- stream_dvir_defect(defect_id) → defect(id)
- stream_dvir_defect(stream_dvir_id) → stream_dvir(id)
- stream_dvir(third_signature_signatory_user_id) → users(id)
- stream_dvir(author_signature_signatory_user_id) → users(id)
- stream_dvir(second_signature_signatory_user_id) → users(id)
- stream_dvir(trailer_id) → trailer(id)
- stream_dvir(vehicle_id) → vehicle(id)
- gps_distance_meter(vehicle_id) → vehicle(id)
- gps_odometer(vehicle_id) → vehicle(id)
- obd_odometer(vehicle_id) → vehicle(id)
- ecu_speed_mph(vehicle_id) → vehicle(id)
- engine_coolant_temperature_milli_c(vehicle_id) → vehicle(id)
- engine_load_percent(vehicle_id) → vehicle(id)
- intake_manifold_temperature_milli_c(vehicle_id) → vehicle(id)
- safety_event_asset_attribute(safety_event_id) → safety_event(id)
- safety_event_asset_tag(id) → tags(id)
- safety_event_asset_tag(parent_tag_id) → tags(id)
- safety_event_asset_tag(safety_event_id) → safety_event(id)
- safety_event_behavior_label(safety_event_id) → safety_event(id)
- safety_event_context_label(safety_event_id) → safety_event(id)
- safety_event_detected_stream(safety_event_id) → safety_event(id)
- safety_event_media(safety_event_id) → safety_event(id)
- safety_event(updated_by_user_id) → users(id)
- safety_event(driver_id) → driver(id)
- fuel_energy_by_vehicle_report(id) → vehicle(id)
- obd_engine_second(vehicle_id) → vehicle(id)
- synthetic_engine_second(vehicle_id) → vehicle(id)
- engine_state(vehicle_id) → vehicle(id)
- form_submission_stream_field_media_list(form_submission_stream_id) → form_submission_stream_field(form_submission_stream_id)
- form_submission_stream_field_media_list(form_submission_stream_field_id) → form_submission_stream_field(id)
- form_submission_stream_field_table_volume_column(form_submission_stream_id) → form_submission_stream_field(form_submission_stream_id)
- form_submission_stream_field_table_volume_column(form_submission_stream_field_id) → form_submission_stream_field(id)
- form_submission_stream_field(form_submission_stream_id) → form_submission_stream(id)
- form_submission_stream(route_id) → route(id)
- form_submission_stream(route_stop_id) → route_stop(id)
- form_submission_stream(form_template_id) → form_template(id)
- def_level_milli_percent(vehicle_id) → vehicle(id)
- driver_vehicle_assignment(driver_id) → driver(id)
- driver_vehicle_assignment(vehicle_id) → vehicle(id)