Field_name
|
Min_value
|
Max_value
|
Min_length
|
Max_length
|
Empties_or_zeros
|
Nulls
|
Avg_value_or_avg_length
|
Std
|
Optimal_fieldtype
|
puroparty.email_users.userid |
1 |
2 |
1 |
1 |
0 |
0 |
1.5000 |
0.5000 |
ENUM('1','2') NOT NULL |
puroparty.email_users.username |
admin |
benmendez |
5 |
9 |
0 |
0 |
7.0000 |
NULL |
ENUM('admin','benmendez') NOT NULL |
puroparty.email_users.password |
0c6569ce8038c6e8558c8f49ae5f505b |
d2cfcb745a74ab8ccdcd9e1e63e534d2 |
32 |
32 |
0 |
0 |
32.0000 |
NULL |
ENUM('0c6569ce8038c6e8558c8f49ae5f505b','d2cfcb745... |
puroparty.email_users.admintype |
a |
c |
1 |
1 |
0 |
0 |
1.0000 |
NULL |
ENUM('a','c') NOT NULL |
puroparty.email_users.listadmintype |
a |
c |
1 |
1 |
0 |
0 |
1.0000 |
NULL |
ENUM('a','c') NOT NULL |
puroparty.email_users.templateadmintype |
a |
a |
1 |
1 |
0 |
0 |
1.0000 |
NULL |
ENUM('a') NOT NULL |
puroparty.email_users.segmentadmintype |
a |
c |
1 |
1 |
0 |
0 |
1.0000 |
NULL |
ENUM('a','c') NOT NULL |
puroparty.email_users.status |
1 |
1 |
1 |
1 |
0 |
0 |
1.0000 |
NULL |
ENUM('1') NOT NULL |
puroparty.email_users.fullname |
|
|
0 |
0 |
2 |
0 |
0.0000 |
NULL |
CHAR(0) NOT NULL |
puroparty.email_users.emailaddress |
benmendez@pmgunited.com |
events@puroparty.com |
20 |
23 |
0 |
0 |
21.5000 |
NULL |
ENUM('benmendez@pmgunited.com','events@puroparty.c... |
puroparty.email_users.settings |
a:3:{s:10:"LoginCheck";s:14:"148ec3aefadad0";s:15:... |
a:5:{s:10:"LoginCheck";s:14:"14babc49d9880a";s:15:... |
240 |
2171 |
0 |
0 |
1205.5000 |
NULL |
ENUM('a:3:{s:10:"LoginCheck";s:14:"148ec3aefadad0"... |
puroparty.email_users.editownsettings |
1 |
1 |
1 |
1 |
0 |
0 |
1.0000 |
NULL |
ENUM('1') NOT NULL |
puroparty.email_users.usertimezone |
GMT-5:00 |
GMT-6:00 |
8 |
8 |
0 |
0 |
8.0000 |
NULL |
ENUM('GMT-5:00','GMT-6:00') NOT NULL |
puroparty.email_users.textfooter |
|
|
0 |
0 |
2 |
0 |
0.0000 |
NULL |
CHAR(0) NOT NULL |
puroparty.email_users.htmlfooter |
|
|
0 |
0 |
2 |
0 |
0.0000 |
NULL |
CHAR(0) NOT NULL |
puroparty.email_users.maxlists |
0 |
0 |
1 |
1 |
2 |
0 |
0.0000 |
0.0000 |
ENUM('0') NOT NULL |
puroparty.email_users.perhour |
0 |
0 |
1 |
1 |
2 |
0 |
0.0000 |
0.0000 |
ENUM('0') NOT NULL |
puroparty.email_users.permonth |
0 |
0 |
1 |
1 |
2 |
0 |
0.0000 |
0.0000 |
ENUM('0') NOT NULL |
puroparty.email_users.unlimitedmaxemails |
1 |
1 |
1 |
1 |
0 |
0 |
1.0000 |
NULL |
ENUM('1') NOT NULL |
puroparty.email_users.maxemails |
0 |
0 |
1 |
1 |
2 |
0 |
0.0000 |
0.0000 |
ENUM('0') NOT NULL |
puroparty.email_users.infotips |
1 |
1 |
1 |
1 |
0 |
0 |
1.0000 |
NULL |
ENUM('1') NOT NULL |
puroparty.email_users.smtpserver |
|
|
0 |
0 |
2 |
0 |
0.0000 |
NULL |
CHAR(0) NOT NULL |
puroparty.email_users.smtpusername |
|
|
0 |
0 |
2 |
0 |
0.0000 |
NULL |
CHAR(0) NOT NULL |
puroparty.email_users.smtppassword |
|
|
0 |
0 |
2 |
0 |
0.0000 |
NULL |
CHAR(0) NOT NULL |
puroparty.email_users.smtpport |
25 |
25 |
2 |
2 |
0 |
0 |
25.0000 |
0.0000 |
ENUM('25') NOT NULL |
puroparty.email_users.createdate |
1219268515 |
1223456349 |
10 |
10 |
0 |
0 |
1221362432.0000 |
2093917.0000 |
ENUM('1219268515','1223456349') NOT NULL |
puroparty.email_users.lastloggedin |
1223459135 |
1269566189 |
10 |
10 |
0 |
0 |
1246512662.0000 |
23053527.0000 |
ENUM('1223459135','1269566189') NOT NULL |
puroparty.email_users.forgotpasscode |
|
|
0 |
0 |
2 |
0 |
0.0000 |
NULL |
CHAR(0) NOT NULL |
puroparty.email_users.usewysiwyg |
1 |
1 |
1 |
1 |
0 |
0 |
1.0000 |
NULL |
ENUM('1') NOT NULL |
puroparty.email_users.xmlapi |
0 |
0 |
1 |
1 |
0 |
0 |
1.0000 |
NULL |
ENUM('0') NOT NULL |
puroparty.email_users.xmltoken |
|
|
0 |
0 |
2 |
0 |
0.0000 |
NULL |
CHAR(0) NOT NULL |
puroparty.email_users.gettingstarted |
1 |
1 |
1 |
1 |
0 |
0 |
1.0000 |
0.0000 |
ENUM('1') NOT NULL |