Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: radioradio

radio

Field Type Null Default
id  smallint(10) No   
amfm  varchar(4) No   
letters  varchar(8) No   
frequency  varchar(8) No   
format  varchar(75) No   
website  varchar(30) No   
owner  varchar(20) No   
city  varchar(20) No   
state  varchar(20) No   


 Indexes :
Keyname Type Cardinality Field
PRIMARY PRIMARY 63 id
id_2 UNIQUE 63 id
frequency_2 UNIQUE 63 frequency
id_3 UNIQUE 63 id
frequency_5 UNIQUE 63 frequency
id_5 UNIQUE 63 id
frequency_9 UNIQUE 63 frequency
id_7 UNIQUE 63 id
id INDEX None id
amfm INDEX None amfm
letters INDEX None letters
frequency INDEX None frequency
format INDEX None format
website INDEX None website
owner INDEX None owner
city INDEX None city
state INDEX None state
amfm_3 INDEX None amfm
format_3 INDEX None format
frequency_4 INDEX None frequency
city_4 INDEX None city
id_4 INDEX None id
owner_4 INDEX None owner
website_4 INDEX None website
state_4 INDEX None state
letters_4 INDEX None letters
format_5 INDEX None format
city_5 INDEX None city
website_5 INDEX None website
frequency_8 INDEX None frequency
id_6 INDEX None id
amfm_6 INDEX None amfm
owner_6 INDEX None owner
state_6 INDEX None state
letters_6 INDEX None letters
city_7 INDEX None city
format_7 INDEX None format
amfm_2 INDEX None amfm
letters_2 INDEX None letters
frequency_3 INDEX None frequency
format_2 INDEX None format
website_2 INDEX None website
owner_2 INDEX None owner
city_2 INDEX None city
state_2 INDEX None state
letters_3 INDEX None letters
state_3 INDEX None state
city_3 INDEX None city
owner_3 INDEX None owner
amfm_4 INDEX None amfm
website_3 INDEX None website
frequency_6 INDEX None frequency
format_4 INDEX None format
letters_5 INDEX None letters
frequency_7 INDEX None frequency
city_6 INDEX None city
amfm_5 INDEX None amfm
website_6 INDEX None website
owner_5 INDEX None owner
state_5 INDEX None state
format_6 INDEX None format
city_8 INDEX None city
frequency_10 INDEX None frequency
amfm_7 INDEX None amfm


 Space usage :
Type Usage
Data 4,780 Bytes
Index 3,072 Bytes
Total 7,852 Bytes
   Row Statistic :
Statements Value
Format dynamic
Rows 63
Row length ø 75
Row size  ø 125 Bytes
Next Autoindex 64
Creation Feb 21, 2018 at 10:09 PM
Last update Mar 29, 2024 at 04:56 AM
Last check Apr 19, 2024 at 02:12 AM