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