SoftwareItemUser
M:n relation between SoftwareItem and User for items that are linked to specific users.
erDiagram
SoftwareItem ||--o{ SoftwareItemUser : "SoftwareItemID"
SoftwareItemAssignmentReason ||--o{ SoftwareItemUser : "SoftwareItemAssignmentReasonID"
User ||--o{ SoftwareItemUser : "UserID"
Fields
| Field |
Type |
Description |
| Created |
datetime |
Date/Time this relation was created |
| CreatedBy |
string |
User that created the relation |
| ExtraData |
string |
Additional data for the SoftwareItemUser relation (JSON format) |
| ID |
numeric |
Internal ID for the SoftwareItemUser entity (Primary Key) |
| LastModification |
datetime |
Date/Time this relation was last updated |
| LastModifiedBy |
string |
User that last modified the relation |
| Res1 |
string |
Reserved for future use |
| Res2 |
string |
Reserved for future use |
| SoftwareItemAssignmentReasonID |
numeric |
Internal ID that references the SoftwareItemAssignmentReason entity (Foreign Key) |
| SoftwareItemID |
numeric |
Internal ID that references the SoftwareItem entity (Foreign Key) |
| UserID |
numeric |
Internal ID that references the User entity (Foreign Key) |
References
| Column Name |
Referenced Table |
Description |
| 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 |
| UserID |
User |
Basic user Information |