The NC_SystemBoard table contains inventory data about system boards.
|
Column |
Key |
Type |
Null |
Description |
|---|---|---|---|---|
|
ComponentOID |
PK, FK |
binary(16) |
No |
An internal ID number used as a primary key. |
|
Revision |
nvarchar(32) |
The motherboard version. |
||
|
Bus1type |
smallint |
The first bus type: 0=unknown, 1=ISA, 2=PCI, 3=MCA, 4=EISA, 5=PCMCIA, 6=VL. |
||
|
Bus1slots |
smallint |
The number of slots for the first bus. |
||
|
Bus2type |
smallint |
The second bus type: 0=unknown, 1=ISA, 2=PCI, 3=MCA, 4=EISA, 5=PCMCIA, 6=VL. |
||
|
Bus2slots |
smallint |
The number of slots for the second bus. |
||
|
L2CacheSize |
smallint |
The size of the L2 cache. |
||
|
L2CacheSpeed |
smallint |
The access time of the L2 cache in nanoseconds. |
||
|
L2CacheWritePolicy |
smallint |
The write policy of the L2 cache: 0=unknown, 1=write back, 2=write through, 3=write variable. |
||
|
SystemBoardId |
nvarchar(64) |
The identification of the system board. |
||
|
MotherboardUID |
binary(16) |
The identification of the mother board. |
NOTE:The ComponentOID foreign key references the ComponentOID primary key column of the NC_Component table.