mobility
Tables (3)
Hazard_Event (Untitled2)
- event_id (PK) — String — Primary key — NOT NULL
- vehicle_id (PK2) — String — Foreign key → Vehicle_Info.vehicle_id — NOT NULL
- sender_id (FK) — String
- hazard_type (1) — String
- location (2) — String
- action (3) — String
- confidence (4) — String
- timestamp (5) — Datetime
Vehicle_Info (Untitled)
- vehicle_id (PK) — String — Primary key — NOT NULL
- type (1) — String
- position (2) — String
- status (3) — String
Vehicle_Log (Untitled3)
- log_id (PK) — String — Primary key — NOT NULL
- vehicle_id (PK2) — String — Foreign key → Vehicle_Info.vehicle_id — NOT NULL
- event_id (PK3) — String — Foreign key → Hazard_Event.event_id — NOT NULL
- vehicle_id (PK22) — String — Foreign key → Hazard_Event.vehicle_id — NOT NULL
- receiver_id (FK1) — String
- event_id (FK2) — String
- response_action (1) — String
- timestamp (2) — Datetime