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