Table wordpress.wp_users 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_posts.ID Implied Constraint
user_login varchar 60
user_pass varchar 64
user_nicename varchar 50
user_email varchar 100
user_url varchar 100
user_registered datetime 19 0000-00-00 00:00:00
user_activation_key varchar 60
user_status int 10 0
display_name varchar 250

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

Indexes:
Column(s) Type Sort Constraint Name
ID Primary key Asc PRIMARY
user_login Must be unique Asc user_login
user_login Performance Asc user_login_key
user_nicename Performance Asc user_nicename

Close relationships: