User Tools

Site Tools


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.

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

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki