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_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...
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_links
Legacy blogroll/links table. Deprecated since WordPress 3.5 (2012) but still present for backward compatibility. Schema Column Type Null Default Description...
wp_options
Key-value store for site settings, plugin options, and transient data. Schema Column Type Null Default Description option_id bigint(20) unsigned NO...
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_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...