User`s guide

SFVRA Connection Manager 201
SQL D ATABASE S CRIPT D EFINITIONS
SFVRA Database Tables
NUMBER_TYPE
Defines the type of number for the User. Refer to the Number Type options table below to translate
the number type codes.
CALLNUMBER
The number.
IP_POOL
Entries are created in this table by the Client interface when the IP Address Pool is enabled for a
CyberSWITCH.
SERVER_NAME
The CyberSWITCH to which the IP address belongs.
IP_ADDR
The IP address in the pool currently being used by USER_NAME.
USER_NAME
The user that is using the IP address from the pool. If NULL, then the address is not in use and
SFVRA-CONN may assign the number to a user when a call is initiated between the CyberSWITCH
and a user that has the ASSIGN_IP_ADDR field of the USER_ACCESS table set to true.
STATIC_IP_ROUTES
Entries are created in this table by the Client interface when a user has IP static routes configured.
USER_NAME
The user to which this static route belongs.
DEST_SUBNET
The destination subnet of the static route.
SUBNET_MASK
The subnet mask of the static route.
METRIC
The metric value of the static route.
Code Number Type Options
1 Telephone Number
2 Calling Line ID