ㅈ

Tables (7)

Untitled (학생)

  • Key (학번) — Primary key — NOT NULL
  • Field (이름)
  • Field2 (전공)

Untitled (교수)

  • Key (교수ID) — Primary key — NOT NULL
  • Field (이름)
  • Field (전공)

Untitled (과목)

  • Key (과목ID) — Primary key — NOT NULL
  • Field (과목명)

Untitled (강의실)

  • Key (강의실Id) — Primary key — NOT NULL
  • Field (장소)
  • Field (인원)

Untitled (수강)

  • Key (학번) — Foreign key → Untitled.Key — NOT NULL
  • Key (개설강좌 ID) — Foreign key → Untitled.Key — NOT NULL
  • Field (성적)
  • Field (출석점수)

Untitled (강의배정)

  • Key (교수ID) — Foreign key → Untitled.Key — NOT NULL
  • Key (개설강좌 ID) — Foreign key → Untitled.Key — NOT NULL
  • Field (팀티칭)

Untitled (개설강좌)

  • Key (개설강좌 ID) — Primary key — NOT NULL
  • Field (강의시간)
  • Field (수강정원)
  • Key (과목ID) — Foreign key → Untitled.Key — NOT NULL
  • Key (강의실Id) — Foreign key → Untitled.Key — NOT NULL