Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 25, 2024 at 08:58 AM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `radio` 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.radio.id | 1 | 63 | 1 | 2 | 0 | 0 | 32.0000 | 18.1842 | TINYINT(2) UNSIGNED NOT NULL |
puroparty.radio.amfm | AM | FM | 2 | 2 | 0 | 0 | 2.0000 | NULL | ENUM('AM','FM') NOT NULL |
puroparty.radio.letters | KANI | KYST | 4 | 4 | 0 | 0 | 4.0000 | NULL | ENUM('KANI','KBME','KBXX','KCOH','KEYH','KFCC','KFTG','KGBC','KGOL','KHCB','KHJZ','KHMX','KHPT','KIKK','KILE','KILT','KJIC','KJOJ','KKBQ','KKHT','KKRW','KLAT','KLDE','KLOL','KLTN','KLVI','KLVL','KMIC','KMJQ','KODA','KOVE','KPFT','KPRC','KPVU','KQBU','KQQK','KQUE','KRBE','KRTS','KRTX','KRWP','KSBJ','KSEV','KSTB','KTBZ','KTEK','KTHT','KTJM','KTRH','KTRU','KTSU','KUHF','KVST','KWWJ','KXYZ','KYND','KYOK','KYST') NOT NULL |
puroparty.radio.frequency | 100.3 | 99.1 | 3 | 5 | 0 | 0 | 4.0635 | NULL | ENUM('100.3','100.7','101.1','101.5','1010','102.1','102.9','103.3','103.7','104.1','104.9','105.7','106.5','106.9','107.5','107.9','1070','1110','1140','1180','1230','1270','1320','1360','1400','1430','1480','1500','1520','1540','1560','1590','560','610','650','700','740','790','850','88.1','88.7','880','89.3','90.1','90.5','90.9','91.3','91.7','92.1','92.9','920','93.3','93.7','94.5','95.7','950','96.5','97.1','97.5','97.9','98.5','980','99.1') NOT NULL |
puroparty.radio.format | '80s rock. | Vietnamese. | 6 | 45 | 0 | 0 | 17.7143 | NULL | ENUM(' \'80s rock.',' Adult contemporary rock.',' Adult contemporary.',' Alternative rock.',' Alternative/ various',' Catholic programming in English and Spanish.',' Christian talk.',' Christian.',' Christian/ Spanish',' Christian/ Vietnamese.',' Classic country.',' Classic rock.',' Classical.',' Classical/National Public Radio.',' Contemporary Christian.',' Contemporary country.',' Country',' Country.',' Eclectic/Pacifica.',' Gospel music.',' Gospel.',' Gospel/ news and talk.',' Hip-hop.',' Hip-Hop/ R&B.',' Hot talk.',' Jazz/ gospel.',' Jazz/gospel/National Public Radio.',' Kids/family.',' Mainstream urban.',' Multicultural/ religion.',' Multilingual Christian.',' News/ talk and sports.',' News/ talk/ sports.',' R&B oldies/ gospel.',' Ranchera.',' Regional Mexican.',' Rock oldies.',' Smooth jazz.',' Spanish adult contemporary.',' Spanish Hip-Hop/Reggaeton/Dance.',' Spanish news/ sports.',' Spanish pop/salsa.',' Spanish religious.',' Spanish talk.',' Spanish Top 40.',' Spanish tropical.',' Sports.',' Talk.',' Tejano.',' Top 40.',' Traditional gospel.',' Urban contemporary.',' Vietnamese.') NOT NULL |
puroparty.radio.website | http://http://www.khjz.com/ | http://www.xoradio.com | 19 | 30 | 14 | 0 | 18.7778 | NULL | ENUM('','http://http://www.khjz.com/','http://kqbu.netmio.com','http://psc.disney.go.com/radio','http://www.104krbe.com/','http://www.1069thepoint.com/','http://www.790kbme.com/','http://www.businessradio650.co','http://www.countrylegends971.c','http://www.kbxx.com/main.html','http://www.kcohradio.com','http://www.khcb.org/','http://www.khmx.com/','http://www.kile1560.com','http://www.kilt.com','http://www.kjic.org/','http://www.kkbq.com','http://www.kkht.com/','http://www.kkrw.com/main.html','http://www.klde.com/','http://www.klol.com/','http://www.klvi.com/','http://www.kmjq.com/','http://www.kpft.org/','http://www.kprcradio.com/','http://www.krts.com/','http://www.ksbj.org/','http://www.ksevradio.com','http://www.ktrh.com/','http://www.ktru.org/','http://www.kuhf.org/','http://www.kwwj.org','http://www.maxkolberadio.com','http://www.netmio.com/radio/kl','http://www.netmio.com/radio/ko','http://www.netmio.com/radio/kr','http://www.power975.com','http://www.pvamu.edu/kpvu/','http://www.radio-noticias.com/','http://www.sportsradio610.com/','http://www.sunny99.com/','http://www.thebuzz.com/','http://www.tsu.edu/student/kts','http://www.vovnradio.com','http://www.xoradio.com') NOT NULL |
puroparty.radio.owner | 0 | 0 | 63 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.radio.city | Houston | Houston | 7 | 7 | 0 | 0 | 7.0000 | NULL | ENUM('Houston') NOT NULL |
puroparty.radio.state | Texas\r | Texas\r | 6 | 6 | 0 | 0 | 6.0000 | NULL | ENUM('Texas\r') NOT NULL |