2.20 NC_MemoryModule Table

The NC_MemoryModule table contains inventory data about memory.

Column

Key

Type

Null

Description

ComponentOID

PK, FK

binary(16)

No

An internal ID number used as a primary key.

MemoryType

smallint

No

The type of memory: 0=Other, 1=Unknown, 2=Standard, 3=Fast page mode, 4=EDO, 5=Burst EDO, 6=SDRAM, 7=CDRAM, 8=3DRAM, 9=SGRAM, 10=RDRAM, 11=DDR, 12=DDR2, 13=DDR2 FB DIMM.

ModuleSize

smallint

The size of the module in MB.

Speed

smallint

Access time in nanoseconds.

SocketDesignator

nvarchar(24)

The socket designator for the module.

FormFactor

smallint

No

The physical configuration: 0=unknown, 1=SIMM, 2=DIMM.

Parity

smallint

No

1 (TRUE) if the parity bit is present; else 0.

ECC

smallint

No

1 (TRUE) if error checking and correction is present; else 0.

NOTE:The ComponentOID foreign key references the ComponentOID primary key column of the NC_Component table.