# 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.