Overview

Cascading deletes

The majority of tables within Conductor take advantage of the CASCADE feature of foreign-key constraints in MySQL.

Two common things that might be deleted automatically by the engine are:

• Accounts - these are added or removed relative to the main CUBED account list, as well as via toggles.
• Definitions - these are added or removed relative to changes to update_agg_pct_batch

If either of these are removed, all related slots and runs are removed as well.

Retention

We can use this feature to implement retention policies, by deleting slots's after a certain time period.