SchemaSpy Analysis of wordpress - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Sat Dec 06 04:04 GMT 2008
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

wordpress contains 99 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Children Parents Comments
wp_bad_behavior date datetime 19 0000-00-00 00:00:00
wp_bad_behavior http_headers text 65535
wp_bad_behavior id int 10  √ 
wp_bad_behavior ip text 65535
wp_bad_behavior key text 65535
wp_bad_behavior request_entity text 65535
wp_bad_behavior request_method text 65535
wp_bad_behavior request_uri text 65535
wp_bad_behavior server_protocol text 65535
wp_bad_behavior user_agent text 65535
wp_comments comment_agent varchar 255
wp_comments comment_approved varchar 20 1
wp_comments comment_author tinytext 255
wp_comments comment_author_email varchar 100
wp_comments comment_author_IP varchar 100
wp_comments comment_author_url varchar 200
wp_comments comment_content text 65535
wp_comments comment_date datetime 19 0000-00-00 00:00:00
wp_comments comment_date_gmt datetime 19 0000-00-00 00:00:00
wp_comments comment_ID bigint unsigned 20  √ 
wp_comments comment_karma int 10 0
wp_comments comment_parent bigint 19 0
wp_comments comment_post_ID int 10 0
wp_comments comment_type varchar 20
wp_comments user_id bigint 19 0
wp_links link_category bigint 19 0
wp_links link_description varchar 255
wp_links link_id bigint 19  √ 
wp_links link_image varchar 255
wp_links link_name varchar 255
wp_links link_notes mediumtext 16777215
wp_links link_owner int 10 1
wp_links link_rating int 10 0
wp_links link_rel varchar 255
wp_links link_rss varchar 255
wp_links link_target varchar 25
wp_links link_updated datetime 19 0000-00-00 00:00:00
wp_links link_url varchar 255
wp_links link_visible varchar 20 Y
wp_options autoload varchar 20 yes
wp_options blog_id int 10 0
wp_options option_id bigint 19  √ 
wp_options option_name varchar 64
wp_options option_value longtext 2147483647
wp_postmeta meta_id bigint 19  √ 
wp_postmeta meta_key varchar 255  √  null
wp_postmeta meta_value longtext 2147483647  √  null
wp_postmeta post_id bigint 19 0
wp_posts comment_count bigint 19 0
wp_posts comment_status varchar 20 open
wp_posts guid varchar 255
wp_posts ID bigint unsigned 20  √ 
wp_users.ID Implied Constraint
wp_posts menu_order int 10 0
wp_posts ping_status varchar 20 open
wp_posts pinged text 65535
wp_posts post_author bigint 19 0
wp_posts post_category int 10 0
wp_posts post_content longtext 2147483647
wp_posts post_content_filtered text 65535
wp_posts post_date datetime 19 0000-00-00 00:00:00
wp_posts post_date_gmt datetime 19 0000-00-00 00:00:00
wp_posts post_excerpt text 65535
wp_posts post_mime_type varchar 100
wp_posts post_modified datetime 19 0000-00-00 00:00:00
wp_posts post_modified_gmt datetime 19 0000-00-00 00:00:00
wp_posts post_name varchar 200
wp_posts post_parent bigint 19 0
wp_posts post_password varchar 20
wp_posts post_status varchar 20 publish
wp_posts post_title text 65535
wp_posts post_type varchar 20 post
wp_posts to_ping text 65535
wp_term_relationships object_id bigint 19 0
wp_term_relationships term_order int 10 0
wp_term_relationships term_taxonomy_id bigint 19 0
wp_term_taxonomy.term_taxonomy_id Implied Constraint
wp_term_taxonomy count bigint 19 0
wp_term_taxonomy description longtext 2147483647
wp_term_taxonomy parent bigint 19 0
wp_term_taxonomy taxonomy varchar 32
wp_term_taxonomy term_id bigint 19 0
wp_terms.term_id Implied Constraint
wp_term_taxonomy term_taxonomy_id bigint 19  √ 
wp_term_relationships.term_taxonomy_id Implied Constraint
wp_terms name varchar 200
wp_terms slug varchar 200
wp_terms term_group bigint 19 0
wp_terms term_id bigint 19  √ 
wp_term_taxonomy.term_id Implied Constraint
wp_usermeta meta_key varchar 255  √  null
wp_usermeta meta_value longtext 2147483647  √  null
wp_usermeta umeta_id bigint 19  √ 
wp_usermeta user_id bigint 19 0
wp_users display_name varchar 250
wp_users ID bigint unsigned 20  √ 
wp_posts.ID Implied Constraint
wp_users user_activation_key varchar 60
wp_users user_email varchar 100
wp_users user_login varchar 60
wp_users user_nicename varchar 50
wp_users user_pass varchar 64
wp_users user_registered datetime 19 0000-00-00 00:00:00
wp_users user_status int 10 0
wp_users user_url varchar 100