Print
drawDB · Alpha Plugins Demo
WordPress core tables
wp_posts
🔑 ID
BIGINT
post_author
BIGINT
post_date
DATETIME
post_date_gmt
DATETIME
post_content
LONGTEXT
post_title
TEXT
post_excerpt
TEXT
post_status
VARCHAR
comment_status
VARCHAR
ping_status
VARCHAR
post_password
VARCHAR
post_name
VARCHAR
to_ping
TEXT
pinged
TEXT
post_modified
DATETIME
post_modified_gmt
DATETIME
post_content_filtered
LONGTEXT
post_parent
BIGINT
guid
VARCHAR
menu_order
INT
post_type
VARCHAR
post_mime_type
VARCHAR
comment_count
BIGINT
wp_postmeta
🔑 meta_id
BIGINT
post_id
BIGINT
meta_key
VARCHAR
meta_value
LONGTEXT
wp_users
🔑 ID
BIGINT
user_login
VARCHAR
user_pass
VARCHAR
user_nicename
VARCHAR
user_email
VARCHAR
user_url
VARCHAR
user_registered
DATETIME
user_activation_key
VARCHAR
user_status
INT
display_name
VARCHAR
wp_usermeta
🔑 umeta_id
BIGINT
user_id
BIGINT
meta_key
VARCHAR
meta_value
LONGTEXT
wp_terms
🔑 term_id
BIGINT
name
VARCHAR
slug
VARCHAR
term_group
BIGINT
wp_term_taxonomy
🔑 term_taxonomy_id
BIGINT
term_id
BIGINT
taxonomy
VARCHAR
description
LONGTEXT
parent
BIGINT
count
BIGINT
wp_term_relationships
🔑 object_id
BIGINT
🔑 term_taxonomy_id
BIGINT
term_order
INT
wp_comments
🔑 comment_ID
BIGINT
comment_post_ID
BIGINT
comment_author
TINYTEXT
comment_author_email
VARCHAR
comment_author_url
VARCHAR
comment_author_IP
VARCHAR
comment_date
DATETIME
comment_date_gmt
DATETIME
comment_content
TEXT
comment_karma
INT
comment_approved
VARCHAR
comment_agent
VARCHAR
comment_type
VARCHAR
comment_parent
BIGINT
user_id
BIGINT
wp_commentmeta
🔑 meta_id
BIGINT
comment_id
BIGINT
meta_key
VARCHAR
meta_value
LONGTEXT
wp_options
🔑 option_id
BIGINT
option_name
VARCHAR
option_value
LONGTEXT
autoload
VARCHAR
wp_postmeta.post_id
wp_usermeta.user_id
wp_term_taxonomy.term_id
wp_comments.user_id
wp_commentmeta.comment_id