졸음운전

테이블 (5)

tb_cam (Untitled)

  • camId (Key) — String — 기본 키 — NOT NULL
  • camSecret (Field) — String

tb_detection (Untitled4)

  • detection_id (Key) — Long — 기본 키 — NOT NULL
  • drive_id (Key2) — Long — 외래 키 → tb_drive.drive_id — NOT NULL
  • date (Field) — DateTime
  • type (Field2) — Enum

tb_drive (Untitled3)

  • drive_id (Key) — Long — 기본 키 — NOT NULL
  • user_id (Key2) — Long — 외래 키 → tb_user.user_id — NOT NULL
  • date (Field) — DateTime
  • detection_count (Field2) — Int
  • isActive (Field3) — Boolean
  • exit_count (Field4) — Int
  • almost_sleep_count (Field5) — Int
  • sleeping_count (Field6) — Int
  • wake_up_count (Field7) — Int

tb_emergency_number (Untitled2)

  • emergency_number_id (Key) — Long — 기본 키 — NOT NULL
  • user_id (Key2) — Long — 외래 키 → tb_user.user_id — NOT NULL
  • number (Field) — String

tb_user (유)

  • user_id (Key) — Long — 기본 키 — NOT NULL
  • camId (Key2) — String — 외래 키 → tb_cam.camId — NOT NULL
  • name (Field) — String
  • email (Field2) — String