tree navigator

Tables (5)

Untitled

    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)