lms 전희나

테이블 (10)

assignments (과제)

  • assignment_id (PK) — INT — 기본 키 — NOT NULL
  • course_id (FK) — INT — 외래 키 → courses.course_id — NOT NULL
  • title — VARCHAR(100)
  • description — TEXT
  • due_date — DATETIME
  • created_at — DATETIME

attendance (출석)

  • attendance_id (PK) — INT — 기본 키 — NOT NULL
  • course_id (FK) — INT — 외래 키 → courses.course_id — NOT NULL
  • student_id (FK2) — INT — 외래 키 → users.user_id — NOT NULL
  • week — INT — NOT NULL
  • status — VARCHAR(20)
  • checked_at — DATETIME

course_contents (주차별 강의자료)

  • content_id (PK) — INT — 기본 키 — NOT NULL
  • course_id (FK) — INT — 외래 키 → courses.course_id — NOT NULL
  • week — INT — NOT NULL
  • title — VARCHAR(100)
  • content_type — VARCHAR(20)
  • file_path — VARCHAR(255)
  • created_at — DATETIME

courses (강의)

  • course_id (PK) — INT — 기본 키 — NOT NULL
  • professor_id — INT — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • description — TEXT
  • semester — VARCHAR(20)
  • created_at — DATETIME

enrollments (수강신청)

  • enroll_id (PK) — INT — 기본 키 — NOT NULL
  • student_id (FK) — INT — 외래 키 → users.user_id — NOT NULL
  • course_id (FK2) — INT — 외래 키 → courses.course_id — NOT NULL
  • enrolled_at — DATETIME

exam_submissions (시험 응시)

  • exam_submission_id (PK) — INT — 기본 키 — NOT NULL
  • exam_id (FK) — INT — 외래 키 → exams.exam_id — NOT NULL
  • student_id (FK2) — INT — 외래 키 → users.user_id — NOT NULL
  • answer_text — TEXT
  • submitted_at — DATETIME
  • score — INT

exams

  • exam_id (PK) — INT — 기본 키 — NOT NULL
  • course_id (FK) — INT — 외래 키 → courses.course_id — NOT NULL
  • title — VARCHAR(100)
  • description — TEXT
  • exam_date — DATETIME

learning_progress (학습 진행도)

  • progress_id (PK) — INT — 기본 키 — NOT NULL
  • student_id (FK) — INT — 외래 키 → users.user_id — NOT NULL
  • content_id (FK2) — INT — 외래 키 → course_contents.content_id — NOT NULL
  • course_id (PK2) — INT — 외래 키 → course_contents.course_id — NOT NULL
  • is_completed — BOOLEAN
  • completed_at — DATETIME

submissions (과제 제출)

  • submission_id (PK) — INT — 기본 키 — NOT NULL
  • assignment_id (FK) — INT — 외래 키 → assignments.assignment_id — NOT NULL
  • student_id (FK2) — INT — 외래 키 → users.user_id — NOT NULL
  • file_path — VARCHAR
  • submitted_at — DATETIME
  • score — INT
  • feedback

users (사용자)

  • user_id (PK) — INT — 기본 키 — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • username — VARCHAR(50) — NOT NULL
  • pw_hash — VARCHAR(255) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • email — VARCHAR(100)
  • created_at — DATETIME