Host: mysql.puroparty.com
Database: puroparty
Generation Time: Mar 29, 2024 at 10:03 AM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `email_module_tracker` PROCEDURE ANALYSE();
Rows: 5
Field_name | Min_value | Max_value | Min_length | Max_length | Empties_or_zeros | Nulls | Avg_value_or_avg_length | Std | Optimal_fieldtype |
---|---|---|---|---|---|---|---|---|---|
puroparty.email_module_tracker.statid | 4 | 7 | 1 | 1 | 0 | 0 | 5.5000 | 1.1180 | ENUM('4','5','6','7') NOT NULL |
puroparty.email_module_tracker.stattype | newsletter | newsletter | 10 | 10 | 0 | 0 | 10.0000 | NULL | ENUM('newsletter') NOT NULL |
puroparty.email_module_tracker.trackername | 6 | 6 | 0 | 0 | 6.0000 | NULL | ENUM('Google') NOT NULL | ||
puroparty.email_module_tracker.newsletterid | 2 | 3 | 1 | 1 | 0 | 0 | 2.2500 | 0.4330 | ENUM('2','3') NOT NULL |
puroparty.email_module_tracker.datastring | a:2:{s:12:"CampaignName";s:17:"Presidential Poll";s:10:"SourceName";s:14:"PP MailingList";} | a:2:{s:12:"CampaignName";s:25:"Copy of Presidential Poll";s:10:"SourceName";s:14:"pp MailingList";} | 91 | 99 | 0 | 0 | 93.2500 | NULL | ENUM('a:2:{s:12:"CampaignName";s:17:"Presidential Poll";s:10:"SourceName";s:14:"PP MailingList";}','a:2:{s:12:"CampaignName";s:17:"Presidential Poll";s:10:"SourceName";s:15:" PP MailingList";}','a:2:{s:12:"CampaignName";s:25:"Copy of Presidential Poll";s:10:"SourceName";s:14:"pp MailingList";}') NOT NULL |