ON DELETE defines what happens to the rows that reference a deleted row: CASCADE deletes them too, RESTRICT (or NO ACTION) forbids the deletion, SET NULL sets the foreign key to NULL. The choice expresses a business rule, and CASCADE should be handled with care.
Example
FOREIGN KEY (client_id) REFERENCES clients(id) ON DELETE RESTRICT