Integritas & Foreign Key

Database ikut menjaga aturan relasi, bukan hanya aplikasi.

  ALTER TABLE lessons
    ADD CONSTRAINT fk_lessons_course
    FOREIGN KEY (course_id) REFERENCES courses(id)
    ON DELETE CASCADE;

ON DELETE CASCADE menghapus materi saat kursus dihapus, menjaga tak ada data yatim.