Difference between revisions of "Tables/bannertrack"
From Joomla! Documentation
< Tables
(New page: == Usage: == * Since: == Description: == The banner_tracks table contains tracking information for banner advertisements summarized by tracking types for any given date. Tracking types in...) |
m (categorisation) |
||
| (5 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | == Usage | + | == Usage == |
* Since: | * Since: | ||
| − | == Description | + | == Description == |
The banner_tracks table contains tracking information for banner | The banner_tracks table contains tracking information for banner | ||
advertisements summarized by tracking types for any given date. | advertisements summarized by tracking types for any given date. | ||
Tracking types include impressions and clicks. | Tracking types include impressions and clicks. | ||
| − | {| border="1" | + | {| class="wikitable" border="1" |
| − | | | + | |+ '''banner_tracks Table (#__banner_tracks)''' |
| − | |||
|- bgcolor="lightgrey" | |- bgcolor="lightgrey" | ||
| Field || Type || Nullable || Default || Key || Extra || Comments | | Field || Type || Nullable || Default || Key || Extra || Comments | ||
| Line 15: | Line 14: | ||
| track_date || DATE || NOT NULL || 0 || PK || || Tracking date. | | track_date || DATE || NOT NULL || 0 || PK || || Tracking date. | ||
|- | |- | ||
| − | | track_type || INTEGER UNSIGNED || NOT NULL || || PK || || Tracking type | + | | track_type || INTEGER UNSIGNED || NOT NULL || || PK || || Tracking type (impression or click). |
| − | (impression or click). | ||
|- | |- | ||
| banner_id || INTEGER UNSIGNED || NOT NULL || || PK || || Banner ID. | | banner_id || INTEGER UNSIGNED || NOT NULL || || PK || || Banner ID. | ||
|- | |- | ||
| − | | count || INTEGER UNSIGNED || NOT NULL || || || || Value for the | + | | count || INTEGER UNSIGNED || NOT NULL || || || || Value for the tracking type. |
| − | tracking type. | ||
|} | |} | ||
| − | == Notes | + | == Notes == |
| − | {| border="1" | + | {| class="wikitable" border="1" |
| − | | | + | |+ '''Indices''' |
| − | |||
|- bgcolor="lightgrey" | |- bgcolor="lightgrey" | ||
| Index Name || Column(s) ||Unique? | | Index Name || Column(s) ||Unique? | ||
| Line 40: | Line 36: | ||
* Default character set: '''utf8''' | * Default character set: '''utf8''' | ||
| + | |||
| + | <noinclude>[[Category:Database]]</noinclude> | ||
Latest revision as of 10:37, 16 March 2013
Usage[edit]
- Since:
Description[edit]
The banner_tracks table contains tracking information for banner advertisements summarized by tracking types for any given date. Tracking types include impressions and clicks.
| Field | Type | Nullable | Default | Key | Extra | Comments |
| track_date | DATE | NOT NULL | 0 | PK | Tracking date. | |
| track_type | INTEGER UNSIGNED | NOT NULL | PK | Tracking type (impression or click). | ||
| banner_id | INTEGER UNSIGNED | NOT NULL | PK | Banner ID. | ||
| count | INTEGER UNSIGNED | NOT NULL | Value for the tracking type. |
Notes[edit]
| Index Name | Column(s) | Unique? |
| idx_track_date | track_date | No |
| idx_track_type | track_type | No |
| idx_banner_id | banner_id | No |
- Default character set: utf8