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 | Description |
|---|---|---|---|
| NUMERIC(19) | NOT NULL | 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 | Description |
|---|---|---|---|
| VARCHAR(255) | NOT NULL | The path of the requested content item. |
| NUMERIC(1) | NOT NULL CHECK | 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 | Description |
|---|---|---|---|
| INT | NOT NULL | The unique identifier of the group used in reporting. |
| WVARCHAR(64) | NOT NULL | 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 | Description |
|---|---|---|---|
| VARCHAR(30) | NOT NULL | 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 | Description |
|---|---|---|---|
| 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 | Description |
|---|---|---|---|
| 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 | Description |
|---|---|---|---|
| NUMERIC(19) | NOT NULL | 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 | Description |
|---|---|---|---|
| VARCHAR(255) | NOT NULL | The name of the request. |
| NUMERIC(1) | NOT NULL CHECK | 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 | Description |
|---|---|---|---|
| VARCHAR(32) | NULL | The session ID. |
| NUMERIC(1) | NOT NULL CHECK | 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 | Description |
|---|---|---|---|
| NUMERIC(19) | NOT NULL | 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 CHECK | 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 | Description |
|---|---|---|---|
| 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 | Description |
|---|---|---|---|
id (primary key) | INTEGER | NOT NULL | The ID associated with the event type. |
name | VARCHAR(32) | NOT NULL UNIQUE | The name of the event. |
