Table wordpress.wp_comments 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
comment_ID bigint unsigned 20  √ 
comment_post_ID int 10 0
comment_author tinytext 255
comment_author_email varchar 100
comment_author_url varchar 200
comment_author_IP varchar 100
comment_date datetime 19 0000-00-00 00:00:00
comment_date_gmt datetime 19 0000-00-00 00:00:00
comment_content text 65535
comment_karma int 10 0
comment_approved varchar 20 1
comment_agent varchar 255
comment_type varchar 20
comment_parent bigint 19 0
user_id bigint 19 0

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

Indexes:
Column(s) Type Sort Constraint Name
comment_ID Primary key Asc PRIMARY
comment_approved Performance Asc comment_approved
comment_approved + comment_date_gmt Performance Asc/Asc comment_approved_date_gmt
comment_date_gmt Performance Asc comment_date_gmt
comment_post_ID Performance Asc comment_post_ID