수강신청
테이블 (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