Actions

Difference between revisions of "Tables/bannertrack"

From Joomla! Documentation

< 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 09: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