Server: mysql.puroparty.com | Database: puroparty | Table: bak_banner |
Field | Type | Null | Default |
---|---|---|---|
bid | int(11) | No | |
cid | int(11) | No | 0 |
type | varchar(30) | No | banner |
name | varchar(255) | No | |
alias | varchar(255) | No | |
imptotal | int(11) | No | 0 |
impmade | int(11) | No | 0 |
clicks | int(11) | No | 0 |
imageurl | varchar(100) | No | |
clickurl | varchar(200) | No | |
date | datetime | Yes | NULL |
showBanner | tinyint(1) | No | 0 |
checked_out | tinyint(1) | No | 0 |
checked_out_time | datetime | No | 0000-00-00 00:00:00 |
editor | varchar(50) | Yes | NULL |
custombannercode | text | Yes | NULL |
catid | int(10) | No | 0 |
description | text | No | |
sticky | tinyint(1) | No | 0 |
ordering | int(11) | No | 0 |
publish_up | datetime | No | 0000-00-00 00:00:00 |
publish_down | datetime | No | 0000-00-00 00:00:00 |
tags | text | No | |
params | text | No |
Keyname | Type | Cardinality | Field | |
---|---|---|---|---|
PRIMARY | PRIMARY | 0 | bid | |
bid_2 | UNIQUE | 0 | bid | |
cid_2 | UNIQUE | 0 | cid | |
type_2 | UNIQUE | 0 | type | |
name_2 | UNIQUE | 0 | name | |
alias_2 | UNIQUE | 0 | alias | |
imptotal_2 | UNIQUE | 0 | imptotal | |
impmade_2 | UNIQUE | 0 | impmade | |
clicks_2 | UNIQUE | 0 | clicks | |
imageurl_2 | UNIQUE | 0 | imageurl | |
clickurl_2 | UNIQUE | 0 | clickurl | |
showBanner_2 | UNIQUE | 0 | showBanner | |
checked_out_2 | UNIQUE | 0 | checked_out | |
checked_out_time_2 | UNIQUE | 0 | checked_out_time | |
catid_2 | UNIQUE | 0 | catid | |
sticky_2 | UNIQUE | 0 | sticky | |
ordering_2 | UNIQUE | 0 | ordering | |
publish_up_2 | UNIQUE | 0 | publish_up | |
publish_down_2 | UNIQUE | 0 | publish_down | |
clicks_3 | UNIQUE | 0 | clicks | |
cid_3 | UNIQUE | 0 | cid | |
alias_4 | UNIQUE | 0 | alias | |
imptotal_3 | UNIQUE | 0 | imptotal | |
clickurl_5 | UNIQUE | 0 | clickurl | |
date_2 | UNIQUE | None | date | |
editor_2 | UNIQUE | None | editor | |
viewbanner | INDEX | None | showBanner | |
idx_banner_catid | INDEX | None | catid | |
bid | INDEX | None | bid | |
cid | INDEX | None | cid | |
type | INDEX | None | type | |
name | INDEX | None | name | |
alias | INDEX | None | alias | |
imptotal | INDEX | None | imptotal | |
impmade | INDEX | None | impmade | |
clicks | INDEX | None | clicks | |
imageurl | INDEX | None | imageurl | |
clickurl | INDEX | None | clickurl | |
date | INDEX | None | date | |
showBanner | INDEX | None | showBanner | |
checked_out | INDEX | None | checked_out | |
checked_out_time | INDEX | None | checked_out_time | |
editor | INDEX | None | editor | |
catid | INDEX | None | catid | |
sticky | INDEX | None | sticky | |
ordering | INDEX | None | ordering | |
publish_up | INDEX | None | publish_up | |
publish_down | INDEX | None | publish_down | |
checked_out_time_3 | INDEX | None | checked_out_time | |
catid_3 | INDEX | None | catid | |
cid_4 | INDEX | None | cid | |
type_3 | INDEX | None | type | |
name_3 | INDEX | None | name | |
alias_3 | INDEX | None | alias | |
imageurl_3 | INDEX | None | imageurl | |
clickurl_3 | INDEX | None | clickurl | |
editor_3 | INDEX | None | editor | |
custombannercode | INDEX | None | custombannercode | |
description | INDEX | None | description | |
tags | INDEX | None | tags | |
params | INDEX | None | params | |
clickurl_4 | INDEX | None | clickurl | |
params_2 | INDEX | None | params | |
name_4 | INDEX | None | name |
Space usage :
|
Row Statistic :
|