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...) |
|||
Line 8: | Line 8: | ||
{| border="1" | {| 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 27: | Line 27: | ||
{| border="1" | {| border="1" | ||
− | | | + | |+ |
− | |''' | + | |'''Indices''' |
|- bgcolor="lightgrey" | |- bgcolor="lightgrey" | ||
| Index Name || Column(s) ||Unique? | | Index Name || Column(s) ||Unique? |
Revision as of 14:26, 30 August 2010
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.
banner_tracks Table (#__banner_tracks) | ||||||
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]
Indices | ||
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