Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: email_log_system_systememail_log_system_system

email_log_system_system

Table comments : InnoDB free: 776192 kB

Field Type Null Default
logid  int(11) No   
logtype  varchar(20) Yes  NULL 
logmodule  varchar(100) No   
logseverity  char(1) No 
logsummary  varchar(250) No   
logmsg  text No   
logdate  int(11) No 


 Indexes :
Keyname Type Cardinality Field
PRIMARY PRIMARY 1937 logid
logid_2 UNIQUE 1937 logid
logid_4 UNIQUE 1937 logid
logid_5 UNIQUE 1937 logid
logid_7 UNIQUE 1937 logid
logid_9 UNIQUE 1937 logid
logid_10 UNIQUE 1937 logid
logid_14 UNIQUE 1937 logid
logid INDEX 1937 logid
logtype INDEX 2 logtype
logmodule INDEX 2 logmodule
logseverity INDEX 2 logseverity
logsummary INDEX 1937 logsummary
logdate INDEX 1937 logdate
logdate_2 INDEX 1937 logdate
logid_3 INDEX 1937 logid
logtype_2 INDEX 2 logtype
logsummary_2 INDEX 1937 logsummary
logseverity_2 INDEX 2 logseverity
logmodule_2 INDEX 2 logmodule
logsummary_3 INDEX 1937 logsummary
logdate_3 INDEX 1937 logdate
logid_6 INDEX 1937 logid
logtype_3 INDEX 2 logtype
logmodule_3 INDEX 2 logmodule
logseverity_3 INDEX 2 logseverity
logseverity_4 INDEX 2 logseverity
logdate_4 INDEX 1937 logdate
logtype_4 INDEX 2 logtype
logsummary_4 INDEX 1937 logsummary
logid_8 INDEX 1937 logid
logmodule_4 INDEX 2 logmodule
logdate_5 INDEX 1937 logdate
logseverity_5 INDEX 2 logseverity
logmodule_5 INDEX 2 logmodule
logdate_6 INDEX 1937 logdate
logseverity_6 INDEX 2 logseverity
logid_11 INDEX 1937 logid
logsummary_5 INDEX 1937 logsummary
logid_12 INDEX 1937 logid
logtype_5 INDEX 2 logtype
logsummary_6 INDEX 1937 logsummary
logtype_6 INDEX 2 logtype
logmodule_6 INDEX 2 logmodule
logid_13 INDEX 1937 logid
logtype_7 INDEX 2 logtype
logmodule_7 INDEX 2 logmodule
logseverity_7 INDEX 2 logseverity
logsummary_7 INDEX 1937 logsummary
logdate_7 INDEX 1937 logdate
logseverity_8 INDEX 2 logseverity
logid_15 INDEX 1937 logid
logdate_8 INDEX 1937 logdate
logtype_8 INDEX 2 logtype
logsummary_8 INDEX 1937 logsummary
logmodule_8 INDEX 2 logmodule
logseverity_9 INDEX 2 logseverity
logid_16 INDEX 1937 logid
logdate_9 INDEX 1937 logdate
logtype_9 INDEX 2 logtype
logmodule_9 INDEX 2 logmodule
logsummary_9 INDEX 1937 logsummary
logsummary_10 INDEX 1937 logsummary
logmodule_10 INDEX 2 logmodule


 Space usage :
Type Usage
Data 3,600 KB
Index 7,776 KB
Total 11,376 KB
   Row Statistic :
Statements Value
Format dynamic
Rows 1,883
Row length ø 1,957
Row size  ø 6,186 Bytes
Next Autoindex 1,954
Creation May 24, 2018 at 03:34 PM