The Personalization module uses the following tables to store logging and reporting information. Note that these tables exist for use with external user profiles only.
dps_con_req
This table contains reporting information about requests for content.
Column | Data Type | Constraint |
---|---|---|
| NUMERIC(19) | NOT NULL |
(primary key) | The unique identifier associated with this content request. | |
| TIMESTAMP | NOT NULL |
The date the content is requested. | ||
| NUMERIC(19) | NULL |
The ID associated with the session in which the request occurs. | ||
| VARCHAR(255) | NOT NULL |
The path name of the requested content. |
dps_con_req_sum
This table contains reporting information about viewed content.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(255) | NOT NULL |
The path of the requested content item. | ||
| NUMERIC(1) | NOT NULL |
Indicates whether or not the user who will receive the content is a member. | ||
| INT | NOTNULL |
The number of requests for this content item. | ||
| TIMESTAMP | NOT NULL |
The beginning of the time span that is summarized. | ||
| TIMESTAMP | NOT NULL |
The end of the time span that is summarized. |
dps_group
This table contains information about reporting groups.
Column | Data Type | Constraint |
---|---|---|
| INT | NOT NULL |
(primary key) | The unique identifier of the group used in reporting. | |
| WVARCHAR(64) | NOT NULL UNIQUE |
The name of the group used in reporting. |
dps_log_id
This table provides the counters for the primary keys for each logging table.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(30) | NOT NULL |
(primary key) | The name of the reporting table. | |
| NUMERIC(19) | NOT NULL |
The next ID the logging table should use for a new row. |
dps_pgrp_con_sum
This table contains a record of summarized profile groups and the content they accessed in a content group.
Column | Data Type | Constraint |
---|---|---|
| WVARCHAR(64) | NOT NULL |
The name of the profile group. | ||
| WVARCHAR(64) | NOT NULL |
The name of the content group | ||
| INT | NOT NULL |
The number of times between the | ||
| TIMESTAMP | NOT NULL |
The beginning of the time span that is summarized. | ||
| TIMESTAMP | NOT NULL |
The end of the time span that is summarized. |
dps_pgrp_req_sum
This table contains a record of summarized profile groups and their requests for content from a content group.
Column | Data Type | Constraint |
---|---|---|
| WVARCHAR(64) | NOT NULL |
The name of the profile group. | ||
| WVARCHAR(255) | NOT NULL |
The name of the content item. | ||
| INT | NOT NULL |
The number of times between the | ||
| TIMESTAMP | NOT NULL |
The beginning of the time span that is summarized. | ||
| TIMESTAMP | NOT NULL |
The end of the time span that is summarized. |
dps_request
This table contains all of the request log entries.
Column | Data Type | Constraint |
---|---|---|
| NUMERIC(19) | NOT NULL |
(primary key) | The unique identifier associated with the request item. | |
| TIMESTAMP | NOT NULL |
The date on which the request was made. | ||
| VARCHAR(32) | NULL |
The ID of the session that made the request. | ||
| VARCHAR(255) | NOT NULL |
The name of the user who made the request. | ||
| NUMERIC(1) | NOT NULL |
Indicates whether a member or a guest made the request that is logged. |
dps_reqname_sum
This table contains records of summarized request names.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(255) | NOT NULL |
The name of the request. | ||
| NUMERIC(1) | NOT NULL |
Indicates whether the user is a member or a guest. | ||
| INT | NOT NULL |
The number of times between the | ||
| TIMESTAMP | NOT NULL |
The beginning of the time span that is summarized. | ||
| TIMESTAMP | NOT NULL |
The end of the time span that is summarized. |
dps_session_sum
This table contains records of summarized sessions.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(32) | NULL |
The session ID. | ||
| NUMERIC(1) | NOT NULL |
The value of the member attribute of the session profile. | ||
| INT | NOT NULL |
The total number of events that occurred during the session. | ||
| TIMESTAMP | NOT NULL |
The beginning of the time span that is summarized. | ||
| TIMESTAMP | NOT NULL |
The end of the time span that is summarized. |
dps_user_event
This table contains a record of any user event.
Column | Data Type | Constraint |
---|---|---|
| NUMERIC(19) | NOT NULL |
(primary key) | The primary key for this logged event. | |
| TIMESTAMP | NOT NULL |
The time that this event occurred. | ||
| VARCHAR(32) | NULL |
The ID associated with the session that triggered this event. | ||
| INT | NOT NULL |
The type of event, for example, login, logout, registration, content view, purchase, etc. References | ||
| VARCHAR(25) | NULL |
The ID associated with the user who triggered the event. | ||
| NUMERIC(1) | NOT NULL |
Whether or not the user is a member or a guest. |
dps_user_event_sum
This table contains records of summarized user event types.
Column | Data Type | Constraint |
---|---|---|
| INT | NOT NULL |
The type of event that is summarized, for example, login, logout, registration, content view, purchase, etc. References | ||
| INT | NOT NULL |
The number of times the event occurred. | ||
| TIMESTAMP | NOT NULL |
The beginning of the time span that is summarized. | ||
| TIMESTAMP | NOT NULL |
The end of the time span that is summarized. |
dps_event_type
This table contains information about the default D4-style events.
Column | Data Type | Constraint |
---|---|---|
id (primary key) | INTEGER | NOT NULL |
The ID associated with the event type. | ||
name | VARCHAR(32) | NOT NULL UNIQUE |
The name of the event. |