The NC_Component table contains information about hardware and software components.
|
Column |
Key |
Type |
Null |
Description |
|---|---|---|---|---|
|
ComponentOID |
PK |
binary(16) |
No |
An internal ID number used as a primary key. |
|
WorkstationOID |
FK |
binary(16) |
No |
The workstation with which the component is associated. |
|
ProductOID |
FK |
binary(16) |
No |
The product as identified by the Collector. |
|
ProductAlias |
FK |
binary(16) |
No |
The product as edited by the user. |
|
ProductType |
|
smallint |
No |
The product type. See "Notes" in "NC_Product Table." |
|
Collector |
|
smallint |
|
The list is:
|
|
Source |
|
smallint |
|
The source of the component:
|
|
SerialNumber |
|
nvarchar(38) |
|
The serial number as discovered by the Collector. |
|
AssetTag |
|
nvarchar(38) |
|
The asset tag as discovered by the Collector. |
|
SerialNumberAlias |
|
nvarchar(38) |
|
The serial number as provided by the user. |
|
AssetTagAlias |
|
nvarchar(38) |
|
The asset tag as provided by the user. |
|
ModelNumber |
|
nvarchar(32) |
|
The model number. |
|
CreateDate |
|
DateTime |
No |
The date the component was first discovered. |
|
DateLastModified |
|
DateTime |
No |
The date the component was last changed. |
|
IsDeleted |
|
DateTime |
|
The date and time the record was deleted; else null. |
|
ExcludedNonColl |
|
Tinyint |
Yes |
0 |
|
ADF0 |
|
nvarchar(256) |
|
Description of "Administrator Defined Field 0" |
|
ADF1 |
|
nvarchar(256) |
|
Description of "Administrator Defined Field 1" |
|
ADF2 |
|
nvarchar(64) |
|
Description of "Administrator Defined Field 2" |
|
ADF3 |
|
nvarchar(64) |
|
Description of "Administrator Defined Field 3" |
|
ADF4 |
|
nvarchar(64) |
|
Description of "Administrator Defined Field 4" |
|
ADF5 |
|
nvarchar(64) |
|
Description of "Administrator Defined Field 5" |
|
ADF6 |
|
nvarchar(64) |
|
Description of "Administrator Defined Field 6" |
|
ADF7 |
|
nvarchar(64) |
|
Description of "Administrator Defined Field 7" |
|
ADF8 |
|
nvarchar(64) |
|
Description of "Administrator Defined Field 8" |
|
ADF9 |
|
nvarchar(64) |
|
Description of "Administrator Defined Field 9" |
|
ADF10 |
|
nvarchar(64) |
|
Description of "Administrator Defined Field 10" |
|
ADF11 |
|
nvarchar(64) |
|
Description of "Administrator Defined Field 11" |
|
ADF12 |
|
nvarchar(64) |
|
Description of "Administrator Defined Field 12" |
|
ADF13 |
|
nvarchar(64) |
|
Description of "Administrator Defined Field 13" |
|
ADF14 |
|
nvarchar(64) |
|
Description of "Administrator Defined Field 14" |
|
ADF15 |
|
nvarchar(64) |
|
Description of "Administrator Defined Field 15" |
|
ADF16 |
|
nvarchar(64) |
|
Description of "Administrator Defined Field 16" |
|
ADF17 |
|
nvarchar(64) |
|
Description of "Administrator Defined Field 17" |
|
ADF18 |
|
nvarchar(64) |
|
Description of "Administrator Defined Field 18" |
|
ADF19 |
|
nvarchar(64) |
|
Description of "Administrator Defined Field 19" |
|
IsRetired |
|
DateTime |
|
The date and time the record was retired; else null. |
NOTE:
ProductType: See note 1 within NC_Product Table
FK references:
FK_Comp_WkstnOID: WorkstationOID references NC_Workstation.WorkstationOID
FK_Comp_ProductOID: ProductOID references NC_Product.ProductOID
FK_Comp_ProductAlias: ProductAlias references NC_Product.ProductOID
Indexes:
IDX_Comp_WkstnOID: WorkstationOID (nonclustered)
IDX_Comp_ProdOID: ProductOID
IDX_Comp_ProdAlias: ProductAlias
NOTE:The NC_Component is a view which is a union of all Component tables like NC_BiosComp, NC_CDRomComp, NC_HotfixComp and so forth.