QPR Knowledge Base 2017.1

QPR UMS Database Tables

QPR UMS Database Tables

Previous topic Next topic No directory for this topic  

QPR UMS Database Tables

Previous topic Next topic Topic directory requires JavaScript Mail us feedback on this topic!  

The QPR User Management System uses a common QPR Database for the user authentication of QPR products. This database also contains the QPR Portal database tables. Fields marked with (*) are key fields.

 

Database Table Structure

 

QPRUM_USER

Field name

Field type

Description

USE_ID

NUMBER NOT NULL (*)

User's id

USE_LOGIN_NAME

VARCHAR2(255) NOT NULL

User's login name

USE_PASSWORD

VARCHAR2(50) NOT NULL

User's encrypted password

USE_FULL_NAME

VARCHAR2(255)

User's full name

USE_EMAIL

VARCHAR2(255)

User's email address

USE_TELEPHONE

VARCHAR2(50)

User's telephone number

USE_DESC

VARCHAR2(2000)

User's description

USE_IS_GROUP

NUMBER NOT NULL

0 for normal user, 1 for group

USE_PRODUCT_RIGHTS_METHOD

NUMBER

1 for group settings 2 for system admin 4 for user specific settings

USE_PRODUCT_RIGHTS

VARCHAR2(50) NOT NULL

Comma-separated list of product rights: <Metrics>,<Modeling>, <Portal>,<User management> - Values: -1 = no access, 0 = view/basic, 1 = update, 2 = administrate

USE_LICENSES

VARCHAR2(50) NOT NULL

Comma-separated list of licenses, <Inherit licenses from groups>,<Metrics user>,<Metrics viewer>,<EA user>,<PD user>,<Modeling viewer> - Values: 0 = off, 1 = on

USE_CREATED

DATE

Time when this user was created

USE_MODIFIED

DATE

Time when this user was last modified

When the user management database tables are created, one default user (with the login name 'qpr' and the password 'demo') is created with administrative rights to all products (QPR Metrics, QPR Modeling Client, QPR Portal and QPR User Management Client) to the QPRUM_USER table.

 

QPRUM_USER_GROUP

Field name

Field type

Description

USG_USE_ID

NUMBER NOT NULL (*)

User's id

USG_GROUP_ID

NUMBER NOT NULL (*)

Group's id

 

 

QPRUM_APP_DATA

Field name

Field type

Description

UAD_USER_ID

NUMBER NOT NULL (*)

User's id

UAD_PRODUCT

NUMBER NOT NULL (*)

Product's id

UAD_KEY

VARCHAR2(50) NOT NULL (*)

Application-specific key that identifies the data

UAD_DATA

Text

Application specific data

This table contains miscellaneous information the applications can store to user management component, like user authentication method (QPR, LDAP, NT) and last portal login time.        

 

 

QPRUM_PARAM_DATA

Field name

Field type

Description

UPD_KEY

VARCHAR2(50) NOT NULL (*)

Key to the data

UPD_DATA

VARCHAR2(2000)

Data

This table contains miscellaneous information like database version and first available id number for a new user.

 

 

QPRUM_ASSOCIATION

Field name

Field type

Description

QPAS_ID

NUMBER NOT NULL (*)

Action ID

QPAS_CREATOR_USER_ID

NUMBER NOT NULL

Action creator's ID

QPAS_CREATION_DATE

DATE

Time when action was created

QPAS_LAST_MODIFICATION_DATE

DATE

Time when action was last edited.

QPAS_TYPE

NUMBER NOT NULL

Type of the action. These correspond to DatabaseId settings for action types in actiontypes.ini

QPAS_HEADER

VARCHAR2(255)

Action's header/name

QPAS_DESCRIPTION

LONG

Action's description

QPAS_VISIBILITY_TYPE

NUMBER

Used to identify for whom the action is published to. Supported values are:

 

0 = Creator

1 = Parent element users

2 = Selected users

3 = All

This table contains the QPR Portal action information.

 

 

QPRUM_ASSOCIATION_ATTRIBUTE

Field name

Field type

Description

QPAAT_ASSOCIATION_ID

NUMBER NOT NULL (*)

Action ID

QPAAT_ATTRIBUTE_ID

NUMBER NOT NULL (*)

Attribute ID

QPAAT_FRAGMENT_ID

NUMBER NOT NULL (*)

Fragment ID (for attributes that don't fit into a single row in DB)

QPAAT_INTEGER_VALUE

NUMBER

Integer value

QPAAT_FLOAT_VALUE

NUMBER

Floating point value (decimal)

QPAAT_STRING_VALUE

Text

String value

QPAAT_SHORT_STRING_VALUE

VARCHAR2(255)

Short string value

QPAAT_DATETIME_VALUE

DATE

Date time value

QPAAT_USER_ID_VALUE

NUMBER

Number value

QPAAT_BLOB_VALUE

BLOB

Binary blob value

QPAAT_OBJECT_ID_VALUE

NUMBER

Object reference value

This table contains the action's attribute values.