software
Tables (10)
Class (Untitled9)
- Key — Primary key — NOT NULL
- 과목id (Key2) — Foreign key → Course.Key — NOT NULL
- 교수id (Key3) — Foreign key → Professor.Key — NOT NULL
- 학기id (Key4) — Foreign key → Semester.Key — NOT NULL
Classroom (Untitled5)
- Key — Primary key — NOT NULL
- 위치 (Field)
- 수용인원 (Field2)
Course (Untitled2)
- Key — Primary key — NOT NULL
- 교수id (Key2) — Foreign key → Professor.Key — NOT NULL
- 과목명 (Field)
- 학점 (Field2)
Grade (Untitled7)
- Key — Primary key — NOT NULL
- 학생id (Key2) — Foreign key → Student.Key — NOT NULL
- 과목id (Key3) — Foreign key → Course.Key — NOT NULL
- 성적 (Field)
GraduationRequirement (Untitled10)
- Key — Primary key — NOT NULL
- 전공 (Field)
- 필수학점 (Field2)
Professor (Untitled3)
- Key — Primary key — NOT NULL
- 이름 (Field)
- 소속 학과 (Field2)
Registration (Untitled4)
- Key — Primary key — NOT NULL
- 학생id (Key2) — Foreign key → Student.Key — NOT NULL
- 과목id (Key3) — Foreign key → Course.Key — NOT NULL
- 신청날짜 (Field)
Semester (Untitled6)
- Key — Primary key — NOT NULL
- 학기명 (Field)
- 시작일 (Field2)
- 종료일 (Field3)
Student (Untitled)
- Key — Primary key — NOT NULL
- 이름 (Field)
- 학번 (Field2)
- 전공 (Field3)
Timetable (Untitled8)
- Key3 — Primary key — NOT NULL
- 과목id (Key) — Foreign key → Course.Key — NOT NULL
- 강의실id (Key2) — Foreign key → Classroom.Key — NOT NULL
- 강의시간 (Field)