Cisco Cisco Unified Customer Voice Portal 11.0(1) Release Note
C
HAPTER
4:
U
SER
M
ANAGEMENT
U
SER
G
UIDE FOR
C
ISCO
U
NIFIED
CVP
VXML
S
ERVER
AND
C
ISCO
U
NIFIED
C
ALL
S
TUDIO
88
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 VXML 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 VXML 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.