7 WebCenter Sites: Analytics Database Schema

This appendix contains the following sections:

7.1 L3 Tables

Level 3 database tables store statistically processed, aggregated data. When aggregated in advance, the data becomes available on demand at report generation time.

Table names indicate which type of data is stored. For example:

  • The table named L3_DATEXSITEXCITYXCOUNT stores daily data for a site that is browsed by visitors from a given city.

  • The table named L3_WEEKXSITEXCITYXCOUNT stores the same type of data as L3_DATEXSITEXCITYXCOUNT, but for the given week (that is, L3_WEEKXSITEXCITYXCOUNT stores weekly data for a site that is browsed by visitors from a given city).

  • The table named L3_MONTHXSITEXCITYXCOUNT stores the same type of data as L3_DATEXSITEXCITYXCOUNT, but for the given month (that is, L3_MONTHXSITEXCITYXCOUNT stores monthly data for a site that is browsed by visitors from a given city).

Note:

The term object impression is used throughout this reference. An object impression is a single invocation of the sensor servlet. An object impression can also be thought of as a "snapshot" of raw site visitor data that is captured for analysis. For more information about object impressions, see the Oracle Fusion Middleware WebCenter Sites: Analytics Administrator's Guide.

7.1.1 CS_L3DATEXSITEXOBJXCOUNT

This table stores data for the chart in the "Clickstream" report. It stores the number of clicks that were made from one object to another on a specific date.

Column Name Type Description

DATEID

NUMBER

Foreign key to the HELP_DATES table to reference the date of the data.

SITEID

NUMBER

Foreign key to the SITE table.

OBJECTFROMID

NUMBER

From which object.

OBJECTTOID

NUMBER

To which object.

COUNT

NUMBER

Number of clicks.

7.1.2 L3_DATEXSITEXCITYXCOUNT

Reserved for internal use. This table stores the number of object impressions, sessions, and visitors from a specific city on a specific day. See Section 7.2.1, "HELP_CITY" for more information.

Column Name Type Description

DATEID

NUMBER

Foreign key to the HELP_DATES table.

SITEID

NUMBER (6)

Foreign key to the SITE table.

CITYID

NUMBER

Foreign key to the HELP_CITY table.

OICOUNT

NUMBER

Number of object impressions for the day, for the site, for the city.

VISCOUNT

NUMBER

Number of visitors for the day, for the site, for the city.

SESCOUNT

NUMBER

Number of sessions for the day, for the site, for the city.

7.1.3 L3_WEEKXSITEXCITYXCOUNT

Reserved for internal use. This table stores the number of object impressions, sessions, and visitors from a specific city on a specific week. See Section 7.2.1, "HELP_CITY" for more information.

Column Name Type Description

DATEID

NUMBER

Foreign key to the HELP_DATES table.

SITEID

NUMBER (6)

Foreign key to the SITE table.

CITYID

NUMBER

Foreign key to the HELP_CITY table.

OICOUNT

NUMBER

Number of object impressions for the week for the site, for the city.

VISCOUNT

NUMBER

Number of visitors for the week for the site, for the city

SESCOUNT

NUMBER

Number of sessions for the week for the site, for the city.

7.1.4 L3_MONTHXSITEXCITYXCOUNT

Reserved for internal use. This table stores the number of object impressions, sessions, and visitors from a specific city on a specific month. See the HELP_CITY table for more information.

Column Name Type Description

DATEID

NUMBER

Foreign key to the HELP_DATES table.

SITEID

NUMBER (6)

Foreign key to the SITE table.

CITYID

NUMBER

Foreign key to the HELP_CITY table.

OICOUNT

NUMBER

Number of object impressions for the month site, and city.

VISCOUNT

NUMBER

Number of visitors for the month, site, and city.

SESCOUNT

NUMBER

Number of sessions for the month site, and city.

7.1.5 L3_DATEXSITEXDLXMIMEXCOUNT

This table stores the number of object impressions for the given object and its MIME type.

Column Name Type Description

DATEID

NUMBER

Foreign key to the HELP_DATES table.

SITEID

NUMBER (6)

Foreign key to the SITE table.

OBJECTID

NUMBER (12)

Foreign key to the L2_OBJECT table.

MIMETYPE

VARCHAR2 (32 BYTE)

The MIME type.

COUNT

NUMBER

Number of object impressions for the day, for the site, and for the object with that MIME type.

7.1.6 L3_DATEXSITEXGROUPXOICOUNT

This table stores how often a group was visited (number of object impressions).

Column Name Type Description

DATEID

NUMBER

Foreign key to the HELP_DATES table.

GROUPID

NUMBER

Foreign key to the L2_GROUP table.

COUNT

NUMBER

Number of object impressions.

7.1.7 L3_DATEXSITEXGROUPXSESCOUNT

This table stores how often a group was visited (number of sessions).

Column Name Type Description

DATEID

NUMBER

Foreign key to the HELP_DATES table.

GROUPID

NUMBER

Foreign key to the L2_GROUP table.

SESCOUNT

NUMBER

Number of sessions.

7.1.8 L3_DATEXSITEXGROUPXVISCOUNT

This table stores the number of visitors a group receives on a daily basis.

Column Name Type Description

DATEID

NUMBER

Foreign key to the HELP_DATES table.

GROUPID

NUMBER

Foreign key to the L2_GROUP table.

VISCOUNT

NUMBER

Number of visitors.

7.1.9 L3_WEEKXSITEXGROUPXVISCOUNT

This table stores the number of visitors a group receives on a weekly basis.

Column Name Type Description

DATEID

NUMBER

Foreign key to the HELP_DATES table.

GROUPID

NUMBER

Foreign key to the L2_GROUP table.

VISCOUNT

NUMBER

Number of visitors.

7.1.10 L3_MONTHXSITEXGROUPXVISCOUNT

This table stores the number of visitors a group receives on a monthly basis.

Column Name Type Description

DATEID

NUMBER

Foreign key to the HELP_DATES table.

GROUPID

NUMBER

Foreign key to the L2_GROUP table.

VISCOUNT

NUMBER

Number of visitors.

7.1.11 L3_DATEXSITEXREGIONXCOUNT

Reserved for internal use. This table stores the number of object impressions, sessions, and visitors that occur daily for each region.

Column Name Type Description

DATEID

NUMBER

Foreign key to the HELP_DATES table.

SITEID

NUMBER (6)

Foreign key to the SITE table.

REGIONID

NUMBER

Foreign key to the HELP_REGION table.

OICOUNT

NUMBER

Number of object impressions from that region on the site for the day.

VISCOUNT

NUMBER

Number of visitors from that region on the site for the day.

SESCOUNT

NUMBER

Number of sessions from that region on the site for the day.

7.1.12 L3_WEEKXSITEXREGIONXCOUNT

Reserved for internal use. This table stores the number of object impressions, sessions, and visitors that occur weekly for each region.

Column Name Type Description

DATEID

NUMBER

Foreign key to the HELP_DATES table.

SITEID

NUMBER (6)

Foreign key to the SITE table.

REGIONID

NUMBER

Foreign key to the HELP_REGION table.

OICOUNT

NUMBER

Number of object impressions from that region on the site for the week.

VISCOUNT

NUMBER

Number of visitors from that region on the site for the week.

SESCOUNT

NUMBER

Number of sessions from that region, on the site for the week.

7.1.13 L3_MONTHXSITEXREGIONXCOUNT

Reserved for internal use. This table stores the number of object impressions, sessions, and visitors that occur monthly for each region.

Column Name Type Description

DATEID

NUMBER

Foreign key to the HELP_DATES table.

SITEID

NUMBER (6)

Foreign key to the SITE table.

REGIONID

NUMBER

Foreign key to the HELP_REGION table.

OICOUNT

NUMBER

Number of object impressions from that region on the site for the month.

VISCOUNT

NUMBER

Number of visitors from that region on the site for the month.

SESCOUNT

NUMBER

Number of sessions from that region on the site for the month.

7.1.14 L3_DATEXSITEXJS

This table stores the number of clients that use JavaScript.

Column Name Type Description

DATEID

NUMBER

Foreign key to the HELP_DATES table.

SITEID

NUMBER (6)

Foreign key to the SITE table.

VALUE

NUMBER

This stores either true or false.

COUNT

NUMBER

Number of object impressions with that VALUE.

7.1.15 L3_DATEXSITEXOBJECTXDURATION

This table stores the length of time that users view an object.

Column Name Type Description

DATEID

NUMBER

Foreign key to the HELP_DATES table.

SITEID

NUMBER (6)

Foreign key to the SITE table.

OBJECTID

NUMBER (12)

Foreign key to the L2_OBJECT table.

DURATION

NUMBER

Number of seconds until the user called another page.

COUNT

NUMBER

Number of data rows from which the duration is calculated.

7.1.16 L3_DATEXSITEXBROWSERXCOUNT

This table stores the number of sessions a type of browser has completed.

Column Name Type Description

DATEID

NUMBER

Foreign key to the HELP_DATES table.

SITEID

NUMBER (6)

Foreign key to the SITE table.

BROWSERID

NUMBER (12)

Foreign key to the L2_BROWSER table.

COUNT

NUMBER

Number of sessions a browser has completed.

7.1.17 L3_DATEXSITEXCOUNTRYXCOUNT

This table stores aggregated data for each country, for the given date.

Column Name Type Description

DATEID

NUMBER

Foreign key to the HELP_DATES table.

SITEID

NUMBER (6)

Foreign key to the SITE table.

COUNTRYID

NUMBER (12)

Foreign key to the HELP_COUNTRY table.

COUNT

NUMBER

Number of sessions for this site, on this date.

OICOUNT

NUMBER

Number of object impressions for this site, on this date.

VISCOUNT

NUMBER

Number of visitors for this site, on this date.

7.1.18 L3_WEEKXSITEXCOUNTRYXCOUNT

This table stores aggregated data for each country, for the given week.

Column Name Type Description

DATEID

NUMBER

Foreign key to the HELP_DATES table.

SITEID

NUMBER (6)

Foreign key to the SITE table.

COUNTRYID

NUMBER (12)

Foreign key to the HELP_COUNTRY table.

COUNT

NUMBER

Number of sessions for this site, within this week.

OICOUNT

NUMBER

Number of object impressions for this site, within this week.

VISCOUNT

NUMBER

Number of visitors for this site, within this week.

7.1.19 L3_MONTHXSITEXCOUNTRYXCOUNT

This table stores aggregated data for each country, for the given month.

Column Name Type Description

DATEID

NUMBER

Foreign key to the HELP_DATES table.

SITEID

NUMBER (6)

Foreign key to the SITE table.

COUNTRYID

NUMBER (12)

Foreign key to the HELP_COUNTRY table.

COUNT

NUMBER

Number of sessions for this site, on this date.

OICOUNT

NUMBER

Number of object impressions for this site, on this date.

VISCOUNT

NUMBER

Number of visitors for this site, on this date.

7.1.20 L3_DATEXSITEXENTRYIDXCOUNT

This table stores entry page data for the given date.

Column Name Type Description

DATEID

NUMBER

Foreign key to the HELP_DATES table.

SITEID

NUMBER (6)

Foreign key to the SITE table.

OBJECTID

NUMBER

Foreign key to the L2_OBJECT table.

COUNT

NUMBER

How often this object was used as an entry page.

7.1.21 L3_DATEXSITEXEXITIDXCOUNT

This table stores exit page data for the given date.

Column Name Type Description

DATEID

NUMBER

Foreign key to the HELP_DATES table.

SITEID

NUMBER (6)

Foreign key to the SITE table.

OBJECTID

NUMBER

Foreign key to the L2_OBJECT table.

COUNT

NUMBER

How often this object was used as an exit page.

7.1.22 L3_DATEXSITEXHOSTNAMEXCOUNT

This table stores the number of sessions for the given host name on the given date.

Column Name Type Description

DATEID

NUMBER

Foreign key to the HELP_DATES table.

SITEID

NUMBER (6)

Foreign key to the SITE table.

HOSTNAME

VARCHAR2 (64 BYTE)

Name of the host.

COUNT

NUMBER

Number of sessions for this host.

7.1.23 L3_DATEXSITEXINTERNALSEARCH

This table stores aggregated data of internal searches for the given date.

Column Name Type Description

DATEID

NUMBER

Foreign key to the HELP_DATES table.

SITEID

NUMBER (6)

Foreign key to the SITE table.

QUERY

VARCHAR2 (2049 BYTE)

Query string that was searched.

COUNT

NUMBER

How often the query was searched.

AVGHITS

NUMBER

Average number of search results.

MAXHITS

NUMBER

Maximum number of search results.

MINHITS

NUMBER

Minimum number of search results.

AVGMAXSCORE

NUMBER

Average maximum score.

MINSCORE

NUMBER

Minimum score.

MAXSCORE NUMBER

NUMBER

Maximum score.

OBJECTTYPEID

NUMBER

Foreign key to L2_OBJECTTYPE of the query.

7.1.24 L3_DATEXSITEXIPXCOUNT

This table stores the number of sessions for the given IP address and date.

Column Name Type Description

DATEID

NUMBER

Foreign key to the HELP_DATES table.

SITEID

NUMBER (6)

Foreign key to the SITE table.

IP

VARCHAR2 (15 BYTE)

IP address.

COUNT

NUMBER

Number of sessions for the IP address on the site for the day.

7.1.25 L3_DATEXSITEXISPXCOUNT

This table stores for each ISP daily the number of object impressions, sessions and visitors.

Column Name Type Description

DATEID

NUMBER

Foreign key to the HELP_DATES table.

SITEID

NUMBER(6)

Foreign key to the SITE table.

ISPID

NUMBER

Foreign key to the HELP_ISP table.

OICOUNT

NUMBER

Number of object impressions for that ISP on that site on that day.

VISCOUNT

NUMBER

Number of visitors for that ISP on that site on that day.

SESCOUNT

NUMBER

Number of sessions for that ISP on that site on that day.

7.1.26 L3_WEEKXSITEXISPXCOUNT

This table stores for each ISP weekly the number of object impressions, sessions and visitors.

Column Name Type Description

DATEID

NUMBER

Foreign key to the HELP_DATES table.

SITEID

NUMBER(6)

Foreign key to the SITE table.

ISPID

NUMBER

Foreign key to the HELP_ISP table.

OICOUNT

NUMBER

Number of object impressions for that ISP on that site on that week.

VISCOUNT

NUMBER

Number of visitors for that ISP on that site on that week.

SESCOUNT

NUMBER

Number of sessions for that ISP on that site on that week.

7.1.27 L3_MONTHXSITEXISPXCOUNT

This table stores for each ISP monthly the number of object impressions, sessions and visitors.

Column Name Type Description

DATEID

NUMBER

Foreign key to the HELP_DATES table.

SITEID

NUMBER(6)

Foreign key to the SITE table.

ISPID

NUMBER

Foreign key to the HELP_ISP table.

OICOUNT

NUMBER

Number of object impressions for that ISP on that site on that month.

VISCOUNT

NUMBER

Number of visitors for that ISP on that site on that month.

SESCOUNT

NUMBER

Number of sessions for that ISP on that site on that month.

7.1.28 L3_DATEXSITEXOBJECTTYPEXCOUNT

This table stores aggregated data for each object type for the given date and hour.

Column Name Type Description

DATEID

NUMBER

Foreign key to the HELP_DATES table.

SITEID

NUMBER (6)

Foreign key to the SITE table.

OBJECTTYPEID

NUMBER (12)

Foreign key to the L2_OBJECTTYPE table.

COUNT

NUMBER

Number of object impressions of that object type for the site, for the day in that hour.

HOUR

VARCHAR2 (2 BYTE)

Hour of the object impressions.

7.1.29 L3_DATEXSITEXOBJECTXCOUNT

This table stores aggregated data for each object, for the given date.

Column Name Type Description

DATEID

NUMBER

Foreign key to the HELP_DATES table.

SITEID

NUMBER (6)

Foreign key to the SITE table.

OBJECTID

NUMBER (12)

Foreign key to the L2_OBJECT table.

COUNT

NUMBER

Number of object impressions.

7.1.30 L3_AUDIT_TRAIL

This table provides audit trail tracking of asset modifications.

Column Name Type Description

DATEID

NUMBER

Foreign key in the HELP_DATES table.

OBJECTID

NUMBER

Asset identifier.

SITEID

NUMBER

Foreign key in the SITE table.

CSUSERID

VARCHAR2(255)

User name of the WebCenter Sites user.

OPTYPE

VARCHAR2(255)

Type of operation:

CREATE|EDIT|DELETE

TIMESTAMP

DATE

When the modification occurred.

7.1.31 L3_DATEXSITEXOPTYPEXCOUNT

This table stores the number of daily asset modifications.

Column Name Type Description

DATEID

NUMBER

Foreign key in the HELP_DATES table.

SITEID

NUMBER

Foreign key in the SITE table.

OPTYPE

VARCHAR2(255)

Type of operation:

CREATE|EDIT|DELETE

COUNT

NUMBER

Number of incidents.

7.1.32 L3_WEEKXSITEXOPTYPEXCOUNT

This table stores the number of weekly asset modifications.

Column Name Type Description

DATEID

NUMBER

Foreign key in the HELP_DATES table.

SITEID

NUMBER

Foreign key in the SITE table.

OPTYPE

VARCHAR2(255)

Type of operation: CREATE|EDIT|DELETE

COUNT

NUMBER

Number of incidents.

7.1.33 L3_MONTHXSITEXOPTYPEXCOUNT

This table stores the number of monthly asset modifications.

Column Name Type Description

DATEID

NUMBER

Foreign key in the HELP_DATES table.

SITEID

NUMBER

Foreign key in the SITE table.

OPTYPE

VARCHAR2(255)

Type of operation:

CREATE|EDIT|DELETE

COUNT

NUMBER

Number of incidents.

7.1.34 L3_DATEXSITEXOSXCOUNT

This table stores the number of sessions for each operating system, for the given date.

Column Name Type Description

DATEID

NUMBER

Foreign key to the HELP_DATES table.

SITEID

NUMBER (6)

Foreign key to the SITE table.

OSID

NUMBER (12)

Foreign key to the L2_OS table.

COUNT

NUMBER

Number of sessions for the operating system.

7.1.35 L3_DATEXSITEXREFERERXCOUNT

This table stores the number of sessions for each referrer URL, for the given date.

Column Name Type Description

DATEID

NUMBER

Foreign key to the HELP_DATES table.

SITEID

NUMBER (6)

Foreign key to the SITE table.

REFERER

VARCHAR2 (500 BYTE)

The referrer URL.

COUNT

NUMBER

Number of sessions from the referrer URL.

7.1.36 L3_DATEXSITEXSCREENRESXCOUNT

This table stores the number of sessions for each screen resolution, for the given date.

Column Name Type Description

DATEID

NUMBER

Foreign key to the HELP_DATES table.

SITEID

NUMBER (6)

Foreign key to the SITE table.

SCREENRESOLUTIONID

NUMBER (12)

Screen resolution as a single number VVVVHHHH, where VVVV is vertical resolution, and HHHH is horizontal resolution.

COUNT

NUMBER

Number of sessions with that screen resolution.

7.1.37 L3_DATEXSITEXSESSION

This table stores session information for each site, for the given date.

Column Name Type Description

DATEID

NUMBER

Foreign key to the HELP_DATES table.

SITEID

NUMBER (6)

Foreign key to the SITE table.

AVG

NUMBER

Average duration of all sessions included in the line.

DURRATIONQUANTIL

NUMBER

  • Null for sessions without a valid session ID.

  • 0 for sessions with a length of 0 seconds.

  • 1 for sessions between 1 and 30 seconds.

  • 30 for sessions between 30 and 120 seconds.

  • 120 for sessions between 120 and 300 seconds.

  • 300 for sessions between 300 and 900 seconds.

  • 900 for sessions between 900 and 1800 seconds.

  • 1800 for sessions between 1,800 and 3,600 seconds.

  • 3600 for sessions between 3,600 and 86,400 seconds.

QUANTILCOUNT

NUMBER

Number of sessions in the quantile.

PICOUNT

NUMBER

Number of object impressions in the quantile.

7.1.38 L3_DATEXSITEXSESSIONXQUANTIL

This table stores session information based on quantile.

Column Name Type Description

DATEID

NUMBER

Foreign key to the HELP_DATES table.

SITEID

NUMBER (6)

Foreign key to the SITE table.

SUM

NUMBER

Number of sessions.

AVG

NUMBER

Average duration of these sessions.

QUAN0

NUMBER

Number of sessions with a length of '0'.

QUAN0AVG

NUMBER

Average duration of all sessions from this quantile.

QUAN1

NUMBER

Number of sessions with a length between 1 and 30 seconds.

QUAN1AVG

NUMBER

Average duration of all sessions from this quantile.

QUAN30

NUMBER

Number of sessions with a length between 31 and 120 seconds (2 minutes).

QUAN30AVG

NUMBER

Average duration of all sessions from this quantile.

QUAN120

NUMBER

Number of sessions with a length between 121 and 300 seconds (5 minutes).

QUAN120AVG

NUMBER

Average duration of all sessions from this quantile.

QUAN300

NUMBER

Number of sessions with a length between 301 and 900 seconds (15 minutes).

QUAN300AVG

NUMBER

Average duration of all sessions from this quantile.

QUAN900

NUMBER

Number of sessions with a length between 901 and 1800 seconds (30 minutes).

QUAN900AVG

NUMBER

Average duration of all sessions from this quantile.

QUAN1800

NUMBER

Number of sessions with a length between 1801 and 3600 seconds (one hour).

QUAN1800AVG

NUMBER

Average duration of all sessions from this quantile.

QUAN3600

NUMBER

Number of sessions with a length between 3601 and 86400 seconds (one week).

QUAN3600AVG

NUMBER

Average duration of all sessions from this quantile.

QUAN86400

NUMBER

Number of sessions with a length exceeding 86400 seconds (more than one week).

QUAN86400AVG

NUMBER

Average duration of all sessions from this quantile.

QUANNULL

NUMBER

Number of sessions with a length of '0' and a SESSIONID of null (no cookie sessions).

QUANNULLAVG

NUMBER

Reserved for internal use.

PICOUNT

NUMBER

Number of object impressions in the quantile.

7.1.39 L3_DATEXSITEXSEXKEYWORDXCOUNT

This table stores the daily number of sessions that start with a given keyword.

Column Name Type Description

DATEID

NUMBER

Foreign key to the HELP_DATES table.

SITEID

NUMBER (6)

Foreign key to the SITE table.

SEARCHENGINEID

NUMBER

Foreign key to the L2_SEARCHENGINE table.

KEYWORD

VARCHAR2 (128 BYTE)

The search phrase.

COUNT

NUMBER

Number of sessions started with the referrer and the phrase from the search engine.

7.1.40 L3_DATEXSITEXVISITORXCOUNT

This table stores the daily number of sessions for each visitor.

Column Name Type Description

DATEID

NUMBER

Foreign key to the HELP_DATES table.

SITEID

NUMBER (6)

Foreign key to the SITE table.

COUNT

NUMBER

Number of visitors to the site for the day.

SESCOUNT

NUMBER

Number of sessions for the site for the day.

PICOUNT

NUMBER

Number of object impressions on the site for the day.

NEW

NUMBER

Number of new visitors on the site for the day.

7.1.41 L3_WEEKXSITEXVISITORXCOUNT

This table stores the weekly number of sessions for each visitor.

Column Name Type Description

DATEID

NUMBER

Foreign key to the HELP_DATES table.

SITEID

NUMBER (6)

Foreign key to the SITE table.

COUNT

NUMBER

Number of visitors on the site for the week

SESCOUNT

NUMBER

Number of sessions on the site for the week.

PICOUNT

NUMBER

Number of object impressions on the site for the week.

NEW

NUMBER

Number of visitors on the site for the week.

7.1.42 L3_MONTHXSITEXVISITORXCOUNT

This table stores the monthly number of sessions for each visitor.

Column Name Type Description

DATEID

NUMBER

Foreign key to the HELP_DATES table.

SITEID

NUMBER (6)

Foreign key to the SITE table.

COUNT

NUMBER

Number of visitors on the site for the month.

SESCOUNT

NUMBER

Number of sessions on the site for the month.

PICOUNT

NUMBER

Number of object impressions on the site for the month.

NEW

NUMBER

Number of new visitors on the site for the month.

7.1.43 REC_L3_RECXCOUNT

This table stores the number of recommendations that were displayed and clicked on a given day.

Column Name Type Description

DATEID

NUMBER

Foreign key to the HELP_DATES table.

SITEID

NUMBER

Foreign key to the SITE table.

RECID

NUMBER (6)

Foreign key to the REC_RECOMMENDATION table.

VIEWCOUNT

NUMBER (12)

Number of times the recommendation was displayed.

CLICKCOUNT

NUMBER (12)

Number of times the recommendation was clicked.

7.1.44 REC_L3_RECXSEGXCOUNT

This table stores the number of recommendations that were displayed and clicked by a given segment on a given day.

Column Name Type Description

DATEID

NUMBER

Foreign key to the HELP_DATES table.

SITEID

NUMBER

Foreign key to the SITE table.

RECID

NUMBER (6)

Foreign key to the REC_RECOMMENDATION table.

SEGID

NUMBER (6)

Foreign key to the REC_SEGMENT table.

VIEWCOUNT

NUMBER (12)

Number of times the recommendation was displayed by that segment.

CLICKCOUNT

NUMBER (12)

Number of times the recommendation was clicked by that segment.

7.1.45 REC_L3_RECXSEGXOBJXCOUNT

This table stores the number of times an object was accessed on a given day by a specific segment of a specific recommendation.

Column Name Type Description

DATEID

NUMBER

Foreign key to the HELP_DATES table.

SITEID

NUMBER

Foreign key to the SITE table.

RECID

NUMBER (6)

Foreign key to the REC_RECOMMENDATION table.

SEGID

NUMBER (6)

Foreign key to the REC_SEGMENT table.

OBJID

NUMBER (24)

Foreign key to the L2_OBJECT table.

OBJVIEWEDCOUNT

NUMBER (12)

How often the object was displayed during a recommendation list.

OBJCLICKEDCOUNT

NUMBER (12)

How often the object was clicked during a recommendation list.

7.2 HELP Tables

Tables in this section store static data that is used by various jobs and reports. The tables are populated at installation time.

7.2.1 HELP_CITY

Reserved for internal use.

Column Name Type Description

ID

NUMBER

The primary key.

NAME

VARCHAR2 (64)

Name of the city.

REGIONID

NUMBER

Foreign key to the HELP_REGION table.

COUNTRYID

NUMBER

Foreign key to the HELP_COUNTRY table.

7.2.2 HELP_REGION

Reserved for internal use.

Column Name Type Description

ID

NUMBER

The primary key.

NAME

VARCHAR2 (128 BYTE)

Name of the region.

COUNTRYID

NUMBER

Foreign key to the HELP_COUNTRY table.

REGIONCODE

VARCHAR2 (2)

Foreign key to the HELP_REGION table.

7.2.3 HELP_COUNTRY

This table stores detailed information about countries.

Column Name Type Description

ID

NUMBER

The primary key.

CODE

VARCHAR2 (5 BYTE)

Two-letter country code.

NAME

VARCHAR2 (50 BYTE)

Country name

COUNTRY

VARCHAR2(50)

This column is not used.

POPULATION

NUMBER (14)

Population of the country.

7.2.4 HELP_DATES

This table has one entry for each day. It is used and referenced for performance reasons.

Column Name Type Description

ID

NUMBER

The primary key.

DAT

DATE

The date (midnight).

STRDAT

VARCHAR2 (10 BYTE)

The date as yyyy-mm-dd string.

7.2.5 HELP_HOURS

This table has one entry for hour (00–23). It is used and referenced for performance reasons.

Column Name Type Description

HOUR

NUMBER

The hour (0-based).

STRHOUR

VARCHAR2 (2 BYTE)

A String representing an hour (any value between 00 and 23).

7.2.6 HELP_ISP

This tables stores all available ISP in the Internet Service Provider report.

Column Name Type Description

ID

NUMBER

Primary key.

NAME

VARCHAR2(255)

Name of the ISP.

7.3 System Configuration and Maintenance Tables

Tables in this section are used to configure and maintain the system.

7.3.1 ACCESSRIGHT

This table defines access rights. A user gains access when one of its user groups has access to reports on the site.

Column Name Type Description

ID

NUMBER (12)

The primary key.

SITE

NUMBER (12)

Foreign key to the SITE table.

REPORT

NUMBER (12)

Foreign key to the REPORT table.

USERGROUP

NUMBER (12)

Foreign key to the USERGROUP table.

7.3.2 BROWSERGROUP

This table stores the names of browser groups. For example, group "Internet Explorer" includes Internet Explorer 6 and 7. Each browser is individually listed in the L2_BROWSER table.

Column Name Type Description

ID

NUMBER

The primary key.

NAME

VARCHAR2 (64 BYTE)

Name of the group.

Legal values: Any value up to 64 characters.

7.3.3 BROWSERIDENTIFICATION

This table is used to identify browsers based on the browser's agent string. If the agent string contains the pattern of an entry for this table, then the agent is assigned to the browser. If an agent string matches more than one record of this table, the record with the highest priority is taken.

Column Name Type Description

ID

INTEGER

The primary key.

BROWSERID

INTEGER

Foreign key to an L2_BROWSER record which assigns the agent to a browser if the pattern applies.

PATTERN

VARCHAR2 (50 BYTE)

The pattern to identify the browser with.

PRIORITY

INTEGER

The priority to use if an agent string applies to more than one record.

7.3.4 IP2COUNTRYCITY_BLOCKS

Reserved for internal use. This table stores information related to an IP address.

Column Name Type Description

IPFROM

NUMBER

Limit this information for addresses above this value.

IPTO

NUMBER

Limit this information for addresses below this value.

LOCATIONID

NUMBER

This column is not used.

COUNTRYID

NUMBER

Foreign key to a HELP_COUNTRY record for a given IP address.

CITYID

NUMBER

Foreign key to a HELP_CITY record for a given IP address.

REGIONID

NUMBER

Foreign key to a HELP_CITY record for a given IP address.

ISPID

NUMBER

Used for custom report development only.

7.3.5 IP2ISP_BLOCKS

This tables stores information related to an IP address.

Column Name Type Description

IPFROM

NUMBER

Limit this information for addresses above this value.

IPTO

NUMBER

Limit this information for addresses below this value.

ISPID

NUMBER

Foreign key to a HELP_ISP record to which the IP address belongs.

ISPNAME

VARCHAR2(255)

Internet Service Provider name.

7.3.6 IPQUICKLIST

This table caches information calculated from the IP2COUNTRYCITY_BLOCKS table for fast access.

Column Name Type Description

IP

NUMBER

The IP address the information is related to.

ISPID

NUMBER

Used for custom report development only.

REGIONID

NUMBER

Foreign key to a HELP_REGION record that the IP address belongs to.

CITYID

NUMBER

Foreign key to a HELP_CITY record that the IP address belongs to.

COUNTRYID

NUMBER

Foreign key to a HELP_COUNTRY record that the IP address belongs to.

7.3.7 ESAUSER

This table stores all valid users who are able to log in to Analytics.

Column Name Type Description

ID

NUMBER

The primary key.

USERNAME

VARCHAR2 (255 BYTE)

The username to log in.

FIRSTNAME

VARCHAR2 (255 BYTE)

First name of the user.

LASTNAME

VARCHAR2 (255 BYTE)

Fast name of the user.

PASSWORD

VARCHAR2 (255 BYTE)

Password of the user (md5hash).

DISABLED

NUMBER

Specifies whether the user account is disabled.

DELETED

NUMBER

Disables the account.

ISADMIN

NUMBER

Defines if the user is able to use the administrator's interface. Use 1 to allow this.

DEFAULTSITEID

NUMBER

Foreign key to a SITE record to use when the user logs in.

7.3.8 IP2COUNTRY

This table stores the IP to country mappings.

Column Name Type Description

IPFROM

NUMBER (16)

The start IP address of the mapping.

IPTO

NUMBER (16)

The end IP address of the mapping.

REGISTRY

VARCHAR2 (16 BYTE)

Reserved for internal use.

ASSIGNED

VARCHAR2 (16 BYTE)

Reserved for internal use.

CTRY

VARCHAR2 (16 BYTE)

Reserved for internal use.

CNTRY

VARCHAR2 (16 BYTE)

Reserved for internal use.

COUNTRY

VARCHAR2 (32 BYTE)

Foreign key to the HELP_COUNTRY table.

7.3.9 OBJECTTYPEGROUP

This table defines object type groups.

Column Name Type Description

ID

NUMBER

The primary key.

NAME

VARCHAR2 (64 BYTE)

Name of the object type group.

7.3.10 SETTING

This table stores various settings in a key=value schema, which are used by database jobs or other parts of the application.

Column Name Type Description

NAME

VARCHAR2 (255 BYTE)

Name of the setting.

VALUE

VARCHAR2 (255 BYTE)

Value of the setting.

ID

NUMBER

The primary key.

7.3.11 OSGROUP

This table stores the names of operating system groups. For example, group "Windows NT" contains Windows NT4, 2000, and XP. Each operating system is individually listed in the L2_OS table.

Column Name Type Description

ID

NUMBER

The primary key.

NAME

VARCHAR2 (64 BYTE)

Name of the group.

Legal values: Any string up to 64 characters.

ICONPATH

VARCHAR2 (64 BYTE)

Name and path of the icon shown in the "Operating Systems" report. This path is appended to the IMGPATH parameter which is defined in the global.xml configuration file.

7.3.12 OSIDENTIFICATION

This table is used to identify operating systems based on the browser's agent string. If the agent string contains the pattern of an entry in this table, the agent is assigned to the operating system. If an agent string matches more than one record in this table, the record with the highest priority is taken.

Column Name Type Description

ID

INTEGER

The primary key.

OSID

INTEGER

Foreign key to an L2_OS record to the operating system the agent is assigned to if the pattern applies.

PATTERN

VARCHAR2 (50 BYTE)

The pattern to identify the operating system.

PRIORITY

INTEGER

The priority to use if an agent string applies to more than one record.

7.3.13 REC_RECOMMENDATION

This table defines all recommendations for the Engage reports.

Column Name Type Description

ID

NUMBER (6)

The primary key.

NAME

VARCHAR2 (125 BYTE)

Name of the recommendation.

DELETED

NUMBER (1)

Marks the record as deleted. (0= false, 1= true).

SITEID

NUMBER (12)

Foreign key to the SITE table to match this recommendation to a site.

RECOMMENDATIONID

VARCHAR2 (21 BYTE)

The WebCenter Sites recommendation asset ID of this recommendation.

DISABLED

NUMBER (1)

Must be set to '0'. Reserved for internal use.

7.3.14 REC_SEGMENT

This table defines all segments for the Engage reports.

Column Name Type Description

ID

NUMBER (6)

The primary key.

NAME

VARCHAR2 (124 BYTE)

Name of the segment.

DELETED

NUMBER (1)

Mark this record as deleted. ('0'= False, '1'= True).

SITEID

NUMBER (12)

Foreign key to the SITE table, to match this segment to a site.

SEGMENTID

VARCHAR2 (21 BYTE)

The WebCenter Sites segment asset ID of this segment.

DISABLED

NUMBER (1)

Must be set to '0'. Reserved for internal use.

7.3.15 REPORT

Reports are defined in this table (one line per report).

Column Name Type Description

ID

NUMBER (12)

The primary key.

NAME

VARCHAR2 (256 BYTE)

Name of the report.

CONFIGPATH

VARCHAR2 (256 BYTE)

This points to the XML configuration file of the report that is relative to the REPORT_INSTDIR parameter in the global.xml configuration file.

7.3.16 REPORT2REPORTGROUP

This table stores the assignment of a report to its group in the report selection panel.

Column Name Type Description

ID

NUMBER (12)

The primary key.

REPORT

NUMBER (12)

Foreign key to the REPORT table.

REPORTGROUP

NUMBER (12)

Foreign key to the REPORTGROUP record.

7.3.17 REPORTGROUP

This table defines the report groups that are available in the report selection panel.

Column Name Type Description

ID

NUMBER (12)

The primary key.

NAME

VARCHAR2 (32 BYTE)

Name of the group.

PRIORITY

NUMBER

The priority of the group. If a report is assigned to more than one group, then the group with the highest priority is used by default.

7.3.18 REPORTPARAMETER

This table stores additional parameters to a report in a key=value schema.

Column Name Type Description

ID

NUMBER

The primary key.

NAME

VARCHAR2 (128 BYTE)

Name of the parameter.

VALUE

VARCHAR2 (128 BYTE)

Value of the parameter.

REPORTID

NUMBER

Foreign key to a REPORT record.

7.3.19 SEARCHENGINEGROUP

This table stores the names of search engine groups (for example, group "Google" contains google.com/.ca/.de). Each search engine is individually listed in the L2_SEARCHENGINE table.

Column Name Type Description

ID

NUMBER

The primary key.

NAME

VARCHAR2 (64 BYTE)

Name of the group.

Legal values: Any value up to 64 characters.

ICONPATH

VARCHAR2 (64 BYTE)

Name and path of the icon shown in the search engine report. This path is appended to the imgpath parameter defined in the global.xml configuration file.

7.3.20 SEARCHENGINEIDENT

This table is used to identify search engine referrers. If the referrer contains the pattern of an entry for this table, the session is assigned to the search engine. If a referrer's string matches more than one record in this table, the record with the highest priority is taken.

Column Name Type Description

ID

INTEGER

The primary key.

SEARCHENGINEID

INTEGER

Foreign key to an L2_SEARCHENGINE record for the search engine to which the session is assigned, if the pattern applies.

PRIORITY

INTEGER

The priority to use if a referrer string applies to more than one record.

PATTERN

VARCHAR2 (50 BYTE)

The pattern to identify the search engine.

7.3.21 SITE

This table stores all registered sites.

Column Name Type Description

ID

NUMBER

The primary key.

NAME

VARCHAR2 (64 BYTE)

Name of the site written exactly as collected from the image tag.

LINK

VARCHAR2 (256 BYTE)

URL of the site starting with http://. This URL will be used to link to the site from Analytics and to identify the internal referrer.

SCREENX

NUMBER

The screen width that the site is designed for. This is used for the "Screen Resolution" report.

SITEGROUPID

NUMBER

This column is used for custom reports only.

COUNTRYID

NUMBER

Foreign key to the HELP_COUNTRY record for the site.

STARTDATE

DATE

Stores the date when the site was registered with Analytics.

LONGNAME

VARCHAR2 (64 BYTE)

This is an optional, longer, more readable name for the site.

USERIDMETHOD

VARCHAR2 (64 BYTE)

Defines how to identify users.

DELETED

NUMBER (1)

This column is not used.

DISABLED

NUMBER (1)

This column is not used.

7.3.22 SITE2OBJECTTYPEGROUP

This table defines which object types are part of which object type group. This setting is site specific.

Column Name Type Description

ID

NUMBER

The primary key.

SITEID

NUMBER

Foreign key to a SITE record.

OBJECTTYPEGROUPID

NUMBER

Foreign key to the OBJECTTYPEGROUP table.

OBJECTTYPEID

NUMBER

Foreign key to an L2_OBJECTTYPE record.

7.3.23 SITEGROUP

This table is used by custom reports only.

Column Name Type Description

ID

NUMBER

The primary key.

NAME

VARCHAR2 (64 BYTE)

Name of the site group.

7.3.24 PI_SITEXOBJECTTYPE

This table defines whether the performance indicator is enabled for a site's object type.

Column Name Type Description

ID

NUMBER (21)

The primary key.

SITEID

NUMBER (21)

Foreign key to a SITE record.

OBJECTTYPEID

NUMBER (12)

Foreign key to an L2_OBJECTTYPE record.

ENABLE

NUMBER (1)

This defines if the performance indicator is enabled: '0' for false, '1' for true.

7.3.25 USER2USERGROUP

This table stores ESAUSER to USERGROUP relations.

Column Name Type Description

ID

NUMBER (12)

The primary key.

ESAUSER

NUMBER (12)

Foreign key to an ESAUSER record.

USERGROUP

NUMBER (1)

Foreign key to a USERGROUP record.

7.3.26 USERGROUP

This table defines user groups.

Column Name Type Description

ID

NUMBER (12)

The primary key.

NAME

VARCHAR (128 BYTE)

Name of the user group.

7.3.27 L2_BROWSER

This table stores information about all known browsers used by the "Browsers" report.

Column Name Type Description

ID

NUMBER (12)

The primary key.

NAME

VARCHAR2 (500 BYTE)

Name of the browser.

BROWSERGROUPID

NUMBER

Foreign key to the BROWSERGROUP table. Reserved for internal use.

ICONPATH

VARCHAR2 (64 BYTE)

Image path of the browser.

7.3.28 L2_GROUP

This table is used by custom reports only.

Column Name Type Description

ID

NUMBER

The primary key.

NAME

VARCHAR2 (255 BYTE)

Name of the group.

PATH

VARCHAR2 (1024 BYTE)

The path string of the group.

PARENTID

NUMBER

The parent node, which is the foreign key to the L2_GROUP table.

EDATE

DATE

Date when added.

SITEID

NUMBER

Foreign key to the SITE table.

7.3.29 L2_OBJECT

This table stores information about all objects (assets). This table is populated on demand by the "normalize" database job.

Column Name Type Description

ID

NUMBER (12)

The primary key.

OBJECTTYPEID

NUMBER (24)

Foreign key to the L2_OBJECTTYPE table.

NAME

VARCHAR2 (255 BYTE)

Name of the object (asset). This value will be updated as soon as it changes.

OBJECTID

VARCHAR2 (255 BYTE)

The identification string of the object. Usually this is the WebCenter Sites AssetID.

URL

VARCHAR2 (256 BYTE)

The URL to link to this object.

SITEID

NUMBER

Foreign key to the SITE table.

7.3.30 L2_OBJECTNAMEHISTORY

This table stores the previous names of the L2_OBJECT records.

Column Name Type Description

ID

NUMBER (12)

The primary key.

OBJECTID

NUMBER (24)

Foreign key to the L2_OBJECT table.

EDATE

DATE

The timestamp when the name was changed.

NAME

VARCHAR2 (255 BYTE)

The previous value.

7.3.31 L2_OBJECTTYPE

This table stores the names of all object types. These object types are referred to as "asset types" in WebCenter Sites.

Column Name Type Description

ID

NUMBER (12)

The primary key.

NAME

VARCHAR2 (128 BYTE)

Name of the object type.

DISABLED

NUMBER (1)

This column is not used.

DELETED

NUMBER (1)

This column is not used.

7.3.32 L2_OS

This table defines the operating systems in the "Operating Systems" report.

Column Name Type Description

ID

NUMBER (12)

The primary key.

NAME

VARCHAR2 (512 BYTE)

Name of the operating system.

OSGROUPID

NUMBER

Foreign key to the OSGROUP table.

7.3.33 L2_PIOBJECTTYPE

This table defines the sites and object types for which the performance indicator is enabled.

Column Name Type Description

SITEID

NUMBER

Foreign key to the site to enable the performance indicator.

OBJECTTYPEID

NUMBER

Foreign key to the L2_OBJECTTYPE table, to enable the performance indicator.

7.3.34 L2_SEARCHENGINE

This table stores information about search engines that are used by the "External Search Engines" report.

Column Name Type Description

ID

NUMBER (12)

The primary key.

NAME

VARCHAR2 (512 BYTE)

Name of the search engine.

SEARCHENGINEGROUPID

NUMBER

Foreign key to the SEARCHENGINEGROUP table.

KEY

VARCHAR2 (16 BYTE)

Name of the parameter.

7.3.35 L2_VISITOR

This table stores visitors.

Column Name Type Description

ID

NUMBER(12)

Primary key.

VISITORID

VARCHAR2(1024 BYTE)

Unique visitor identification string.

7.3.36 TASKSTATUSHISTORY

This table is used to maintain information about work packages as they are processed by the Hadoop-jobs scheduler.

Column Name Type Description

IDENTFIER

VARCHAR2(255)

Job name identifier.

ENDDATE

VARCHAR2(128)

Date and time job ended or failed.

INTERNALIDENTIFIER

VARCHAR2(255)

Internal Hadoop job ID.

STARTDATE

VARCHAR2(128)

Date and time job started.

STATUS

VARCHAR2(128)

Current status of the task.

TARGET

VARCHAR2(1024)

Target path of output data.

TYPE

VARCHAR2(128)

Type of job.

WORKPACKAGEPATH

VARCHAR2(1024)

Work package path.

7.3.37 HDFSAGENTSTATUSHISTORY

This table is used to maintain information about files moved from local file systems to HDFS for analytics processing.

Column Name Type Description

ID

VARCHAR2(256)

Identifier.

DESTFILENAME

VARCHAR2(1020)

Output raw work package file on HDFS.

ENDDATE

VARCHAR2(20)

End date.

IDENTIFIER

VARCHAR2(128)

Internal identifier.

FILESIZE

NUMBER

Size of the file.

SRCFILENAME

VARCHAR2(1020)

Source file taken from local file system.

STARTDATE

VARCHAR2(20)

Date when transfer started.

STATUSNR

NUMBER

Internal status code.

LOGTIMESTAMP

NUMBER

Timestamp when history registered.

7.3.38 DETAILDEFINITION

This table is used to identify URL parameters that can be used by the system. Unlisted parameters are ignored. This table is especially important if you are creating custom reports. You must enter tag-generated URL parameters into this table in order for the parameters to be retained for processing and reporting purposes.

Column Name Type Description

ID

NUMBER(12)

Primary key

NAME

VARCHAR2(64 BYTE)

Name of the parameter.

KEY

VARCHAR2(64 BYTE)

This column must have the same value as the name column.

OBJECTTYPEID

NUMBER

This field is deprecated.

SITEID

NUMBER

This field is deprecated.

TYPE

NUMBER

Type of DETAILDEFINITION entry.

GROUPFUNCTION

NVARCHAR2(12)

Only for L2_SESSIONDET (type 1): the value can be first, to use the first value of the session, last to use the last value, or all to use all values of the session.

AUTODEF

NUMBER

This field is deprecated.

7.4 Database Indexes

This section lists the Analytics database tables and index names.

Database Index Name Table Columns

ACCESSRIGHT_PK_IDX

ACCESSRIGHT

ID

IDX$$_55B10002

ACCESSRIGHT

SITE, REPORT

BROWSERGROUP_PK_IDX

BROWSERGROUP

ID

BROWSERIDENTIFICATION_PK_IDX

BROWSERIDENTIFICATION

ID

PK_USER

ESAUSER

ID

CITY_COUNTRYID_IDX

HELP_CITY

COUNTRYID

CITY_ID_IDX

HELP_CITY

ID

CITY_NAME_IDX

HELP_CITY

NAME

COUNTRY_CODE_IDX

HELP_COUNTRY

CODE

COUNTRY_ID_IDX

HELP_COUNTRY

ID

HELP_DATES_DAT_IDX

HELP_DATES

DAT

IDX$$_4C6E0002

HELP_DATES

ID

<AUTO GENERATED VALUE>

HELP_DATES

STRDAT

REGION_COUNTRYID_CODE_IDX

HELP_REGION

COUNTRYID, REGIONCODE

REGION_ID_IDX

HELP_REGION

ID

PK_IPQUICKLIST_IDX

IPQUICKLIST

IP

IP2COUNTRY_IPFROM_IDX

IP2COUNTRY

IPFROM

IP2COUNTRY_IPTO_IDX

IP2COUNTRY

IPTO

PK_IP2COUNTRYCITY_BLOCKS_IDX

IP2COUNTRYCITY_BLOCKS

IPTO,IPFROM

PK_L2_BROWSER

L2_BROWSER

ID

GROUP_ID_IDX

L2_GROUP

ID

L2_OBJECT_NAME_IDX

L2_OBJECT

NAME

L2_OBJECT_OBJECTID_IDX

L2_OBJECT

OBJECTID

L2_OBJECT_OBJECTTYPEID_IDX

L2_OBJECT

OBJECTTYPEID

PK_L2_OBJECT

L2_OBJECT

ID

L2_OJECTNH_OBJECTID_IDX

L2_OBJECTNAMEHISTORY

OBJECTID

PK_L2_OBJECTNAMEHISTORY

L2_OBJECTNAMEHISTORY

ID

L2_OBJECTTYPE_NAME_IDX

L2_OBJECTTYPE

NAME

PK_L2_OBJECTTYPE

L2_OBJECTTYPE

ID

INDEX PK_L2_OS

L2_OS

ID

IDX44_4BFF0003

L3_DATEXSITEXBROWSERXCOUNT

DATEID

L3_CITY_DATE_IDX

L3_DATEXSITEXCITYXCOUNT

DATEID

L3_COUNTRY_DATE_IDX

L3_DATEXSITEXCOUNTRYXCOUNT

DATEID

L3_DL_MIME_IDX

L3_DATEXSITEXDLXMIMEXCOUNT

DATEID

IDX$$_4BFF0005

L3_DATEXSITEXENTRYIDXCOUNT

DATEID

IDX$$_4C6D0001

L3_DATEXSITEXENTRYIDXCOUNT

SITEID

IDX$$_4BFF0006

L3_DATEXSITEXEXITIDXCOUNT

DATEID

IDX$$_4C6E0001

L3_DATEXSITEXEXITIDXCOUNT

SITEID

L3_GROUP_OI_IDX

L3_DATEXSITEXGROUPXOICOUNT

DATEID

L3_GROUP_SES_IDX

L3_DATEXSITEXGROUPXSESCOUNT

DATEID

L3_GROUP_VIS_DATE_IDX

L3_DATEXSITEXGROUPXVISCOUNT

DATEID

IDX$$_4BFF0007

L3_DATEXSITEXHOSTNAMEXCOUNT

DATEID

L3_ISP_DATE_IDX

L3_DATEXSITEXREGIONXCOUNT

DATEID

L3_JS_IDX

L3_DATEXSITEXJS

DATEID

IDX$$_4BFF0002

L3_DATEXSITEXOBJECTTYPEXCOUNT

DATEID

IDX$$_4BFF0001

CS_L3DATEXSITEXOBJXCOUNT

DATEID

IDX$$_4C1D0001

CS_L3DATEXSITEXOBJXCOUNT

OBJECTID

L3_DURATION_IDX

L3_DATEXSITEXOBJECTXDURATION

DATEID

L3_REGION_DATE_IDX

L3_MONTHXSITEXREGIONXCOUNT

DATEID

<AUTO GENERATED VALUE>

L3_DATEXSITEXSESSIONXQUANTIL

DATEID, SITEID

L3_CITY_MONTH_IDX

L3_MONTHXSITEXCITYXCOUNT

DATEID

L3_COUNTRY_MONTH-IDX

L3_MONTHXSITEXCOUNTRYXCOUNT

DATEID

L3_GROUP_VIS_MONTH_IDX

L3_MONTHXSITEXGROUPXVISCOUNT

DATEID

L3_REGION_MONTH_IDX

L3_MONTHXSITEXREGIONXCOUNT

DATEID

L3_CITY_WEEK_IDX

L3_WEEKXSITEXCITYXCOUNT

DATEID

L3_COUNTRY_WEEK_IDX

L3_WEEKXSITEXCOUNTRYXCOUNT

DATEID

L3_GROUP_VIS_WEEK_IDX

L3_WEEKXSITEXGROUPXVISCOUNT

DATEID

OSIDPRIM

OSIDENTIFICATION

ID

<AUTO GENERATED VALUE>

REC_L3_RECXSEGXCOUNT

DATEID, SEGID, RECID

<AUTO GENERATED VALUE>

REC_L3_RECXSEGXOBJXCOUNT

DATEID, SEGID, RECID, OBJID

PK_REC_RECOMMENDATION

REC_RECOMMENDATION

ID

<AUTO GENERATED VALUE>

REC_RECOMMENDATION

RECOMMENDATIONID

REC_RECOMMENDATION

REC_SEGMENT

ID

<AUTO GENERATED VALUE>

REC_SEGMENT

SEGMENTID

PK_REPORT

REPORT

ID

UNIQUE_REPORT_NAME

REPORT

NAME

PK_REPORTPARAMETER

REPORTPARAMETER

ID

UNIQUE_NAME_REPORTID

REPORTPARAMETER

REPORTID, NAME

PK_REPORT2REPORTGROUP

REPORT2REPORTGROUP

ID

PK_SETTING

SETTING

ID

PK_SITE

SITE

ID

<AUTO GENERATED VALUE>

SITE

NAME

PK_STATUSPARAMETER

PI_SITEXOBJECTTYPE

ID

<AUTO GENERATED VALUE>

PI_SITEXOBJECTTYPE

NAME

PK_USERGROUP

USERGROUP

ID

IDX$$_55B10001

USER2USERGROUP

ESAUSER

PK_USER2USERGROUP

USER2USERGROUP

ID