# Table overview
This section contains a short description of the database tables currently used by ELO Sync.
All the tables used by ELO Sync have the prefix elosync_.
| Table | Description |
|---|---|
| elosync_approvaldetails | Details for approvals |
| elosync_approvals | Actions that must be approved by users |
| elosync_claimidentities | Identities that are assigned synchronization jobs. |
| elosync_claims | Claims for each identity. |
| elosync_data_mappings | Data mappings between elements. The connected elements always have the same name, contents, and metadata. |
| elosync_EFMigrationsHistory | Contains the migration history for all ELO Sync tables. |
| elosync_elosynctargets | The configured synchronization targets in the ELO repositories, usually folders |
| elosync_fields | Contains data for fields that are synchronized. |
| elosync_masks | All metadata forms referenced by synchronization jobs only contain reference data. The actual configuration data is loaded from the repository. |
| elosync_msal | Data required for the MSAL (opens new window) library. |
| elosync_msalactivities | User authentications via the MSAL library also contain the last sign-in date. |
| elosync_onedrivesynctargets | The configured synchronization targets in OneDrive, either drives or folders in drives. |
| elosync_settings | The data linked to the settings. |
| elosync_sharepointsynctargets | The configured synchronization targets in SharePoint Online, either sites, lists, or folders |
| elosync_structure_mappings | The structural mappings between elements. The connected elements are always moved to the same relative position in the synchronized structure. |
| elosync_syncactivities | The logged activities of listed synchronization jobs. |
| elosync_syncactivitydetails | Details for logs. |
| elosync_synccollections | The collections contained in the synchronized systems. Each system can contain several collections. |
| elosync_syncconflictdetails | Details on the currently active synchronization conflicts. |
| elosync_syncconflicts | All the currently active conflicts when synchronizing items across systems. Each conflict must be resolved by a user. |
| elosync_syncitem_fields | Data for field groups. |
| elosync_syncitems | The elements that are contained in the synchronized collections. Each collection has multiple elements. |
| elosync_syncjobs | All synchronization jobs that are managed by ELO Sync. |
| elosync_syncjobstrigger | Relation table between synchronization jobs and triggers. |
| elosync_syncsystems | The systems referenced by synchronization jobs. |
| elosync_trigger | List of individual triggers that can trigger synchronization of synchronization jobs. |