Church Cashbook
Data Schema Manual
Manual home Return to Church Cashbook

Church Cashbook Data Schema Manual

Gift Aid declarations (donor-level records).

Purpose

To be completed.

Relationships

To be completed.

Columns

See DDL below.

Indexes

See DDL below.

Constraints

See DDL below.

Operational notes / invariants

DDL

CREATE TABLE `gift_aid_declarations` (
  `id` int UNSIGNED NOT NULL,
  `church_id` int UNSIGNED NOT NULL,
  `full_name` varchar(200) NOT NULL,
  `address_line1` varchar(200) NOT NULL,
  `address_line2` varchar(200) DEFAULT NULL,
  `town` varchar(120) DEFAULT NULL,
  `county` varchar(120) DEFAULT NULL,
  `postcode` varchar(20) NOT NULL,
  `declaration_date` date NOT NULL,
  `is_uk_taxpayer` tinyint(1) NOT NULL DEFAULT '1',
  `designated_charity` varchar(255) DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
← PreviousNext →