User`s guide

SFVRA Connection Manager 215
SQL D ATABASE S CRIPT D EFINITIONS
SFVRA Database Tables
CATEGORY_NAME
A string created by the administrators of SFVRA-CONN’s Client interface to do their own
categorizing.
USER_INFO
Entries are created in this table by the Client interface for every User configured.
Note: For every entry in the USER_INFO table there must be a corresponding entry in the
USER_ACCESS table.
USER_NAME
A string used to uniquely identify a User.
NAME_LAST
Identifies a responsible person for the User. The SFVRA Service does not use this information.
NAME_FIRST
Identifies a responsible person for the User. The SFVRA Service does not use this information.
ADDR1
Identifies the address of a responsible person for the User. The SFVRA Service does not use this
information.
ADDR2
Identifies the address of a responsible person for the User. The SFVRA Service does not use this
information.
POST_CODE
Identifies the ZIP code of a responsible person for the User. The SFVRA Service does not use this
information.
CITY
Identifies the city of a responsible person for the User. The SFVRA Service does not use this
information.
STATE
Identifies the state of a responsible person for the User. The SFVRA Service does not use this
information.
COUNTRY
Identifies the country of a responsible person for the User. The SFVRA Service does not use this
information.
TELEPHONE1
Identifies a telephone number of a responsible person for the User. The SFVRA Service does not use
this information.
TELEPHONE2
Identifies a telephone number of a responsible person for the User. The SFVRA Service does not use
this information.