Table iliasRelease_3_10_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  √ 
mail_attachment.mail_id Implied Constraint R
user_id int 10 0
member_export_user_settings.user_id Implied Constraint R
folder_id int 10 0
sender_id int 10  √  null
attachments varchar 255  √  null
send_time datetime 19 0000-00-00 00:00:00
rcp_to text 65535  √  null
rcp_cc text 65535  √  null
rcp_bcc text 65535  √  null
m_status varchar 16  √  null
m_type varchar 255  √  null
m_email bit 0  √  null
m_subject varchar 255  √  null
m_message text 65535  √  null
import_name text 65535  √  null
use_placeholders bit 0 0

Table contained 0 rows at Tue Aug 26 10:32 CEST 2014

Indexes:
Column(s) Type Sort Constraint Name
mail_id Primary key Asc PRIMARY
folder_id Performance Asc folder_id
user_id Performance Asc jmp_uid
m_status Performance Asc m_status

Close relationships: