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