mysql.puroparty.com
puroparty
jos_banner
| Server: mysql.puroparty.com
|
Database: puroparty
|
Table: jos_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 | 8 | bid | |
| bid_2 | UNIQUE | 8 | bid | |
| name_2 | UNIQUE | 8 | name | |
| alias_2 | UNIQUE | 8 | alias | |
| alias_4 | UNIQUE | 8 | alias | |
| name_6 | UNIQUE | 8 | name | |
| 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 | |
| name_4 | INDEX | None | name | |
| clickurl_3 | INDEX | None | clickurl | |
| publish_down_2 | INDEX | None | publish_down | |
| checked_out_time_2 | INDEX | None | checked_out_time | |
| type_3 | INDEX | None | type | |
| bid_3 | INDEX | None | bid | |
| alias_5 | INDEX | None | alias | |
| impmade_2 | INDEX | None | impmade | |
| publish_up_2 | INDEX | None | publish_up | |
| ordering_2 | INDEX | None | ordering | |
| sticky_2 | INDEX | None | sticky | |
| checked_out_2 | INDEX | None | checked_out | |
| cid_2 | INDEX | None | cid | |
| catid_2 | INDEX | None | catid | |
| clicks_2 | INDEX | None | clicks | |
| date_2 | INDEX | None | date | |
| imageurl_4 | INDEX | None | imageurl | |
| imptotal_2 | INDEX | None | imptotal | |
| type_2 | INDEX | None | type | |
| name_3 | INDEX | None | name | |
| alias_3 | INDEX | None | alias | |
| imageurl_2 | INDEX | None | imageurl | |
| clickurl_2 | INDEX | None | clickurl | |
| editor_2 | INDEX | None | editor | |
| custombannercode | INDEX | None | custombannercode | |
| description | INDEX | None | description | |
| tags | INDEX | None | tags | |
| params | INDEX | None | params | |
| clickurl_4 | INDEX | None | clickurl | |
| name_5 | INDEX | None | name | |
| alias_6 | INDEX | None | alias | |
| imageurl_3 | INDEX | None | imageurl | |
| editor_3 | INDEX | None | editor | |
| tags_2 | INDEX | None | tags | |
| custombannercode_2 | INDEX | None | custombannercode | |
| description_2 | INDEX | None | description | |
Space usage :
|
Row Statistic :
|
|||||||||||||||||||||||||||||||