The following section describes the database tables used for the ATG Campaign Optimizer core functionality.
abt_test
This table contains information about an ATG Campaign Optimizer test.
Column | Data Type | Constraint |
|---|---|---|
VARCHAR(40) | not null | |
(primary key) | The ID of the test | |
WVARCHAR(100) | Null | |
The name of the test | ||
VARCHAR(40) | Null | |
For future use | ||
TINYINT | Null | |
Indicates whether the test has been enabled | ||
TIMESTAMP | Null | |
The date the test is set to start running | ||
TIMESTAMP | Null | |
The date the test is set to complete | ||
WVARCHAR(2000) | Null | |
The set of users to be tested | ||
WVARCHAR(254) | Null | |
Copied from | ||
WVARCHAR(254) | Null | |
For future use | ||
WVARCHAR(255) | Null | |
The URL to use when previewing a test group | ||
WVARCHAR(254) | Null | |
For future use | ||
TINYINT | Null | |
For future use | ||
TIMESTAMP | Null | |
The date the test was created | ||
TIMESTAMP | Null | |
The last date the test was modified | ||
WVARCHAR(254) | Null | |
A description of the test | ||
VARCHAR(40) | Null | |
The ID of the user who created the test | ||
VARCHAR(40) | Null | |
The ID of the last user to modify the test | ||
INTEGER | not null | |
The repository version used to prevent conflicting changes | ||
abt_group
This table contains information about a test group.
Column | Data Type | Constraint |
|---|---|---|
VARCHAR(40) | not null | |
(primary key) | The ID of the group | |
WVARCHAR(100) | Null | |
The name of the test group | ||
NUMERIC(197) | not null | |
The percentage of test participants to assign to the group | ||
TINYINT | Null | |
Indicates whether the group percentage can be edited in the ATG Campaign Optimizer UI or if it should be computed automatically | ||
TINYINT | null | |
Indicates whether the test is a control group | ||
WVARCHAR(254) | null | |
A description of the group | ||
abt_element
This table contains information about a test element.
Column | Data Type | Constraint |
|---|---|---|
VARCHAR(40) | not null | |
(primary key) | The ID of the test element | |
INTEGER | Null | |
Indicates which element type this is | ||
abt_test_group
This table contains information about linking tests to the groups they contain.
Column | Data Type | Constraint |
|---|---|---|
VARCHAR(40) | not null | |
(primary key) | The ID of the test | |
VARCHAR(40) | not null | |
The ID of a group in this test | ||
INTEGER | not null | |
(primary key) | The position of this group in the list of groups | |
abt_group_elem
This table contains information linking groups to the elements they contain.
Column | Data Type | Constraint |
|---|---|---|
VARCHAR(40) | not null | |
(primary key) | The ID of the test group | |
VARCHAR(40) | not null | |
The ID of a test element in this group | ||
INTEGER | not null | |
(primary key) | The position of this element in the list of elements | |
abt_elem_page
This table contains information about an element that tests pages.
Column | Data Type | Constraint |
|---|---|---|
VARCHAR(40) | not null | |
(primary key) | The ID of the page element | |
WVARCHAR(254) | not null | |
The location of the page to be replaced | ||
WVARCHAR(254) | Not null | |
The location of the page to be used during the test | ||
abt_elem_pg_frag
This table contains information about an element that tests page fragments.
Column | Data Type | Constraint |
|---|---|---|
VARCHAR(40) | Not null | |
(primary key) | The ID of the page fragment element | |
WVARCHAR(254) | Not null | |
The location of the page fragment to be replaced | ||
WVARCHAR(254) | Not null | |
The location of the page fragment to be used during the test | ||
WVARCHAR(254) | Null | |
The page in which to substitute the page fragment | ||
abt_elem_rep_slot
This table contains information about an element that tests repository content.
Column | Data Type | Constraint |
|---|---|---|
VARCHAR(40) | not null | |
(primary key) | The ID of the repository content test element | |
WVARCHAR(254) | not null | |
The slot whose contents will be substituted | ||
WVARCHAR(254) | null | |
For future use | ||
abt_elrs_item
This table contains information about the repository items to be substituted by repository content test elements.
