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