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 (수강신청날짜)