Actions

Difference between revisions of "Tables/bannertrack"

From Joomla! Documentation

< Tables
m (categorisation)
 
(3 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)'''
|'''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.
Line 23: Line 21:
 
|}
 
|}
  
== Notes: ==
+
== Notes ==
  
{| border="1"
+
{| class="wikitable" border="1"
|+
+
|+ '''Indices'''
|'''Indices'''
+
 
|- bgcolor="lightgrey"
 
|- bgcolor="lightgrey"
 
| Index Name || Column(s) ||Unique?
 
| Index Name || Column(s) ||Unique?
Line 39: Line 36:
  
 
* Default character set: '''utf8'''
 
* Default character set: '''utf8'''
 +
 +
<noinclude>[[Category:Database]]</noinclude>

Latest revision as of 10: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.

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

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