Eric P on Nostr: Cascade tells it to apply actions on the parent table to child tables. For example, ...

Cascade tells it to apply actions on the parent table to child tables. For example, if you deleted a feed out of the feeds table, it would cascade that action down to any table that has feed_id as a foreign key (e.g. feed poll rolls, feed value tags, etc).

It's to avoid the case where you've deleted a feed_id from the feeds table, but other tables still reference that feed_id.