User`s guide
SFVRA Connection Manager 217
SQL D
ATABASE
S
CRIPT
D
EFINITIONS
SFVRA Database Tables
CONNECTTYPE_ID
The type of connection for the User as referenced in the USER_CONNECTTYPES table.
USER_AUTHENTICATIONS
This table is currently not in use by the current version of the SFVRA Service or the Client interface
and will be removed at a later date. The inclusion of this table is necessary for backward
compatibility.
AUTHENTICATION_ID
AUTHENTICATION_ID is not currently supported.
AUTHENTICATION_NAME
AUTHENTICATION_NAME is not currently supported.
USER_CONNECTTYPES
Entries are created in this table when the database is installed or upgraded.
CONNECTTYPE_ID
A unique number used to identify the type of connection to make to a User. Refer to the Connection
Type options table below to translate the connection type codes.
CONNECTTYPE_NAME
A string representation of the ID type.
USER_LAYER2
This table is currently not in use by the current version of the SFVRA Service or the Client interface
and will be removed at a later date. The inclusion of this table is necessary for backward
compatibility.
LAYER2_ID
LAYER2_ID is not currently supported.
LAYER2_NAME
LAYER2_NAME is not currently supported.
USER_CALLDIRECTIONS
Entries are created in this table when the database is installed or upgraded.
CALLDIRECTION_ID
A unique number used to identify the direction of the call with a User.
CALLDIRECTION_NAME
A string representation of the ID.