SoftwareItemOrganization
M:n SoftwareItem to Organization relation for Items that are linked to specific organizations.
erDiagram
Organization ||--o{ SoftwareItemOrganization : "OrganizationID"
SoftwareItem ||--o{ SoftwareItemOrganization : "SoftwareItemID"
SoftwareItemAssignmentReason ||--o{ SoftwareItemOrganization : "SoftwareItemAssignmentReasonID"
Fields
| Field |
Type |
Description |
| ExtraData |
string |
Extra data for the SoftwareItemOrganization relation (JSON forma) |
| ID |
numeric |
Internal ID for the SoftwareItemOrganization entity (Primary Key) |
| MachineEntitled |
boolean |
True if machines of the organizations are entitled |
| OrganizationID |
numeric |
Internal ID that references the Organization 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) |
| UserEntitled |
boolean |
True if users of the organization are entitled |
| Visible |
boolean |
Reserved for future use |
References
| Column Name |
Referenced Table |
Description |
| OrganizationID |
Organization |
Defines the organizations of this OctoSAM installation |
| 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 |