drowsiness

Tables (8)

admin (Untitled3)

  • Key — Primary key — NOT NULL
  • Field
  • Field2
  • Field3

drowsiness_level (졸음 정도)

  • Key — Primary key — NOT NULL
  • video_id (Key2) — Foreign key → video.Key — NOT NULL
  • student_id (Key3) — Foreign key → student.Key — NOT NULL
  • timestamp (Field)
  • drowsiness_score (Field2)

enrollment (수강신청 내역)

  • Key — Primary key — NOT NULL
  • lecture_id (Key2) — Foreign key → lecture.Key — NOT NULL
  • student_id (Key3) — Foreign key → student.Key — NOT NULL
  • enrolled_at (Field)

instructor (사용자(강의자))

  • Key — Primary key — NOT NULL
  • name (Field)
  • email (Field2)
  • password (Field3)

lecture (강의)

  • Key — Primary key — NOT NULL
  • instructor_id (Key2) — Foreign key → instructor.Key — NOT NULL
  • name (Field)

student (사용자(학생))

  • Key — Primary key — NOT NULL
  • name (Field)
  • email (Field2)
  • password (Field3)

video (영상 데이터)

  • Key — Primary key — NOT NULL
  • lecture_id (Key2) — Foreign key → lecture.Key — NOT NULL
  • title (Field)
  • s3_link (Field2)
  • duration (Field3)
  • upload_at (Field4)
  • index (Field5)

watch_history (시청기록)

  • Key — Primary key — NOT NULL
  • student_id (Key2) — Foreign key → student.Key — NOT NULL
  • video_id (Key3) — Foreign key → video.Key — NOT NULL
  • timestamp (Field)