Cisco Cisco Customer Voice Portal Downloads 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
87
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 Unified CVP 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
Unified CVP user management system is used
exclusively.
conjunction with this one there must be a way to link a
user on the Unified CVP 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
Unified CVP 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
balances, proprietary IDs, etc. Can be null.
place custom user-related data in the system. It can be
used for such data as e-mail addresses, financial account
balances, proprietary IDs, etc. Can be null.