Key-value storage for comment metadata. Extends comments with custom data. Schema Column Type Null Default Description meta_id bigint(20) unsigned NO auto_increment Unique identifier comment_id bigint(20) unsigned NO 0 Comment ID...
Stores comments and other comment-like content (pingbacks, trackbacks). Schema Column Type Null Default Description comment_ID bigint(20) unsigned NO auto_increment Unique identifier comment_post_ID bigint(20) unsigned NO 0 Post ID (FK →...
Legacy blogroll/links table. Deprecated since WordPress 3.5 (2012) but still present for backward compatibility. Schema Column Type Null Default Description link_id bigint(20) unsigned NO auto_increment Unique identifier link_url varchar(255) NO...
Key-value store for site settings, plugin options, and transient data. Schema Column Type Null Default Description option_id bigint(20) unsigned NO auto_increment Unique identifier option_name varchar(191) NO '' Option key (unique)...
Key-value storage for post metadata. Extends wp_posts with arbitrary custom fields. Schema Column Type Null Default Description meta_id bigint(20) unsigned NO auto_increment Unique identifier for the meta entry post_id bigint(20)...
The central content table storing all WordPress content including posts, pages, attachments, revisions, and custom post types. Schema Column Type Null Default Description ID bigint(20) unsigned NO auto_increment Unique identifier...
Guidelines for creating and managing custom database tables in WordPress plugins and themes. When to Use Custom Tables Use Custom Tables When: Data has complex relationships (many-to-many beyond taxonomies) High...
WordPress core database tables and structure. Source: wp-admin/includes/schema.php Core Tables Table Description wp_posts.md Posts, pages, and custom post types wp_postmeta.md Post metadata wp_comments.md Comments wp_commentmeta.md Comment metadata wp_users.md User accounts...
WordPress Multisite adds network-level tables and per-site table copies. Network Tables These tables exist once per network, typically without a numeric prefix. wp_blogs Stores all sites in the network. Column...
The WordPress Customizer (Theme Customization API) provides a framework for live-previewing any changes to WordPress settings. Introduced in WordPress 3.4, it allows developers to customize and preview changes to the...