Cisco Cisco Unified Customer Voice Portal 11.0(1) User Guide
C
HAPTER
4:
U
SER
M
ANAGEMENT
C
ISCO
CVP
V
OICE
XML
User Guide
User Data
The tables under this category are used to store information about the users in the system.
users
This table is the main user table. Each row contains the information for a single user. Both
demographic and account information are stored here. The table specification is as follows:
demographic and account information are stored here. The table specification is as follows:
Column
Type
Description
uid integer
(primary
key)
key)
This is a user ID automatically generated by the system to
identify a particular user. Once a call is associated with a
UID, the system knows the caller’s identity. The user
management system relies on this UID throughout.
identify a particular user. Once a call is associated with a
UID, the system knows the caller’s identity. The user
management system relies on this UID throughout.
external_uid
varchar(50)
If an external user management system is used in
conjunction with this one there must be a way to link a
user on the Cisco CVP VoiceXML system with one in the
external system. This column stores the ID for this user on
the external system to provide that link. Can be null if the
CVP VoiceXML user management system is used
exclusively.
conjunction with this one there must be a way to link a
user on the Cisco CVP VoiceXML system with one in the
external system. This column stores the ID for this user on
the external system to provide that link. Can be null if the
CVP VoiceXML user management system is used
exclusively.
account_created
datetime
This stores the time the user was added to the system. It
will always have a value.
will always have a value.
account_modified
datetime
This stores the time of the last update to this user in the
system. It will always have a value.
system. It will always have a value.
account_number
varchar(50)
Some voice applications identify users by account
numbers. If so, the account number should be stored here,
otherwise it can be null.
numbers. If so, the account number should be stored here,
otherwise it can be null.
pin
varchar(20)
If the voice application uses a PIN to verify the user, the
PIN is stored here. Null if no PIN is used or required.
PIN is stored here. Null if no PIN is used or required.
name
varchar(50)
The user’s name. Can be null.
birthday
varchar(50)
The user’s birthday. Can be null.
zip_code varchar(10)
The
user’s zip code. Can be null.
gender
varchar(10)
The user’s gender: “male”, “female”, or null if not stored.
social_security varchar(10)
The
social
security number of the user. Can be null.
country
varchar(50)
The user’s full country name. Can be null.
language
varchar(50)
The language the user speaks or prefers. This can be used
to provide audio content in different languages. Can be
null.
to provide audio content in different languages. Can be
null.
custom1-custom4 varchar(200) These
columns
are provided to allow the developer to
place custom user-related data in the system. It can be
used for such data as e-mail addresses, financial account
used for such data as e-mail addresses, financial account
©2000 - 2005 Audium Corporation. All Rights Reserved. 1/14/05
60