SQL result

Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 20, 2024 at 10:00 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','Bessie','Bianca','Chayeroold','Clarissa','Claudia','Delores','Deysi','Diana','Elidia','Esmerelda','Estella','Eva','Flor','Gladys','Gloria','Grace','Gracie','Griselda','Heather','Isadora','Jamie','Jana','Janet','Jennifer','Jenny','Jessica','Joy','Juanita','Karen','Karla','Kristy','Laura','Liana','Lizet','Luisa','Lydia','Maggie','Maria','Maricela','Maritza','Martha','Mary','Melissa','Mierya','Mona','Monica','Nancy','Natalia','Norma','Olga','Priscilla','Rachida','Rosa','Rosie','Rosio','Rosy','Roxanna','Ruby','Sandra','Stephanie','Susie','Teresa','Terry','Theresa','Vanessa','Veronica','Victoria','Vielca','Ximena') NOT NULL
puroparty.networkgirls.lname Aguilar Zepeda 3 16 0 0 6.5794 NULL ENUM('Aguilar','Aleman','Arriaga','Bernal','Bernard','Buckner','Buonamici','Canales','Cantu','Carrasco','Castillo','Cavassos','Ceballos','Chapa','Chavez','Chramti','Colecio','Costas','Crane','Cruz','Cuellar','Dalmolin','Degrand','Diaz','Escobar','Esparza','Faubion','Fernandez','Flores','Garcia','Garfias','Garza','Gibson','Gomez','Gonzales','Guerrera','Hernandez','Hogeda','Huerta','Juaregui-Celeita','Landin','Lara','Lee','Lemon','Licon','Loar','Lopez','Lozano','Manrique','Martinez','Medina','Mendez','Mendoza','Molina','Montalvo','Montejano','Moran','Munoz','Palermo','Perez','Pinon','Reyes','Rodriguez','Saavedra','Salas','Segovia','Seksinski','Serrano','Stokes','Terrazas','Tisdale','Torres','Trevino','Vargas','Vicars','Villanueva','Walker','Weller','Ybarra','Zepeda') NOT NULL
puroparty.networkgirls.address 1020 Pathfinder 9898 Colonnade  #9204 10 26 0 0 17.4206 NULL ENUM('1020 Pathfinder','105 W. Ruben Torres','1107 Oyster Bay Dr.','1115 Macclesby Ln','112 Centre','1123 Brannon Park Lane','1206 Honey Tree','12423 Plum Point Dr.','12446 Chalmette St.','1308 Bryan St','13154 Cherryglade Ct','13625 Forest Rock','1431 Patricia','14807 Hermit Thrush','1502 Douglas Dr','1525 Prairie Walker Dr.','1530 Chertsey Circle','1600 Yonker St #2','16106 Bollard Dr','16240 San Pedro #172','1647 Post Road #4212','1712 Wheless LAne','1713 Howel Dr.','1801 S. Lakeshore   #101','18503 Dural','187 Shiloh Dr.','18707 Forest Forge Dr.','202 14th St','20202 Laverton Dr.','22946 Highland Estate Ct.','2400 Drifting Leaf','2406 McClendon','2420 Britt Dr.','2472 Rosita Valley Road','2500 Aquatic Lane','2600 West Hollow Dr #1132','2905 Ash Field Dr','309 Hagerman Street','3109 Texas St','3118 W Kansas Ave','317 Chickering Ave','318 Rustic Dr','318 Rustic Dr.','3180 Queens Garden Circle','3223 John Glenn','330 S. Walnut Ave','3309 Jay Ave.','3402 Preston #228','3434 Edgecreek Dr','3501 Shoreline Dr. #1114','3706 40th St','3720 Bowie Ave','3721 Wilson Dr.','3909 Burke Rd #3109','3911 April Lane','401 N. Fredericksburg #406','4138 Winter Sunrise','4219 W. Expressway 83','4233 Aaron Cove','4705 Hackberry Ave.','4802 Ridgecreek circle.','4808 White Elm Drive','4830 Scarlet Oak Dr','4848 Pin Oak Park #219','4921 Love Rd','5003 S. Bonhan St.','5042 Hacienda Dr.','508 Blue Valley Drive','5415 Cairnleigh Dr.','5465 Braesvalley #579','5501 48th 3125','565 James Rd','643 Rey Salomon','6500 RamPart #39','6666 Chimney Rock #19','6715 Providence View Lane','6810 Huron Ave','702 State Court Dr.','717 Sandpiper #2','719 Quinella Dr','7322 Mar Vista','7334 Park West','7431 Magnolia','7434 Walker St.','770 Botany Bay','7835 Leonora St.','8032 Lenore','8038 Holiday Dr','8060 Carpenter Dr.','8215 Augustine Drive','8338 Silvan Wind Lane','9006 Sterling Pt LN','920 East Houston Ave #2507','9406 Carlton','9823 Vermont Green Trail','9898 Colonnade  #9204') NOT NULL
puroparty.networkgirls.city Amarillo Weslaco 4 14 0 0 8.0280 NULL ENUM('Amarillo','Argyle','Austin','Brownsville','Cedar Park','Channelview','Conroe','Corpus Christi','Crosby','Cypress','Dallas','Eagle Pass','El Paso','Ferris','Hereford','Houston','Katy','Kingsville','Levelland','Lubbock','McAllen','Midland','New Braunfels','Odessa','Palmview','Pasadena','Plainview','Richmond','Round Rock','San Angelo','San Antonio','San Benito','San Marcos','Spring','Sugarland','Tomball','Weslaco') NOT NULL
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','77011','77015','77017','77023','77030','77036','77040','77044','77049','77053','77061','77066','77075','77077','77081','77082','77083','77084','77092','77094','77096','77099','77373','77377','77385','77433','77450','77469','77478','77502','77504','77505','77530','77532','78130','78210','78217','78230','78231','78232','78233','78244','78245','78250','78363','78408','78413','78501','78504','78520','78521','78572','78586','78596','78613','78664','78666','78723','78728','78741','78748','78749','78852','79045','79072','79110','79336','79413','79414','79424','79701','79762','79765','79915','79922','79936') NOT NULL
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-1894','210-326-8504','210-363-3522','210-363-9486','210-367-8638','210-383-9402','210-385-8516','210-454-9571','210-493-1263','210-843-6608','210-887-1647','214-315-9649','214-566-1294','281-236-8087','281-384-0271','281-384-1952','281-627-1253','281-687-0048','281-723-7386','281-757-6458','281-795-0654','281-924-0630','281-933-0844','325-277-9647','325-450-4373','361-228-3963','361-793-6924','361-853-7335','432-202-1161','432-352-0430','432-553-1050','432-557-1929','512-258-5750','512-280-3244','512-626-9976','512-627-8159','512-825-3164','512-923-2057','512-923-5976','713-204-7006','713-385-9105','713-416-1553','713-429-3836','713-447-8339','713-478-0763','713-501-5874','713-530-9213','713-668-5376','713-775-7267','806 722 5175','806-236-2168','806-292-8371','806-438-4548','806-690-3473','806-793-8142','817-707-7387','830-757-8382','830-776-0420','830-776-3564','830-968-5263','832-212-2218','832-277-2540','832-282-7304','832-287-9020','832-338-0607','832-372-3565','832-434-2186','832-444-3216','832-444-5842','832-453-4333','832-455-4519','832-455-8572','832-466-1182','832-518-0004','832-606-3549','832-618-8272','832-661-2013','832-721-1619','832-883-2144','915 240-4970','915-494-5488','915-633-5284','915-855-8591','915-873-3668','918-794-5020','940-464-3838','956-495-6103','956-532-7288','956-551-0699','956-571-8347','956-648-9555','956-735-7227','956-821-7062','956-867-6892','956-928-0830','956.466.9133','956.639-2770','972-345-1357') NOT NULL
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