학사 관리 시스템

테이블 (13)

AU Major (major)

  • Key (majorcode) — VARCHAR(10) — 외래 키 → majorinformation.Key — NOT NULL
  • Key (stunumber) — VARCHAR(8) — 외래 키 → Untitled.Key — NOT NULL

Untitled (stu)

  • Key (stunumber) — INTEGER(8) — 기본 키 — NOT NULL
  • Field (pname) — VARCHAR(20)
  • Field (pwd) — VARCHAR(10)
  • Field (address) — VARCHAR(60)
  • Field (sex) — VARCHAR(2)
  • Field (age) — INTEGER(3)
  • Field (ssn) — VARCHAR(14)
  • Key (professorcode) — VARCHAR(10) — 외래 키 → Untitled.Key — NOT NULL
  • Key (deptcode) — VARCHAR(10) — 외래 키 → Untitled.Key — NOT NULL

Untitled (professor)

  • Key (professorcode) — VARCHAR(10) — 기본 키 — NOT NULL
  • Field (pname) — VARCHAR(20)
  • Field (ssn) — VARCHAR(14)
  • Field (majorcode) — VARCHAR(10)
  • Field (pwd) — VARCHAR(10)
  • Field (address) — VARCHAR(60)
  • Field (lab) — VARCHAR(20)
  • Field (salary) — INTEGER(10)
  • Field (sex) — VARCHAR(2)
  • Field (age) — INTEGER(3)
  • Key (deptcode) — VARCHAR(10) — 외래 키 → Untitled.Key — NOT NULL

Untitled (dept)

  • Key (deptcode) — VARCHAR(10) — 기본 키 — NOT NULL
  • Field (deptname) — VARCHAR(20)
  • Field (depttel) — VARCHAR(15)

Untitled (scholarship)

  • Key (stunumber) — INTEGER(8) — 외래 키 → Untitled.Key — NOT NULL
  • Key (scholarshipcode) — VARCHAR(10) — 외래 키 → Untitled.Key — NOT NULL
  • Field (scholarshipdate) — DATE
  • Field (receipmoney) — INTEGER(15)

Untitled (scholarshipinformation)

  • Key (scholarshipcode) — VARCHAR(10) — 기본 키 — NOT NULL
  • Field (scholarshipname) — VARCHAR(20)
  • Field (scholarshipmoney) — INTEGER(10)

Untitled (openingsubject)

  • Key (subjectcode) — VARCHAR(10) — 기본 키 — NOT NULL
  • Key (openingyear) — INTEGER(4) — 기본 키 — NOT NULL
  • Field (subjectname) — VARCHAR(18)
  • Field (classification) — VARCHAR(2)
  • Field (academicyear) — INTEGER(1)
  • Field (semaster) — INTEGER(1)
  • Field (credit) — INTEGER(1)
  • Field (lecturetimenum) — INTEGER(1)

Untitled (takingsubject)

  • Key (subjectcode) — VARCHAR(10) — 외래 키 → Untitled.Key — NOT NULL
  • Key (openingyear) — INTEGER(4) — 외래 키 → Untitled.Key — NOT NULL
  • Key (stunumber) — INTEGER(8) — 외래 키 → Untitled.Key — NOT NULL
  • Field (grade) — VARCHAR(1)

Untitled (tm)

  • Key (tmcode) — VARCHAR(10) — 기본 키 — NOT NULL
  • Field (tmname) — VARCHAR(20)
  • Key (professorcode) — VARCHAR(10) — 외래 키 → Untitled.Key — NOT NULL
  • Key (subjectcode) — VARCHAR(10) — 외래 키 → Untitled.Key — NOT NULL
  • Key (openingyear) — INTEGER(4) — 외래 키 → Untitled.Key — NOT NULL

Untitled (lecture)

  • Key (professorcode) — VARCHAR(10) — 외래 키 → Untitled.Key — NOT NULL
  • Key (subjectcode) — VARCHAR(10) — 외래 키 → Untitled.Key — NOT NULL
  • Key (openingyear) — INTEGER(4) — 외래 키 → Untitled.Key — NOT NULL
  • Field (lectureschedule) — VARCHAR(18)
  • Field (lectureroom) — VARCHAR(18)
  • Field (lecturetime) — VARCHAR(18)

Untitled (treatiseinformation)

  • Key (treatisecode) — VARCHAR(10) — 기본 키 — NOT NULL
  • Field (treatisename) — VARCHAR(20)
  • Field (treatisedate) — DATE
  • Field (aqency) — VARCHAR(20)

Untitled (treatise)

  • Key (professorcode) — VARCHAR(10) — 외래 키 → Untitled.Key — NOT NULL
  • Key (treatisecode) — VARCHAR(10) — 외래 키 → Untitled.Key — NOT NULL

majorinformation

  • Key (majorcode) — VARCHAR(10) — 기본 키 — NOT NULL
  • 전공명 (majorname) — VARCHAR(20)