2.41 NC_SystemBoard Table

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.