I have not written SQL in a while, and today I know I needed to define a column with ON DELETE CASCADE. However, playing out the deletion scenario in my head was challenging (i.e. should it be here or the other table?) — it felt like the first time learning SQL.

I found a DBA StackExchange thread that was helpful: SQL:2011 Spec of ON DELETE behaviors.