StudentManage
Tables (5)
Untitled (학과 MAJOR)
- Key (학과번호) — NUMBER(10) — Primary key — NOT NULL
- Field (학과명) — VARCHAR2
Untitled (학생 STD)
- Key (학생번호) — CHAR(8) — Primary key — NOT NULL
- Key — Primary key — NOT NULL
- Key2 — Primary key — NOT NULL
- Key (학과번호) — NUMBER(10) — Foreign key → Untitled.Key — NOT NULL
- Field (이름) — VARCHAR2(30)
- Field (평점) — NUMBER(3,2)
- Field2 (연락처) — CHAR(11)
- Field3 (이메일) — VARCHAR2(100)
Untitled (교수)
- Key (학과번호2) — NUMBER(10) — Foreign key → Untitled.Key — NOT NULL
- Field (교수번호) — CHAR(8) — NOT NULL
- Field2 (이름) — VARCHAR2(30)
- Field3 (학과번호) — VARCHAR2(30)
- Field4 (연락처) — CHAR(11)
- Field5 (이메일) — VARCHAR2(100)
Untitled (과목 SUBJECT)
- Key (과목번호) — CHAR(4) — Primary key — NOT NULL
- Key (학생번호) — CHAR(8) — Foreign key → Untitled.Key — NOT NULL
- Key — Foreign key → Untitled.Key — NOT NULL
- Key2 — Foreign key → Untitled.Key2 — NOT NULL
- Field (과목명) — VARCHAR2(60)
- Field (수강제한인원) — NUMBER(3)
Untitled (수강)
- Key (학과번호2) — NUMBER(10) — Foreign key → Untitled.Key — NOT NULL
- Key (과목번호2) — CHAR(4) — Foreign key → Untitled.Key — NOT NULL
- Key (학생번호2) — CHAR(8) — Foreign key → Untitled.Key — NOT NULL
- Key — Foreign key → Untitled.Key — NOT NULL
- Key2 — Foreign key → Untitled.Key2 — NOT NULL
- Field (순번) — CHAR(10)
- Field2 (과목번호) — CHAR(4)
- Field3 (학생번호) — CHAR(8)
- Field (수강신청날짜)