SoftwareItemSoftwarePackage
M:n relation between SoftwareItem and SoftwarePackage, curently only 1:n is used.
erDiagram
SoftwareItem ||--o{ SoftwareItemSoftwarePackage : "SoftwareItemID"
SoftwarePackage ||--o{ SoftwareItemSoftwarePackage : "SoftwarePackageID"
Fields
| Field |
Type |
Description |
| Created |
datetime |
Date/Time this entity was created |
| CreatedBy |
string |
User who created this entity |
| ID |
numeric |
Internal ID for the SoftwareItemSoftwarePackage entity (Primary Key) |
| SoftwareItemID |
numeric |
Internal ID that references the SoftwareItem entity (Foreign Key) |
| SoftwarePackageID |
numeric |
Internal ID that references the SoftwarePackage entity (Foreign Key) |
References
| Column Name |
Referenced Table |
Description |
| SoftwareItemID |
SoftwareItem |
Software items hold customer specific information about software objects |
| SoftwarePackageID |
SoftwarePackage |
A software package defines a logical software entity. A software package can own 0 to n software signatures. |