The NC_Software table contains inventory data about software.
|
Column |
Key |
Type |
Null |
Description |
|---|---|---|---|---|
|
ComponentOID |
PK, FK |
binary(16) |
No |
An internal ID number used as a primary key. |
|
Path |
|
nvarchar(255) |
|
The path to the folder where the software resides. |
|
AdditionalInfo |
|
nvarchar(200) |
|
Additional information about the software, for example, the date of a virus definition. |
|
ParentSuiteOID |
|
binary(16) |
Yes |
Link from a suite component to the parent suite product. |
NOTE:
FK references:
FK_SW_CompOID: ComponentOID references NC_Component.ComponentOID
FK_SW_ParentSuiteOID: ParentSuiteOID references NC_Software.ComponentOID
Indexes:
IDX_SW_ParentSuiteOID: ParentSuiteOID