This table contains data describing the advertisements used by marketing campaigns.
Column Name | Column Type | Column Description |
---|---|---|
COLLATERAL_ID | INTEGER NOT NULL |
The internal reference number of the Collateral. |
COLLTYPE_ID | INTEGER NOT NULL |
Identifies the type of Collateral. Foreign key to the COLLTYPE table. The supported default types are Image and Flash. |
FIELD1 | VARCHAR (254) NULL |
Customizable. |
FIELD2 | VARCHAR (254) NULL |
Customizable. |
NAME | VARCHAR (30) NULL |
The name of the Collateral. |
STOREENT_ID | INTEGER NOT NULL |
The ID of the store to which the Collateral belongs. |
URL | VARCHAR (254) NULL |
The click action to be invoked when the Collateral on the page is clicked. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000077 | NAME, STOREENT_ID | Unique Index |
I0000312 | STOREENT_ID | Non-Unique Index |
SQL030625034931780 | COLLATERAL_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_248 | COLLTYPE_ID | COLLTYPE | COLLTYPE_ID | Cascade |
F_249 | STOREENT_ID | STOREENT | STOREENT_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_251 | COLLATERAL_ID | COLLDESC | COLLATERAL_ID | Cascade |