실라버스(Syllaverse) 분석

테이블 (3)

Assignment

  • AssignmentID — INT
  • AssignmentName — VARCHAR(50)
  • AssignmentDescription — TEXT
  • AssignmentDeadline — DATE
  • LectureID — INT — 외래 키 → Lecture.LectureID

Lecture

  • LectureID — INT
  • LectureName — VARCHAR(50)
  • LectureDescription — TEXT
  • InstructorName — VARCHAR(50)
  • LectureDate — DATE
  • CourseID — INT

Survey

  • SurveyID — INT
  • SurveyName — VARCHAR(50)
  • SurveyDescription — TEXT
  • SurveyDeadline — DATE
  • AssignmentID — INT — 외래 키 → Assignment.AssignmentID