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