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.
