Jump to: navigation, search

In the Column List:

  • P = Primary key
  • M = Mandatory field
  • F = Foreign key (where the term is used loosely to indicate a surrogate key reference to a field in another table, not a formal constraint)
  • DV = Default value
  • In the Data Type column, varchar/nvarchar means that the data type is varchar except in multi-language databases that use Unicode, in which case the data type is nvarchar. (The Info Mart database in Cloud deployments is not multi-language.)

Table COBROWSE_FACT

Description

Introduced: 8.5.011.14

In partitioned databases, this table is partitioned.


Reserved for future use.

Tip
To assist you in preparing supplementary documentation, click the following link to download a comma-separated text file containing information such as the data types and descriptions for all columns in this table: Download a CSV file.

Hint: For easiest viewing, open the downloaded CSV file in Excel and adjust settings for column widths, text wrapping, and so on as desired. Depending on your browser and other system settings, you might need to save the file to your desktop first.

Column List

Legend

Column Data Type P M F DV

SESSION_ID

varchar(50)/nvarchar(50) X

SESSION_TOKEN

varchar(20)/nvarchar(20) X

FIRST_SESSION

int X

MEDIA_SERVER_IXN_GUID

varchar(50) X

SESSION_START_TIME_TS

int X

START_DATE_TIME_KEY

int X X X

SESSION_RW_FLAG

int X

SESSION_END_TIME_TS

int X

SEGMENT_ID

varchar(50)/nvarchar(50) X

SEGMENT_INDEX

int X

SEGMENT_START_TIME_TS

int X

SEGMENT_END_TIME_TS

int X

PAGE_ID

varchar(50)/nvarchar(50) X X

PAGE_INDEX

int X

PAGE_URL

varchar(512)/nvarchar(512) X

PAGE_QUERY

varchar(255)/nvarchar(255) X

PAGE_START_TIME_TS

int X

PAGE_END_TIME_TS

int X

COBROWSE_USER_AGENT_KEY

int X -2

COBROWSE_END_REASON_KEY

int X X -2

COBROWSE_MODE_KEY

int X X -2

COBROWSE_PAGE_KEY

int X X -2

CREATE_AUDIT_KEY

numeric(19) X X

UPDATE_AUDIT_KEY

numeric(19) X

SESSION_ID

SESSION_TOKEN

FIRST_SESSION

MEDIA_SERVER_IXN_GUID

SESSION_START_TIME_TS

START_DATE_TIME_KEY

SESSION_RW_FLAG

SESSION_END_TIME_TS

SEGMENT_ID

SEGMENT_INDEX

SEGMENT_START_TIME_TS

SEGMENT_END_TIME_TS

PAGE_ID

PAGE_INDEX

PAGE_URL

PAGE_QUERY

PAGE_START_TIME_TS

PAGE_END_TIME_TS

COBROWSE_USER_AGENT_KEY

COBROWSE_END_REASON_KEY

COBROWSE_MODE_KEY

COBROWSE_PAGE_KEY

CREATE_AUDIT_KEY

UPDATE_AUDIT_KEY


Index List

CODE U C Description

I_COBROWSE_FACT_SDT

Reserved for future use.

Index I_COBROWSE_FACT_SDT

Field Sort Comment
START_DATE_TIME_KEY Ascending

No subject area information available.

 

Feedback

Comment on this article:

blog comments powered by Disqus
This page was last modified on September 27, 2018, at 13:35.