QuoCar
Tables (15)
admin_users
- user_id — uuid
battery_predictions
- id — bigint
- vehicle_id — bigint — NOT NULL
- predicted_at — timestamptz — NOT NULL
- horizon_hours — int — NOT NULL
- risk — text — NOT NULL
- expected_voltage_min — float8
- time_to_risk_minutes — int
- model_version — text
- meta — jsonb
devices
- id — bigint
- serial — text — NOT NULL
- activated_at — timestamptz
- fw_version — text
- last_seen_at — timestamptz
driving_events
- id — bigint
- trip_id — bigint — NOT NULL
- event_type — text — NOT NULL
- latitude — float8
- longitude — float8
- occurred_at — timestamptz — NOT NULL
- meta — jsonb
driving_logs
- id — bigint
- trip_id — bigint — NOT NULL
- recorded_at — timestamptz — NOT NULL
- latitude — float8
- longitude — float8
- speed_kmh — int
- rpm — int
- battery_voltage — float8
- coolant_temp_c — int
- engine_load — float8
- accel_pedal — float8
- throttle_pos — float8
- brake_status — boolean
- maf — float8
- fuel_rate — float8
- fuel_level — float8
- extra — jsonb
expenses
- id — bigint
- vehicle_id — bigint — NOT NULL
- date — date — NOT NULL
- amount — int — NOT NULL
- category — text — NOT NULL
- location — text
- memo — text
- receipt_url — text
- latitude — float8
- longitude — float8
maintenance_predictions
- id — bigint
- vehicle_id — bigint — NOT NULL
- item — text — NOT NULL
- predicted_at — timestamptz — NOT NULL
- predicted_due_date — date
- predicted_due_km — float8
- confidence — float8
- model_version — text
- meta — jsonb
- unique(vehicle_id, — item)
monthly_reports
- id — bigint
- vehicle_id — bigint — NOT NULL
- month — date — NOT NULL
- total_distance_km — float8
- avg_fuel_efficiency — float8
- rapid_accel_cnt — int
- rapid_brake_cnt — int
- total_expense — int
- fuel_expense — int
- repair_expense — int
- etc_expense — int
- insight — jsonb
- updated_at — timestamptz — NOT NULL
- unique(vehicle_id, — month)
parking_impacts
- id — bigint
- vehicle_id — bigint — NOT NULL
- occurred_at — timestamptz — NOT NULL
- intensity_g — float8
- ai_result — text
- latitude — float8
- longitude — float8
- waveform_data — jsonb
- evidence_url — text
parking_voltage_logs
- id — bigint
- vehicle_id — bigint — NOT NULL
- recorded_at — timestamptz — NOT NULL
- battery_voltage — float8 — NOT NULL
profiles
- id — uuid
- name — text
- phone_number — text
- created_at — timestamptz — NOT NULL
test_logs
- id — bigint
- created_at — timestamptz
- rpm — int
- speed — int
trips
- id — bigint
- vehicle_id — bigint — NOT NULL
- start_time — timestamptz — NOT NULL
- end_time — timestamptz
- start_lat — float8
- start_lon — float8
- end_lat — float8
- end_lon — float8
- distance_km — float8
- avg_fuel_efficiency — float8
- driving_score — int
- status — text — NOT NULL
vehicle_state
- vehicle_id — bigint
- updated_at — timestamptz — NOT NULL
- mode — text — NOT NULL
- rpm — int
- speed_kmh — int
- coolant_temp_c — int
- battery_voltage — float8
- discharge_risk — text
- estimated_range_km — int
- driving_score — int
- latitude — float8
- longitude — float8
vehicles
- id — bigint
- user_id — uuid — NOT NULL
- car_number — text — NOT NULL
- model_name — text
- model_year — int
- fuel_type — text
- total_distance_km — float8
- device_id — bigint
- last_telemetry_at — timestamptz
- created_at — timestamptz