Within the Charity Radar database, all tables use the Aria storage engine. There are four types of table:
Tables that are used to hold static data such as country codes or types of email address.
Tables that hold data that changes but where we don't want to record changes to the data within the database.
Standard tables used to link two other tables to form a many-to-many relationship.
Tables that record the changes to the data including when it was changed, who changed it and why it was changed. See versioning.