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

Table for event categories

SQL-query
SQL-query: 
SELECT *
FROM `extcal2_categories`
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.extcal2_categories.cat_id 1 10 1 2 0 0 5.5000 2.8723 ENUM('1','2','3','4','5','6','7','8','9','10') NOT...
puroparty.extcal2_categories.cat_parent 0 0 1 1 10 0 0.0000 0.0000 ENUM('0') NOT NULL
puroparty.extcal2_categories.cat_name Austin West Texas 5 17 0 0 9.8000 NULL ENUM('Austin','Corpus Christi','Dallas/Fort Worth'...
puroparty.extcal2_categories.description Events located in a state other than Texas. Events located in West Texas. 25 45 0 0 36.3000 NULL ENUM('Events located in a state other than Texas.'...
puroparty.extcal2_categories.color #000000 #FFCC33 7 7 0 0 7.0000 NULL ENUM('#000000','#000099','#33CC00','#555555','#660...
puroparty.extcal2_categories.bgcolor #EEF0F0 #EEF0F0 7 7 0 0 7.0000 NULL ENUM('#EEF0F0') NOT NULL
puroparty.extcal2_categories.options 2 3 1 1 0 0 2.1000 0.3000 ENUM('2','3') NOT NULL
puroparty.extcal2_categories.enabled 1 1 1 1 0 0 1.0000 0.0000 ENUM('1') NOT NULL


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