technical:table_types
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.
Link Tables
Standard tables used to link two other tables to form a many-to-many relationship.
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.txt · Last modified: 2022/12/20 01:15 by admin