Host: mysql.puroparty.com
Database: puroparty
Generation Time: May 17, 2024 at 03:22 AM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `ads_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.ads_ad_types.type_id | 9 | 9 | 1 | 1 | 0 | 0 | 9.0000 | 0.0000 | ENUM('9') NOT NULL |
puroparty.ads_ad_types.type_title | Club Ad | Club Ad | 7 | 7 | 0 | 0 | 7.0000 | NULL | ENUM('Club Ad') NOT NULL |
puroparty.ads_ad_types.type_required | 537 | 537 | 3 | 3 | 0 | 0 | 537.0000 | 0.0000 | ENUM('537') NOT NULL |
puroparty.ads_ad_types.type_use | 793 | 793 | 3 | 3 | 0 | 0 | 793.0000 | 0.0000 | ENUM('793') NOT NULL |
puroparty.ads_ad_types.option1 | cover | cover | 5 | 5 | 0 | 0 | 5.0000 | NULL | ENUM('cover') NOT NULL |
puroparty.ads_ad_types.def_option1 | door admission | door admission | 14 | 14 | 0 | 0 | 14.0000 | NULL | ENUM('door admission') NOT NULL |
puroparty.ads_ad_types.option2 | 0 | 0 | 1 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.ads_ad_types.def_option2 | 0 | 0 | 1 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.ads_ad_types.option3 | 0 | 0 | 1 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.ads_ad_types.def_option3 | 0 | 0 | 1 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.ads_ad_types.option4 | 0 | 0 | 1 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.ads_ad_types.def_option4 | 0 | 0 | 1 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.ads_ad_types.option5 | 0 | 0 | 1 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.ads_ad_types.def_option5 | 0 | 0 | 1 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.ads_ad_types.option6 | 0 | 0 | 1 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.ads_ad_types.def_option6 | 0 | 0 | 1 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.ads_ad_types.option7 | 0 | 0 | 1 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.ads_ad_types.def_option7 | 0 | 0 | 1 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.ads_ad_types.option8 | 0 | 0 | 1 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.ads_ad_types.def_option8 | 0 | 0 | 1 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.ads_ad_types.option9 | 0 | 0 | 1 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.ads_ad_types.def_option9 | 0 | 0 | 1 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.ads_ad_types.option10 | 0 | 0 | 1 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.ads_ad_types.def_option10 | 0 | 0 | 1 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.ads_ad_types.template | <table width="100%" border="0" cellspacing="0" cel... | <table width="100%" border="0" cellspacing="0" cel... | 735 | 735 | 0 | 0 | 735.0000 | NULL | ENUM('<table width="100%" border="0" cellspacing="... |