Table drupal.users Generated by
SchemaSpy
Implied relationships Related columns Constraint names Comments Legend
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
Dashed lines show
implied relationships
< n > number of related tables
Please support this project 
Column Type Size Nulls Auto Default Children Parents Comments
uid int unsigned 10 0
sessions.uid Implied Constraint
users_roles.uid Implied Constraint
name varchar 60
pass varchar 32
mail varchar 64  √ 
mode tinyint 4 0
sort tinyint 4  √  0
threshold tinyint 4  √  0
theme varchar 255
signature varchar 255
created int 11 0
access int 11 0
login int 11 0
status tinyint 4 0
timezone varchar 8  √  null
language varchar 12
picture varchar 255
init varchar 64  √ 
data longtext 2147483647  √  null

Table contained 2 rows at Fri Jan 19 10:16 EST 2007

Indexes:
Column(s) Type Sort Constraint Name
uid Primary key Asc PRIMARY
access Performance Asc access
name Must be unique Asc name

Close relationships: