default table of WordPress
A default WordPress installation typically includes 12 core database tables, each serving a specific function to store and manage your website's data. These tables are usually prefixed with "wp_" by default, though this prefix can be customized for security reasons.
Here are the default WordPress tables:
- wp\_options: Stores site settings, configurations, and plugin options.
- wp\_users: Contains information about registered users, including usernames, passwords (hashed), emails, and display names.
- wp\_usermeta: Stores additional metadata for users, such as user-specific settings or profile information.
- wp\_posts: Stores all content types, including posts, pages, revisions, custom post types, and navigation menu items.
- wp\_postmeta: Stores metadata associated with posts, pages, and custom post types (e.g., featured images, custom fields).
- wp\_comments: Stores all comments submitted on your posts and pages, whether approved or unapproved.
- wp\_commentmeta: Stores additional metadata for comments.
- wp\_terms: Stores categories, tags, and custom taxonomies.
- wp\_term\_taxonomy: Defines the taxonomy for the terms (e.g., whether a term is a category or a tag).
- wp\_term\_relationships: Establishes the relationships between posts/pages and terms (e.g., which categories a post belongs to).
- wp\_links: (Less common in modern WordPress) Stores information about blogrolls or custom links.
- wp\_termmeta: (Introduced in WordPress 4.4) Stores metadata for terms.