Data Dictionary
>
FPSAPP Tables
> FPSAPP.APP_W_USERS_ROLES
Table FPSAPP.APP_W_USERS_ROLES"
app_W_USERS_ROLES table used to store role information for each user
-
Schema: FPSAPP
-
Tablespace: FPSDATA
-
Primary key: APP_NAME, ROLE_NAME, USER_ID
-
Foreign keys: APP_W_USERS_ROLES_FK_ROLES: APP_NAME, ROLE_ID REFERENCES FPSAPP.APP_G_ROLES (APP_NAME, ROLE_ID)
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
APP_NAME |
VARCHAR2(50) |
N |
|
|
ROLE_NAME |
VARCHAR2(100) |
N |
This is used to define the role name. |
|
USER_ID |
VARCHAR2(50) |
N |
The user Id that initiated the last move of this carrier (* from FPSINPUT.MHS_CARRIERS) |
|
IS_AUTHORIZED |
CHAR(1) |