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