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

SQL-query
SQL-query: 
SELECT *
FROM `jos_contact_details`
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_contact_details.id 1 1 1 1 0 0 1.0000 0.0000 ENUM('1') NOT NULL
puroparty.jos_contact_details.name Name Name 4 4 0 0 4.0000 NULL ENUM('Name') NOT NULL
puroparty.jos_contact_details.alias name name 4 4 0 0 4.0000 NULL ENUM('name') NOT NULL
puroparty.jos_contact_details.con_position Position Position 8 8 0 0 8.0000 NULL ENUM('Position') NOT NULL
puroparty.jos_contact_details.address Street Street 6 6 0 0 6.0000 NULL ENUM('Street') NOT NULL
puroparty.jos_contact_details.suburb Suburb Suburb 6 6 0 0 6.0000 NULL ENUM('Suburb') NOT NULL
puroparty.jos_contact_details.state State State 5 5 0 0 5.0000 NULL ENUM('State') NOT NULL
puroparty.jos_contact_details.country Country Country 7 7 0 0 7.0000 NULL ENUM('Country') NOT NULL
puroparty.jos_contact_details.postcode Zip Code Zip Code 8 8 0 0 8.0000 NULL ENUM('Zip Code') NOT NULL
puroparty.jos_contact_details.telephone Telephone Telephone 9 9 0 0 9.0000 NULL ENUM('Telephone') NOT NULL
puroparty.jos_contact_details.fax Fax Fax 3 3 0 0 3.0000 NULL ENUM('Fax') NOT NULL
puroparty.jos_contact_details.misc Miscellanous info Miscellanous info 17 17 0 0 17.0000 NULL ENUM('Miscellanous info') NOT NULL
puroparty.jos_contact_details.image powered_by.png powered_by.png 14 14 0 0 14.0000 NULL ENUM('powered_by.png') NOT NULL
puroparty.jos_contact_details.imagepos top top 3 3 0 0 3.0000 NULL ENUM('top') NOT NULL
puroparty.jos_contact_details.email_to email@email.com email@email.com 15 15 0 0 15.0000 NULL ENUM('email@email.com') NOT NULL
puroparty.jos_contact_details.default_con 1 1 1 1 0 0 1.0000 0.0000 ENUM('1') NOT NULL
puroparty.jos_contact_details.published 1 1 1 1 0 0 1.0000 0.0000 ENUM('1') NOT NULL
puroparty.jos_contact_details.checked_out 0 0 1 1 1 0 0.0000 0.0000 ENUM('0') NOT NULL
puroparty.jos_contact_details.checked_out_time 0000-00-00 00:00:00 0000-00-00 00:00:00 19 19 0 0 19.0000 NULL ENUM('0000-00-00 00:00:00') NOT NULL
puroparty.jos_contact_details.ordering 1 1 1 1 0 0 1.0000 0.0000 ENUM('1') NOT NULL
puroparty.jos_contact_details.params show_name=1\r\nshow_position=1\r\nshow_email=0\r\nshow_s... show_name=1\r\nshow_position=1\r\nshow_email=0\r\nshow_s... 420 420 0 0 420.0000 NULL ENUM('show_name=1\r\nshow_position=1\r\nshow_email=0\r\n...
puroparty.jos_contact_details.user_id 0 0 1 1 1 0 0.0000 0.0000 ENUM('0') NOT NULL
puroparty.jos_contact_details.catid 12 12 2 2 0 0 12.0000 0.0000 ENUM('12') NOT NULL
puroparty.jos_contact_details.access 0 0 1 1 1 0 0.0000 0.0000 ENUM('0') NOT NULL
puroparty.jos_contact_details.mobile     0 0 1 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.jos_contact_details.webpage     0 0 1 0 0.0000 NULL CHAR(0) NOT NULL


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