mysql.puroparty.com
puroparty
jos_contact_details
| Server: mysql.puroparty.com
|
Database: puroparty
|
Table: jos_contact_details
|
| Field | Type | Null | Default |
|---|---|---|---|
| id | int(11) | No | |
| name | varchar(255) | No | |
| alias | varchar(255) | No | |
| con_position | varchar(255) | Yes | NULL |
| address | text | Yes | NULL |
| suburb | varchar(100) | Yes | NULL |
| state | varchar(100) | Yes | NULL |
| country | varchar(100) | Yes | NULL |
| postcode | varchar(100) | Yes | NULL |
| telephone | varchar(255) | Yes | NULL |
| fax | varchar(255) | Yes | NULL |
| misc | mediumtext | Yes | NULL |
| image | varchar(255) | Yes | NULL |
| imagepos | varchar(20) | Yes | NULL |
| email_to | varchar(255) | Yes | NULL |
| default_con | tinyint(1) | No | 0 |
| published | tinyint(1) | No | 0 |
| checked_out | int(11) | No | 0 |
| checked_out_time | datetime | No | 0000-00-00 00:00:00 |
| ordering | int(11) | No | 0 |
| params | text | No | |
| user_id | int(11) | No | 0 |
| catid | int(11) | No | 0 |
| access | tinyint(3) | No | 0 |
| mobile | varchar(255) | No | |
| webpage | varchar(255) | No |
| Keyname | Type | Cardinality | Field | |
|---|---|---|---|---|
| PRIMARY | PRIMARY | 1 | id | |
| id_2 | UNIQUE | 1 | id | |
| name_2 | UNIQUE | 1 | name | |
| alias_2 | UNIQUE | 1 | alias | |
| default_con_2 | UNIQUE | 1 | default_con | |
| published_2 | UNIQUE | 1 | published | |
| checked_out_2 | UNIQUE | 1 | checked_out | |
| checked_out_time_2 | UNIQUE | 1 | checked_out_time | |
| ordering_2 | UNIQUE | 1 | ordering | |
| user_id_2 | UNIQUE | 1 | user_id | |
| catid_3 | UNIQUE | 1 | catid | |
| access_2 | UNIQUE | 1 | access | |
| mobile_2 | UNIQUE | 1 | mobile | |
| webpage_2 | UNIQUE | 1 | webpage | |
| con_position_2 | UNIQUE | None | con_position | |
| suburb_2 | UNIQUE | None | suburb | |
| state_2 | UNIQUE | None | state | |
| country_2 | UNIQUE | None | country | |
| postcode_2 | UNIQUE | None | postcode | |
| telephone_2 | UNIQUE | None | telephone | |
| fax_2 | UNIQUE | None | fax | |
| image_2 | UNIQUE | None | image | |
| imagepos_2 | UNIQUE | None | imagepos | |
| email_to_2 | UNIQUE | None | email_to | |
| catid | INDEX | None | catid | |
| id | INDEX | None | id | |
| name | INDEX | None | name | |
| alias | INDEX | None | alias | |
| con_position | INDEX | None | con_position | |
| suburb | INDEX | None | suburb | |
| state | INDEX | None | state | |
| country | INDEX | None | country | |
| postcode | INDEX | None | postcode | |
| telephone | INDEX | None | telephone | |
| fax | INDEX | None | fax | |
| image | INDEX | None | image | |
| imagepos | INDEX | None | imagepos | |
| email_to | INDEX | None | email_to | |
| default_con | INDEX | None | default_con | |
| published | INDEX | None | published | |
| checked_out | INDEX | None | checked_out | |
| checked_out_time | INDEX | None | checked_out_time | |
| ordering | INDEX | None | ordering | |
| user_id | INDEX | None | user_id | |
| catid_2 | INDEX | None | catid | |
| access | INDEX | None | access | |
| mobile | INDEX | None | mobile | |
| webpage | INDEX | None | webpage | |
| name_3 | INDEX | None | name | |
| alias_3 | INDEX | None | alias | |
| con_position_3 | INDEX | None | con_position | |
| address | INDEX | None | address | |
| suburb_3 | INDEX | None | suburb | |
| state_3 | INDEX | None | state | |
| country_3 | INDEX | None | country | |
| postcode_3 | INDEX | None | postcode | |
| telephone_3 | INDEX | None | telephone | |
| fax_3 | INDEX | None | fax | |
| misc | INDEX | None | misc | |
| image_3 | INDEX | None | image | |
| imagepos_3 | INDEX | None | imagepos | |
| email_to_3 | INDEX | None | email_to | |
| params | INDEX | None | params | |
| mobile_3 | INDEX | None | mobile | |
Space usage :
|
Row Statistic :
|
|||||||||||||||||||||||||||||||