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