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)