Data Schema Manual
Applies to application version: 1.2.0
Documentation revision: 15 March 2026
Change Log
- System diagnostics page introduced
- Backup monitoring and status reporting
- Runtime certification display
- Maintenance mode improvements (OFF / DRAIN / MAINTENANCE)
- Release integrity verification
- Automated test reporting
Reference documentation for the Church Cashbook MySQL schema: table purposes, relationships, constraints, and operational invariants.
Scope: This manual describes the database schema and the rules the application relies on (e.g., void-not-delete, opening balances per financial year).
How we will complete this manual
- We start with a complete structure and placeholder pages for every table/module.
- You paste each table’s DDL (
CREATE TABLE+ indexes + constraints). - I update the relevant page with accurate column explanations, constraints, and usage notes.