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