QPR UMS Database Tables |
|
|
|
QPR UMS Database Tables |
|
|
QPR UMS Database Tables |
|
|
|
QPR UMS Database Tables |
|
|
|
|
||
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_PERMISSIONS |
NUMBER |
1 for group settings 2 for system admin 4 for user specific settings |
USE_CREATED |
DATE |
Time when this user was created |
USE_MODIFIED |
DATE |
Time when this user was last modified |
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 |
LONG |
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_PRODUCT_INFO
Field name |
Field type |
Description |
|---|---|---|
UPI_USER_ID |
NUMBER NOT NULL (*) |
user's id |
UPI_PRODUCT_ID |
NUMBER NOT NULL (*) |
Product's id |
UPI_WEBCLIENT_USER |
NUMBER NOT NULL |
0 = user is disabled to product's web client 1 = user is enabled to product's web client |
UPI_DEVCLIENT_USER |
NUMBER NOT NULL |
0 = user is disabled to product's dev client 1 = user is enabled to product's dev client |
UPI_ENABLED |
NUMBER NOT NULL |
0 = user is disabled both to product's web AND dev client. 1 = user is enabled to product's web OR dev client. |
UPI_ACCESS_RIGHT |
NUMBER NOT NULL |
0 = view rights to product 1 = update rights to product 2 = administrate rights to product |
This table is used to store product specific permissions for users.
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).
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 |
LONG |
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.