|
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... |
mysql.puroparty.com
puroparty
bos_ad_types
Print view
Export
Structure
Browse
SQL
Search
Insert
Operations
Empty
Drop