학사 관리 시스템
테이블 (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)