academic
Tables (8)
course_offerings (개설강좌)
- course_offering_id (개설강좌id) — BIGINT — Primary key — NOT NULL
- course_id (강의id) — BIGINT — Foreign key → courses.course_id — NOT NULL
- professor_id (교수id) — BIGINT — Foreign key → professors.professor_id — NOT NULL
- semester (학기) — VARCHAR(10) — NOT NULL
- capacity (정원) — INTEGER — NOT NULL
courses (강의)
- course_id (강의id) — BIGINT — Primary key — NOT NULL
- course_name (이름) — VARCHAR(200) — NOT NULL
enrollments (등록)
- enrollment_id (등록id) — BIGINT — Primary key — NOT NULL
- student_id (학생id) — BIGINT — Foreign key → students.student_id — NOT NULL
- course_offering_id (개설강좌id) — BIGINT — Foreign key → course_offerings.course_offering_id — NOT NULL
- status (상태) — VARCHAR(20) — NOT NULL
- semester (학기) — VARCHAR(10) — NOT NULL
grades (학점)
- grade_id (학점id) — BIGINT — Primary key — NOT NULL
- enrollment_id (등록id) — BIGINT — Foreign key → enrollments.enrollment_id — NOT NULL
- grade (학점) — VARCHAR(3) — NOT NULL
- semester (학기) — VARCHAR(10) — NOT NULL
professors (교수)
- professor_id (교수id) — BIGINT — Primary key — NOT NULL
- professor_name (이름) — VARCHAR(100) — NOT NULL
- department (학과) — VARCHAR(100) — NOT NULL
- email (이메일) — VARCHAR(255) — NOT NULL
- phone_number (전화번호) — VARCHAR(30)
scholarship_awards (장학금)
- scholarship_award_id (장학금id) — BIGINT — Primary key — NOT NULL
- student_id (학생id) — BIGINT — Foreign key → students.student_id — NOT NULL
- semester (학기) — VARCHAR(10) — NOT NULL
- scholarship_name (장학금명) — VARCHAR(200) — NOT NULL
- amount (총액) — NUMERIC(12, 2) — NOT NULL
students (학생)
- student_id (학번) — BIGINT — Primary key — NOT NULL
- student_name (이름) — VARCHAR(100) — NOT NULL
- department (학과) — VARCHAR(100) — NOT NULL
- academic_status (학적) — VARCHAR(20) — NOT NULL
- email (이메일) — VARCHAR(255) — NOT NULL
- phone_number (전화번호) — VARCHAR(30)
tuition_invoices (등록금)
- tuition_invoice_id (등록금id) — BIGINT — Primary key — NOT NULL
- student_id (학생id) — BIGINT — Foreign key → students.student_id — NOT NULL
- semester (학기) — VARCHAR(10) — NOT NULL
- amount (총액) — NUMERIC(12, 2) — NOT NULL