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 |
True(1) indicates if the parity bit is present; else 0. |
|
|
ECC |
smallint |
No |
True(1) indicates 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.