Table banners history

From Zen Cart(tm) Wiki
Jump to: navigation, search

Database Version

1.3.5


Description

Contains tracking data about each banner. Banners are defined in the banners table.


Table Details

Primary Key

banners_history_id

Indexed Fields

banners_id


Columns

banners_history_id Primary Key

A unique, auto incremented value, to identify each banner history record.
Type: int(11)
Null: No
Default:
Extra: auto_increment


banners_id Foreign Key Index

Links the record to a specific banner. Foreign key to banners.banners_id.
Type: int(11)
Null: No
Default: 0


banners_shown

Number of banner impressions shown.
Type: int(5)
Null: No
Default: 0


banners_clicked

Number of click thrus on the specific banner.
Type: int(5)
Null: No
Default: 0
Info.png Limitation!
Banners written in the HTML box do not record click thrus.


banners_history_date

The date and time the entry was first recorded in the database.
Type: datetime
Null: No
Default: 0001-01-01 00:00:00


Default Entries

None.