Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 25, 2024 at 07:07 PM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `bos_ad_types` PROCEDURE ANALYSE();
Rows: 25
Field_name | Min_value | Max_value | Min_length | Max_length | Empties_or_zeros | Nulls | Avg_value_or_avg_length | Std | Optimal_fieldtype |
---|---|---|---|---|---|---|---|---|---|
puroparty.bos_ad_types.type_id | 12 | 25 | 2 | 2 | 0 | 0 | 20.7500 | 3.7997 | ENUM('12','19','20','21','22','23','24','25') NOT NULL |
puroparty.bos_ad_types.type_title | Artist Ad | Mariachis | 5 | 19 | 0 | 0 | 10.5000 | NULL | ENUM('Artist Ad','Clubs/Bars','Concert/Festival Ad','DJ Ad','Fundraiser Ad','Halls','Happy Hour Ad!','Mariachis') NOT NULL |
puroparty.bos_ad_types.type_required | 3609 | 423449 | 4 | 6 | 0 | 0 | 120921.0000 | 139567.5369 | ENUM('3609','5657','7705','32281','116249','129049','249369','423449') NOT NULL |
puroparty.bos_ad_types.type_use | 7961 | 524057 | 4 | 6 | 0 | 0 | 185817.0000 | 210884.7975 | ENUM('7961','32537','124697','257817','523545','524057') NOT NULL |
puroparty.bos_ad_types.option1 | state | state | 5 | 5 | 0 | 0 | 5.0000 | NULL | ENUM('state') NOT NULL |
puroparty.bos_ad_types.def_option1 | 3|1|1|Texas | 3|1|1|Texas| | 11 | 12 | 0 | 0 | 11.2500 | NULL | ENUM('3|1|1|Texas','3|1|1|Texas|') NOT NULL |
puroparty.bos_ad_types.option2 | beneficiary | ticket price | 10 | 12 | 0 | 0 | 11.1250 | NULL | ENUM('beneficiary','company name','contact# 1','cover charge','group name','ticket price') NOT NULL |
puroparty.bos_ad_types.def_option2 | 1||| | 2||| | 4 | 5 | 0 | 0 | 4.2500 | NULL | ENUM('1|||','1||||','2|||') NOT NULL |
puroparty.bos_ad_types.option3 | # members | Phone | 5 | 10 | 1 | 0 | 7.7500 | NULL | ENUM('','# members','contact #','contact #1','contact #2','dj name(s)','headliner','Phone') NOT NULL |
puroparty.bos_ad_types.def_option3 | 1||| | 2||| | 4 | 5 | 1 | 0 | 3.7500 | NULL | ENUM('','1|||','1||||','2|||') NOT NULL |
puroparty.bos_ad_types.option4 | contact #2 | venue name | 10 | 15 | 2 | 0 | 8.7500 | NULL | ENUM('','contact #2','drink selection','genre types','group gender','max capacity','venue name') NOT NULL |
puroparty.bos_ad_types.def_option4 | 1||| | 5|4||beer|draft|wine|liquor | 4 | 31 | 2 | 0 | 9.2500 | NULL | ENUM('','1|||','2|||','4|2|2|all male|all female|mixed','5|4||beer|draft|wine|liquor') NOT NULL |
puroparty.bos_ad_types.option5 | seating | 0 | 17 | 3 | 0 | 6.5000 | NULL | ENUM('','Drinks Avail','food avail?','genre','genre specialties','seating') NOT NULL | |
puroparty.bos_ad_types.def_option5 | 5|4||beer|draft|wine|liquor | 0 | 27 | 3 | 0 | 9.0000 | NULL | ENUM('','1|||','4|2|2|yes|no','4|3|2|indoor|outdoor|both','5|4||beer|draft|wine|liquor') NOT NULL | |
puroparty.bos_ad_types.option6 | patio seating? | 0 | 14 | 3 | 0 | 6.2500 | NULL | ENUM('','# members','equip','event month','Food Avail?','patio seating?') NOT NULL | |
puroparty.bos_ad_types.def_option6 | 5|2|sound|lights | 0 | 54 | 3 | 0 | 12.2500 | NULL | ENUM('','1|||','3|12||jan|feb|mar|apr|may|jun|jul|aug|sep|oct|nov|dec|','4|2|2|yes|no','5|2|sound|lights') NOT NULL | |
puroparty.bos_ad_types.option7 | Patio Seating? | 0 | 15 | 4 | 0 | 6.0000 | NULL | ENUM('','available area','booking contact','music','Patio Seating?') NOT NULL | |
puroparty.bos_ad_types.def_option7 | 5|5||piped|jukebox|karaoke|dj|band | 0 | 34 | 4 | 0 | 6.7500 | NULL | ENUM('','1|||','4|2|2|yes|no','5|5||piped|jukebox|karaoke|dj|band') NOT NULL | |
puroparty.bos_ad_types.option8 | other stuff | 0 | 11 | 4 | 0 | 4.3750 | NULL | ENUM('','booking #','contact #1','music','other stuff') NOT NULL | |
puroparty.bos_ad_types.def_option8 | 5|5||piped|jukebox|karaoke|dj|band | 0 | 34 | 4 | 0 | 7.7500 | NULL | ENUM('','1|||','5|2|pool|big screens','5|5||piped|jukebox|karaoke|dj|band') NOT NULL | |
puroparty.bos_ad_types.option9 | other stuff | 0 | 11 | 5 | 0 | 3.6250 | NULL | ENUM('','contact #2','event mo','other stuff') NOT NULL | |
puroparty.bos_ad_types.def_option9 | 5|2||pool|big screens | 0 | 54 | 5 | 0 | 9.8750 | NULL | ENUM('','1|||','3|12||jan|feb|mar|apr|may|jun|jul|aug|sep|oct|nov|dec|','5|2||pool|big screens') NOT NULL | |
puroparty.bos_ad_types.option10 | other comments | 0 | 14 | 6 | 0 | 3.0000 | NULL | ENUM('','event date','other comments') NOT NULL | |
puroparty.bos_ad_types.def_option10 | 2||| | 0 | 5 | 6 | 0 | 1.1250 | NULL | ENUM('','1||||','2|||') NOT NULL | |
puroparty.bos_ad_types.template | \r\n\r\n<table width="100%" border="0" cellspacing="0" cellpadding="3">\r\n <tr>\r\n <td class="headtd" width="50%">%adTitle%</td>\r\n <td class="headtd" width="50%" align="right">%adNumber%</td>\r\n </tr>\r\n <tr>\r\n <td valign="top" width="50%">\r\n\r\n <!--%adSeller%-------------------rrs----------------->\r\n %adDescription% <!-- added rrs -->\r\n %adPrice%\r\n %adCondition%\r\n %adCity%\r\n %adState%\r\n %adPostal%\r\n %adCountry%\r\n %adTypeOpt1%\r\n %adTypeOpt2%\r\n %adTypeOpt3%\r\n %adTypeOpt4%\r\n %adTypeOpt5%\r\n %adTypeOpt6%\r\n %adTypeOpt7%\r\n %adTypeOpt8%\r\n %adTypeOpt9%\r\n %adTypeOpt10%\r\n %adCatOpt1%\r\n %adCatOpt2%\r\n %adCatOpt3%\r\n %adCatOpt4%\r\n %adCatOpt5%\r\n </td>\r\n <td valign="top" width="50%">\r\n %adImages%\r\n </td>\r\n </tr>\r\n<!-- rrs\r\n <tr>\r\n <td colspan="2">\r\n %adDescription%\r\n </td>\r\n </tr>\r\n -->\r\n</table> | <table width="100%" border="0" cellspacing="0" cellpadding="3">\r\n <tr>\r\n <td class="headtd" width="50%">%adTitle%</td>\r\n <td class="headtd" width="50%" align="right">%adNumber%</td>\r\n </tr>\r\n <tr>\r\n <td valign="top" width="50%">\r\n\r\n <!--%adSeller%-------------------rrs----------------->\r\n %adDescription% <!-- added rrs -->\r\n %adPrice%\r\n %adCondition%\r\n %adCity%\r\n %adState%\r\n %adPostal%\r\n %adCountry%\r\n %adTypeOpt1%\r\n %adTypeOpt2%\r\n %adTypeOpt3%\r\n %adTypeOpt4%\r\n %adTypeOpt5%\r\n %adTypeOpt6%\r\n %adTypeOpt7%\r\n %adTypeOpt8%\r\n %adTypeOpt9%\r\n %adTypeOpt10%\r\n %adCatOpt1%\r\n %adCatOpt2%\r\n %adCatOpt3%\r\n %adCatOpt4%\r\n %adCatOpt5%\r\n </td>\r\n <td valign="top" width="50%">\r\n %adImages%\r\n </td>\r\n </tr>\r\n<!-- rrs\r\n <tr>\r\n <td colspan="2">\r\n %adDescription%\r\n </td>\r\n </tr>\r\n -->\r\n</table> | 846 | 850 | 0 | 0 | 847.0000 | NULL | ENUM('\r\n\r\n<table width="100%" border="0" cellspacing="0" cellpadding="3">\r\n <tr>\r\n <td class="headtd" width="50%">%adTitle%</td>\r\n <td class="headtd" width="50%" align="right">%adNumber%</td>\r\n </tr>\r\n <tr>\r\n <td valign="top" width="50%">\r\n\r\n <!--%adSeller%-------------------rrs----------------->\r\n %adDescription% <!-- added rrs -->\r\n %adPrice%\r\n %adCondition%\r\n %adCity%\r\n %adState%\r\n %adPostal%\r\n %adCountry%\r\n %adTypeOpt1%\r\n %adTypeOpt2%\r\n %adTypeOpt3%\r\n %adTypeOpt4%\r\n %adTypeOpt5%\r\n %adTypeOpt6%\r\n %adTypeOpt7%\r\n %adTypeOpt8%\r\n %adTypeOpt9%\r\n %adTypeOpt10%\r\n %adCatOpt1%\r\n %adCatOpt2%\r\n %adCatOpt3%\r\n %adCatOpt4%\r\n %adCatOpt5%\r\n </td>\r\n <td valign="top" width="50%">\r\n %adImages%\r\n </td>\r\n </tr>\r\n<!-- rrs\r\n <tr>\r\n <td colspan="2">\r\n %adDescription%\r\n </td>\r\n </tr>\r\n -->\r\n</table>','\r\n<table width="100%" border="0" cellspacing="0" cellpadding="3">\r\n <tr>\r\n <td class="headtd" width="50%">%adTitle%</td>\r\n <td class="headtd" width="50%" align="right">%adNumber%</td>\r\n </tr>\r\n <tr>\r\n <td valign="top" width="50%">\r\n\r\n <!--%adSeller%-------------------rrs----------------->\r\n %adDescription% <!-- added rrs -->\r\n %adPrice%\r\n %adCondition%\r\n %adCity%\r\n %adState%\r\n %adPostal%\r\n %adCountry%\r\n %adTypeOpt1%\r\n %adTypeOpt2%\r\n %adTypeOpt3%\r\n %adTypeOpt4%\r\n %adTypeOpt5%\r\n %adTypeOpt6%\r\n %adTypeOpt7%\r\n %adTypeOpt8%\r\n %adTypeOpt9%\r\n %adTypeOpt10%\r\n %adCatOpt1%\r\n %adCatOpt2%\r\n %adCatOpt3%\r\n %adCatOpt4%\r\n %adCatOpt5%\r\n </td>\r\n <td valign="top" width="50%">\r\n %adImages%\r\n </td>\r\n </tr>\r\n<!-- rrs\r\n <tr>\r\n <td colspan="2">\r\n %adDescription%\r\n </td>\r\n </tr>\r\n -->\r\n</table>','<table width="100%" border="0" cellspacing="0" cellpadding="3">\r\n <tr>\r\n <td class="headtd" width="50%">%adTitle%</td>\r\n <td class="headtd" width="50%" align="right">%adNumber%</td>\r\n </tr>\r\n <tr>\r\n <td valign="top" width="50%">\r\n\r\n <!--%adSeller%-------------------rrs----------------->\r\n %adDescription% <!-- added rrs -->\r\n %adPrice%\r\n %adCondition%\r\n %adCity%\r\n %adState%\r\n %adPostal%\r\n %adCountry%\r\n %adTypeOpt1%\r\n %adTypeOpt2%\r\n %adTypeOpt3%\r\n %adTypeOpt4%\r\n %adTypeOpt5%\r\n %adTypeOpt6%\r\n %adTypeOpt7%\r\n %adTypeOpt8%\r\n %adTypeOpt9%\r\n %adTypeOpt10%\r\n %adCatOpt1%\r\n %adCatOpt2%\r\n %adCatOpt3%\r\n %adCatOpt4%\r\n %adCatOpt5%\r\n </td>\r\n <td valign="top" width="50%">\r\n %adImages%\r\n </td>\r\n </tr>\r\n<!-- rrs\r\n <tr>\r\n <td colspan="2">\r\n %adDescription%\r\n </td>\r\n </tr>\r\n -->\r\n</table>') NOT NULL |