Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 26, 2024 at 12:42 PM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `jos_categories` PROCEDURE ANALYSE();
Rows: 17
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 |