Table iliasRelease_5_0_x_branch.mail 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
mail_id int 10 0
user_id int 10 0
folder_id int 10 0
sender_id int 10  √  null
send_time datetime 19  √  null
m_status varchar 16  √  null
m_type varchar 255  √  null
m_email tinyint 3  √  null
m_subject varchar 255  √  null
import_name varchar 4000  √  null
use_placeholders tinyint 3 0
m_message longtext 2147483647  √  null
rcp_to longtext 2147483647  √  null
rcp_cc longtext 2147483647  √  null
rcp_bcc longtext 2147483647  √  null
attachments longtext 2147483647  √  null

Table contained 0 rows at Thu Apr 28 00:43 CEST 2016

Indexes:
Column(s) Type Sort Constraint Name
mail_id Primary key Asc PRIMARY
user_id Performance Asc i1_idx
folder_id Performance Asc i2_idx
m_status Performance Asc i3_idx
sender_id + user_id Performance Asc/Asc i4_idx