2.39 NC_Software Table

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:

  1. FK_SW_CompOID: ComponentOID references NC_Component.ComponentOID

  2. FK_SW_ParentSuiteOID: ParentSuiteOID references NC_Software.ComponentOID

Indexes:

  • IDX_SW_ParentSuiteOID: ParentSuiteOID