dd

Tables (13)

academic_program

  • program_id — BIGINT
  • program_name — VARCHAR(100) — NOT NULL
  • description — VARCHAR(500)
  • required_credits — INT — NOT NULL

classroom

  • classroom_id — BIGINT
  • building — VARCHAR(100) — NOT NULL
  • room_number — VARCHAR(30) — NOT NULL
  • capacity — INT — NOT NULL

course

  • course_id — BIGINT
  • course_code — VARCHAR(30) — NOT NULL
  • course_name — VARCHAR(100) — NOT NULL
  • description — VARCHAR(500)
  • credits — INT — NOT NULL
  • department — VARCHAR(100) — NOT NULL

course_section

  • section_id — BIGINT
  • course_id — BIGINT — Foreign key → course.course_id — NOT NULL
  • instructor_id — BIGINT — Foreign key → instructor.instructor_id — NOT NULL
  • year — INT — NOT NULL
  • semester — VARCHAR(20) — NOT NULL
  • section_name — VARCHAR(30) — NOT NULL
  • capacity — INT — NOT NULL

enrollment

  • enrollment_id — BIGINT
  • student_id — BIGINT — Foreign key → student.student_id — NOT NULL
  • section_id — BIGINT — Foreign key → course_section.section_id — NOT NULL
  • enrollment_date — DATE — NOT NULL
  • enrollment_status — VARCHAR(30) — NOT NULL

grade

  • grade_id — BIGINT
  • enrollment_id — BIGINT — Foreign key → enrollment.enrollment_id — NOT NULL
  • midterm_score — DECIMAL(5,2)
  • final_score — DECIMAL(5,2)
  • assignment_score — DECIMAL(5,2)
  • total_score — DECIMAL(5,2)
  • letter_grade — VARCHAR(5)
  • grade_point — DECIMAL(3,2)

instructor

  • instructor_id — BIGINT
  • account_id — BIGINT — Foreign key → user_account.account_id
  • name — VARCHAR(50) — NOT NULL
  • phone — VARCHAR(30)
  • email — VARCHAR(100)
  • department — VARCHAR(100) — NOT NULL

prerequisite

  • course_id — BIGINT — Foreign key → course.course_id — NOT NULL
  • prerequisite_course_id — BIGINT — Foreign key → course.course_id — NOT NULL

program_course

  • program_id — BIGINT — Foreign key → academic_program.program_id — NOT NULL
  • course_id — BIGINT — Foreign key → course.course_id — NOT NULL
  • course_type — VARCHAR(20) — NOT NULL

role

  • role_id — BIGINT
  • role_name — VARCHAR(30) — NOT NULL
  • description — VARCHAR(255)

section_schedule

  • schedule_id — BIGINT
  • section_id — BIGINT — Foreign key → course_section.section_id — NOT NULL
  • classroom_id — BIGINT — Foreign key → classroom.classroom_id — NOT NULL
  • day_of_week — VARCHAR(20) — NOT NULL
  • start_time — TIME — NOT NULL
  • end_time — TIME — NOT NULL

student

  • student_id — BIGINT
  • account_id — BIGINT — Foreign key → user_account.account_id
  • program_id — BIGINT — Foreign key → academic_program.program_id — NOT NULL
  • student_number — VARCHAR(30) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • phone — VARCHAR(30)
  • email — VARCHAR(100)
  • enrollment_status — VARCHAR(30) — NOT NULL

user_account

  • account_id — BIGINT
  • login_id — VARCHAR(50) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • role_id — BIGINT — Foreign key → role.role_id — NOT NULL
  • created_at — DATETIME — NOT NULL
  • is_active — BOOLEAN — NOT NULL