Data Structure of the Viewtracker app

All Viewtracker data is stored in the Confluence database.

Viewtracker Data Structure

Table name: AO_05769A_VISIT_ENTITY

Column	Data Type	Description

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 the view was coming from. 0 = Desktop 1 = Mobile 2 = Confluence Mobile App 3 = Linchpin Mobile App 4 = Jira Service Management (JSM)