Server: mysql.puroparty.com | Database: puroparty | Table: email_log_system_system |
Field | Type | Null | Default |
---|---|---|---|
logid | int(11) | No | |
logtype | varchar(20) | Yes | NULL |
logmodule | varchar(100) | No | |
logseverity | char(1) | No | 4 |
logsummary | varchar(250) | No | |
logmsg | text | No | |
logdate | int(11) | No | 0 |
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 :
|
Row Statistic :
|