Actions

Difference between revisions of "Tables/bannerclient"

From Joomla! Documentation

< Tables
(New page: <h2>Usage:</h2> <dl> <dt>Since:</dt> <dd></dd> </dl> <h2>Description:</h2> <p> The banner_clients table contains information that identifies clients for banner advertisements us...)
 
m (categorisation)
 
(12 intermediate revisions by 2 users not shown)
Line 1: Line 1:
<h2>Usage:</h2>
+
== Usage ==
 +
* Since:
  
<dl>
+
== Description ==
  <dt>Since:</dt>
+
The banner_clients table contains information that identifies clients for banner advertisements used in the mod_banners module.
  <dd></dd>
+
</dl>
+
  
<h2>Description:</h2>
+
<table class="wikitable" border="1">
 
+
   <caption>'''banner_clients Table (#__banner_clients)'''</caption>
<p>
+
  The banner_clients table contains information that identifies clients
+
  for banner advertisements used in the mod_banners module.
+
</p>
+
 
+
<table>
+
   <caption>Table (#__banner_clients)</caption>
+
 
   <tr>
 
   <tr>
 
     <th>Field</th>
 
     <th>Field</th>
Line 31: Line 23:
 
     <td>PK            </td>
 
     <td>PK            </td>
 
     <td>auto_increment</td>
 
     <td>auto_increment</td>
     <td>
+
     <td>Banner Client ID.</td>
      Banner Client ID.
+
    </td>
+
 
   </tr>
 
   </tr>
 
   <tr>
 
   <tr>
Line 42: Line 32:
 
     <td></td>
 
     <td></td>
 
     <td></td>
 
     <td></td>
     <td>
+
     <td>Client name.</td>
      Client name.
+
    </td>
+
 
   </tr>
 
   </tr>
 
   <tr>
 
   <tr>
Line 53: Line 41:
 
     <td></td>
 
     <td></td>
 
     <td></td>
 
     <td></td>
     <td>
+
     <td>Contact name.</td>
      Contact name.
+
    </td>
+
 
   </tr>
 
   </tr>
 
   <tr>
 
   <tr>
Line 64: Line 50:
 
     <td></td>
 
     <td></td>
 
     <td></td>
 
     <td></td>
     <td>
+
     <td>Contact email address.</td>
      Contact email address.
+
    </td>
+
 
   </tr>
 
   </tr>
 
   <tr>
 
   <tr>
Line 75: Line 59:
 
     <td></td>
 
     <td></td>
 
     <td></td>
 
     <td></td>
     <td>
+
     <td>Free-form text to describe the banner client.</td>
      Free-form text to describe the banner client.
+
    </td>
+
 
   </tr>
 
   </tr>
 
   <tr>
 
   <tr>
Line 86: Line 68:
 
     <td></td>
 
     <td></td>
 
     <td></td>
 
     <td></td>
     <td>
+
     <td>State for the banner client.</td>
      State for the banner client.
+
    </td>
+
 
   </tr>
 
   </tr>
 
   <tr>
 
   <tr>
Line 97: Line 77:
 
     <td></td>
 
     <td></td>
 
     <td></td>
 
     <td></td>
     <td>
+
     <td>User ID that has the banner client entry checked out. FK references #__users.id.</td>
      User ID that has the banner client entry checked out.
+
      FK references #__users.id.
+
    </td>
+
 
   </tr>
 
   </tr>
 
   <tr>
 
   <tr>
Line 109: Line 86:
 
     <td></td>
 
     <td></td>
 
     <td></td>
 
     <td></td>
     <td>
+
     <td>Date/time that the banner client entry was checked out by the specified user ID.</td>
      Date/time that the banner client entry was checked out by the specified
+
      user ID.
+
    </td>
+
 
   </tr>
 
   </tr>
 
   <tr>
 
   <tr>
Line 121: Line 95:
 
     <td></td>
 
     <td></td>
 
     <td></td>
 
     <td></td>
     <td>
+
     <td>Metadata keywords for the banner client.</td>
      Metadata keywords for the banner client.
+
    </td>
+
 
   </tr>
 
   </tr>
 
   <tr>
 
   <tr>
Line 159: Line 131:
 
     <td></td>
 
     <td></td>
 
     <td></td>
 
     <td></td>
     <td>
+
     <td>Indicates if the number of clicks are tracked for a banner client.</td>
      Indicates if the number of clicks are tracked for a banner client.
+
    </td>
+
 
   </tr>
 
   </tr>
 
   <tr>
 
   <tr>
Line 170: Line 140:
 
     <td></td>
 
     <td></td>
 
     <td></td>
 
     <td></td>
     <td>
+
     <td>Indicates if the number of impressions are tracked for a banner client.</td>
      Indicates if the number of impressions are tracked for a banner client.
+
    </td>
+
 
   </tr>
 
   </tr>
 
</table>
 
</table>
  
<h2>Notes:</h2>
+
== Notes ==
  
<table>
+
<table class="wikitable" border="1">
   <caption>Indices</caption>
+
   <caption>'''Indices'''</caption>
 
   <tr>
 
   <tr>
 
     <th>Index Name</th>
 
     <th>Index Name</th>
Line 197: Line 165:
 
</table>
 
</table>
  
<dl>
+
* Default character set: '''utf8'''
  <dt>Default character set: </dt>
+
 
  <dd><b>utf8</b></dd>
+
<noinclude>[[Category:Database]]</noinclude>
</dl>
+

Latest revision as of 10:37, 16 March 2013

Usage

  • Since:

Description

The banner_clients table contains information that identifies clients for banner advertisements used in the mod_banners module.

banner_clients Table (#__banner_clients)
Field Type Nullable Default Key Extra Comments
id INTEGER NOT NULL PK auto_increment Banner Client ID.
name VARCHAR(255) NOT NULL Client name.
contact VARCHAR(255) NOT NULL Contact name.
email VARCHAR(255) NOT NULL Contact email address.
extrainfo TEXT NOT NULL Free-form text to describe the banner client.
state TINYINT(3) NOT NULL 0 State for the banner client.
checked_out INTEGER UNSIGNED NOT NULL 0 User ID that has the banner client entry checked out. FK references #__users.id.
checked_out_time DATETIME NOT NULL '0000-00-00 00:00:00' Date/time that the banner client entry was checked out by the specified user ID.
metakey TEXT NOT NULL Metadata keywords for the banner client.
own_prefix TINYINT NOT NULL 0
metakey_prefix VARCHAR(255) NOT NULL
purchase_type TINYINT NOT NULL -1
track_clicks TINYINT NOT NULL -1 Indicates if the number of clicks are tracked for a banner client.
track_impressions TINYINT NOT NULL -1 Indicates if the number of impressions are tracked for a banner client.

Notes

Indices
Index Name Column(s) Unique?
idx_own_prefix own_prefix No
idx_metakey_prefix metakey_prefix No
  • Default character set: utf8