[This is pre-release documentation and subject to change in future releases. This topic's current status is: Milestone-Ready]

Topic Last Modified: 2010-03-26

The database schema consists of the following tables.

Supporting Tables

Table Description

UserAgent Table

Stores SIP User Agent (UA) strings and UA types used in audio and video sessions.

User Table

Stores user, conference, and phone URIs used in audio and video sessions.

Tenant Table

Stores tenant of users.

Endpoint Table

Stores FQDN computer names of endpoints participating in audio and video sessions.

Pool Table

Stores the names of pools to which metrics data belongs.

Device Table

Stores capture devices and render devices which are used in an audio/video calls.

DeviceDriver Table

Stores driver for capture device and render device which are used in audio/video calls.

Conference Table

Stores Conference URIs for conference scenarios, or DialogID for other scenarios.

SessionCorrelation Table

Stores CorrelationID for PSTN calls.

PayloadDescription Table

Stores the codec used in audio/video calls.

AppliedBandwidthSource Table

Stores the bandwidth source used in audio/video calls.

MacAddress Table

Stores the MAC address of the endpoints participating in audio and video sessions.

Dialog Table

Stores the Dialog ID of audio and video sessions.

Region Table

Stores the Region defined in NCS setting.

UserSite Table

Stores the NetworkSite defined in NCS setting.

Subnet Table

Stores the subnet defined in NCS setting.

MonitoredRegionLink Table

Stores the region link defined in NCS setting.

MonitoredUserSiteLink Table

Stores the network site links defined in NCS setting.

EndpointSubnet Table

Stores the subnet of the endpoint participating in audio and video session.

Server Table

Stores the FQDN or IP address of the server the media goes through.

Tables for metrics data

Table Description

Session Table

Stores overall information about an audio or audio/video session. A session is defined as an audio or video SIP dialog between two endpoints.

MediaLine Table

Stores information about each media line in a session. A media line is a collection of one or more audio and video streams. Typically, a single media line will have two streams, either audio or video.

AudioStream Table

Stores audio media quality metrics for each audio stream in the media line.

AudioSignal Table

Stores audio media quality metrics in the media line, this includes AEC and AGC metrics.

VideoStream Table

Stores video media quality metrics for each audio stream in the media line.

AudioClientEvent Table

Stores audio media quality metrics collected from client event.

VideoClientEvent Table

Stores video media quality metrics collected from client event.

DiagnosticData Table

Stores diagnostic data which is for internal use only.

Tables for summary data

Table Description

ServerSummary Table

Stores summary data for the servers, these data is used for QoE reporting only.

UserSummary Table

Stores summary data for users, these data is used for QoE reporting only.

CallTypeSummary Table

Store summary data for call types, these data is used for QoE reporting only.

Tables for Internal Use by Monitoring Server

Table Description

DbConfigDateTime

For internal use only.

DbConfigInt

For internal use only.

SummaryTableConfiguration

For internal use only.

DbErrorMessage

For internal use only.