Cisco Cisco Customer Voice Portal 8.0(1) Guida Utente

User Data

The tables under this category are used to store information about the users in the system.

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:

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

integer (primary key)

uid

knows the caller’s identity. The user management system relies on
this UID throughout.

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

varchar(50)

external_uid

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.

This stores the time the user was added to the system. It will always
have a value.

datetime

account_created

This stores the time of the last update to this user in the system. It
will always have a value.

datetime

account_modified

Some voice applications identify users by account numbers. If so,
the account number should be stored here, otherwise it can be null.

varchar(50)

account_number

If the voice application uses a PIN to verify the user, the PIN is stored
here. Null if no PIN is used or required.

varchar(20)

pin

The user’s name. Can be null.

varchar(50)

name

The user’s birthday. Can be null.

varchar(50)

birthday

The user’s zip code. Can be null.

varchar(10)

zip_code

The user’s gender: male, female, or null if not stored.

varchar(10)

gender

The social security number of the user. Can be null.

varchar(10)

social_security

The user’s full country name. Can be null.

varchar(50)

country

The language the user speaks or prefers. This can be used to provide
audio content in different languages. Can be null.

varchar(50)

language

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

varchar(200)

custom1-custom4

addresses, financial account balances, proprietary IDs, and so on.
Can be null.

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

User Guide for Cisco Unified CVP VXML Server and Cisco Unified Call Studio Release 8.0(1)