EOS학사관리ERD
테이블 (15)
AcademicRecord (academicRecord)
- SerialNumber (serialNumber) — char(9) — 외래 키 → Student.SerialNumber — NOT NULL — student
- Semester (semester) — char(6) — 외래 키 → Semester.Semester — NOT NULL
- SubjectCode (subjectCode) — varchar(10) — 외래 키 → Semester.SubjectCode — NOT NULL
- Score (score) — char(2)
- SerialNumber (serialNumber2) — char(9) — 외래 키 → Professor.SerialNumber — NOT NULL — professor
- evaluationCode — char(1)
Basket (basket)
- SerialNumber (serialNumber) — char(9) — 외래 키 → Student.SerialNumber — NOT NULL — 최대 21학점이면 기본 한명당 7개의 데이터중복이 일어난다.
- SubjectCode (subjectCode) — varchar(10) — 외래 키 → Subject.SubjectCode — NOT NULL
Board (board)
- BoardNumber (boardNumber) — number — 기본 키 — NOT NULL
- BoardType (boardType) — varchar(10) — 외래 키 → BoardType.BoardType — NOT NULL
- SerialNumber (serialNumber) — char(9) — 외래 키 → Privacy.SerialNumber — NOT NULL
- Title (title) — varchar(120)
- ReadCount (readCount) — number
- Reference (reference) — number
- Step (step) — number
- Depth (depth) — number
- RegistrationDate (registrationDate) — char(10)
- Content (content) — varchar(4000)
- IpAddress (ipAddress) — char(16)
- rwmd — char(3)
- Files (files) — varchar(600)
BoardType (boardType)
- BoardType (boardType) — varchar(10) — 기본 키 — NOT NULL — subjectcode
- Description (description) — varchar(60)
Campus (campus)
- HouseNumber (houseNumber) — char(7) — 기본 키 — NOT NULL — 0008/321
- HouseName (houseName) — varchar(60)
- Latitude (latitude) — char(12)
- Longitude (longitude) — char(12)
Department (department)
- DepartmentCode (departmentCode) — char(7) — 기본 키 — NOT NULL — SCSW/000
- DepartmentName (departmentName) — varchar(60)
- HouseNumber (houseNumber) — char(7) — 외래 키 → Campus.HouseNumber — NOT NULL
- Capacity (capacity) — char(4) — 4자리 자연수
Faculty (faculty)
- SerialNumber (serialNumber) — char(9) — 외래 키 → Privacy.SerialNumber — NOT NULL — faculty
- HouseNumber (houseNumber) — char(7) — 외래 키 → Campus.HouseNumber — NOT NULL
- SubjectCode (subjectCode) — varchar(10) — 외래 키 → Subject.SubjectCode — NOT NULL
- Password (password) — varhar(50)
- Grade (grade) — char(2)
Identification (identification)
- IdentificationCode (identificationCode) — char(4) — 기본 키 — NOT NULL — 두자리 자연수까지사용가능
- Description (description) — varchar(30) — 한글로 10글자 삽입가능
Major
- MajorCode (majorCode) — varchar(10) — 기본 키 — NOT NULL
- MajorName (majorName) — varchar(60)
- DepartmentCode (departmentCode) — char(7) — 외래 키 → Department.DepartmentCode — NOT NULL
- Capacity (capacity) — char(4)
Privacy (privacy)
- SerialNumber (serialNumber) — char(9) — 기본 키 — NOT NULL — 9자리자연수
- IdentificationCode (identificationCode) — char(2) — 외래 키 → Identification.IdentificationCode — NOT NULL — anybody
- Name (name) — varchar(30)
- ResidentRegistrationNumber (rRNum) — char(14) — '-' 연산x
- PhoneNumber (phoneNumber) — char(13)
- Email (email) — varchar(40)
- Gender (gender) — char(1) — F 또는 M
- Birthday (birthDay) — char(6)
- Address (address) — varchar(120)
- Admission (admission) — char(4) — 4자리 자연수
Professor (professor)
- SerialNumber (serialNumber) — char(9) — 외래 키 → Privacy.SerialNumber — NOT NULL — professor
- HouseNumber (houseNumber) — char(7) — 외래 키 → Campus.HouseNumber — NOT NULL
- DepartmentCode (departmentCode) — char(7) — 외래 키 → Department.DepartmentCode — NOT NULL
- MajorCode (majorCode) — varchar(10) — 외래 키 → Major.MajorCode — NOT NULL
- Password (password) — varhar(50)
- Grade (grade) — char(2)
RequiredSubject (requiredSubject)
- MajorCode (majorCode) — varchar(10) — 외래 키 → Major.MajorCode — NOT NULL
- SubjectCode (subjectCode) — varchar(10) — 외래 키 → Subject.SubjectCode — NOT NULL
- classification — varchar(30)
Semester (semester)
- Semester (semester) — char(6) — 기본 키 — NOT NULL
- SubjectCode (subjectCode) — varchar(10) — 외래 키 → Subject.SubjectCode — NOT NULL
Student (student)
- SerialNumber (serialNumber) — char(9) — 외래 키 → Privacy.SerialNumber — NOT NULL — student
- DepartmentCode (departmentCode) — char(7) — 외래 키 → Department.DepartmentCode — NOT NULL
- MajorCode (majorCode) — varchar(10) — 외래 키 → Major.MajorCode — NOT NULL
- Password (password) — varhar(50)
- Grade (grade) — char(2) — 1학년은 10
Subject (subject)
- SubjectCode (subjectCode) — varchar(10) — 기본 키 — NOT NULL
- SubjectName (subjectName) — varchar(60)
- Credit (credit) — number
- SerialNumber (serialNumber) — char(9) — 외래 키 → Professor.SerialNumber — NOT NULL — professor
- HouseNumber (houseNumber) — char(7) — 외래 키 → Campus.HouseNumber — NOT NULL
- Timetable (timetable) — char(30)
- Open (open) — char(1)
- capacity — number