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