SoftwareItemGroup
Relation between SoftwareItem and Group entities.
erDiagram
Group ||--o{ SoftwareItemGroup : "GroupID"
SoftwareItem ||--o{ SoftwareItemGroup : "SoftwareItemID"
SoftwareItemAssignmentReason ||--o{ SoftwareItemGroup : "SoftwareItemAssignmentReasonID"
Fields
| Field |
Type |
Description |
| Created |
datetime |
Date/Time this entity was created in the database |
| CreatedBy |
string |
User that created this entity |
| ExtraData |
string |
An optional JSON document that can hold extra data for this SoftwareItemGroup relation |
| GroupID |
numeric |
Internal ID that references the Group entity (Foreign Key) |
| ID |
numeric |
Internal ID for the SoftwareItemGroup entity (Primary Key) |
| LastModification |
datetime |
Date/Time this entity was last modified |
| LastModifiedBy |
string |
User that last modified this entity |
| 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) |
References
| Column Name |
Referenced Table |
Description |
| GroupID |
Group |
Group of users or machines |
| 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 |