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
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
The size of the module in MB.
Speed
Access time in nanoseconds.
SocketDesignator
nvarchar(24)
The socket designator for the module.
FormFactor
The physical configuration: 0=unknown, 1=SIMM, 2=DIMM.
Parity
1 (TRUE) if the parity bit is present; else 0.
ECC
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.