WordPress Database Structure
WordPress is written using PHP as its scripting language and MySQL as its database management system. For using WordPress you don’t need to learn php & MySQL, but if you have basic understanding of how it works that will be enough to solve any problems that you will get into. Here in this article you will learn about WordPress database structure.
Default installation of WordPress comes with eleven tables. These are the following tables.
- Each comment features information called the meta data and it is stored in the wp_commentmeta.
- The comments within WordPress are stored in the wp_comments table.
- The wp_links holds information related to the links entered into the Links feature of WordPress.
- The Options set under the Administration > Settings panel are stored in the wp_options table.
- Each post features information called the meta data and it is stored in the wp_postmeta. Some plugins may add their own information to this table.
- The core of the WordPress data is the posts. It is stored in the wp_posts table. Also Pages and navigation menu items are stored in this table.
- The categories for both posts and links and the tags for posts are found within the wp_terms table.
- Posts are associated with categories and tags from the wp_terms table and this association is maintained in the wp_term_relationships table. The association of links to their respective categories are also kept in this table.
- This table describes the taxonomy (category, link, or tag) for the entries in the wp_terms table.
- Each user features information called the meta data and it is stored in wp_usermeta.
- The list of users is maintained in table wp_users.
Above are the eleven tables, wp_ is the database prefix, we can change database prefix while installing WordPress.
database database structure in worddpress