Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 23, 2024 at 11:05 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_street_address=1\r\nshow_suburb=1\r\nshow_state=1\r\nshow_postcode=1\r\nshow_country=1\r\nshow_telephone=1\r\nshow_mobile=1\r\nshow_fax=1\r\nshow_webpage=1\r\nshow_misc=1\r\nshow_image=1\r\nallow_vcard=0\r\ncontact_icons=0\r\nicon_address=\r\nicon_email=\r\nicon_telephone=\r\nicon_fax=\r\nicon_misc=\r\nshow_email_form=1\r\nemail_description=1\r\nshow_email_copy=1\r\nbanned_email=\r\nbanned_subject=\r\nbanned_text= | show_name=1\r\nshow_position=1\r\nshow_email=0\r\nshow_street_address=1\r\nshow_suburb=1\r\nshow_state=1\r\nshow_postcode=1\r\nshow_country=1\r\nshow_telephone=1\r\nshow_mobile=1\r\nshow_fax=1\r\nshow_webpage=1\r\nshow_misc=1\r\nshow_image=1\r\nallow_vcard=0\r\ncontact_icons=0\r\nicon_address=\r\nicon_email=\r\nicon_telephone=\r\nicon_fax=\r\nicon_misc=\r\nshow_email_form=1\r\nemail_description=1\r\nshow_email_copy=1\r\nbanned_email=\r\nbanned_subject=\r\nbanned_text= | 420 | 420 | 0 | 0 | 420.0000 | NULL | ENUM('show_name=1\r\nshow_position=1\r\nshow_email=0\r\nshow_street_address=1\r\nshow_suburb=1\r\nshow_state=1\r\nshow_postcode=1\r\nshow_country=1\r\nshow_telephone=1\r\nshow_mobile=1\r\nshow_fax=1\r\nshow_webpage=1\r\nshow_misc=1\r\nshow_image=1\r\nallow_vcard=0\r\ncontact_icons=0\r\nicon_address=\r\nicon_email=\r\nicon_telephone=\r\nicon_fax=\r\nicon_misc=\r\nshow_email_form=1\r\nemail_description=1\r\nshow_email_copy=1\r\nbanned_email=\r\nbanned_subject=\r\nbanned_text=') NOT NULL |
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 |