Dept_new
Tables (7)
Untitled (학생)
- 학번 — char(8) — Primary key — NOT NULL
- 이름 — char(4)
- 전화 — char(11)
- Field (주소) — VARCHAR(50)
- Key (학과명) — VARCHAR(30) — Foreign key → Untitled.Key — NOT NULL
- Key (상담교수) — char(5) — Foreign key → Untitled.Key — NOT NULL
Untitled (교과목)
- Key (학수번호) — char(7) — Primary key — NOT NULL
- Field (과목명) — varchar(40)
- Field (학점) — int
- Key (학과명) — VARCHAR(30) — Foreign key → Untitled.Key — NOT NULL
Untitled (교수)
- Key (직번) — char(5) — Primary key — NOT NULL
- Field (이름) — char(4)
- Field (전화) — char(11)
- Field (주소) — VARCHAR(50)
- Key (학과명) — VARCHAR(30) — Foreign key → Untitled.Key — NOT NULL
Untitled (실험실)
- Key (실험실ID) — CHAR(5) — Primary key — NOT NULL
- Field (ROOMNO) — CHAR(5)
- Field (실험실명) — VARCHAR(30)
- Key (직번) — char(5) — Foreign key → Untitled.Key — NOT NULL
Untitled (학과)
- Key (학과명) — VARCHAR(30) — Primary key — NOT NULL
- Field (ROOMNO) — CHAR(5)
- Field (PHONE) — CHAR(11)
- Field (FAX) — CHAR(11)
- Field (주소) — VARCHAR(50)
Untitled (수강신청)
- Key (학수번호) — char(7) — Foreign key → Untitled.Key — NOT NULL
- 학번 — char(8) — Foreign key → Untitled.학번 — NOT NULL
- Field (개설연도) — DATE
- Field (성적) — CHAR(2)
- Key (담당교수) — char(5) — Foreign key → Untitled.Key — NOT NULL
- Key (담당강의실) — CHAR(5) — Foreign key → Untitled.Key — NOT NULL
Untitled (강의실)
- Key (ROONNO) — CHAR(5) — Primary key — NOT NULL
- Field (강의실명) — VARCHAR(20)