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

Table for event categories

SQL-query
SQL-query: 
SELECT *
FROM `extcal_1categories`
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.extcal_1categories.cat_id 1 53944 1 5 0 0 2848.1579 12043.4065 ENUM('1','2','3','4','5','6','7','8','9','10','11'...
puroparty.extcal_1categories.cat_parent 0 9 1 1 18 0 0.4737 2.0097 ENUM('0','9') NOT NULL
puroparty.extcal_1categories.cat_name 1511878819 wharton and more 3 16 0 0 8.0000 NULL ENUM('1511878819','arizona','austin','beaumont','c...
puroparty.extcal_1categories.description \0 wharton, el campo, bay city 1 28 0 0 15.6316 NULL ENUM('\0','austin msa','beaumont/port arthur area'...
puroparty.extcal_1categories.color #000000 3872 4 7 0 0 6.8421 NULL ENUM('#000000','#0066CC','#00FF00','#33FFCC','#505...
puroparty.extcal_1categories.bgcolor #EEF0F0 2070-08-29 7 10 0 0 7.1579 NULL ENUM('#EEF0F0','2070-08-29') NOT NULL
puroparty.extcal_1categories.options 0 53 1 2 1 0 4.5789 11.4217 ENUM('0','2','53') NOT NULL
puroparty.extcal_1categories.enabled 1 1 1 1 1 0 0.9474 0.2233 ENUM('0','1') NOT NULL


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