#WCLanc @salcode

Introduction to the WordPress Database

Sal Ferrarello / @salcode

salcode.com/wpdb

Database

Database

A blank spreadsheet.
  • wp_links
  • wp_options
  • wp_posts
  • wp_comments
  • wp_users
  • wp_usermeta
  • wp_postmeta
  • wp_commentmeta
  • wp_terms
  • wp_termmeta
  • wp_term_relationships
  • wp_term_taxonomy
  • wp_links
  • wp_options
  • wp_posts
  • wp_comments
  • wp_users
  • wp_usermeta
  • wp_postmeta
  • wp_commentmeta
  • wp_terms
  • wp_termmeta
  • wp_term_relationships
  • wp_term_taxonomy
  • wp_links
  • wp_options
  • wp_posts
  • wp_comments
  • wp_users
  • wp_usermeta
  • wp_postmeta
  • wp_commentmeta
  • wp_terms
  • wp_termmeta
  • wp_term_relationships
  • wp_term_taxonomy
  • Options (settings)
  • Users
  • Posts
  • Comments

wp_options

Example entries in wp_options database table.
Screenshot of WordPress General Settings.

wp_options

Additional example entries in wp_options database table.
  • Options (settings)
    • wp_options
  • Users
  • Posts
  • Comments

wp_users

Example entries in wp_users database table.
  • Options
    • wp_options
  • Users
    • wp_users
  • Posts
  • Comments

wp_posts

Example entries in wp_posts database table.
  • Options
    • wp_options
  • Users
    • wp_users
  • Posts
    • wp_posts
  • Comments

wp_comments

Example entries in wp_comments database table.
  • Options
    • wp_options
  • Users
    • wp_users
  • Posts
    • wp_posts
  • Comments
    • wp_comments

Meta Data

  • User's favorite breakfast food
  • Post's subtitle
  • Comment Author's Twitter handle

Meta Data

  • User's favorite breakfast food
  • Post's subtitle
  • Comment Author's Twitter handle

wp_usermeta

Example entries in wp_usermeta database table.

wp_postmeta

Example entries in wp_postmeta database table.

wp_commentmeta

Example entries in wp_commentmeta database table.
  • Options
    • wp_options
  • Users
    • wp_users
    • wp_usermeta
  • Comments
    • wp_comments
    • wp_commentmeta
  • Posts
    • wp_posts
    • wp_postmeta

Terms & Taxonomies

wp_terms

Example entries in wp_terms database table.

wp_term_taxonomy

Example entries in wp_term_taxonomy database table.

wp_term_relationships

Example entries in wp_term_relationships database table.

wp_termmeta

Example entries in wp_termmeta database table.
  • Settings
    • wp_options
  • Users
    • wp_users
    • wp_usermeta
  • Comments
    • wp_comments
    • wp_commentmeta
  • Posts
    • wp_posts
    • wp_postmeta
    • wp_terms
    • wp_term_taxonomy
    • wp_term_relationships
    • wp_termmeta

Iron Code Studio

Sal Ferrarello

salcode.com/wpdb

@salcode

Image Credits