Link orders to customers with an enforced, cascading foreign key

customers and orders exist as two separate tables, but nothing stops orders.customer_id from pointing at a customer that doesn't exist — the two tables aren't actually linked at the database level yet.

Add a FOREIGN KEY from orders.customer_id to customers.id. A customer who closes their account should have their orders removed automatically, so the constraint needs ON DELETE CASCADE.