The whistleblower pivot
The single most useful key to the schema: the codebase was forked from a generic
case_status enum history
The Postgres case_status enum evolved through three migrations and, because PG enums
Key tables (map)
A quick map of the ~30 tables, grouped. Full column detail lives in the migrations; this is
Role model
Roles are the approle enum, stored on **companymemberships.role (company-wide) and