시간표DB

테이블 (4)

LectureInstance (Untitled)

  • Id (Key) — string — 기본 키 — NOT NULL
  • Duration (Field) — int
  • IsContinuation (Field2) — bool

TimeTableBlock (Untitled2)

  • Id (Key) — int — 기본 키 — NOT NULL
  • ClassName (Field) — string
  • ProfessorName (Field2) — string
  • Grade (Field3) — string
  • Classroom (Field4)
  • IsFixedTime (Field5) — bool
  • FixedTimeSlot (Field6)
  • UnavailableSlot1 (Field7)
  • UnavailableSlot2 (Field8)
  • AdditionalUnavailableSlot1 (Field9)
  • AdditionalUnavailableSlot2 (Field10)
  • LectureHours_1 (Field11) — int?
  • LectureHours_2 (Field12) — int?
  • SectionCount (Field13) — int?
  • DisplayName (Field14) — string
  • Duration (Field15) — int
  • InstanceIndex (Field16) — int

professor (교수)

  • professor_id (교수id) — 기본 키 — NOT NULL
  • professor_name (교수이름)

professor-subject (교수-과목 관계)