Server: mysql.puroparty.com | Database: puroparty | Table: bak_categories |
Field | Type | Null | Default |
---|---|---|---|
id | int(11) | No | |
parent_id | int(11) | No | 0 |
title | varchar(255) | No | |
name | varchar(255) | No | |
alias | varchar(255) | No | |
image | varchar(255) | No | |
section | varchar(50) | No | |
image_position | varchar(30) | No | |
description | text | No | |
published | tinyint(1) | No | 0 |
checked_out | int(11) | No | 0 |
checked_out_time | datetime | No | 0000-00-00 00:00:00 |
editor | varchar(50) | Yes | NULL |
ordering | int(11) | No | 0 |
access | tinyint(3) | No | 0 |
count | int(11) | No | 0 |
params | text | No |
Keyname | Type | Cardinality | Field | |
---|---|---|---|---|
PRIMARY | PRIMARY | 0 | id | |
id_2 | UNIQUE | 0 | id | |
parent_id_2 | UNIQUE | 0 | parent_id | |
title_2 | UNIQUE | 0 | title | |
name_2 | UNIQUE | 0 | name | |
alias_2 | UNIQUE | 0 | alias | |
image_2 | UNIQUE | 0 | image | |
section_2 | UNIQUE | 0 | section | |
image_position_2 | UNIQUE | 0 | image_position | |
published_2 | UNIQUE | 0 | published | |
checked_out_2 | UNIQUE | 0 | checked_out | |
checked_out_time_2 | UNIQUE | 0 | checked_out_time | |
ordering_2 | UNIQUE | 0 | ordering | |
access_2 | UNIQUE | 0 | access | |
count_2 | UNIQUE | 0 | count | |
checked_out_3 | UNIQUE | 0 | checked_out | |
image_5 | UNIQUE | 0 | image | |
section_5 | UNIQUE | 0 | section | |
parent_id_4 | UNIQUE | 0 | parent_id | |
access_3 | UNIQUE | 0 | access | |
title_6 | UNIQUE | 0 | title | |
published_3 | UNIQUE | 0 | published | |
count_3 | UNIQUE | 0 | count | |
alias_5 | UNIQUE | 0 | alias | |
ordering_4 | UNIQUE | 0 | ordering | |
editor_2 | UNIQUE | None | editor | |
cat_idx | INDEX | None | section | |
published | ||||
access | ||||
idx_access | INDEX | None | access | |
idx_checkout | INDEX | None | checked_out | |
id | INDEX | None | id | |
parent_id | INDEX | None | parent_id | |
title | INDEX | None | title | |
name | INDEX | None | name | |
alias | INDEX | None | alias | |
image | INDEX | None | image | |
section | INDEX | None | section | |
image_position | INDEX | None | image_position | |
published | INDEX | None | published | |
checked_out | INDEX | None | checked_out | |
checked_out_time | INDEX | None | checked_out_time | |
editor | INDEX | None | editor | |
ordering | INDEX | None | ordering | |
access | INDEX | None | access | |
count | INDEX | None | count | |
checked_out_time_3 | INDEX | None | checked_out_time | |
section_4 | INDEX | None | section | |
parent_id_3 | INDEX | None | parent_id | |
ordering_3 | INDEX | None | ordering | |
title_5 | INDEX | None | title | |
title_3 | INDEX | None | title | |
name_3 | INDEX | None | name | |
alias_3 | INDEX | None | alias | |
image_3 | INDEX | None | image | |
section_3 | INDEX | None | section | |
image_position_3 | INDEX | None | image_position | |
description | INDEX | None | description | |
editor_3 | INDEX | None | editor | |
params | INDEX | None | params | |
params_2 | INDEX | None | params | |
image_4 | INDEX | None | image | |
name_4 | INDEX | None | name | |
title_4 | INDEX | None | title | |
section_6 | INDEX | None | section | |
alias_4 | INDEX | None | alias |
Space usage :
|
Row Statistic :
|