The following section describes the database tables used for the ATG Campaign Optimizer for Commerce test description functionality.
abt_elem_ctgy_tmp
This table contains information about a test element that substitutes one category template for another.
Column | Data Type | Constraint |
|---|---|---|
VARCHAR(40) | not null | |
(primary key) | The ID for the test element. | |
VARCHAR(40) | not null | |
The ID of the category template you want to test | ||
VARCHAR(40) | Null | |
The ID of the category template to be replaced | ||
VARCHAR(40) | Null | |
The ID for the catalog containing the affected categories | ||
TINYINT | Null | |
The flag that indicates whether to include (false) or exclude (true) a set of categories in your test. The excluded/included categories are described in the abt_elct_ctgs table. | ||
abt_elct_ctgs
This table lists categories that are either explicitly included or excluded from a category template element.
Column | Data Type | Constraint |
|---|---|---|
VARCHAR(40) | not null | |
(primary key) | The ID for the test element | |
VARCHAR(40) | not null | |
The ID of a category to include or exclude in the test as based on the value of the | ||
INTEGER | not null | |
(primary key) | The position of this category in the list of categories | |
abt_elem_prod_tmp
This table contains information about an element that substitutes one product template for another.
Column | Data Type | Constraint |
|---|---|---|
VARCHAR(40) | not null | |
(primary key) | The ID for the test element | |
VARCHAR(40) | not null | |
The ID of the product template you want to test | ||
VARCHAR(40) | Null | |
The ID of the product template to be replaced | ||
VARCHAR(40) | Null | |
The ID for the catalog containing the affected products | ||
TINYINT | Null | |
The flag that indicates whether to include (false) or exclude (true) a set of items in your test. When the items are products, the list of included/excluded products is described in the | ||
abt_elpt_prds
This table lists products that are either explicitly included in or excluded from a product template element.
Column | Data Type | Constraint |
|---|---|---|
VARCHAR(40) | not null | |
(primary key) | The ID for the test element. | |
VARCHAR(40) | not null | |
The ID of a product to include or exclude in the test as based on the value of the | ||
INTEGER | not null | |
(primary key) | The position for a product in the list of products | |
abt_elpt_ctgs
This table lists categories that are either explicitly included in or excluded from a product template element.
Column | Data Type | Constraint |
|---|---|---|
VARCHAR(40) | not null | |
(primary key) | The ID for the test element | |
VARCHAR(40) | not null | |
The ID of a category to include or exclude in the test as based on the value of the exclude flag in the abt_elem_prod_tmp table. | ||
INTEGER | not null | |
(primary key) | The position of the category in the list of categories | |
abt_elem_promo
This table contains information about an element that tests a promotion.
Column | Data Type | Constraint |
|---|---|---|
VARCHAR(40) | not null | |
(primary key) | The ID for the test element | |
VARCHAR(40) | not null | |
The ID for the promotion | ||
INTEGER | not null | |
The number that identifies the type of activity that triggers a promotion to be granted | ||
WVARCHAR(254) | null | |
The name of the page that triggers a page viewing event | ||
