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. |