Church Cashbook Data Schema Manual

High-level model, key invariants, and how to read this manual.

What this schema supports

• Simple “money in / money out” entry for non-accountants.
• Double-entry bookkeeping stored internally for reporting integrity.
• Per-church scope isolation for RBAC.
• Void-not-delete model for audit transparency.
• Opening balances per financial year.

How to complete the table pages

Each table page has placeholders. Paste the table DDL (CREATE TABLE + indexes + constraints), and we will replace placeholders with accurate documentation.

PII and sensitive areas

• Gift Aid declarations contain personal data.
• Receipts may contain names/addresses/bank details.
• Logs may contain identifiers and operational details.

Overall ERD