Database schema
Exponential 6 in this section
The schema of Exponential 6.0.15 is share/db_schema.dba: 149 tables, 37 more than 4.4 had. The new tables are listed below by feature, with the release each arrived in; the page "Tables (6.0.15)" lists every table with its fields and indexes.
Below please find a link to the Exponential database schema, the blueprint of the Exponential database. The database schema defines the tables of the Exponential database and the relationship between them.
The database schema documentation contains tabs that will show you the database tables from various "angles".
Please know that the schema consists of drill-down elements, so you can click down to the next level of information.
For a list of the deprecated fields check the Deprecated database fields documentation.
New in Exponential 6
The tables of share/db_schema.dba that 4.4 did not have, by feature.
Their fields and indexes: Tables (6.0.15).
| Feature | Table | Since |
|---|---|---|
| API keys | expapikey | 6.0.15 (in development) |
| Audit trail | expaudit_cursor | 6.0.15 (in development) |
| Audit trail | expaudit_event | 6.0.15 (in development) |
| Audit trail | expaudit_file | 6.0.15 (in development) |
| Bookmarks | expbookmark_folder | 6.0.15 (in development) |
| Bookmarks | expbookmark_view | 6.0.15 (in development) |
| Data tables | exp_data_connection | 6.0.15 (in development) |
| Data tables | exp_data_sync | 6.0.15 (in development) |
| Data tables | exp_data_sync_conflict | 6.0.15 (in development) |
| Data tables | exp_data_sync_link | 6.0.15 (in development) |
| Help | exphelp_feedback | 6.0.15 (in development) |
| Help | exphelp_help_id | 6.0.15 (in development) |
| Mail preferences and consent | expmail_category | 6.0.15 (in development) |
| Mail preferences and consent | expmail_consent_log | 6.0.15 (in development) |
| Mail preferences and consent | expmail_pending | 6.0.15 (in development) |
| Mail preferences and consent | expmail_preference | 6.0.15 (in development) |
| Mail preferences and consent | expmail_suppression | 6.0.15 (in development) |
| Other | exp_migration | 6.0.15 (in development) |
| Other | exp_migration_deploy | 6.0.15 (in development) |
| Other | exp_migration_deploy_host | 6.0.15 (in development) |
| Other | exp_migration_recording | 6.0.15 (in development) |
| Other | exp_migration_recording_event | 6.0.15 (in development) |
| Other | exp_migration_run | 6.0.15 (in development) |
| Other | exp_secret | 6.0.15 (in development) |
| Other | exp_static_page | 6.0.15 (in development) |
| Other | exp_static_run | 6.0.15 (in development) |
| Other | exp_transfer_run | 6.0.15 (in development) |
| Other | ezprest_authcode | older than 6.0 |
| Other | ezprest_authorized_clients | older than 6.0 |
| Other | ezprest_clients | older than 6.0 |
| Other | ezprest_token | older than 6.0 |
| Other | ezpublishingqueueprocesses | older than 6.0 |
| Other | ezrss_export_opml_item | 6.0.15 (in development) |
| Users, sessions and sign in | exppasskey | 6.0.15 (in development) |
| Users, sessions and sign in | expuser_audit | 6.0.15 (in development) |
| Users, sessions and sign in | expuser_session | 6.0.15 (in development) |
| Users, sessions and sign in | expuser_session_info | 6.0.15 (in development) |
Added for Exponential 6.0.15 and the earlier 6.0.x releases.
Geir Arne Waaler (13/12/2010 1:00 pm)
Graham Brookins (05/11/2026 11:19 am)
