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)