SoftwareItemRbacUser
M:n relation between SoftwareItem and RbacUser for items that are linked to specific RBAC users.
erDiagram
RbacUser ||--o{ SoftwareItemRbacUser : "RbacUserID"
SoftwareItem ||--o{ SoftwareItemRbacUser : "SoftwareItemID"
SoftwareItemAssignmentReason ||--o{ SoftwareItemRbacUser : "SoftwareItemAssignmentReasonID"
Fields
| Field |
Type |
Description |
| Created |
datetime |
Date/Time this relation between a software item and an RBAC user was created |
| CreatedBy |
string |
User that created this relation |
| ExtraData |
string |
An optional JSON document that can hold extra data for this SoftwareItemRbacUser relation |
| ID |
numeric |
Internal ID for the SoftwareItemRbacUser entity (Primary Key) |
| LastModification |
datetime |
Date/Time this relation was last modified |
| LastModifiedBy |
string |
User that last modified this relation |
| RbacUserID |
numeric |
Internal ID that references the RbacUser entity (Foreign Key) |
| SoftwareItemAssignmentReasonID |
numeric |
Internal ID that references the SoftwareItemAssignmentReason entity (Foreign Key) |
| SoftwareItemID |
numeric |
Internal ID that references the SoftwareItem entity (Foreign Key) |
References
| Column Name |
Referenced Table |
Description |
| RbacUserID |
RbacUser |
User object for RBAC. Typically replicated from Active Directory. |
| SoftwareItemAssignmentReasonID |
SoftwareItemAssignmentReason |
Defines reasons why a software item is assigned to a user, group or machine |
| SoftwareItemID |
SoftwareItem |
Software items hold customer specific information about software objects |