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

email_user_stats_emailsperhour

Table comments : InnoDB free: 730112 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
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 57 emailssent
userid INDEX 2 userid
statid_2 INDEX 172 statid
userid_2 INDEX 2 userid
summaryid_4 INDEX 172 summaryid
emailssent_2 INDEX 57 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 57 emailssent
statid_4 INDEX 172 statid
sendtime_4 INDEX 172 sendtime
userid_4 INDEX 2 userid
summaryid_8 INDEX 172 summaryid
emailssent_4 INDEX 57 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 57 emailssent
userid_6 INDEX 2 userid
emailssent_6 INDEX 57 emailssent
sendtime_6 INDEX 172 sendtime
sendtime_7 INDEX 172 sendtime
emailssent_7 INDEX 57 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 57 emailssent
summaryid_16 INDEX 172 summaryid
statid_8 INDEX 172 statid
userid_9 INDEX 2 userid
sendtime_9 INDEX 172 sendtime
emailssent_9 INDEX 57 emailssent
sendtime_10 INDEX 172 sendtime
userid_10 INDEX 2 userid
statid_9 INDEX 172 statid
summaryid_19 INDEX 172 summaryid


 Space usage :
Type Usage
Data 16,384 Bytes
Index 966,656 Bytes
Total 983,040 Bytes
   Row Statistic :
Statements Value
Format fixed
Rows 172
Row length ø 95
Row size  ø 5,715 Bytes
Next Autoindex 173
Creation Apr 26, 2024 at 06:29 AM