Host: mysql.puroparty.com
Database: puroparty
Generation Time: Mar 29, 2024 at 08:38 AM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `networkgirls` PROCEDURE ANALYSE();
Rows: 10
Field_name | Min_value | Max_value | Min_length | Max_length | Empties_or_zeros | Nulls | Avg_value_or_avg_length | Std | Optimal_fieldtype |
---|---|---|---|---|---|---|---|---|---|
puroparty.networkgirls.id | 1 | 107 | 1 | 3 | 0 | 0 | 54.0000 | 30.8869 | TINYINT(3) UNSIGNED NOT NULL |
puroparty.networkgirls.fname | Amanda | Ximena | 3 | 10 | 0 | 0 | 5.8131 | NULL | ENUM('Amanda','Amarie','Amy','Andrea','Bea','Bessi... |
puroparty.networkgirls.lname | Aguilar | Zepeda | 3 | 16 | 0 | 0 | 6.5794 | NULL | ENUM('Aguilar','Aleman','Arriaga','Bernal','Bernar... |
puroparty.networkgirls.address | 1020 Pathfinder | 9898 Colonnade #9204 | 10 | 26 | 0 | 0 | 17.4206 | NULL | ENUM('1020 Pathfinder','105 W. Ruben Torres','1107... |
puroparty.networkgirls.city | Amarillo | Weslaco | 4 | 14 | 0 | 0 | 8.0280 | NULL | ENUM('Amarillo','Argyle','Austin','Brownsville','C... |
puroparty.networkgirls.state | TX | TX | 2 | 2 | 1 | 0 | 1.9813 | NULL | ENUM('','TX') NOT NULL |
puroparty.networkgirls.zip | 75125 | 79936 | 5 | 5 | 0 | 0 | 5.0000 | NULL | ENUM('75125','75211','76226','76904','76905','7701... |
puroparty.networkgirls.phone | (806) 790-6479 | 972-345-1357 | 12 | 14 | 0 | 0 | 12.0561 | NULL | ENUM('(806) 790-6479','1-713-992-3291','210-219-18... |
puroparty.networkgirls.bilingual | No\r | Yes\r | 3 | 4 | 0 | 0 | 3.6355 | NULL | ENUM('No\r','Yes\r') NOT NULL |
puroparty.networkgirls.pic | 0 | 0 | 107 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL |