WordPress Database Table Details

In wordpress currently there are 11 database tables have been created. So we have mentioned below their names and details on what type of data they store:

  • wp_commentmeta — This table is use for contains all metadata for comments.
  • wp_comments — This table is use for contains all comments within WordPress. The individual comments are linked back to posts through a post ID.
  • wp_links — This table is use for contains all links added via the Link Manager section.
  • wp_options — This table is use for stores all website options defined under the Settings SubPanel. It has stores also the plugin options, active plugins and themes.
  • wp_postmeta — This table is use for contains all post metadata (custom fields).
  • wp_posts — This table is use for contains all types of post data (default and custom post types), pages, media records, and revisions. Commonly this is the largest table in the database of WordPress.
  • wp_terms — This table is use for contains all taxonomy terms defined for your website, mapping their text descriptions to term numbers that can be used as unique indexes into other tables.
  • wp_term_relationships — This table is use for Joins taxonomy terms with content, providing a membership table. It maps a term such as a tag or category name to the page or post that references it.
  • wp_term_taxonomy — This table is use for defines the taxonomy to which each term is assigned. This table allows you to have categories and tags with the same name, placing them in different named taxonomies.
  • wp_users — This table is use for contains all users created in your website (login, password, e-mail).
  • wp_usermeta — This table is use for contains metadata for users (fi rst/last name, nickname, user level, and so on).

         Every table of database has a specific purpose within WordPress.