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