Table soap.users
User list

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
user_id varchar 16
persistent_data.user_id fk_persistent_data_users C
sessions.user_id fk_sessions_users C
title enum 3 Mr
password varchar 32 MD5 encoded
firstname varchar 255  √  null
lastname varchar 255  √  null
email varchar 255
phone varchar 255  √  null
comments text 65535  √  null
admin enum 2 n
loginfailed_count int 10 0 Number of consecutive failed logins
access_level int unsigned 10 0 Access level granted to the very user

Analyzed at Wed Apr 25 13:30 CEST 2012

Indexes:
Column(s) Type Sort Constraint Name
user_id Primary key Asc PRIMARY
email Must be unique Asc uq_email

Close relationships  within of separation: