mail


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 √ null
mail_aliases.mn_id mail_aliases_ibfk_1 R
mail_redir.mn_id mail_redir_ibfk_1 R
mail_resp.mn_id mail_resp_ibfk_1 R
MailOutgoingMessagesPeaks.mailId MailOutgoingMessagesPeaks_ibfk_1 R
MailOutgoingMessagesStats.mailId MailOutgoingMessagesStats_ibfk_1 R
mn_param.mn_id mn_param_ibfk_1 R
userId INT 10 √ null
smb_users.id mail_ibfk_1 R
mail_name VARCHAR 245 null
postbox enum('false', 'true') 6 false
account_id INT UNSIGNED 10 0
accounts.id mail_ibfk_2 R
redirect enum('false', 'true') 6 false
redir_addr VARCHAR 255 √ null
mail_group enum('false', 'true') 6 false
autoresponder enum('false', 'true') 6 false
mbox_quota BIGINT 19 -1
description VARCHAR 255 √ null
dom_id INT UNSIGNED 10 0
domains.id mail_ibfk_3 R
disk_usage BIGINT UNSIGNED 20 0
apsServiceAccountInstanceId INT 10 0
smb_apsInstances.id mail_ibfk_4 R
perm_id INT UNSIGNED 10 0
Permissions.id mail_ibfk_5 R
apsAntispamServiceInstanceId INT UNSIGNED 10 0
apsAntivirusServiceInstanceId INT UNSIGNED 10 0
spamfilter enum('false', 'true') 6 true
virusfilter enum('none', 'incoming', 'outgoing', 'any') 8 none

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
account_id Performance Asc account_id
apsServiceAccountInstanceId Performance Asc apsServiceAccountInstanceId
dom_id Must be unique Asc/Asc dom_id + mail_name
perm_id Performance Asc perm_id
userId Performance Asc userId

Relationships

Close relationships within degrees of separation