Cisco Cisco Customer Voice Portal 8.0(1) User Guide
C
HAPTER
4:
U
SER
M
ANAGEMENT
V
OICE
XML
S
ERVER
U
SER
G
UIDE
FOR
C
ISCO
U
NIFIED
C
USTOMER
V
OICE
P
ORTAL
R
ELEASE
4.0(1)
58
user_phone
This table is an adjunct to the main user table. It is used to store the phone numbers associated
with the user. The reason this data is placed in a separate table is to allow an application to
associate more than one phone number with a user. For example, a voice application allowing a
user to associate with their account both their home and work numbers can automatically
recognize who the caller is when calls are received from either number, rather than requiring
them to log in. If multiple phone numbers are not required or necessary, this table can contain
one entry per account or remain empty. Since there may be multiple rows in the system with the
same UID, there is no primary key to this table. The table specification is as follows:
with the user. The reason this data is placed in a separate table is to allow an application to
associate more than one phone number with a user. For example, a voice application allowing a
user to associate with their account both their home and work numbers can automatically
recognize who the caller is when calls are received from either number, rather than requiring
them to log in. If multiple phone numbers are not required or necessary, this table can contain
one entry per account or remain empty. Since there may be multiple rows in the system with the
same UID, there is no primary key to this table. The table specification is as follows:
Column
Type
Description
phone
varchar(10)
A phone number to associate with this account.
uid integer
(foreign key)
The UID identifying the user.
users_by_ani
This table is used to track calls made from specific phone numbers (ANIs). This table is
automatically updated by Unified CVP VoiceXML Server and need only be queried by the
developer when information about a caller is desired. The table contains information about the
number of calls and the last call made from a phone number. This information can be used to
welcome a caller back to the application or warn that menu options have changed since their last
call even if the application itself is not set up to track individual users through logins. The table
specification is as follows:
automatically updated by Unified CVP VoiceXML Server and need only be queried by the
developer when information about a caller is desired. The table contains information about the
number of calls and the last call made from a phone number. This information can be used to
welcome a caller back to the application or warn that menu options have changed since their last
call even if the application itself is not set up to track individual users through logins. The table
specification is as follows:
Column
Type
Description
ani
varchar(10)
The phone number of the caller.
app_id
integer
The application the caller called into. This exists in case
multiple applications share a common user management
system.
multiple applications share a common user management
system.
call_count
integer
The number of calls received by this phone number to
this application.
this application.
last_call
datetime
The last time a call was received by this phone number to
this application.
this application.