Server: mysql.puroparty.com | Database: puroparty | Table: jos_weblinks |
Field | Type | Null | Default |
---|---|---|---|
id | int(11) | No | |
catid | int(11) | No | 0 |
sid | int(11) | No | 0 |
title | varchar(250) | No | |
alias | varchar(255) | No | |
url | varchar(250) | No | |
description | text | No | |
date | datetime | No | 0000-00-00 00:00:00 |
hits | int(11) | 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 |
archived | tinyint(1) | No | 0 |
approved | tinyint(1) | No | 1 |
params | text | No |
Keyname | Type | Cardinality | Field | |
---|---|---|---|---|
PRIMARY | PRIMARY | 6 | id | |
id_2 | UNIQUE | 6 | id | |
title_2 | UNIQUE | 6 | title | |
alias_2 | UNIQUE | 6 | alias | |
url_2 | UNIQUE | 6 | url | |
ordering_2 | UNIQUE | 6 | ordering | |
id_3 | UNIQUE | 6 | id | |
url_5 | UNIQUE | 6 | url | |
ordering_4 | UNIQUE | 6 | ordering | |
title_6 | UNIQUE | 6 | title | |
alias_4 | UNIQUE | 6 | alias | |
id_5 | UNIQUE | 6 | id | |
url_7 | UNIQUE | 6 | url | |
ordering_6 | UNIQUE | 6 | ordering | |
alias_8 | UNIQUE | 6 | alias | |
title_8 | UNIQUE | 6 | title | |
catid | INDEX | None | catid | |
published | ||||
archived | ||||
id | INDEX | None | id | |
catid_2 | INDEX | None | catid | |
sid | INDEX | None | sid | |
title | INDEX | None | title | |
alias | INDEX | None | alias | |
url | INDEX | None | url | |
date | INDEX | None | date | |
hits | INDEX | None | hits | |
published | INDEX | None | published | |
checked_out | INDEX | None | checked_out | |
checked_out_time | INDEX | None | checked_out_time | |
ordering | INDEX | None | ordering | |
archived | INDEX | None | archived | |
approved | INDEX | None | approved | |
ordering_3 | INDEX | None | ordering | |
checked_out_2 | INDEX | None | checked_out | |
catid_3 | INDEX | None | catid | |
url_4 | INDEX | None | url | |
published_2 | INDEX | None | published | |
title_4 | INDEX | None | title | |
checked_out_time_2 | INDEX | None | checked_out_time | |
alias_5 | INDEX | None | alias | |
id_4 | INDEX | None | id | |
approved_2 | INDEX | None | approved | |
date_2 | INDEX | None | date | |
hits_2 | INDEX | None | hits | |
archived_2 | INDEX | None | archived | |
sid_2 | INDEX | None | sid | |
ordering_5 | INDEX | None | ordering | |
catid_4 | INDEX | None | catid | |
alias_9 | INDEX | None | alias | |
id_6 | INDEX | None | id | |
approved_3 | INDEX | None | approved | |
title_3 | INDEX | None | title | |
alias_3 | INDEX | None | alias | |
url_3 | INDEX | None | url | |
description | INDEX | None | description | |
params | INDEX | None | params | |
title_5 | INDEX | None | title | |
params_2 | INDEX | None | params | |
url_6 | INDEX | None | url | |
description_2 | INDEX | None | description | |
alias_6 | INDEX | None | alias | |
alias_7 | INDEX | None | alias | |
title_7 | INDEX | None | title | |
description_3 | INDEX | None | description | |
url_8 | INDEX | None | url |
Space usage :
|
Row Statistic :
|