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: | ||
− | + | == Usage == | |
+ | * Since: | ||
− | + | == Description == | |
− | + | The banner_clients table contains information that identifies clients for banner advertisements used in the mod_banners module. | |
− | |||
− | |||
− | + | <table class="wikitable" border="1"> | |
− | + | <caption>'''banner_clients Table (#__banner_clients)'''</caption> | |
− | |||
− | |||
− | |||
− | |||
− | |||
− | <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> |
− | |||
− | |||
</tr> | </tr> | ||
<tr> | <tr> | ||
Line 42: | Line 32: | ||
<td></td> | <td></td> | ||
<td></td> | <td></td> | ||
− | <td> | + | <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> |
− | |||
− | |||
</tr> | </tr> | ||
<tr> | <tr> | ||
Line 64: | Line 50: | ||
<td></td> | <td></td> | ||
<td></td> | <td></td> | ||
− | <td> | + | <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> |
− | |||
− | |||
</tr> | </tr> | ||
<tr> | <tr> | ||
Line 86: | Line 68: | ||
<td></td> | <td></td> | ||
<td></td> | <td></td> | ||
− | <td> | + | <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> |
− | |||
− | |||
− | |||
</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> |
− | |||
− | |||
− | |||
</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> |
− | |||
− | |||
</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> |
− | |||
− | |||
</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> |
− | |||
− | |||
</tr> | </tr> | ||
</table> | </table> | ||
− | + | == 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> | ||
− | + | * Default character set: '''utf8''' | |
− | + | ||
− | + | <noinclude>[[Category:Database]]</noinclude> | |
− | </ |
Latest revision as of 10:37, 16 March 2013
Usage[edit]
- Since:
Description[edit]
The banner_clients table contains information that identifies clients for banner advertisements used in the mod_banners module.
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. | |||
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[edit]
Index Name | Column(s) | Unique? |
---|---|---|
idx_own_prefix | own_prefix | No |
idx_metakey_prefix | metakey_prefix | No |
- Default character set: utf8