This table contains data describing the
advertisements used by marketing campaigns.
Column Descriptions:
| Name | Type | Description |
| COLLATERAL_ID | INTEGER NOT NULL | The internal reference number of the
Collateral. |
| STOREENT_ID | INTEGER NOT NULL | The ID of the store to which the Collateral
belongs. |
| COLLTYPE_ID | INTEGER NOT NULL | Foreign key to the COLLTYPE table. Identifies the
type of Collateral. The supported default types are Image, Flash,
and Text. |
| NAME | VARCHAR (256) | The name of the Collateral. |
| URL | VARCHAR (1024) | The click action to be invoked when the
Collateral on the page is clicked. |
| FIELD1 | VARCHAR (254) | Customizable. |
| FIELD2 | VARCHAR (254) | Customizable. |
| UP_NAME | VARCHAR (256) | The equivalent value of the NAME column in upper
case characters. This column is used only for DB2 (LUW)
database-types to enhance performance of text-based searches issued
from Management Center. |
| BEHAVIOR | SMALLINT NOT NULL DEFAULT 0 | If this content displays the same results to all
customers, then set this value to 0. If this content has dynamic
behavior that can display different results, then set this value to
1. The associated e-Marketing Spot can use this setting to
determine how to cache the e-Marketing Spot results. |
| UIDISPLAYABLE | SMALLINT | Indicates if this element should be displayed in
CMC. Null/1: means Yes. 0: means No. |
| MANAGINGTOOL | SMALLINT | Indicates what tools manages that element.
Null/0: means Marketing tool. 1: means Page Layout. |
| OVRMKTLIMIT | SMALLINT | Indicates if this Marketing Content can contain
attachments that are greater than the set Marketing Limit. 0: No 1:
Yes null: Yes |
| OPTCOUNTER | SMALLINT | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
| Name | Column Names | Type |
| <SYSTEM-GENERATED> | COLLATERAL_ID | Primary Key |
| I0000077 | NAME+STOREENT_ID | Unique Index |
| I0000312 | STOREENT_ID | Non-Unique Index |
| IPF00008 | UP_NAME | Non-Unique Index |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | Type |
| F_248 | COLLTYPE_ID | COLLTYPE | COLLTYPE_ID | Cascade |
| F_249 | STOREENT_ID | STOREENT | STOREENT_ID | Cascade |
Referenced By Child Tables:
| Constraint | Columns | Child Table | Child Columns | Type |
| F_251 | COLLATERAL_ID | COLLDESC | COLLATERAL_ID | Cascade |
| F_3741 | COLLATERAL_ID | DMEMSPOTCOLLDEF | COLLATERAL_ID | Cascade |
| F_3742 | COLLATERAL_ID | COLLIMGMAPAREA | COLLATERAL_ID | Cascade |