lms_clone
Tables (5)
Comment (댓글)
- 댓글ID (comment_id) — NOT NULL — Primary key — NOT NULL
- 회원ID (user_id) — NOT NULL — Primary key — NOT NULL
- 생성일 (created_date)
- 내용 (Field)
Courses (과목)
- 과목ID (course_id) — NOT NULL — Primary key — NOT NULL
- 과목이름 (name)
- 분반 (class)
- 개설년도 (created_year)
- 개설학기 (semester)
QnA
- 질문ID (qna_id) — NOT NULL — Primary key — NOT NULL
- 회원ID (user_id) — NOT NULL — Primary key — NOT NULL
- 과목ID (course_id) — NOT NULL — Primary key — NOT NULL
- 제목 (title)
- 내용 (content)
- 생성일 (created_date)
- 과목ID (course_id2) — NOT NULL — Foreign key → Courses.과목ID — NOT NULL
User (유저)
- 회원ID (user_id) — NOT NULL — Primary key — NOT NULL
- 이름 (name)
- 학번 (student_id)
UserCourses (유저과목)
- 회원ID (user_id) — NOT NULL — Foreign key → User.회원ID — NOT NULL
- 과목ID (course_id) — NOT NULL — Foreign key → Courses.과목ID — NOT NULL