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