COLLATERAL

This table contains data describing the advertisements used by marketing campaigns.

Column Descriptions:

NameTypeDescription
COLLATERAL_IDINTEGER NOT NULLThe internal reference number of the Collateral.
STOREENT_IDINTEGER NOT NULLThe ID of the store to which the Collateral belongs.
COLLTYPE_IDINTEGER NOT NULLForeign key to the COLLTYPE table. Identifies the type of Collateral. The supported default types are Image, Flash, and Text.
NAMEVARCHAR (256)The name of the Collateral.
URLVARCHAR (1024)The click action to be invoked when the Collateral on the page is clicked.
FIELD1VARCHAR (254)Customizable.
FIELD2VARCHAR (254)Customizable.
UP_NAMEVARCHAR (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.
BEHAVIORSMALLINT NOT NULL DEFAULT 0If 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.
UIDISPLAYABLESMALLINTIndicates if this element should be displayed in CMC. Null/1: means Yes. 0: means No.
MANAGINGTOOLSMALLINTIndicates what tools manages that element. Null/0: means Marketing tool. 1: means Page Layout.
OVRMKTLIMITSMALLINTIndicates if this Marketing Content can contain attachments that are greater than the set Marketing Limit. 0: No 1: Yes null: Yes
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>COLLATERAL_IDPrimary Key
I0000077NAME+STOREENT_IDUnique Index
I0000312STOREENT_IDNon-Unique Index
IPF00008UP_NAMENon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_248COLLTYPE_IDCOLLTYPECOLLTYPE_IDCascade
F_249STOREENT_IDSTOREENTSTOREENT_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_251COLLATERAL_IDCOLLDESCCOLLATERAL_IDCascade
F_3741COLLATERAL_IDDMEMSPOTCOLLDEFCOLLATERAL_IDCascade
F_3742COLLATERAL_IDCOLLIMGMAPAREACOLLATERAL_IDCascade