3.4 KiB
Database Schema
Updated: 2026-05-07 | Total tables: Unknown from files | Engine: MySQL/MariaDB via WordPress | Charset: Not available from files
WordPress Core Schema
This repository does not include an authoritative live database dump or project-owned migration set. The site depends on the standard WordPress schema managed by WordPress core and plugins.
Expected core tables use the configured table prefix from wp-config.php:
| Table | Purpose | Source |
|---|---|---|
wp_posts |
Pages, posts, Elementor documents, attachments, revisions | WordPress core |
wp_postmeta |
Post/page/Elementor metadata | WordPress core |
wp_options |
Site options, plugin settings, active theme/plugin state | WordPress core |
wp_users |
WordPress users | WordPress core |
wp_usermeta |
User metadata/capabilities | WordPress core |
wp_terms |
Terms/categories/tags | WordPress core |
wp_term_taxonomy |
Term taxonomy definitions | WordPress core |
wp_term_relationships |
Content-to-term relationships | WordPress core |
wp_comments |
Comments/submissions where applicable | WordPress core |
wp_commentmeta |
Comment metadata | WordPress core |
Elementor page layouts, form definitions, menus, options, and active plugin/theme state are database-resident and are not fully visible in this file tree.
Elementor Pro Tables
Elementor Pro includes plugin-managed migrations for form submissions and notes.
Form submissions - lead/form submission storage
- Migration:
wp-content/plugins/elementor-pro/modules/forms/submissions/database/migrations/initial.php. - Creates submission, submission value, and form action log tables via WordPress
dbDelta. - Exact live table names depend on WordPress table prefix.
Notes - Elementor collaboration/notes features
- Migration:
wp-content/plugins/elementor-pro/modules/notes/database/migrations/initial.php. - Creates note-related custom tables via plugin migration infrastructure.
Other database migration/update infrastructure exists under:
wp-content/plugins/elementor/core/database.wp-content/plugins/elementor-pro/core/database.wp-content/plugins/elementor/modules/*/database.
Backup / Installer Database Logic
Duplicator Pro contains database packaging and installer logic, but this is restore tooling rather than the authoritative application schema.
Relevant paths:
wp-content/plugins/duplicator-pro-v4.5.16.2/classes.wp-content/plugins/duplicator-pro-v4.5.16.2/installer.wp-content/backups-dup-pro/.
No extracted SQL dump was found during the scan.
Schema Characteristics
| Property | Value |
|---|---|
| Engine | MySQL/MariaDB through WordPress |
| Charset | Not available from files |
| Encrypted columns | Not detected in project-owned schema |
| Soft deletes | Not detected in project-owned schema |
| Audit via JSON | Not detected in project-owned schema |
| Migrations | WordPress core/plugin-managed; no project-owned migration directory detected |
| Deferred indexes | Not documented |
| Table prefix | Configured in wp-config.php; value intentionally not repeated here |
Verification Notes
- For planning that touches form submissions, leads, Elementor layouts, or page content, verify live schema/content via database access, WP-CLI, or WordPress admin.
- Do not rely on file tree alone for Elementor page structure or active form settings.