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

SQL-query
SQL-query: 
SELECT *
FROM `jos_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.jos_categories.id 1 33 1 2 0 0 16.8636 10.7547 ENUM('1','2','3','4','5','6','7','12','13','14','1...
puroparty.jos_categories.parent_id 0 0 1 1 22 0 0.0000 0.0000 ENUM('0') NOT NULL
puroparty.jos_categories.title Benefits The Project 5 22 0 0 10.1364 NULL ENUM('Benefits','Business: General','Contacts','Cu...
puroparty.jos_categories.name     0 0 22 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.jos_categories.alias benefits the-project 5 21 0 0 10.1364 NULL ENUM('benefits','business-general','contacts','cur...
puroparty.jos_categories.image clock.jpg taking_notes.jpg 9 16 20 0 1.1364 NULL ENUM('','clock.jpg','taking_notes.jpg') NOT NULL
puroparty.jos_categories.section 1 com_weblinks 1 19 0 0 7.5909 NULL ENUM('1','3','4','com_banner','com_contact_details...
puroparty.jos_categories.image_position left left 4 4 0 0 4.0000 NULL ENUM('left') NOT NULL
puroparty.jos_categories.description A selection of links that are all related to the J... The latest news from the Joomla! Team 33 71 12 0 21.1364 NULL ENUM('','A selection of links that are all related...
puroparty.jos_categories.published 1 1 1 1 3 0 0.8636 0.3432 ENUM('0','1') NOT NULL
puroparty.jos_categories.checked_out 0 65 1 2 21 0 2.9545 13.5394 ENUM('0','65') NOT NULL
puroparty.jos_categories.checked_out_time 0000-00-00 00:00:00 2007-06-28 14:50:15 19 19 0 0 19.0000 NULL ENUM('0000-00-00 00:00:00','2007-06-28 14:50:15') ...
puroparty.jos_categories.editor     0 0 2 20 0.0000 NULL CHAR(0)
puroparty.jos_categories.ordering 1 7 1 1 3 0 2.3636 1.9434 ENUM('0','1','2','3','4','6','7') NOT NULL
puroparty.jos_categories.access 0 0 1 1 22 0 0.0000 0.0000 ENUM('0') NOT NULL
puroparty.jos_categories.count 1 1 1 1 21 0 0.0455 0.2083 ENUM('0','1') NOT NULL
puroparty.jos_categories.params     0 0 22 0 0.0000 NULL CHAR(0) NOT NULL


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