| SchemaSpy Analysis of wordpress - Columns | Generated by SchemaSpy |
| Generated by SchemaSpy on Sat Dec 06 04:04 GMT 2008 |
| ||||||
|
| |||||||
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_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 | 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_term_taxonomy | term_taxonomy_id | bigint | 19 | √ |
|
||||||
| wp_terms | name | varchar | 200 | ||||||||
| wp_terms | slug | varchar | 200 | ||||||||
| wp_terms | term_group | bigint | 19 | 0 | |||||||
| wp_terms | term_id | bigint | 19 | √ |
|
||||||
| 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_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 |