Table zot.account 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
account_id int unsigned 10  √ 
mail.account_id Implied Constraint R
account_parent int unsigned 10 0
account_default_channel int unsigned 10 0
account_salt char 32
account_password char 255
account_email char 255
account_external char 255
account_language char 16 en
account_created datetime 19 0000-00-00 00:00:00
account_lastlog datetime 19 0000-00-00 00:00:00
account_flags int unsigned 10 0
account_roles int unsigned 10 0
account_reset char 255
account_expires datetime 19 0000-00-00 00:00:00
account_expire_notified datetime 19 0000-00-00 00:00:00
account_service_class char 32
account_level int unsigned 10 0
account_password_changed datetime 19 0000-00-00 00:00:00

Table contained 2 rows at fr nov 06 17:11 CET 2015

Indexes:
Column(s) Type Sort Constraint Name
account_id Primary key Asc PRIMARY
account_default_channel Performance Asc account_default_channel
account_email Performance Asc account_email
account_expires Performance Asc account_expires
account_external Performance Asc account_external
account_flags Performance Asc account_flags
account_lastlog Performance Asc account_lastlog
account_level Performance Asc account_level
account_parent Performance Asc account_parent
account_password_changed Performance Asc account_password_changed
account_roles Performance Asc account_roles
account_service_class Performance Asc account_service_class

Close relationships: