Table wordpress.wp_posts Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
ID bigint unsigned 20  √ 
wp_users.ID Implied Constraint
post_author bigint 19 0
post_date datetime 19 0000-00-00 00:00:00
post_date_gmt datetime 19 0000-00-00 00:00:00
post_content longtext 2147483647
post_title text 65535
post_category int 10 0
post_excerpt text 65535
post_status varchar 20 publish
comment_status varchar 20 open
ping_status varchar 20 open
post_password varchar 20
post_name varchar 200
to_ping text 65535
pinged text 65535
post_modified datetime 19 0000-00-00 00:00:00
post_modified_gmt datetime 19 0000-00-00 00:00:00
post_content_filtered text 65535
post_parent bigint 19 0
guid varchar 255
menu_order int 10 0
post_type varchar 20 post
post_mime_type varchar 100
comment_count bigint 19 0

Table contained 509 rows at Sat Dec 06 04:04 GMT 2008

Indexes:
Column(s) Type Sort Constraint Name
ID Primary key Asc PRIMARY
post_name Performance Asc post_name
post_parent Performance Asc post_parent
post_status Performance Asc post_status
post_type + post_status + post_date + ID Performance Asc/Asc/Asc/Asc type_status_date

Close relationships: