Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 26, 2024 at 01:28 PM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `kxtn` 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.kxtn.rank | 1 | 10 | 1 | 2 | 0 | 0 | 5.5000 | 2.8723 | ENUM('1','2','3','4','5','6','7','8','9','10') NOT NULL |
| puroparty.kxtn.song | David Lee Garza y Los Musicales - Ladrona de Corazones | Michael Salgado - Duneo de Mi Corazon | 16 | 54 | 0 | 0 | 28.9000 | NULL | ENUM('David Lee Garza y Los Musicales - Ladrona de Corazones','DJ Kane - Brinca','Duelo - Bienvenido Al Amor','Duelo - Solo Callas','Intocable - Tiempo','Joe Posada - Con Un Cachito','Kumbia Kings - Parte de Mi Corazon','La Tropa F - El Caminante','Las 3 Divas - La Cumbia Del Oeste','Michael Salgado - Duneo de Mi Corazon') NOT NULL |
| puroparty.kxtn.playstw | 21 | 36 | 2 | 2 | 0 | 0 | 2.0000 | NULL | ENUM('21','22','23','25','27','33','35','36') NOT NULL |
| puroparty.kxtn.playslw | 22 | 6 | 1 | 2 | 1 | 0 | 1.7000 | NULL | ENUM('','22','23','26','28','31','33','35','6') NOT NULL |
| puroparty.kxtn.video | 0 | 0 | 10 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
| puroparty.kxtn.audio | 0 | 0 | 10 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
| puroparty.kxtn.lyrics | - | <a href=http://www.puroparty.com/lyricdetail.php?id=574 target=blank>Lyrics Here</a> | 1 | 84 | 0 | 0 | 34.2000 | NULL | ENUM('-','<a href=http://www.puroparty.com/lyricdetail.php?id=569 target=blank>Lyrics Here</a>','<a href=http://www.puroparty.com/lyricdetail.php?id=572 target=blank>Lyrics Here</a>','<a href=http://www.puroparty.com/lyricdetail.php?id=573 target=blank>Lyrics Here</a>','<a href=http://www.puroparty.com/lyricdetail.php?id=574 target=blank>Lyrics Here</a>') NOT NULL |
| puroparty.kxtn.label | Baby Dude | Univison | 3 | 9 | 0 | 0 | 7.5000 | NULL | ENUM('Baby Dude','DLG','EMI Latin','Freddie','Tejas','Univision','Univison') NOT NULL |
| puroparty.kxtn.pic | 3divas.jpg | tropaf.jpg | 9 | 15 | 0 | 0 | 11.2000 | NULL | ENUM('3divas.jpg','davidlee.jpg','djkane.jpg','duelo.jpg','intocable.jpg','joeposada.jpg','kumbiakings.jpg','salgado.jpg','tropaf.jpg') NOT NULL |