Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 19, 2024 at 06:15 AM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `djs` PROCEDURE ANALYSE();
Rows: 9
| Field_name | Min_value | Max_value | Min_length | Max_length | Empties_or_zeros | Nulls | Avg_value_or_avg_length | Std | Optimal_fieldtype |
|---|---|---|---|---|---|---|---|---|---|
| puroparty.djs.id | 1 | 13 | 1 | 2 | 0 | 0 | 7.0000 | 3.7417 | ENUM('1','2','3','4','5','6','7','8','9','10','11'... |
| puroparty.djs.name | Dimensional Sounds - DJ Benny | DJ Spice | 8 | 35 | 0 | 0 | 15.8462 | NULL | ENUM('Dimensional Sounds - DJ Benny','DJ Eddie S',... |
| puroparty.djs.phone1 | 281-331-3322 | 713-645-8402 | 12 | 12 | 0 | 0 | 12.0000 | NULL | ENUM('281-331-3322','713-645-8402') NOT NULL |
| puroparty.djs.phone2 | 713-891-0867 | 0 | 12 | 12 | 0 | 0.9231 | NULL | ENUM('','713-891-0867') NOT NULL | |
| puroparty.djs.type | Tejano, Country, Latin, Old School & more | Tejano, Top 40, Country & Oldies | 32 | 41 | 0 | 0 | 36.6923 | NULL | ENUM('Tejano, Country, Latin, Old School & more','... |
| puroparty.djs.website | 0 | 0 | 13 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
| puroparty.djs.location | Houston, TX | Houston, TX | 11 | 11 | 0 | 0 | 11.0000 | NULL | ENUM('Houston, TX') NOT NULL |
| puroparty.djs.smallpic | benny_t.jpg | spice_t.jpg | 9 | 17 | 0 | 0 | 12.6923 | NULL | ENUM('benny_t.jpg','eddies_t.jpg','ericg_t.jpg','g... |
| puroparty.djs.largepic | benny.jpg | spice.jpg | 7 | 15 | 0 | 0 | 10.6923 | NULL | ENUM('benny.jpg','eddies.jpg','ericg.jpg','gene.jp... |