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