Being able to easily switch between different technology stacks requires a common data model, meaning the same tables and the same columns with the same column type. The latter is unrealistic because different data stores have different data types. This does not have to be a problem though if only simple column types are used.
This page describes the common data model.
Having a common data model does not restrict a specific distribution of having additions for functional or performance reasons as long as the complete common data model is implemented too.
The table below gives an high-level overview of the common data model.
| Display name | Description |
|---|---|
| FaF - Action templates | This table contains all action templates. |
| FaF - Actions | This table contains all actions. |
| FaF - Actions - Log | This table contains all action log items. |
| FaF - App errors | This table contains all app errors. |
| FaF - Authorizations | This table contains all authorizations. |
| FaF - Config | This table contains all config settings. |
| FaF - Email templates | This table contains all email templates. |
| FaF - Emails | This table contains all emails. |
| FaF - Flows errors | This table contains all flow errors. |
| FaF - Log | This table contains log items. |
| FaF - Process managers | This table contains all process managers. |
| FaF - Processes | This table contains all processes. |
| FaF - Resources | This table contains all resource settings. |
| FaF - Role - User | This table contains roles assigned to users. |
| FaF - Roles | This table contains all roles. |
| FaF - Runs | This table contains all runs. |
| FaF - Runs - Log | This table contains all run log items. |
| FaF - Sessions | This table contains sessions. |
| FaF - Settings | This table contains all general settings. |
| FaF - User profiles | This table contains all user profile settings. |