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 :
|