Wordpress (4.7.3)

Wordpress ERD

Tables (12)

wp_commentmeta

  • meta_id — bigint(20) — Primary key — NOT NULL
  • comment_id — bigint(20) — Foreign key → wp_comments.comment_ID — NOT NULL
  • meta_key — varchar(255)
  • meta_value — longtext

wp_comments

  • comment_ID — bigint(20) — Primary key — NOT NULL
  • comment_post_ID — bigint(20) — Foreign key → wp_posts.ID — NOT NULL
  • comment_author — tinytext — NOT NULL
  • comment_author_email — varchar(100) — NOT NULL
  • comment_author_url — varchar(200) — NOT NULL
  • comment_author_IP — varchar(100) — NOT NULL
  • comment_date — datetime — NOT NULL — 0000-00-00 00:00:00
  • comment_date_gmt — datetime — NOT NULL — 0000-00-00 00:00:00
  • comment_content — text — NOT NULL
  • comment_karma — int(11) — NOT NULL — 0
  • comment_approved — varchar(20) — NOT NULL — 1
  • comment_agent — varchar(255) — NOT NULL
  • comment_type — varchar(20) — NOT NULL
  • comment_parent — bigint(20) — Foreign key → wp_comments.comment_ID — NOT NULL
  • user_id — bigint(20) — Foreign key → wp_users.ID — NOT NULL

wp_links

  • link_id — bigint(20) — Primary key — NOT NULL
  • link_url — varchar(255) — NOT NULL
  • link_name — varchar(255) — NOT NULL
  • link_image — varchar(255) — NOT NULL
  • link_target — varchar(25) — NOT NULL
  • link_description — varchar(255) — NOT NULL
  • link_visible — varchar(20) — NOT NULL
  • link_owner — bigint(20) — NOT NULL
  • link_rating — int(11) — NOT NULL
  • link_updated — datetime — NOT NULL
  • link_rel — varchar(255) — NOT NULL
  • link_notes — mediumtext — NOT NULL
  • link_rss — varchar(255) — NOT NULL

wp_options

  • option_id — bigint(20) — Primary key — NOT NULL
  • option_name — varchar(191) — NOT NULL
  • option_value — longtext — NOT NULL
  • autoload — varchar(20) — NOT NULL

wp_postmeta

  • meta_id — bigint(20) — Primary key — NOT NULL
  • post_id — bigint(20) — Foreign key → wp_posts.ID — NOT NULL
  • meta_key — varchar(255)
  • meta_value — longtext

wp_posts

  • ID — bigint(20) — Primary key — NOT NULL
  • post_author — bigint(20) — Foreign key → wp_users.ID — NOT NULL
  • post_date — datetime — NOT NULL
  • post_date_gmt — datetime — NOT NULL
  • post_content — longtext — NOT NULL
  • post_title — text — NOT NULL
  • post_excerpt — text — NOT NULL
  • post_status — varchar(20) — NOT NULL
  • comment_status — varchar(20) — NOT NULL — open
  • ping_status — varchar(20) — NOT NULL
  • post_password — varchar(255) — NOT NULL
  • post_name — varchar(200) — NOT NULL
  • to_ping — text — NOT NULL
  • pinged — text — NOT NULL
  • post_modified — datetime — NOT NULL
  • post_modified_gmt — datetime — NOT NULL
  • post_content_filtered — longtext — NOT NULL
  • post_parent — bigint(20) — Foreign key → wp_posts.ID — NOT NULL
  • guid — varchar(255) — NOT NULL
  • menu_order — int(11) — NOT NULL
  • post_type — varchar(20) — NOT NULL
  • post_mime_type — varchar(100) — NOT NULL
  • comment_count — bigint(20) — NOT NULL — 0

wp_term_relationships

  • object_id — bigint(20) — Primary key — NOT NULL
  • term_taxonomy_id — bigint(20) — Foreign key → wp_term_taxonomy.term_taxonomy_id — NOT NULL
  • term_order — int(11) — NOT NULL

wp_term_taxonomy

  • term_taxonomy_id — bigint(20) — Primary key — NOT NULL
  • term_id — bigint(20) — Foreign key → wp_terms.term_id — NOT NULL
  • taxonomy — varchar(32) — NOT NULL
  • description — longtext — NOT NULL
  • parent — bigint(20) — NOT NULL
  • count — bigint(20) — NOT NULL

wp_termmeta

  • meta_id — bigint(20) — Primary key — NOT NULL
  • term_id — bigint(20) — Foreign key → wp_terms.term_id — NOT NULL
  • meta_key — varchar(255)
  • meta_value — longtext

wp_terms

  • term_id — bigint(20) — Primary key — NOT NULL
  • name — varchar(200) — NOT NULL
  • slug — varchar(200) — NOT NULL
  • term_group — bigint(10) — NOT NULL

wp_usermeta

  • umeta_id — bigint(20) — Primary key — NOT NULL
  • user_id — bigint(20) — Foreign key → wp_users.ID — NOT NULL
  • meta_key — varchar(255)
  • meta_value — longtext

wp_users

  • ID — bigint(20) — Primary key — NOT NULL
  • user_login — varchar(60) — NOT NULL
  • user_pass — varchar(255) — NOT NULL
  • user_nicename — varchar(50) — NOT NULL
  • user_email — varchar(100) — NOT NULL
  • user_url — varchar(100) — NOT NULL
  • user_registered — datetime — NOT NULL
  • user_activation_key — varchar(255) — NOT NULL
  • user_status — int(11) — NOT NULL
  • display_name — varchar(250) — NOT NULL