ON DELETE CASCADE

Also written: ON DELETE RESTRICT, ON DELETE SET NULL

Options after REFERENCES that say what happens when a referenced row is deleted. CASCADE deletes the dependent rows too, RESTRICT refuses the delete, and SET NULL empties the link.