Database Schema
wp_users
Stores WordPress user accounts. Core authentication and profile data. Schema Column Type Null Default Description ID bigint(20) unsigned NO auto_increment...
wp_terms
Stores the basic term data (name and slug) for categories, tags, and custom taxonomies. Schema Column Type Null Default Description...
wp_usermeta
Key-value storage for user metadata. Stores capabilities, preferences, and custom user data. Schema Column Type Null Default Description umeta_id bigint(20)...
wp_postmeta
Key-value storage for post metadata. Extends wp_posts with arbitrary custom fields. Schema Column Type Null Default Description meta_id bigint(20) unsigned...
wp_posts
The central content table storing all WordPress content including posts, pages, attachments, revisions, and custom post types. Schema Column Type...
wp_term_relationships
Junction table linking posts (objects) to terms. Implements the many-to-many relationship between content and taxonomies. Schema Column Type Null Default...
wp_term_taxonomy
Links terms to their taxonomies and stores taxonomy-specific data. Each term can appear in multiple taxonomies. Schema Column Type Null...
wp_termmeta
Key-value storage for term metadata. Added in WordPress 4.4 to extend terms with custom data. Schema Column Type Null Default...
Table Prefixes
WordPress uses configurable table prefixes for security and multi-installation support. Default Prefix // wp-config.php $table_prefix = 'wp_'; All core tables...
wp_commentmeta
Key-value storage for comment metadata. Extends comments with custom data. Schema Column Type Null Default Description meta_id bigint(20) unsigned NO...
wp_comments
Stores comments and other comment-like content (pingbacks, trackbacks). Schema Column Type Null Default Description comment_ID bigint(20) unsigned NO auto_increment Unique...
wp_links
Legacy blogroll/links table. Deprecated since WordPress 3.5 (2012) but still present for backward compatibility. Schema Column Type Null Default Description...