WS8 F/G bundled migration: firm models + deletion governance

↗ view on GitHub · sloth-ninja · 2026-07-27 · f9dd9eb7

Owner-authorised 27/07/2026 (allowlist entry added by the owner).
Additive, defaulted columns only - zero behaviour change until PR F/G
code lands:

- organisations: allow_member_model_prefs (default false), model_config
  jsonb, retention_days (default 30)
- deleted_at/deleted_by tombstones + pending-purge partial indexes on
  projects, documents, chats, tabular_reviews, workflows
  (document_versions precedent)
- deletion_audit_logs: append-only org-scoped audit trail, RLS enabled,
  browser-role grants revoked

schema.sql mirrored; BUILD_LOG records the gate decisions (account
deletion blocked for org members in v1, retention 1-365 admin-editable,
one audit row per bulk action).

Co-Authored-By: Claude Fable 5 <noreply@anthropic.com>
Repository Sloth-ninja/JessicaOSS
Author sloth-ninja <ezanahaddis@gmail.com>
Authored
Parents 28c8343e
Stats 4 files changed , +164 , -3
Part of WS8: firm deletion governance and retention controls

Capture this commit into my fork

Download a Markdown prompt that tells Claude how to port this exact commit into your working tree. Run it via claude -p < capture-commit-f9dd9eb7.md from inside the repo you want the change in.

⬇ Download capture-commit-f9dd9eb7.md