🔌 TeslaSync Database

47 tables · 778 columns · 37 relationships
Core (6)Drives (7)Charging (3)Snapshots (11)Alerts (4)Geofences (1)Commands (1)Fleet (1)Audit (2)Export (1)Other (10)
addresses 13 cols
🔑 id BIGINT NN
display_name TEXT NN
latitude DOUBLE NN
longitude DOUBLE NN
name VARCHAR(255) NULL
house_number VARCHAR(50) NULL
road VARCHAR(255) NULL
city VARCHAR(255) NULL
county VARCHAR(255) NULL
state VARCHAR(255) NULL
country VARCHAR(255) NULL
postcode VARCHAR(50) NULL
created_at TIMESTAMPTZ NN
alert_rules 8 cols
🔑 id BIGINT NN
name VARCHAR(255) NN
type VARCHAR(50) NN
enabled BOOLEAN NN
threshold DOUBLE NN
🔗 vehicle_id BIGINT NULL
created_at TIMESTAMPTZ NN
updated_at TIMESTAMPTZ NN
alerts 8 cols
🔑 id BIGINT NN
🔗 vehicle_id BIGINT NULL
type VARCHAR(50) NN
severity VARCHAR(20) NN
title VARCHAR(500) NN
message TEXT NN
is_read BOOLEAN NN
created_at TIMESTAMPTZ NN
api_call_logs 10 cols
🔑 id BIGINT NN
method VARCHAR(10) NN
url TEXT NN
status_code INTEGER NULL
request_body TEXT NULL
response_body TEXT NULL
duration_ms INTEGER NN
error TEXT NULL
created_at TIMESTAMPTZ NN
source VARCHAR(20) NN
api_keys 8 cols
🔑 id BIGINT NN
name VARCHAR(255) NN
key_hash VARCHAR(64) NN
key_prefix VARCHAR(20) NULL
permissions VARCHAR(50) NN
last_used_at TIMESTAMPTZ NULL
created_at TIMESTAMPTZ NN
expires_at TIMESTAMPTZ NULL
audit_logs 6 cols
🔑 id BIGINT NN
action TEXT NN
resource TEXT NN
details TEXT NN
ip TEXT NN
created_at TIMESTAMPTZ NN
battery_snapshots 9 cols
🔑 id BIGINT NN
🔗 vehicle_id BIGINT NN
health_score DOUBLE NN
capacity_kwh DOUBLE NN
degradation_pct DOUBLE NN
est_range_km DOUBLE NN
cycle_count INTEGER NN
avg_cell_temp_c DOUBLE NN
created_at TIMESTAMPTZ NN
charge_telemetry_readings 20 cols
🔑 id BIGINT NN
🔗 session_id BIGINT NN
🔗 vehicle_id BIGINT NN
battery_level INTEGER NULL
soc DOUBLE NULL
power_kw DOUBLE NULL
voltage DOUBLE NULL
current_amps DOUBLE NULL
phases INTEGER NULL
energy_added DOUBLE NULL
rated_range DOUBLE NULL
ideal_range DOUBLE NULL
est_range DOUBLE NULL
inside_temp DOUBLE NULL
outside_temp DOUBLE NULL
battery_temp DOUBLE NULL
latitude DOUBLE NULL
longitude DOUBLE NULL
charge_rate DOUBLE NULL
created_at TIMESTAMPTZ NN
charging_sessions 25 cols
🔑 id BIGINT NN
🔗 vehicle_id BIGINT NN
start_date TIMESTAMPTZ NN
end_date TIMESTAMPTZ NULL
address_id BIGINT NULL
charge_energy_added DOUBLE NN
charge_energy_used DOUBLE NULL
start_battery_level INTEGER NN
end_battery_level INTEGER NULL
start_range_km DOUBLE NULL
end_range_km DOUBLE NULL
charger_phases INTEGER NULL
charger_voltage INTEGER NULL
charger_actual_current INTEGER NULL
charger_power DOUBLE NULL
fast_charger_type VARCHAR(100) NULL
fast_charger_brand VARCHAR(100) NULL
conn_charge_cable VARCHAR(100) NULL
cost DOUBLE NULL
duration_min DOUBLE NN
latitude DOUBLE NULL
longitude DOUBLE NULL
location_name TEXT NULL
inside_temp_avg DOUBLE NULL
outside_temp_avg DOUBLE NULL
charging_telemetry 60 cols
🔑 id BIGINT NN
🔗 vehicle_id BIGINT NN
battery_level INTEGER NULL
soc DOUBLE NULL
charge_state VARCHAR(30) NULL
detailed_charge_state VARCHAR(30) NULL
charge_limit_soc INTEGER NULL
charge_amps DOUBLE NULL
charge_current_request DOUBLE NULL
charge_current_request_max DOUBLE NULL
charge_enable_request BOOLEAN NULL
charger_voltage DOUBLE NULL
charger_phases INTEGER NULL
charge_rate_mph DOUBLE NULL
dc_charging_power DOUBLE NULL
dc_charging_energy_in DOUBLE NULL
ac_charging_power DOUBLE NULL
ac_charging_energy_in DOUBLE NULL
energy_remaining DOUBLE NULL
est_battery_range DOUBLE NULL
ideal_battery_range DOUBLE NULL
rated_range DOUBLE NULL
pack_voltage DOUBLE NULL
pack_current DOUBLE NULL
charge_port_door_open BOOLEAN NULL
charge_port_latch VARCHAR(20) NULL
charge_port_cold_weather_mode BOOLEAN NULL
charging_cable_type VARCHAR(30) NULL
fast_charger_present BOOLEAN NULL
fast_charger_type VARCHAR(30) NULL
time_to_full_charge DOUBLE NULL
estimated_hours_to_charge DOUBLE NULL
scheduled_charging_mode VARCHAR(20) NULL
scheduled_charging_pending BOOLEAN NULL
preconditioning_enabled BOOLEAN NULL
brick_voltage_max DOUBLE NULL
brick_voltage_min DOUBLE NULL
num_brick_voltage_max INTEGER NULL
num_brick_voltage_min INTEGER NULL
module_temp_max DOUBLE NULL
module_temp_min DOUBLE NULL
num_module_temp_max INTEGER NULL
num_module_temp_min INTEGER NULL
battery_heater_on BOOLEAN NULL
not_enough_power_to_heat BOOLEAN NULL
bms_state VARCHAR(20) NULL
bms_fullcharge_complete BOOLEAN NULL
dcdc_enable BOOLEAN NULL
isolation_resistance DOUBLE NULL
lifetime_energy_used DOUBLE NULL
supercharger_session_trip_planner BOOLEAN NULL
powershare_status VARCHAR(20) NULL
powershare_type VARCHAR(20) NULL
powershare_stop_reason VARCHAR(50) NULL
powershare_hours_left DOUBLE NULL
powershare_power_kw DOUBLE NULL
created_at TIMESTAMPTZ NN
scheduled_charging_start_time TEXT NULL
scheduled_departure_time TEXT NULL
expected_energy_pct_at_arrival DOUBLE NULL
chatbot_messages 5 cols
🔑 id BIGINT NN
session_id TEXT NN
role TEXT NN
content TEXT NN
created_at TIMESTAMPTZ NN
climate_snapshots 33 cols
🔑 id BIGINT NN
🔗 vehicle_id BIGINT NN
inside_temp DOUBLE NULL
outside_temp DOUBLE NULL
hvac_power DOUBLE NULL
hvac_fan_speed INTEGER NULL
hvac_left_temp_request DOUBLE NULL
hvac_right_temp_request DOUBLE NULL
cabin_overheat_mode VARCHAR(10) NULL
defrost_mode BOOLEAN NULL
battery_heater_on BOOLEAN NULL
created_at TIMESTAMPTZ NN
hvac_ac_enabled BOOLEAN NULL
hvac_auto_mode BOOLEAN NULL
hvac_fan_status INTEGER NULL
hvac_steering_wheel_heat_auto BOOLEAN NULL
hvac_steering_wheel_heat_level INTEGER NULL
climate_keeper_mode VARCHAR(20) NULL
cabin_overheat_protection_temp_limit DOUBLE NULL
defrost_for_preconditioning BOOLEAN NULL
seat_heater_left INTEGER NULL
seat_heater_right INTEGER NULL
seat_heater_rear_left INTEGER NULL
seat_heater_rear_center INTEGER NULL
seat_heater_rear_right INTEGER NULL
seat_vent_enabled BOOLEAN NULL
climate_seat_cooling_front_left INTEGER NULL
climate_seat_cooling_front_right INTEGER NULL
auto_seat_climate_left BOOLEAN NULL
auto_seat_climate_right BOOLEAN NULL
rear_defrost_enabled BOOLEAN NULL
rear_display_hvac_enabled BOOLEAN NULL
wiper_heat_enabled BOOLEAN NULL
command_logs 7 cols
🔑 id BIGINT NN
🔗 vehicle_id BIGINT NN
command VARCHAR(100) NN
params TEXT NN
status VARCHAR(20) NN
error TEXT NN
created_at TIMESTAMPTZ NN
daily_mileage 8 cols
🔑 id BIGINT NN
🔗 vehicle_id BIGINT NULL
date DATE NN
distance_km DOUBLE NULL
odometer_start DOUBLE NULL
odometer_end DOUBLE NULL
drive_count INTEGER NULL
energy_used_kwh DOUBLE NULL
drive_telemetry_readings 28 cols
🔑 id BIGINT NN
🔗 drive_id BIGINT NN
🔗 vehicle_id BIGINT NN
latitude DOUBLE NULL
longitude DOUBLE NULL
elevation DOUBLE NULL
heading INTEGER NULL
odometer DOUBLE NULL
speed DOUBLE NULL
power DOUBLE NULL
battery_level INTEGER NULL
soc DOUBLE NULL
usable_soc DOUBLE NULL
rated_range DOUBLE NULL
ideal_range DOUBLE NULL
est_range DOUBLE NULL
inside_temp DOUBLE NULL
outside_temp DOUBLE NULL
driver_temp DOUBLE NULL
passenger_temp DOUBLE NULL
fan_status INTEGER NULL
is_climate_on BOOLEAN NULL
tire_pressure_fl DOUBLE NULL
tire_pressure_fr DOUBLE NULL
tire_pressure_rl DOUBLE NULL
tire_pressure_rr DOUBLE NULL
battery_heater_on BOOLEAN NULL
created_at TIMESTAMPTZ NN
drives 61 cols
🔑 id BIGINT NN
🔗 vehicle_id BIGINT NN
start_date TIMESTAMPTZ NN
end_date TIMESTAMPTZ NULL
start_position_id BIGINT NULL
end_position_id BIGINT NULL
start_address_id BIGINT NULL
end_address_id BIGINT NULL
distance DOUBLE NN
duration_min DOUBLE NN
start_range_km DOUBLE NULL
end_range_km DOUBLE NULL
speed_max DOUBLE NULL
power_max DOUBLE NULL
power_min DOUBLE NULL
start_battery_level INTEGER NULL
end_battery_level INTEGER NULL
inside_temp_avg DOUBLE NULL
outside_temp_avg DOUBLE NULL
start_odometer DOUBLE NULL
end_odometer DOUBLE NULL
speed_avg DOUBLE NULL
speed_min DOUBLE NULL
start_rated_range_km DOUBLE NULL
end_rated_range_km DOUBLE NULL
rated_range_avg DOUBLE NULL
rated_range_max DOUBLE NULL
rated_range_min DOUBLE NULL
start_ideal_range_km DOUBLE NULL
end_ideal_range_km DOUBLE NULL
ideal_range_avg DOUBLE NULL
ideal_range_max DOUBLE NULL
ideal_range_min DOUBLE NULL
start_est_range_km DOUBLE NULL
end_est_range_km DOUBLE NULL
est_range_avg DOUBLE NULL
est_range_max DOUBLE NULL
est_range_min DOUBLE NULL
soc_start DOUBLE NULL
soc_end DOUBLE NULL
soc_avg DOUBLE NULL
soc_max DOUBLE NULL
soc_min DOUBLE NULL
usable_soc_start DOUBLE NULL
usable_soc_end DOUBLE NULL
usable_soc_avg DOUBLE NULL
usable_soc_max DOUBLE NULL
usable_soc_min DOUBLE NULL
elevation_start DOUBLE NULL
elevation_end DOUBLE NULL
elevation_gain DOUBLE NULL
elevation_loss DOUBLE NULL
driver_temp_avg DOUBLE NULL
passenger_temp_avg DOUBLE NULL
battery_heater_on BOOLEAN NULL
start_address TEXT NULL
end_address TEXT NULL
start_latitude DOUBLE NULL
start_longitude DOUBLE NULL
end_latitude DOUBLE NULL
end_longitude DOUBLE NULL
export_jobs 15 cols
🔑 id TEXT NN
type TEXT NN
format TEXT NN
status TEXT NN
vehicle_id BIGINT NULL
start_date TIMESTAMPTZ NULL
end_date TIMESTAMPTZ NULL
file_name TEXT NULL
file_data BYTEA NULL
file_size BIGINT NULL
record_count INTEGER NULL
error_message TEXT NULL
created_at TIMESTAMPTZ NN
updated_at TIMESTAMPTZ NN
completed_at TIMESTAMPTZ NULL
fleet_telemetry_subscriptions 15 cols
🔑 id BIGINT NN
🔗 vehicle_id BIGINT NULL
vin VARCHAR(17) NULL
signals _TEXT NN
interval_seconds INTEGER NN
hostname TEXT NN
port INTEGER NN
protocol TEXT NN
ca_pem TEXT NULL
subscribed_at TIMESTAMPTZ NN
expires_at TIMESTAMPTZ NULL
status TEXT NN
response_code INTEGER NULL
response_body TEXT NULL
created_at TIMESTAMPTZ NN
gas_price_history 7 cols
🔑 id BIGINT NN
price_per_unit DOUBLE NN
unit VARCHAR(10) NN
efficiency_mpg DOUBLE NN
effective_from TIMESTAMPTZ NN
effective_to TIMESTAMPTZ NULL
created_at TIMESTAMPTZ NN
gas_price_poll_state 5 cols
🔑 id INTEGER NN
enabled BOOLEAN NN
poll_interval VARCHAR(10) NN
last_poll_time TIMESTAMPTZ NN
last_price DOUBLE NN
geofence_electricity_rates 6 cols
🔑 id BIGINT NN
🔗 geofence_id BIGINT NN
cost_per_kwh DOUBLE NN
effective_from TIMESTAMPTZ NN
effective_to TIMESTAMPTZ NULL
created_at TIMESTAMPTZ NN
geofences 8 cols
🔑 id BIGINT NN
name VARCHAR(255) NN
latitude DOUBLE NN
longitude DOUBLE NN
radius DOUBLE NN
created_at TIMESTAMPTZ NN
updated_at TIMESTAMPTZ NN
cost_per_kwh DOUBLE NULL
location_snapshots 19 cols
🔑 id BIGINT NN
🔗 vehicle_id BIGINT NN
destination_name VARCHAR(255) NULL
destination_lat DOUBLE NULL
destination_lon DOUBLE NULL
origin_lat DOUBLE NULL
origin_lon DOUBLE NULL
miles_to_arrival DOUBLE NULL
minutes_to_arrival DOUBLE NULL
route_line TEXT NULL
route_traffic_delay_min DOUBLE NULL
located_at_home BOOLEAN NULL
located_at_work BOOLEAN NULL
located_at_favorite BOOLEAN NULL
gps_state VARCHAR(20) NULL
created_at TIMESTAMPTZ NN
route_last_updated TIMESTAMPTZ NULL
current_lat DOUBLE NULL
current_lon DOUBLE NULL
media_snapshots 14 cols
🔑 id BIGINT NN
🔗 vehicle_id BIGINT NN
now_playing_title VARCHAR(255) NULL
now_playing_artist VARCHAR(255) NULL
now_playing_album VARCHAR(255) NULL
now_playing_station VARCHAR(255) NULL
now_playing_duration INTEGER NULL
now_playing_elapsed INTEGER NULL
playback_status VARCHAR(20) NULL
playback_source VARCHAR(50) NULL
audio_volume INTEGER NULL
audio_volume_max INTEGER NULL
created_at TIMESTAMPTZ NN
audio_volume_increment DOUBLE NULL
motor_snapshots 49 cols
🔑 id BIGINT NN
🔗 vehicle_id BIGINT NN
di_state VARCHAR(20) NULL
di_torque DOUBLE NULL
di_axle_speed DOUBLE NULL
di_stator_temp DOUBLE NULL
pedal_position DOUBLE NULL
brake_pedal BOOLEAN NULL
lateral_accel DOUBLE NULL
longitudinal_accel DOUBLE NULL
vehicle_speed DOUBLE NULL
gear VARCHAR(5) NULL
created_at TIMESTAMPTZ NN
di_torque_actual_f DOUBLE NULL
di_torque_actual_r DOUBLE NULL
di_torque_actual_rel DOUBLE NULL
di_torque_actual_rer DOUBLE NULL
di_axle_speed_f DOUBLE NULL
di_axle_speed_rel DOUBLE NULL
di_axle_speed_rer DOUBLE NULL
di_state_f VARCHAR(20) NULL
di_state_rel VARCHAR(20) NULL
di_state_rer VARCHAR(20) NULL
di_stator_temp_f DOUBLE NULL
di_stator_temp_rel DOUBLE NULL
di_stator_temp_rer DOUBLE NULL
di_heatsink_t_f DOUBLE NULL
di_heatsink_t_r DOUBLE NULL
di_heatsink_t_rel DOUBLE NULL
di_heatsink_t_rer DOUBLE NULL
di_inverter_t_f DOUBLE NULL
di_inverter_t_r DOUBLE NULL
di_inverter_t_rel DOUBLE NULL
di_inverter_t_rer DOUBLE NULL
di_motor_current_f DOUBLE NULL
di_motor_current_r DOUBLE NULL
di_motor_current_rel DOUBLE NULL
di_motor_current_rer DOUBLE NULL
di_v_bat_f DOUBLE NULL
di_v_bat_r DOUBLE NULL
di_v_bat_rel DOUBLE NULL
di_v_bat_rer DOUBLE NULL
di_slave_torque_cmd DOUBLE NULL
hvil VARCHAR(20) NULL
brake_pedal_pos DOUBLE NULL
cruise_set_speed DOUBLE NULL
drive_rail BOOLEAN NULL
lifetime_energy_gained_regen DOUBLE NULL
lifetime_energy_used_drive DOUBLE NULL
notification_channels 7 cols
🔑 id BIGINT NN
name TEXT NN
type TEXT NN
config JSONB NN
enabled BOOLEAN NN
created_at TIMESTAMPTZ NN
updated_at TIMESTAMPTZ NN
notification_logs 11 cols
🔑 id BIGINT NN
🔗 channel_id BIGINT NN
🔗 alert_id BIGINT NULL
title TEXT NN
message TEXT NN
status TEXT NN
error TEXT NULL
created_at TIMESTAMPTZ NN
sent_at TIMESTAMPTZ NULL
scheduled_at TIMESTAMPTZ NULL
latency_ms INTEGER NULL
notification_metrics 6 cols
🔑 id BIGINT NN
🔗 channel_id BIGINT NN
date DATE NN
total_sent INTEGER NN
total_failed INTEGER NN
avg_latency_ms INTEGER NN
notification_preferences 5 cols
🔑 id BIGINT NN
🔗 channel_id BIGINT NN
event_type TEXT NN
enabled BOOLEAN NN
created_at TIMESTAMPTZ NN
notification_schedules 11 cols
🔑 id BIGINT NN
🔗 channel_id BIGINT NN
title TEXT NN
message TEXT NN
cron_expr TEXT NULL
scheduled_at TIMESTAMPTZ NULL
last_run_at TIMESTAMPTZ NULL
next_run_at TIMESTAMPTZ NULL
enabled BOOLEAN NN
created_at TIMESTAMPTZ NN
updated_at TIMESTAMPTZ NN
positions 17 cols
🔑 id BIGINT NN
🔗 vehicle_id BIGINT NN
latitude DOUBLE NN
longitude DOUBLE NN
speed DOUBLE NULL
power DOUBLE NULL
heading INTEGER NULL
elevation DOUBLE NULL
odometer DOUBLE NN
ideal_range DOUBLE NULL
rated_range DOUBLE NULL
battery_level INTEGER NN
inside_temp DOUBLE NULL
outside_temp DOUBLE NULL
fan_status INTEGER NULL
is_climate_on BOOLEAN NULL
🔑 created_at TIMESTAMPTZ NN
safety_snapshots 14 cols
🔑 id BIGINT NN
🔗 vehicle_id BIGINT NN
automatic_blind_spot_camera BOOLEAN NULL
automatic_emergency_braking_off BOOLEAN NULL
blind_spot_collision_warning BOOLEAN NULL
cruise_follow_distance VARCHAR(10) NULL
emergency_lane_departure_avoidance BOOLEAN NULL
forward_collision_warning BOOLEAN NULL
lane_departure_avoidance BOOLEAN NULL
speed_limit_warning VARCHAR(20) NULL
pin_to_drive_enabled BOOLEAN NULL
miles_since_reset DOUBLE NULL
self_driving_miles_since_reset DOUBLE NULL
created_at TIMESTAMPTZ NN
schema_migrations 2 cols
🔑 version BIGINT NN
dirty BOOLEAN NN
security_events 29 cols
🔑 id BIGINT NN
🔗 vehicle_id BIGINT NN
locked BOOLEAN NULL
sentry_mode BOOLEAN NULL
door_state VARCHAR(20) NULL
fd_window VARCHAR(20) NULL
fp_window VARCHAR(20) NULL
rd_window VARCHAR(20) NULL
rp_window VARCHAR(20) NULL
homelink_nearby BOOLEAN NULL
guest_mode BOOLEAN NULL
created_at TIMESTAMPTZ NN
homelink_device_count INTEGER NULL
guest_mode_mobile_access_state VARCHAR(20) NULL
driver_seat_occupied BOOLEAN NULL
center_display VARCHAR(20) NULL
speed_limit_mode VARCHAR(20) NULL
valet_mode_enabled BOOLEAN NULL
service_mode BOOLEAN NULL
current_limit_mph DOUBLE NULL
paired_phone_key_count INTEGER NULL
lights_hazards_active BOOLEAN NULL
lights_high_beams BOOLEAN NULL
lights_turn_signal VARCHAR(10) NULL
tonneau_position VARCHAR(20) NULL
tonneau_open_percent DOUBLE NULL
tonneau_tent_mode BOOLEAN NULL
driver_seat_belt BOOLEAN NULL
passenger_seat_belt BOOLEAN NULL
settings 14 cols
🔑 id INTEGER NN
unit_of_length VARCHAR(5) NN
unit_of_temp VARCHAR(5) NN
preferred_range VARCHAR(10) NN
language VARCHAR(10) NN
base_cost_per_kwh DOUBLE NN
api_suspended BOOLEAN NN
theme VARCHAR(20) NN
mode VARCHAR(20) NN
custom_primary VARCHAR(10) NN
custom_accent VARCHAR(10) NN
gas_price_per_unit DOUBLE NN
gas_unit VARCHAR(10) NN
gas_efficiency_mpg DOUBLE NN
software_updates 7 cols
🔑 id BIGINT NN
🔗 vehicle_id BIGINT NN
version VARCHAR(100) NN
status VARCHAR(50) NN
scheduled_at TIMESTAMPTZ NULL
installed_at TIMESTAMPTZ NULL
created_at TIMESTAMPTZ NN
tesla_public_key 4 cols
🔑 id INTEGER NN
public_key_pem TEXT NN
fingerprint VARCHAR(64) NN
created_at TIMESTAMPTZ NN
tire_pressure_snapshots 13 cols
🔑 id BIGINT NN
🔗 vehicle_id BIGINT NULL
front_left DOUBLE NULL
front_right DOUBLE NULL
rear_left DOUBLE NULL
rear_right DOUBLE NULL
created_at TIMESTAMPTZ NN
tpms_hard_warnings TEXT NULL
tpms_soft_warnings TEXT NULL
last_seen_time_fl TIMESTAMPTZ NULL
last_seen_time_fr TIMESTAMPTZ NULL
last_seen_time_rl TIMESTAMPTZ NULL
last_seen_time_rr TIMESTAMPTZ NULL
tokens 6 cols
🔑 id INTEGER NN
access_token TEXT NN
refresh_token TEXT NN
expires_at TIMESTAMPTZ NN
created_at TIMESTAMPTZ NN
updated_at TIMESTAMPTZ NN
trip_drives 2 cols
🔑 trip_id BIGINT NN
🔑 drive_id BIGINT NN
trips 11 cols
🔑 id BIGINT NN
🔗 vehicle_id BIGINT NULL
name VARCHAR(255) NULL
start_date TIMESTAMPTZ NN
end_date TIMESTAMPTZ NULL
total_distance_km DOUBLE NULL
total_energy_kwh DOUBLE NULL
total_cost DOUBLE NULL
drive_count INTEGER NULL
charge_count INTEGER NULL
created_at TIMESTAMPTZ NN
user_preference_snapshots 8 cols
🔑 id BIGINT NN
🔗 vehicle_id BIGINT NN
setting_24hr_time BOOLEAN NULL
setting_charge_unit VARCHAR(10) NULL
setting_distance_unit VARCHAR(10) NULL
setting_temperature_unit VARCHAR(10) NULL
setting_tire_pressure_unit VARCHAR(10) NULL
created_at TIMESTAMPTZ NN
vampire_drain_events 13 cols
🔑 id BIGINT NN
🔗 vehicle_id BIGINT NULL
start_date TIMESTAMPTZ NN
end_date TIMESTAMPTZ NULL
start_battery INTEGER NN
end_battery INTEGER NULL
battery_lost INTEGER NULL
range_lost_km DOUBLE NULL
duration_hours DOUBLE NULL
drain_rate_pct_per_hour DOUBLE NULL
outside_temp_avg DOUBLE NULL
sentry_mode BOOLEAN NULL
created_at TIMESTAMPTZ NN
vehicle_config_snapshots 23 cols
🔑 id BIGINT NN
🔗 vehicle_id BIGINT NN
car_type VARCHAR(50) NULL
trim VARCHAR(50) NULL
exterior_color VARCHAR(50) NULL
roof_color VARCHAR(50) NULL
wheel_type VARCHAR(50) NULL
rear_seat_heaters BOOLEAN NULL
sunroof_installed BOOLEAN NULL
efficiency_package BOOLEAN NULL
europe_vehicle BOOLEAN NULL
right_hand_drive BOOLEAN NULL
remote_start_enabled BOOLEAN NULL
charge_port VARCHAR(20) NULL
offroad_lightbar_present BOOLEAN NULL
version VARCHAR(50) NULL
vehicle_name VARCHAR(100) NULL
software_update_version VARCHAR(50) NULL
software_update_download_pct INTEGER NULL
software_update_install_pct INTEGER NULL
software_update_expected_duration INTEGER NULL
created_at TIMESTAMPTZ NN
software_update_scheduled_start TEXT NULL
vehicle_states 7 cols
🔑 id BIGINT NN
🔗 vehicle_id BIGINT NULL
state VARCHAR(20) NN
start_date TIMESTAMPTZ NN
end_date TIMESTAMPTZ NULL
duration_min DOUBLE NULL
created_at TIMESTAMPTZ NN
vehicles 12 cols
🔑 id BIGINT NN
vehicle_id BIGINT NN
vin VARCHAR(17) NN
display_name VARCHAR(255) NN
model VARCHAR(50) NN
trim_badging VARCHAR(50) NN
exterior_color VARCHAR(50) NN
wheel_type VARCHAR(50) NN
state VARCHAR(20) NN
healthy BOOLEAN NN
created_at TIMESTAMPTZ NN
updated_at TIMESTAMPTZ NN
visited_locations 7 cols
🔑 id BIGINT NN
🔗 vehicle_id BIGINT NULL
🔗 address_id BIGINT NULL
visit_count INTEGER NULL
total_duration_min DOUBLE NULL
last_visited TIMESTAMPTZ NULL
created_at TIMESTAMPTZ NN