Production data model • backend planning
Production Data Model / Schema Preview
A practical schema preview so the next backend build can connect the preview workflows to secure accounts, matters, document storage, packages, review orders, payments, assignments, permissions, audit logs, and attorney engagements.
Planning only: This does not create a production database. It lists the tables/collections, controls, and relationships needed before real documents, payments, attorney review, or secure access can go live.
v1.0.36: A PostgreSQL production schema blueprint is included at
backend/database/schema.sql for users, roles, matters, drafts, uploads, referrals, payments, rewards, attorney engagements, finalization releases, AI runs, consents, and audit logs.