likelion_erd

Tables (9)

assignment (Untitled5)

  • 과제ID (assignment_id) — Primary key — NOT NULL
  • 강의ID (lecture_id) — Foreign key → lecture.강의ID — NOT NULL
  • 강좌ID (course_id) — Foreign key → lecture.강좌ID — NOT NULL
  • 마감기한 (deadline)
  • 제목 (title)
  • 설명 (explanation)

assignment_submition (Untitled7)

  • 제출ID (submition_id) — Primary key — NOT NULL
  • 회원ID (user_id) — Foreign key → user.회원ID — NOT NULL
  • 과제ID (assignment_id) — Foreign key → assignment.과제ID — NOT NULL
  • 강의ID (lecture_id) — Foreign key → assignment.강의ID — NOT NULL
  • 강좌ID (course_id) — Foreign key → assignment.강좌ID — NOT NULL
  • 제목 (submit_title)
  • 본문 (submit_main)
  • 제출일시 (submit_date)
  • 제출파일 (submit_file)

course (Untitled3)

  • 강좌ID (course_id) — Primary key — NOT NULL
  • 교수ID (professor_id) — Foreign key → professor.교수ID — NOT NULL
  • 제목 (Field)

enrollment (Untitled2)

  • 등록ID (enrollment_id) — Primary key — NOT NULL
  • 회원ID (user_id) — Foreign key → user.회원ID — NOT NULL
  • 강좌ID (course_id) — Foreign key → course.강좌ID — NOT NULL

grading (Untitled8)

  • 채점자ID (grading_id) — Primary key — NOT NULL
  • 제출ID (submition_id) — Foreign key → assignment_submition.제출ID — NOT NULL
  • 점수 (grading_point)

info (Untitled9)

  • 공지사항ID (info_id) — Primary key — NOT NULL
  • 강좌ID (course_id) — Foreign key → course.강좌ID — NOT NULL
  • 제목 (info_title)
  • 작성일 (info_date)
  • 조회수 (info_views)

lecture (Untitled6)

  • 강의ID (lec_id) — Primary key — NOT NULL
  • 강좌ID (course_id) — Foreign key → course.강좌ID — NOT NULL
  • 강의제목 (lec_title)
  • 첨부파일 (lec_files)

professor (Untitled4)

  • 교수ID (professor_id) — Primary key — NOT NULL

user (Untitled)

  • 회원ID (user_id) — Primary key — NOT NULL
  • 이름 (name)
  • 학번 (student_number)
  • 비밀번호 (password)
  • 학과 (department)
  • 메일 (email)