Cisco Cisco Unified Customer Voice Portal 11.0(1)

Page of 96
Description
Index
Null
Type
Field
Minor version
Yes (Composite index
MajorVersion,
MinorVersion)
No
varchar(20)
MinorVersion
The date and time
when the record is
updated
No
No
datetime
UpdateDateTime
CVPLog Table
Description
Index
Null
Type
Field
Date and time of
message
No
Yes
datetime
MessageDateTime
Message details
No
Yes
varchar(255)
Message
Type of message: Add,
Aged Off, Alter, Err
Yes
Yes
char(8)
MessageClass
Info, Remainder,
EPurge
CVPPartitionInfo Table
Description
Index
Null
Type
Field
Name of the table
Yes (Composite index
TableName, PartDate)
No
varchar(32)
TableName
Date of the data in
partition
Yes (Composite index
TableName, PartDate)
No
date
PartDate
Name of the partition
No
No
char(12)
PartName
The date and time that
the partition was
created
No
No
datetime
DBDateTime
CVPPartitionParameters Table
Description
Index
Null
Type
Field
Usable data size in GB
No
No
int
DBSize
Percent of space to
keep free in the DB
space
No
No
float
PCTFree
Planned growth factor,
used to determine sizes
for future table extents
No
No
float
Bump
Reporting Guide for Cisco Unified Customer Voice Portal Release 4.1(1)
62
Chapter 5: - Introduction to the Database Schema
Table Definitions