User Tools

Site Tools


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

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki