Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 17, 2024 at 04:33 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 ... |
puroparty.bos_ad_types.type_title | Artist Ad | Mariachis | 5 | 19 | 0 | 0 | 10.5000 | NULL | ENUM('Artist Ad','Clubs/Bars','Concert/Festival Ad... |
puroparty.bos_ad_types.type_required | 3609 | 423449 | 4 | 6 | 0 | 0 | 120921.0000 | 139567.5369 | ENUM('3609','5657','7705','32281','116249','129049... |
puroparty.bos_ad_types.type_use | 7961 | 524057 | 4 | 6 | 0 | 0 | 185817.0000 | 210884.7975 | ENUM('7961','32537','124697','257817','523545','52... |
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','co... |
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','cont... |
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 type... |
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|m... |
puroparty.bos_ad_types.option5 | seating | 0 | 17 | 3 | 0 | 6.5000 | NULL | ENUM('','Drinks Avail','food avail?','genre','genr... | |
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|outdoo... | |
puroparty.bos_ad_types.option6 | patio seating? | 0 | 14 | 3 | 0 | 6.2500 | NULL | ENUM('','# members','equip','event month','Food Av... | |
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|... | |
puroparty.bos_ad_types.option7 | Patio Seating? | 0 | 15 | 4 | 0 | 6.0000 | NULL | ENUM('','available area','booking contact','music'... | |
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|... | |
puroparty.bos_ad_types.option8 | other stuff | 0 | 11 | 4 | 0 | 4.3750 | NULL | ENUM('','booking #','contact #1','music','other st... | |
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|... | |
puroparty.bos_ad_types.option9 | other stuff | 0 | 11 | 5 | 0 | 3.6250 | NULL | ENUM('','contact #2','event mo','other stuff') NOT... | |
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|... | |
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"... | <table width="100%" border="0" cellspacing="0" cel... | 846 | 850 | 0 | 0 | 847.0000 | NULL | ENUM('\r\n\r\n<table width="100%" border="0" cellspaci... |