Table zot.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
id int unsigned 10  √ 
verify.id Implied Constraint R
convid int unsigned 10 0
mail_flags int unsigned 10 0
from_xchan char 255
xchan.xchan_hash Defined in XML R
to_xchan char 255
xchan.xchan_hash Defined in XML R
account_id int unsigned 10 0
account.account_id Implied Constraint R
channel_id int unsigned 10 0
channel.channel_id Implied Constraint R
title text 65535
body mediumtext 16777215
sig text 65535
attach mediumtext 16777215
mid char 255
parent_mid char 255
mail_deleted tinyint 3 0
mail_replied tinyint 3 0
mail_isreply tinyint 3 0
mail_seen tinyint 3 0
mail_recalled tinyint 3 0
mail_obscured smallint 5 0
created datetime 19 0000-00-00 00:00:00
expires datetime 19 0000-00-00 00:00:00
conv_guid char 255

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

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
account_id Performance Asc account_id
channel_id Performance Asc channel_id
conv_guid Performance Asc conv_guid
convid Performance Asc convid
created Performance Asc created
expires Performance Asc expires
from_xchan Performance Asc from_xchan
mail_deleted Performance Asc mail_deleted
mail_flags Performance Asc mail_flags
mail_isreply Performance Asc mail_isreply
mail_obscured Performance Asc mail_obscured
mail_recalled Performance Asc mail_recalled
mail_replied Performance Asc mail_replied
mail_seen Performance Asc mail_seen
mid Performance Asc mid
parent_mid Performance Asc parent_mid
to_xchan Performance Asc to_xchan

Close relationships  within of separation: