Tables/banner: Difference between revisions

From Joomla! Documentation

< Tables
← Older edit
Dsiders (talk | contribs)
87 edits
m categorisation
 
(16 intermediate revisions by 2 users not shown)
Line 1: Line 1:
== Usage ==
* Since:


== Usage: ==
== Description ==


== Description: ==
The Banners table contains banner advertisement content for the mod_banners module.


The Banners table
{| class="wikitable" border=1
|+ '''Banners Table (#__banners)'''
|- bgcolor=grey
! Field !! Type !! Nullable !! Key !! Default !! Extra !! Comments
|-
| id                || INTEGER || Not Null || PK || || auto_increment || Identifier for the Banner entry
|-
| cid              || INTEGER || Not Null || || 0 || || Banner Client ID (FK) references __banner_clients
|-
| type              || INTEGER      || Not Null  ||          || 0        ||          || Banner type identifier (FK)
|-
| name              || VARCHAR(255)  || Not Null  ||          || ''        ||          || Name for the banner advertisement
|-
| alias            || VARCHAR(255)  || Not Null  ||          || ''        ||          || Alias for the banner advertisement
|-
| imptotal          || INTEGER      || Not Null  ||          || 0      ||          || Total impressions for the banner advertisement
|-
| impmade          || INTEGER      || Not Null  ||          || 0      ||          || Impression made for the banner advertisement
|-
| clicks            || INTEGER              || Not Null || || 0  || || Number of clicks recorded for the banner advertisement
|-
| clickurl          || VARCHAR(200)        || Not Null || || ''  || || URL to visit when the banner advertisement is clicked
|-
| state            || TINYINT(3)          || Not Null || || 0  || || State
|-
| catid            || UNSIGNED INTEGER    || Not Null || || 0    || || Category ID (FK) references #__categories.id
|-
| description      || TEXT                || Not Null || ||      || || Brief description of the banner advertisement
|-
| custombannercode  || VARCHAR(2048)        || Not Null || ||      || || Code that represents the content for the banner advertisement
|-
| sticky            || TINYINT(1) UNSIGNED  || Not Null || || 0    || || Flag indicating the banner ad is ???
|-
| ordering          || INTEGER              || Not Null || || 0    || || The relative ordering of the banner ad
|-
| metakey          || TEXT                || Not Null || ||      || || The meta keywords for the item
|-
| params            || TEXT                || Not Null || ||      || || Parameters
|-
| own_prefix        || TINYINT(1)          || Not Null || || 0  || || Flag indicating ???
|-
| metakey_prefix    || VARCHAR(255)        || Not Null || || ''  || || When matching metakey keywords, search only for this prefix
|-
| purchase_type    || TINYINT              || Not Null || || -1 || || Flag indicating if the target URL is a purchase
|-
| track_clicks      || TINYINT              || Not Null || || -1 || || Flag indicating if clicks are tracked for the banner ad
|-
| track_impressions || TINYINT              || Not Null || || -1 || || Flag indicating if impressions are track for the banner ad
|-
| checked_out      || INTEGER UNSIGNED    || Not Null || || 0  || || (FK) references #__users.id
|-
| checked_out_time  || DATETIME            || Not Null || || '0000-00-00 00:00:00' || || The time the item was checked out
|-
| publish_up        || DATETIME            || Not Null || || '0000-00-00 00:00:00' || || Date/time the banner ad is published
|-
| publish_down      || DATETIME            || Not Null || || '0000-00-00 00:00:00' || || Date/time the banner ad is unpublished
|-
| reset            || DATETIME            || Not Null || || '0000-00-00 00:00:00' || || Date/time the impressions and clicks were reset
|-
| created          || DATETIME            || Not Null || || '0000-00-00 00:00:00' || || Date/time the banner ad was created
|-
| language          || char(7)              || Not Null || || ''  || || Language identifier (like 'en-GB')
|}


{| border=1
== Notes ==
|+ '''Bannes Table (#__banners)'''
The following indexes are defined for use as alternate keys:
 
{| class="wikitable" border=1
|+ '''Indexes (#__banners)'''
|- bgcolor=grey
|- bgcolor=grey
! Field !! Type !! Null !! Key !! Default !! Extra !! Comments
! Index Name !! Column(s)
|-
|-
| id || INTEGER || Not Null || PK || auto_increment || Identifier for the Banner entry
| idx_state || state
|-
|-
| cid || INTEGER || Not Null || 0 || || Banner Client ID (FK) references __banner_clients
| idx_own_prefix || own_prefix
|-
| idx_metakey_prefix || metakey_prefix
|-
| idx_banner_catid || catid
|-
| idx_language || language
|}
|}


== Notes: ==
Default character set: '''utf8'''.
 
<noinclude>[[Category:Database]]</noinclude>

Latest revision as of 15:36, 16 March 2013

Usage

  • Since:

Description

The Banners table contains banner advertisement content for the mod_banners module.

Banners Table (#__banners)
Field Type Nullable Key Default Extra Comments
id INTEGER Not Null PK auto_increment Identifier for the Banner entry
cid INTEGER Not Null 0 Banner Client ID (FK) references __banner_clients
type INTEGER Not Null 0 Banner type identifier (FK)
name VARCHAR(255) Not Null Name for the banner advertisement
alias VARCHAR(255) Not Null Alias for the banner advertisement
imptotal INTEGER Not Null 0 Total impressions for the banner advertisement
impmade INTEGER Not Null 0 Impression made for the banner advertisement
clicks INTEGER Not Null 0 Number of clicks recorded for the banner advertisement
clickurl VARCHAR(200) Not Null URL to visit when the banner advertisement is clicked
state TINYINT(3) Not Null 0 State
catid UNSIGNED INTEGER Not Null 0 Category ID (FK) references #__categories.id
description TEXT Not Null Brief description of the banner advertisement
custombannercode VARCHAR(2048) Not Null Code that represents the content for the banner advertisement
sticky TINYINT(1) UNSIGNED Not Null 0 Flag indicating the banner ad is ???
ordering INTEGER Not Null 0 The relative ordering of the banner ad
metakey TEXT Not Null The meta keywords for the item
params TEXT Not Null Parameters
own_prefix TINYINT(1) Not Null 0 Flag indicating ???
metakey_prefix VARCHAR(255) Not Null When matching metakey keywords, search only for this prefix
purchase_type TINYINT Not Null -1 Flag indicating if the target URL is a purchase
track_clicks TINYINT Not Null -1 Flag indicating if clicks are tracked for the banner ad
track_impressions TINYINT Not Null -1 Flag indicating if impressions are track for the banner ad
checked_out INTEGER UNSIGNED Not Null 0 (FK) references #__users.id
checked_out_time DATETIME Not Null '0000-00-00 00:00:00' The time the item was checked out
publish_up DATETIME Not Null '0000-00-00 00:00:00' Date/time the banner ad is published
publish_down DATETIME Not Null '0000-00-00 00:00:00' Date/time the banner ad is unpublished
reset DATETIME Not Null '0000-00-00 00:00:00' Date/time the impressions and clicks were reset
created DATETIME Not Null '0000-00-00 00:00:00' Date/time the banner ad was created
language char(7) Not Null Language identifier (like 'en-GB')

Notes

The following indexes are defined for use as alternate keys:

Indexes (#__banners)
Index Name Column(s)
idx_state state
idx_own_prefix own_prefix
idx_metakey_prefix metakey_prefix
idx_banner_catid catid
idx_language language

Default character set: utf8.

Retrieved from "https://docs.sandbox.joomla.org/index.php?title=Tables/banner&oldid=82887"