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

email_stats_emailforwards

Table comments : InnoDB free: 739328 kB

Field Type Null Default
forwardid  int(11) No   
forwardtime  int(11) Yes 
forwardip  varchar(20) Yes  NULL 
subscriberid  int(11) Yes  NULL 
statid  int(11) Yes 
subscribed  int(11) Yes 
listid  int(11) Yes  NULL 
emailaddress  varchar(255) Yes  NULL 


 Indexes :
Keyname Type Cardinality Field
PRIMARY PRIMARY 0 forwardid
forwardid_2 UNIQUE 0 forwardid
forwardid_4 UNIQUE 0 forwardid
forwardid_6 UNIQUE 0 forwardid
forwardtime_2 UNIQUE 0 forwardtime
forwardip_2 UNIQUE 0 forwardip
subscriberid_2 UNIQUE 0 subscriberid
statid_2 UNIQUE 0 statid
subscribed_2 UNIQUE 0 subscribed
listid_2 UNIQUE 0 listid
emailaddress_2 UNIQUE 0 emailaddress
statid_3 UNIQUE 0 statid
forwardip_3 UNIQUE 0 forwardip
forwardtime_3 UNIQUE 0 forwardtime
subscribed_4 UNIQUE 0 subscribed
listid_4 UNIQUE 0 listid
emailaddress_4 UNIQUE 0 emailaddress
subscriberid_4 UNIQUE 0 subscriberid
forwardip_5 UNIQUE 0 forwardip
subscriberid_5 UNIQUE 0 subscriberid
emailaddress_5 UNIQUE 0 emailaddress
forwardtime_5 UNIQUE 0 forwardtime
subscribed_6 UNIQUE 0 subscribed
statid_6 UNIQUE 0 statid
listid_6 UNIQUE 0 listid
listid_7 UNIQUE 0 listid
statid_7 UNIQUE 0 statid
emailaddress_8 UNIQUE 0 emailaddress
subscribed_8 UNIQUE 0 subscribed
forwardip_7 UNIQUE 0 forwardip
forwardtime_7 UNIQUE 0 forwardtime
subscriberid_8 UNIQUE 0 subscriberid
email_stats_emailforwards_subscriberid_idx INDEX 0 subscriberid
email_stats_emailforwards_statid_idx INDEX 0 statid
email_stats_emailforwards_listid_idx INDEX 0 listid
forwardid INDEX 0 forwardid
forwardtime INDEX 0 forwardtime
forwardip INDEX 0 forwardip
subscriberid INDEX 0 subscriberid
statid INDEX 0 statid
subscribed INDEX 0 subscribed
listid INDEX 0 listid
emailaddress INDEX 0 emailaddress
statid_4 INDEX 0 statid
subscribed_3 INDEX 0 subscribed
forwardtime_4 INDEX 0 forwardtime
listid_3 INDEX 0 listid
forwardid_3 INDEX 0 forwardid
emailaddress_3 INDEX 0 emailaddress
subscriberid_3 INDEX 0 subscriberid
forwardip_4 INDEX 0 forwardip
forwardid_5 INDEX 0 forwardid
emailaddress_6 INDEX 0 emailaddress
subscriberid_6 INDEX 0 subscriberid
statid_5 INDEX 0 statid
listid_5 INDEX 0 listid
subscribed_5 INDEX 0 subscribed
forwardtime_6 INDEX 0 forwardtime
forwardip_6 INDEX 0 forwardip
emailaddress_7 INDEX 0 emailaddress
subscribed_7 INDEX 0 subscribed
listid_8 INDEX 0 listid
subscriberid_7 INDEX 0 subscriberid
statid_8 INDEX 0 statid


 Space usage :
Type Usage
Data 16,384 Bytes
Index 1,008 KB
Total 1,024 KB
   Row Statistic :
Statements Value
Format dynamic
Rows 0
Next Autoindex 1
Creation Mar 15, 2024 at 08:17 PM