A database is an organized collection of data. It is a software used to store, organize and retrieve information. A database structure stores data in a tabular format.
WordPress uses MySQL as its database management system. MySQL is a software used to create databases. MySQL is an open source relational database management system used by high profile web properties like Facebook and Youtube.
You require MySQL to install the WordPress on web hosting. All hosting providers offer MySQL in their hosting packages.
During the WordPress installation, it asks you to provide the information like database name, host, username and password. WordPress uses this information to create the tables in your database and stores installation data in tables.
A default WordPress installation creates 12 tables inside your WordPress database. Each table contains different sections, features and functionality of WordPress. Following tables will be created by a default WordPress installation.
WordPress Database Tables:
wp_commentmeta: This table contains comments Meta information about the comments that are posted on WordPress website. It contains meta id, meta key, meta value and comment id.
wp_comments: This table contains comments that are posted on WordPress website. It contains comment author, author URL, author IP, comment date, content post ID etc.
wp_links: This table contains information related to links that entered into the links feature in WordPress.
wp_options: This table contains WordPress admin settings.
wp_postmeta: This table contains post Meta information about the posts and pages that are posted on WordPress website. It contains meta id, meta key, meta value and post id.
wp_posts: This table contains posts and pages that are posted on WordPress website. It contains post name, title, author, status, content, date, type, revisions etc.
wp_terms: This table contains posts categories. WordPress has a powerful taxonomy system, which is used to sort and group the publishing content into sections called terms. Categories and tags are the taxonomies and individual taxonomies are called terms. These terms are stored in this table. It contains term name, slug, group and ID.
wp_termmeta: This table contains term Meta information.
wp_term_relationships: Posts are associated with categories and terms from the table wp_term and this table maintains that relationship.
wp_term_taxonomy: This table describes the taxonomy for the term entries in the wp_terms table.
wp_usermeta: This table contains user Meta information. It contains meta id, meta key, meta value and user id.
wp_users: This table contains user’s information. It contains the username, email, ID etc.