https://www.onradar.uk/wiki/ 2026-04-11T21:42:50+00:00 https://www.onradar.uk/wiki/ https://www.onradar.uk/wiki/lib/tpl/dokuwiki/images/favicon.ico text/html 2022-12-18T21:31:38+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.onradar.uk/wiki/doku.php?id=technical:address_templates&rev=1671399098&do=diff Address Templates International mailing addresses vary a great deal. Most of the address can be stored as plain text. However, certain parts need to be separated so that users can perform analytics on the data. For example: finding everyone in a town or everyone within 20 miles of a postcode. text/html 2023-01-30T20:21:19+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.onradar.uk/wiki/doku.php?id=technical:index&rev=1675110079&do=diff Technical Documentation Database and ERD * Address Templates * Core information * Tables * Table Types * Versioning Form Data * Create New Organisation text/html 2023-02-03T15:48:32+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.onradar.uk/wiki/doku.php?id=technical:new_org&rev=1675439312&do=diff Form Data to Create New Organisation During the self-service onboarding process, a user provides their personal name, email and optionally, phone number. These are held in the New_User table. Next, they select the type of organisation and this is added to the text/html 2022-12-20T01:15:41+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.onradar.uk/wiki/doku.php?id=technical:table_types&rev=1671498941&do=diff Table Types Within the Charity Radar database, all tables use the Aria storage engine. There are four types of table: Lookup Tables Tables that are used to hold static data such as country codes or types of email address. Standard Tables Tables that hold data that changes but where we don't want to record changes to the data within the database. text/html 2022-12-27T00:21:33+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.onradar.uk/wiki/doku.php?id=technical:versioning&rev=1672100493&do=diff Versioning It is essential to be able to look back at the core data and see when it was changed and by whom. Tables that are versioned will have SYSTEM VERSIONING enabled. Plus, they will have these three fields immediately after the primary key and check key if included. They will be partitioned to separate the current and historical data. Historical data will go into a