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

email_user_stats_emailsperhour

Table comments : InnoDB free: 727040 kB

Field Type Null Default
summaryid  int(11) No   
statid  int(11) Yes 
sendtime  int(11) Yes 
emailssent  int(11) Yes 
userid  int(11) Yes 


 Indexes :
Keyname Type Cardinality Field
PRIMARY PRIMARY 172 summaryid
summaryid_2 UNIQUE 172 summaryid
summaryid_3 UNIQUE 172 summaryid
summaryid_5 UNIQUE 172 summaryid
summaryid_7 UNIQUE 172 summaryid
summaryid_9 UNIQUE 172 summaryid
summaryid_11 UNIQUE 172 summaryid
summaryid_13 UNIQUE 172 summaryid
summaryid_15 UNIQUE 172 summaryid
summaryid_17 UNIQUE 172 summaryid
summaryid_18 UNIQUE 172 summaryid
summaryid_21 UNIQUE 172 summaryid
email_user_stats_emailsperhour_statid_idx INDEX 172 statid
email_user_stats_emailsperhour_userid_idx INDEX 2 userid
summaryid INDEX 172 summaryid
statid INDEX 172 statid
sendtime INDEX 172 sendtime
emailssent INDEX 86 emailssent
userid INDEX 2 userid
statid_2 INDEX 172 statid
userid_2 INDEX 2 userid
summaryid_4 INDEX 172 summaryid
emailssent_2 INDEX 86 emailssent
sendtime_2 INDEX 172 sendtime
statid_3 INDEX 172 statid
userid_3 INDEX 2 userid
summaryid_6 INDEX 172 summaryid
sendtime_3 INDEX 172 sendtime
emailssent_3 INDEX 86 emailssent
statid_4 INDEX 172 statid
sendtime_4 INDEX 172 sendtime
userid_4 INDEX 2 userid
summaryid_8 INDEX 172 summaryid
emailssent_4 INDEX 86 emailssent
summaryid_10 INDEX 172 summaryid
statid_5 INDEX 172 statid
userid_5 INDEX 2 userid
summaryid_12 INDEX 172 summaryid
statid_6 INDEX 172 statid
sendtime_5 INDEX 172 sendtime
emailssent_5 INDEX 86 emailssent
userid_6 INDEX 2 userid
emailssent_6 INDEX 86 emailssent
sendtime_6 INDEX 172 sendtime
sendtime_7 INDEX 172 sendtime
emailssent_7 INDEX 86 emailssent
summaryid_14 INDEX 172 summaryid
statid_7 INDEX 172 statid
userid_7 INDEX 2 userid
userid_8 INDEX 2 userid
sendtime_8 INDEX 172 sendtime
emailssent_8 INDEX 86 emailssent
summaryid_16 INDEX 172 summaryid
statid_8 INDEX 172 statid
userid_9 INDEX 2 userid
sendtime_9 INDEX 172 sendtime
emailssent_9 INDEX 86 emailssent
sendtime_10 INDEX 172 sendtime
userid_10 INDEX 2 userid
statid_9 INDEX 172 statid
summaryid_19 INDEX 172 summaryid
summaryid_20 INDEX 172 summaryid
userid_11 INDEX 2 userid
emailssent_10 INDEX 86 emailssent


 Space usage :
Type Usage
Data 16,384 Bytes
Index 1,008 KB
Total 1,024 KB
   Row Statistic :
Statements Value
Format fixed
Rows 172
Row length ø 95
Row size  ø 6,096 Bytes
Next Autoindex 173
Creation May 03, 2024 at 12:20 AM