Roard-Guardian-IoT-Core

Tables (3)

Accident_Status

  • seq — int — Primary key — NOT NULL
  • device_id — varchar(20) — Foreign key → Device_Info.device_id — NOT NULL
  • drowsiness — bool
  • unintended — bool
  • sudden — bool
  • event_time — timestamp

Device_Info

  • device_id — varchar(20) — Primary key — NOT NULL
  • device_type — varchar(20)
  • device_name — varchar(20)
  • connected_status — bool
  • drive_status — bool
  • connected_time — timestamp

Drive_Events

  • seq — int — Primary key — NOT NULL
  • device_id — varchar(20) — Foreign key → Device_Info.device_id — NOT NULL
  • handle — int
  • break — Int
  • accel — int
  • drive_time — timestamp