We'll want to use SET NULL instead of CASCADE here like we did for lists.sr.ht mailing list webhooks to avoid deletion problems.
To reproduce the deletion problem: create a ticket/tracker webhook for the TICKET_DELETED/TRACKER_DELETED events, then try to delete the ticket/tracker. The ticket/tracker cannot be deleted.