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

email_newsletters

Table comments : InnoDB free: 739328 kB

Field Type Null Default
newsletterid  int(11) No   
name  varchar(255) Yes  NULL 
format  char(1) Yes  NULL 
subject  varchar(255) Yes  NULL 
textbody  longtext Yes  NULL 
htmlbody  longtext Yes  NULL 
createdate  int(11) Yes  0 
active  int(11) Yes  0 
archive  int(11) Yes  0 
ownerid  int(11) No  0 


 Indexes :
Keyname Type Cardinality Field
PRIMARY PRIMARY 23 newsletterid
newsletterid_2 UNIQUE 23 newsletterid
newsletterid_3 UNIQUE 23 newsletterid
newsletterid_6 UNIQUE 23 newsletterid
newsletterid_7 UNIQUE 23 newsletterid
newsletterid_10 UNIQUE 23 newsletterid
newsletterid_12 UNIQUE 23 newsletterid
newsletterid_14 UNIQUE 23 newsletterid
name_2 UNIQUE 23 name
name_3 UNIQUE 23 name
name_6 UNIQUE 23 name
name_7 UNIQUE 23 name
name_10 UNIQUE 23 name
email_newsletters_owner_idx INDEX 2 ownerid
newsletterid INDEX 23 newsletterid
name INDEX 23 name
format INDEX 2 format
subject INDEX 23 subject
createdate INDEX 23 createdate
active INDEX 4 active
archive INDEX 2 archive
ownerid INDEX 2 ownerid
subject_2 INDEX 23 subject
ownerid_2 INDEX 2 ownerid
newsletterid_4 INDEX 23 newsletterid
createdate_2 INDEX 23 createdate
name_4 INDEX 23 name
active_2 INDEX 4 active
archive_2 INDEX 2 archive
format_2 INDEX 2 format
name_5 INDEX 23 name
subject_3 INDEX 23 subject
format_3 INDEX 2 format
ownerid_3 INDEX 2 ownerid
newsletterid_5 INDEX 23 newsletterid
active_3 INDEX 4 active
createdate_3 INDEX 23 createdate
archive_3 INDEX 2 archive
ownerid_4 INDEX 2 ownerid
subject_4 INDEX 23 subject
archive_4 INDEX 2 archive
createdate_4 INDEX 23 createdate
active_4 INDEX 4 active
newsletterid_8 INDEX 23 newsletterid
name_8 INDEX 23 name
format_4 INDEX 2 format
archive_5 INDEX 2 archive
archive_6 INDEX 2 archive
subject_5 INDEX 23 subject
ownerid_5 INDEX 2 ownerid
createdate_5 INDEX 23 createdate
newsletterid_9 INDEX 23 newsletterid
name_9 INDEX 23 name
active_5 INDEX 4 active
subject_6 INDEX 23 subject
ownerid_6 INDEX 2 ownerid
format_5 INDEX 2 format
createdate_6 INDEX 23 createdate
active_6 INDEX 4 active
name_11 INDEX 23 name
newsletterid_11 INDEX 23 newsletterid
ownerid_7 INDEX 2 ownerid
subject_7 INDEX 23 subject
newsletterid_13 INDEX 23 newsletterid


 Space usage :
Type Usage
Data 147,456 Bytes
Index 1,008 KB
Total 1,152 KB
   Row Statistic :
Statements Value
Format dynamic
Rows 23
Row length ø 6,411
Row size  ø 51,289 Bytes
Next Autoindex 31
Creation Mar 29, 2024 at 11:53 AM