The foreign key construction contains the option on cascade delete. The
role of this option is to define the behavior of the tables when deletions occur
in the table where the primary key occurs. Namely, when a row is removed
from the table containing the primary key and the clause on cascade delete is
specified, then all rows from the table that contains the corresponding foreign
key that match the removed row are also removed.