Cisco Cisco Unified Customer Voice Portal 10.0(1) Guía Del Usuario
C
HAPTER
4:
U
SER
M
ANAGEMENT
U
SER
G
UIDE FOR
C
ISCO
U
NIFIED
C
ALL
S
ERVICES
,
U
NIVERSAL
E
DITION
AND
U
NIFIED
C
ALL
S
TUDIO
89
balances, proprietary IDs, etc. Can be null.
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)
(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 Call Services 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 Call Services 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.