Tables/bannertrack: Difference between revisions
From Joomla! Documentation
< Tables
< Tables
class="wikitable" |
m categorisation |
||
| 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. | ||
| Line 21: | Line 21: | ||
|} | |} | ||
== Notes | == Notes == | ||
{| class="wikitable" border="1" | {| class="wikitable" border="1" | ||
| Line 36: | Line 36: | ||
* Default character set: '''utf8''' | * Default character set: '''utf8''' | ||
<noinclude>[[Category:Database]]</noinclude> | |||
Latest revision as of 15:37, 16 March 2013
Usage
- Since:
Description
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
| 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