Add migration with on cascade delete constraint

[mattwparas]

Problem

Closes: #2871

Solution

I am occasionally running into this #2871 - after reviewing the migrations it appears that a cascade delete constraint was missing. I believe this is a backwards compatible change. The problem manifests itself when the retention job runs, and causes the retention jobs to quit and not continue since it can't move forward.

One-line summary:

Checklist

• [x] You've signed-off your work
• [ ] Your changes are accompanied by tests (if relevant)
• [ ] Your change contains a small diff and is self-contained
• [ ] You've updated any relevant documentation (if relevant)
• [ ] You've included a one-line summary of your change for the CHANGELOG.md (Depending on the change, this may not be necessary).
• [ ] You've versioned your .sql database schema migration according to Flyway's naming convention (if relevant)
• [ ] You've included a header in any source code files (if relevant)

[boring-cyborg[bot]]

Thanks for opening your first pull request in the Marquez project! Please check out our contributing guidelines (https://github.com/MarquezProject/marquez/blob/main/CONTRIBUTING.md).

[netlify[bot]]

✅ Deploy Preview for peppy-sprite-186812 canceled.

Name	Link
🔨 Latest commit	b6dec32190d381ebca2a9340856b268706a4c721
🔍 Latest deploy log	https://app.netlify.com/sites/peppy-sprite-186812/deploys/66c8acf31cc94d00088e71d2

[codecov[bot]]

Codecov Report

All modified and coverable lines are covered by tests :white_check_mark:

Project coverage is 83.28%. Comparing base (ead480b) to head (b6dec32). Report is 1 commits behind head on main.

Additional details and impacted files

```diff @@ Coverage Diff @@ ## main #2878 +/- ## ========================================= Coverage 83.28% 83.28% Complexity 1477 1477 ========================================= Files 259 259 Lines 6785 6785 Branches 313 313 ========================================= Hits 5651 5651 Misses 977 977 Partials 157 157 ```

:umbrella: View full report in Codecov by Sentry.
:loudspeaker: Have feedback on the report? Share it here.

[boring-cyborg[bot]]

Great job! Congrats on your first merged pull request in the Marquez project!