technical:table_types
This is an old revision of the document!
Table Types
Within the Charity Radar database, all tables use the Aria
storage engine. There are three 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.
Versioned Tables
Tables that record the changes to the data including when it was changed, who changed it and why it was changed. See versioning.
technical/table_types.1671496636.txt.gz · Last modified: 2022/12/20 00:37 by admin