tree navigator
Tables (5)
courses
- id — INT — NOT NULL
- title — VARCHAR(100) — NOT NULL
- credits — INT
- recommended_year — INT
- track_name — VARCHAR(50)
prerequisites
- pre_id — INT — Foreign key → courses.id — NOT NULL
- post_id — INT — Foreign key → courses.id — NOT NULL
student_courses
- student_id — VARCHAR(20) — Foreign key → students.student_id — NOT NULL
- course_id — INT — Foreign key → courses.id — NOT NULL
- completed_at — DATETIME
students
- student_id — VARCHAR(20) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- role — VARCHAR(10)