| Table slot9.WORLD.TSTA.IJIS_USER_PROFILE_ROLES This table stores the roles that a particular user has. This table is populated under the security table of a user's profile
|
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Analyzed at Mon Sep 20 21:05 MDT 2021 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Requirements (check constraints):
| Constraint | Constraint Name |
|---|---|
| "LOGIN_ID" IS NOT NULL | IUPR_LOGIN_ID_NN |
| "ROLE_NAME" IS NOT NULL | IUPR_ROLE_NAME_NN |
Indexes:
| Column(s) | Type | Sort | Constraint Name |
|---|---|---|---|
| LOGIN_ID + ROLE_NAME | Primary key | Asc/Asc | IUPR_PK |
| LOGIN_ID | Performance | Asc | IUPR_IUP_FK_I |
| ROLE_NAME | Performance | Asc | IUPR_RS_FK_I |
| Performance | IUPR_UPPERTRIM_FNCBAS_I | ||
| Performance | IUPR_UPPERTRIM_ROL_FNCBAS_I |
|