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)