heaventree reverse-engineers Mike's database from scratch

Upstream Mike ships the application but not a canonical database schema, leaving anyone who wants to host their own copy to piece it together from the code. heaventree has done that work: a single migration stands up the full data model - user profiles and tiered credits, encrypted per-user API keys for Claude, Gemini and OpenAI, projects and subfolders, documents with version history, workflows, chats, and the tabular review tables. Access is locked down to a backend service role rather than exposed to anonymous users, and new signups automatically get a profile row.

A few details to scrutinise before borrowing it wholesale: the default tabular model points at a Gemini preview that may not match upstream, and project ownership is stored loosely rather than as a strict foreign key to the auth system. Worth a careful read, not a blind copy.