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