Data Structure of Viewtracker Data Center
All Viewtracker data is stored in the Confluence database.
Viewtracker Data Structure
Table name: AO_05769A_VISIT_ENTITY
Column | Data Type | Description |
|---|---|---|
CONTENT_ID | BIGINT | The ID of the tracked page. |
ID | INTEGER | The individual ID of the view (Primary Key). |
PROTECTED_USER | BOOLEAN | TRUE = Extended Privacy Mode is enabled. The page viewer is a Confluence user (not anonymous access). NULL = Extended Privacy Mode is disabled. |
USER_KEY | VARCHAR(255) | The tracked user's key. Only filled if Extended Privacy Mode is disabled. In the Extended Privacy Mode, no user data is stored. |
VISIT_TIME | DATETIME | The timestamp of the view. |
SOURCE | INTEGER | The device type (source) the view was coming from.
|
see also: Data collection and storage in Viewtracker
Attachment Tracking Data Structure
Table name: AO_F117EB_ATTACHMENT_VIEWS
Column | Data Type | Description |
|---|---|---|
ATTACHMENT_ID | BIGINT | ID of the attachment |
CONTENT_ID | BIGINT | ID of the content that the attachment is attached to. |
ID | INTEGER | The primary key of the table (auto-increment). |
PROTECTED_USER | BOOLEAN | A flag that indicates whether the user viewed the attachment in Extended Privacy Mode. TRUE = Extended Privacy Mode is enabled. The attachment viewer is a Confluence user (not anonymous access). NULL = Extended Privacy Mode is disabled. |
USER_KEY | VARCHAR(255) | The tracked user's key. Only filled in if Extended Privacy Mode is disabled. |
VIEW_TIME | TIMESTAMP | The time when the attachment view was generated. |
Search Analytics Data Structure
Table name: AO_075EEE_SEARCH
Column | Data Type | Description |
|---|---|---|
ID | INTEGER | The primary key of the table (auto-increment). |
NUMBER_OF_RESULTS | INTEGER | The number of search results returned by the Confluence Search API. For an unsuccessful search, it’s 0. |
PROTECTED_USER | BOOLEAN | A flag that indicates whether the user performed a search in Extended Privacy Mode. TRUE = Extended Privacy Mode is enabled. The searcher is a Confluence user (not anonymous access). NULL = Extended Privacy Mode is disabled. |
SEARCH_DATE | TIMESTAMP | The time when the search action was performed. |
SEARCH_PLACE | INTEGER | The place where the search was performed.
|
SEARCH_TERM | VARCHAR(255) | The input from the user that was used for search. |
USER | VARCHAR(255) | The tracked user's key. Only filled in if Extended Privacy Mode is disabled. |