f915866f83
Expand 03-database.md with complete table structure reference for all 23 tables in the final schema: active QuoteForge tables, competitor subsystem, legacy RFQ tables, and server-side-only tables. Also clarifies access patterns per group and notes removal of qt_client_local_migrations from the schema. Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
QuoteForge Bible
Project-specific architecture and operational contracts.
Files
| File | Scope |
|---|---|
| 01-overview.md | Product scope, runtime model, repository map |
| 02-architecture.md | Local-first rules, sync, pricing, versioning |
| 03-database.md | SQLite and MariaDB data model, permissions, migrations |
| 04-api.md | HTTP routes and API contract |
| 05-config.md | Runtime config, paths, env vars, startup behavior |
| 06-backup.md | Backup contract and restore workflow |
| 07-dev.md | Development commands and guardrails |
| 09-vendor-spec.md | Vendor BOM and CFXML import contract |
Rules
bible-local/is the source of truth for QuoteForge-specific behavior.- Keep these files in English.
- Update the matching file in the same commit as any architectural change.
- Remove stale documentation instead of preserving history in place.
Quick reference
- Local DB path: see 05-config.md
- Runtime bind: loopback only
- Local backups: see 06-backup.md
- Release notes:
releases/<version>/RELEASE_NOTES.md