SchemaSpy Analysis of soap - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Wed Apr 25 13:30 CEST 2012
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

soap contains 24 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Comments
users admin enum 2 n
users title enum 3 Mr
users access_level int unsigned 10 0 Access level granted to the very user
users loginfailed_count int 10 0 Number of consecutive failed logins
sessions time int unsigned 10  √  null Time at which session as established
persistent_data user_id varchar 16
sessions user_id varchar 16
sessions_data user_id varchar 16
users user_id varchar 16
server_data lastupdate datetime 19 0000-00-00 00:00:00 Date & time of the Last update of this value
users password varchar 32 MD5 encoded
sessions ip varchar 39 Client's IP Address
sessions token varchar 64 Token of the user (md5(user_id)+md5(time))
users email varchar 255
users firstname varchar 255  √  null
persistent_data key varchar 255 Key of the data
server_data key varchar 255 Key of the data
sessions_data key varchar 255 Key of the data
users lastname varchar 255  √  null
users phone varchar 255  √  null
users comments text 65535  √  null
persistent_data value text 65535  √  null Value of the data
sessions_data value text 65535  √  null Value of the data
server_data value longtext 2147483647  √  null Value of the data