likelion_hw7

Tables (5)

CourseHistory (이수내역)

  • ID (학번) — Foreign key → User.ID — NOT NULL
  • Code (과목코드) — Foreign key → Lecture.Code — NOT NULL
  • MajorName (전공명) — Foreign key → Major.MajorName — NOT NULL

Lecture (강의)

  • Code (과목코드) — Primary key — NOT NULL
  • Name (과목명)
  • MajorName (전공명) — Foreign key → Major.MajorName — NOT NULL
  • CourseLevel (난이도)
  • Category (강의분류)

Major (전공)

  • MajorName (전공명) — Primary key — NOT NULL
  • College (단과대학)

PreRequisiteRelation (선이수관계)

  • Code (과목코드) — Foreign key → Lecture.Code — NOT NULL
  • PreCode (선이수과목코드) — Foreign key → Lecture.Code — NOT NULL

User (사용자)

  • ID (학번) — Primary key — NOT NULL
  • Name (이름)
  • Interest (관심전공) — Foreign key → Major.MajorName — NOT NULL
  • Level (수준)
  • MajorName (이수전공) — Foreign key → Major.MajorName — NOT NULL