24-2

Tables (8)

Untitled (학생)

  • Key (학번) — Primary key — NOT NULL
  • Key (주민번호) — Primary key — NOT NULL
  • Field (전공)
  • Field (부전공)
  • Field (성별)
  • Field (학년)
  • Key (주소) — Foreign key → Untitled.Key — NOT NULL
  • Key (이름) — Foreign key → Untitled.Key — NOT NULL

Untitled (학과)

  • Key (학과명) — Primary key — NOT NULL
  • Key (코드) — Primary key — NOT NULL
  • Field (사무실번호)
  • Field2 (전화번호)
  • Field (소속단과대학)

Untitled (교수)

  • Key (교번) — Primary key — NOT NULL
  • Field (이름)
  • Field (최종학위)
  • Field2 (연구분야)

Untitled (분반)

  • Key (분반번호) — Primary key — NOT NULL
  • Field (개설연도)
  • Field (개설학기)
  • Key (과목번호) — Foreign key → Untitled2.Key — NOT NULL
  • Key (교번) — Foreign key → Untitled.Key — NOT NULL

Untitled (수강)

  • Key (학번) — Foreign key → Untitled.Key — NOT NULL
  • Key (주민번호) — Foreign key → Untitled.Key — NOT NULL
  • Key (분반번호) — Foreign key → Untitled.Key — NOT NULL
  • Field (평점)

Untitled (주소)

  • Key (주소) — Primary key — NOT NULL
  • Field (CITY)
  • Field (STATE)
  • Field2 (ZIP)

Untitled (이름)

  • Key (이름) — Primary key — NOT NULL
  • Field (FISRT NAME)
  • Field2 (LAST NAME)

Untitled2 (과목)

  • Key (과목번호) — Primary key — NOT NULL
  • Key (학과명) — Foreign key → Untitled.Key — NOT NULL
  • Key (코드) — Foreign key → Untitled.Key — NOT NULL
  • Field (과목명)
  • Field2 (과목소개)
  • Field (학점)
  • Field (대상학년)