The NC_Monitor table contains inventory data about monitors.
|
Column |
Key |
Type |
Null |
Description |
|---|---|---|---|---|
|
ComponentOID |
PK, FK |
binary(16) |
No |
An internal ID number used as a primary key. |
|
EISAManufacturer |
nvarchar(64) |
The manufacturer’s name. |
||
|
VESAProduct |
nvarchar(64) |
The product name. |
||
|
YearManufactured |
smallint |
The year of manufacture. |
||
|
WeekManufactured |
smallint |
The week (1-52) of manufacture. |
||
|
DiagonalSize |
Float |
The calculated diagonal size. |
||
|
DisplayType |
smallint |
The display type of the monitor. |
NOTE:
DisplayType: 0=Unknown, 1=CRT, 2=LCD.
The ComponentOID foreign key references the ComponentOID primary key column of the NC_Component table.