mota_erd2

Tables (8)

alerts

  • alert_id — UUID — Primary key — NOT NULL
  • vehicle_id — VARCHAR(20) — Foreign key → vehicles.vehicle_id — NOT NULL
  • rental_id — UUID — Foreign key → rentals.rental_id
  • alert_type — VARCHAR(50) — NOT NULL
  • severity — VARCHAR(20) — NOT NULL
  • occurred_at — TIMESTAMP
  • resolved_at — TIMESTAMP

checklist_photos

  • photo_id — UUID — Primary key — NOT NULL
  • checklist_id — UUID — Foreign key → checklist_results.checklist_id — NOT NULL
  • photo_url — TEXT — NOT NULL
  • category — VARCHAR(50)
  • uploaded_at — TIMESTAMP

checklist_results

  • checklist_id — UUID — Primary key — NOT NULL
  • rental_id — UUID — Foreign key → rentals.rental_id — NOT NULL
  • vehicle_id — VARCHAR(20) — Foreign key → vehicles.vehicle_id — NOT NULL
  • checked_at — TIMESTAMP
  • exterior_ok — BOOLEAN
  • lights_ok — BOOLEAN
  • fuel_level — INT
  • warning_lights — BOOLEAN
  • parking_brake_ok — BOOLEAN
  • hvac_ok — BOOLEAN
  • seat_mirror_ok — BOOLEAN
  • emergency_kit_ok — BOOLEAN

rentals

  • rental_id — UUID — Primary key — NOT NULL
  • vehicle_id — VARCHAR(20) — Foreign key → vehicles.vehicle_id — NOT NULL
  • started_at — TIMESTAMP — NOT NULL
  • returned_at — TIMESTAMP
  • contact — VARCHAR(100)
  • created_at — TIMESTAMP

reports

  • report_id — UUID — Primary key — NOT NULL
  • rental_id — UUID — Foreign key → rentals.rental_id — NOT NULL
  • driving_score — INT
  • ai_summary — TEXT
  • pdf_url — TEXT
  • generated_at — TIMESTAMP

sensor_readings

  • time — TIMESTAMP — NOT NULL
  • vehicle_id — VARCHAR(20) — Foreign key → vehicles.vehicle_id — NOT NULL
  • rental_id — UUID — Foreign key → rentals.rental_id
  • sensor_position — VARCHAR(10) — NOT NULL
  • pressure_psi — FLOAT
  • temperature_c — FLOAT
  • acc_x — FLOAT
  • acc_y — FLOAT
  • acc_z — FLOAT
  • battery_volt — FLOAT

trip_stats

  • stat_id — UUID — Primary key — NOT NULL
  • rental_id — UUID — Foreign key → rentals.rental_id — NOT NULL
  • hard_braking_count — INT
  • hard_accel_count — INT
  • sharp_corner_count — INT
  • impact_count — INT
  • total_distance_km — FLOAT
  • updated_at — TIMESTAMP

vehicles

  • vehicle_id — VARCHAR(20) — Primary key — NOT NULL
  • model — VARCHAR(100) — NOT NULL
  • plate — VARCHAR(20) — NOT NULL
  • year — INT — NOT NULL
  • created_at — TIMESTAMP