CASCADE

policy is to delete any rows referencing the deleted row, or update the value of the referencing column to the new value of the referenced column, respectively