수강신청

테이블 (8)

Classroom

  • ClassroomID — VARCHAR(10) — 기본 키 — NOT NULL
  • Location — VARCHAR(255) — NOT NULL
  • Capacity — INT — NOT NULL
  • Equipment — VARCHAR(255)

CourseRegistration

  • Year — YEAR — 기본 키 — NOT NULL
  • Semester — VARCHAR(10) — 기본 키 — NOT NULL
  • StudentID — VARCHAR(10) — 외래 키 → Student.StudentID — NOT NULL
  • LectureCode — VARCHAR(10) — 외래 키 → Lecture.LectureCode — NOT NULL

CourseWithdrawal

  • StudentID — VARCHAR(10) — 외래 키 → Student.StudentID — NOT NULL
  • LectureCode — VARCHAR(10) — 외래 키 → Lecture.LectureCode — NOT NULL
  • WithdrawalDate — DATE — NOT NULL
  • Reason — VARCHAR(255)

Department

  • DepartmentCode — VARCHAR(10) — 기본 키 — NOT NULL
  • DepartmentName — VARCHAR(255) — NOT NULL
  • EstablishedYear — YEAR
  • DepartmentPhone — VARCHAR(15)

Lecture

  • LectureCode — VARCHAR(10) — 기본 키 — NOT NULL
  • WeeklyHours — INT — NOT NULL
  • ProfessorID — VARCHAR(10) — 외래 키 → Professor.ProfessorID — NOT NULL
  • ClassroomID — VARCHAR(10) — 외래 키 → Classroom.ClassroomID — NOT NULL
  • SubjectCode — VARCHAR(10) — 외래 키 → Subject.SubjectCode — NOT NULL
  • DepartmentCode — VARCHAR(10) — 외래 키 → Department.DepartmentCode — NOT NULL

Professor

  • ProfessorID — VARCHAR(10) — 기본 키 — NOT NULL
  • Name — VARCHAR(255) — NOT NULL
  • SSN — VARCHAR(11) — NOT NULL
  • HighestDegree — VARCHAR(100)
  • Address — VARCHAR(255)
  • Phone — VARCHAR(15)
  • Email — VARCHAR(255)
  • Gender — CHAR(1)

Student

  • StudentID — VARCHAR(10) — 기본 키 — NOT NULL
  • Name — VARCHAR(255) — NOT NULL
  • SSN — VARCHAR(11) — NOT NULL
  • ZipCode — VARCHAR(10)
  • Address — VARCHAR(255)
  • Phone — VARCHAR(15)
  • Email — VARCHAR(255)
  • Gender — CHAR(1)
  • IsEnrolled — BOOLEAN — NOT NULL
  • DepartmentCode — VARCHAR(10) — 외래 키 → Department.DepartmentCode — NOT NULL

Subject

  • SubjectCode — VARCHAR(10) — 기본 키 — NOT NULL
  • SubjectName — VARCHAR(255) — NOT NULL