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 | |||
| INTEGER | NOT NULL | ||
Manages the optimistic locking feature of the SQL Repository. This value is automatically incremented by the SQL Repository when any value of the item is modified. If you change rows directly outside of the ATG framework, you should also increment the version number. | ||||
| DATE | NULL | ||
The date this test was created. | ||||
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 | ||||
VARCHAR(80) | Null | |||
In a multisite environment, the site ID of the site where the test will run | ||||
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.
