https://www.onradar.uk/wiki/ 2026-04-11T23:11:01+00:00 https://www.onradar.uk/wiki/ https://www.onradar.uk/wiki/lib/tpl/dokuwiki/images/favicon.ico text/html 2022-12-26T00:42:47+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.onradar.uk/wiki/doku.php?id=tables:account_address&rev=1672015367&do=diff Account_Address Table The Account_Address Table is a Link Table connecting the Account table with the Address table. This table may have multiple entries for each Account. field Type NULL Account_idAccount INT NO FK - idAccount in the Account table Address_idAddress INT text/html 2022-12-27T00:14:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.onradar.uk/wiki/doku.php?id=tables:account_note&rev=1672100060&do=diff Account_Note The Account_Note table stores notes about an organisation's account. It is only visible to SYSADMIN and GOD - see users. This is a Standard Table because it will not be editable. field Type NULL idNote INT NO Primary Key - auto increment text/html 2023-07-19T13:32:05+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.onradar.uk/wiki/doku.php?id=tables:account&rev=1689773525&do=diff Account Table The Account Table represents an organisation that is subscribed to Charity Radar This is a Versioned Table field Type NULL idAccount INT NO Primary Key - auto increment idCheck CHAR(6) NO Six character random string generated when the entry is created text/html 2023-04-05T13:23:25+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.onradar.uk/wiki/doku.php?id=tables:index&rev=1680701005&do=diff List of Database Tables Core Tables The core tables are used to hold the core CRM data for Charity Radar * Account * Account_Address * Account_Note * Account_Social * Address * Address_Line * Anniversary * Country * Email * Email_Type * EML_Email * EML_Part * EML_Queue * EML_Step * EML_Trigger * List * List_has_Person * Log * Login * New_User * Note * Person * Person_Social * Privilege * Social * Social_Platform * Subscribe_Email * Subsc…