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

email_log_system_system

Table comments : InnoDB free: 726016 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 4984 logid
logid_2 UNIQUE 4984 logid
logid_4 UNIQUE 4984 logid
logid_5 UNIQUE 4984 logid
logid_7 UNIQUE 4984 logid
logid_9 UNIQUE 4984 logid
logid_10 UNIQUE 4984 logid
logid_14 UNIQUE 4984 logid
logid INDEX 4984 logid
logtype INDEX 1 logtype
logmodule INDEX 1 logmodule
logseverity INDEX 1 logseverity
logsummary INDEX 4984 logsummary
logdate INDEX 4984 logdate
logdate_2 INDEX 4984 logdate
logid_3 INDEX 4984 logid
logtype_2 INDEX 1 logtype
logsummary_2 INDEX 4984 logsummary
logseverity_2 INDEX 1 logseverity
logmodule_2 INDEX 1 logmodule
logsummary_3 INDEX 4984 logsummary
logdate_3 INDEX 4984 logdate
logid_6 INDEX 4984 logid
logtype_3 INDEX 1 logtype
logmodule_3 INDEX 1 logmodule
logseverity_3 INDEX 1 logseverity
logseverity_4 INDEX 1 logseverity
logdate_4 INDEX 4984 logdate
logtype_4 INDEX 1 logtype
logsummary_4 INDEX 4984 logsummary
logid_8 INDEX 4984 logid
logmodule_4 INDEX 1 logmodule
logdate_5 INDEX 4984 logdate
logseverity_5 INDEX 1 logseverity
logmodule_5 INDEX 1 logmodule
logdate_6 INDEX 4984 logdate
logseverity_6 INDEX 1 logseverity
logid_11 INDEX 4984 logid
logsummary_5 INDEX 4984 logsummary
logid_12 INDEX 4984 logid
logtype_5 INDEX 1 logtype
logsummary_6 INDEX 4984 logsummary
logtype_6 INDEX 1 logtype
logmodule_6 INDEX 1 logmodule
logid_13 INDEX 4984 logid
logtype_7 INDEX 1 logtype
logmodule_7 INDEX 1 logmodule
logseverity_7 INDEX 1 logseverity
logsummary_7 INDEX 4984 logsummary
logdate_7 INDEX 4984 logdate
logseverity_8 INDEX 1 logseverity
logid_15 INDEX 4984 logid
logdate_8 INDEX 4984 logdate
logtype_8 INDEX 1 logtype
logsummary_8 INDEX 4984 logsummary
logmodule_8 INDEX 1 logmodule
logseverity_9 INDEX 1 logseverity
logid_16 INDEX 4984 logid
logdate_9 INDEX 4984 logdate
logtype_9 INDEX 1 logtype
logmodule_9 INDEX 1 logmodule
logsummary_9 INDEX 4984 logsummary
logsummary_10 INDEX 4984 logsummary
logmodule_10 INDEX 1 logmodule


 Space usage :
Type Usage
Data 9,728 KB
Index 21,040 KB
Total 30,768 KB
   Row Statistic :
Statements Value
Format dynamic
Rows 5,053
Row length ø 1,971
Row size  ø 6,235 Bytes
Next Autoindex 8,635
Creation Apr 23, 2024 at 10:28 PM