Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: ads_ad_typesads_ad_types
StructureStructure BrowseBrowse SQLSQL SearchSearch InsertInsert ExportExport OperationsOperations EmptyEmpty DropDrop

SQL-query
SQL-query: 
SELECT *
FROM `ads_ad_types`
PROCEDURE ANALYSE ( )
 [Edit] [Explain SQL] [Create PHP Code] [Refresh]



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="...


Print viewPrint view    Print view (with full texts)Print view (with full texts)     ExportExport