Samsara
Explore the interactive ERD
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 | PKFK |
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 | PKFK |
days_of_week | Json | |
end_time | String | |
start_time | String |
hub_location_skill_required
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
hub_location_id | String | PKFK |
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 | PKFK |
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 | PKFK |
updated_at_time | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
form_template_id | Unknown | PKFK |
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 | PKFK |
form_template_id | Unknown | PKFK |
actions | Json | |
condition_selected_option_id | Json | |
condition_type | Unknown |
form_template_field
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
form_template_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
entity_type | Unknown | |
external_id | Json | |
value | Unknown |
equipment_stats
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
value | Unknown |
ambient_air_temperature_milli_c
| Column | Type | Keys |
|---|---|---|
time | Unknown | PK |
vehicle_id | String | PKFK |
value | Unknown |
barometric_pressure_pa
| Column | Type | Keys |
|---|---|---|
time | Unknown | PK |
vehicle_id | String | PKFK |
value | Unknown |
defect_photo
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
defect_id | Unknown | PKFK |
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 | PKFK |
trailer_defect_id | Unknown | PKFK |
dvir_vehicle_defect
| Column | Type | Keys |
|---|---|---|
dvir_id | String | PKFK |
vechile_defect_id | Unknown | PKFK |
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 | PKFK |
hos_log_log_end_time | Unknown | PKFK |
hos_log_log_start_time | Unknown | PKFK |
hos_log_vehicle_id | String | PKFK |
hos_log
| Column | Type | Keys |
|---|---|---|
log_end_time | Unknown | PK |
log_start_time | Unknown | PK |
vehicle_id | String | PKFK |
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 | PKFK |
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 | PKFK |
value | Long |
battery_milli_volt
| Column | Type | Keys |
|---|---|---|
time | Unknown | PK |
vehicle_id | String | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
value | Double |
gps_odometer
| Column | Type | Keys |
|---|---|---|
time | Unknown | PK |
vehicle_id | String | PKFK |
value | Long |
obd_odometer
| Column | Type | Keys |
|---|---|---|
time | Unknown | PK |
vehicle_id | String | PKFK |
value | Long |
ecu_speed_mph
| Column | Type | Keys |
|---|---|---|
time | Unknown | PK |
vehicle_id | String | PKFK |
value | Unknown |
engine_coolant_temperature_milli_c
| Column | Type | Keys |
|---|---|---|
time | Unknown | PK |
vehicle_id | String | PKFK |
value | Unknown |
engine_load_percent
| Column | Type | Keys |
|---|---|---|
time | Unknown | PK |
vehicle_id | String | PKFK |
value | Unknown |
intake_manifold_temperature_milli_c
| Column | Type | Keys |
|---|---|---|
time | Unknown | PK |
vehicle_id | String | PKFK |
value | Unknown |
safety_event_asset_attribute
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
safety_event_id | Unknown | PKFK |
date_values | Json | |
id | Unknown | |
name | Unknown | |
number_values | Json | |
string_values | Json |
safety_event_asset_tag
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
safety_event_id | Unknown | PKFK |
parent_tag_id | Unknown | FK |
safety_event_behavior_label
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
safety_event_id | Unknown | PKFK |
label | Unknown | |
source | Unknown |
safety_event_context_label
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
safety_event_id | Unknown | PKFK |
created_at_time | Unknown | |
id | Unknown | |
name | Unknown |
safety_event_detected_stream
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
safety_event_id | Unknown | PKFK |
auxcam_serial | Unknown | |
camera_role | Unknown | |
input | Unknown | |
url | Unknown |
safety_event_media
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
safety_event_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
value | Long |
synthetic_engine_second
| Column | Type | Keys |
|---|---|---|
time | Unknown | PK |
vehicle_id | String | PKFK |
value | Long |
engine_state
| Column | Type | Keys |
|---|---|---|
time | Unknown | PK |
vehicle_id | String | PKFK |
value | String |
form_submission_stream_field_media_list
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
form_submission_stream_field_id | Unknown | PKFK |
form_submission_stream_id | Unknown | PKFK |
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 | PKFK |
form_submission_stream_id | Unknown | PKFK |
label | Unknown | |
type | Unknown |
form_submission_stream_field
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
form_submission_stream_id | Unknown | PKFK |
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 | PKFK |
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 |