A SQL trigger is database code that runs automatically when a specified database event occurs. It can enforce related cleanup without requiring every application path to implement the same deletion logic. section 5.9
A trigger was considered for an ACH-record consistency problem:
- When a parsed record is deleted, a trigger could also delete its associated unparsed record. section 5.9
- The alternative would be expanding application code so every deletion path removes both records. section 5.9
- The design ultimately retained both record types through table reorganization rather than implementing the trigger. section 5.9
