Dept_new

Tables (7)

Untitled (학생)

  • Key (학번) — char(8) — Primary key — NOT NULL
  • Field (이름) — char(4)
  • Field (전화) — char(11)
  • Field (주소) — varchar(50)
  • Key (학과명) — varchar(50) — Foreign key → Untitled2.Key — NOT NULL
  • Key (상담교수) — char(5) — Foreign key → Untitled3.Key — NOT NULL

Untitled (수강신청)

  • Key (학수번호) — char(7) — Foreign key → Untitled4.Key — NOT NULL
  • Key (학번) — char(8) — Foreign key → Untitled.Key — NOT NULL
  • Field (개설연도) — date
  • Field2 (성적) — char(2)
  • Key (담당교수) — char(5) — Foreign key → Untitled3.Key — NOT NULL
  • Key (담당강의실) — char(5) — Foreign key → Untitled.Key — NOT NULL

Untitled (강의실)

  • Key (ROOMnO) — char(5) — Primary key — NOT NULL
  • Field (강의실명) — varchar(20)

Untitled2 (학과)

  • Key (학과명) — varchar(50) — Primary key — NOT NULL
  • Field (ROOMnO) — char(5)
  • Field2 (PHONE) — char(11)
  • Field3 (FAX) — char(11)
  • Field4 (주소) — varvhar(50)

Untitled3 (교수)

  • Key (직번) — char(5) — Primary key — NOT NULL
  • Field (이름) — char(4)
  • Field (전화) — char(11)
  • Field (주소) — varchar(50)
  • Key (학과명) — varchar(50) — Foreign key → Untitled2.Key — NOT NULL

Untitled4 (교과목)

  • Key (학수번호) — char(7) — Primary key — NOT NULL
  • Field (과목명) — varchar(40)
  • Field (학점) — int
  • Key (학과명) — varchar(50) — Foreign key → Untitled2.Key — NOT NULL

Untitled5 (실험실)

  • Key (실험실id) — char(5) — Primary key — NOT NULL
  • Field (ROOMNO) — char(5)
  • Field (실험실명) — varchar(30)
  • Key (직번) — char(5) — Foreign key → Untitled3.Key — NOT NULL