DMS 시스템
테이블 (5)
Copy Of DrivingSession (운행 기록 (Driving Record))
- session_id (Record_id) — INT — 기본 키 — NOT NULL
- Key (User_id) — VARCHAR(50) — 외래 키 → User.Key — NOT NULL
- Field (Start Time) — DATETIME
- Field2 (End Time) — DATETIME
- Field3 (Driving Result) — VARCHAR(50)
Untitled (운전 상태 (Driving State))
- Key (State_id) — INT — 기본 키 — NOT NULL
- session_id (Record_id) — INT — 외래 키 → Copy Of DrivingSession.session_id — NOT NULL
- Field3 (Pose_Data) — TEXT
- Field5 (Judgement_Result) — VARCHAR(50)
- Field4 (Behavior_Data) — TEXT
Untitled (이상 감지 (Anomaly Detection))
- Key (Detection_id) — INT — 기본 키 — NOT NULL
- Key (State_id) — INT — 외래 키 → Untitled.Key — NOT NULL
- Field (Detection_Type) — VARCHAR(50)
- Field2 (Warning_Start_Time) — DATETIME
- Field3 (Driver_Reaction) — VARCHAR(1)
- Field4 (Report_Generated) — VARCHAR(1)
- Field5 (SOS_Requested) — VARCHAR(1)
Untitled2 (비상 상황 조치 (Emergency Action))
- Key (Action_id) — INT — 기본 키 — NOT NULL
- Key (Detection_id) — INT — 외래 키 → Untitled.Key — NOT NULL
- Field (Action_Type) — VARCHAR(50)
- Field2 (Action_Time) — DATETIME
- Field3 (Details) — TEXT
User (사용자 (User))
- Key (User_id) — VARCHAR(50) — 기본 키 — NOT NULL
- name (Name) — VARCHAR(50)
- created_at (Contact) — VARCHAR(50)
- Field (Reg_Date) — DATE