Hosts that require referential integrity (kof22's foreign key guardrail) get
fk_release_notes_item_release_id from the qbit itself (ON DELETE CASCADE).
Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>
Standard release_notes_ tables with a Liquibase changelog (no foreign
keys) and seeded settings; once-per-version detection guarded by a unique
app + version key; GitHub and platform-component sources behind a
ReleaseSource SPI; a deterministic rule-based drafter and a sanitizer that
keeps internal references, personal data and secrets out of published
text; Publish, Skip and Redraft record actions and Check for new release;
one RELEASE notification per published release via QAlerts.notify; and the
release-notes UI API extension (releases, summary, seen) with a committed
OpenAPI contract and a complete help bundle.
Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>
james.maesandClaude Opus 5.5