The NC_CDROM table contains inventory data about CD-ROM components.
|
Column |
Key |
Type |
Null |
Description |
|---|---|---|---|---|
|
ComponentOID |
PK, FK |
binary(16) |
No |
An internal ID number used as a primary key. |
|
InterfaceType |
smallint |
No |
The interface type: 0=Unknown, 1=IDE, 2=SCSI, 3=USB, 4=FireWire. |
|
|
DriveLetter |
|
nvarchar(64) |
Yes |
A letter assigned to the drive |
|
DeviceType |
|
smallint |
Yes |
Drive type (capabilities) |
|
Device Type |
|
|
|
|---|---|---|---|
|
0 |
Unknown |
7 |
CDR/DVD -R |
|
1 |
CD Reader |
8 |
CDR/DVD -RW |
|
2 |
DVD ROM |
9 |
CDR/DVD +R |
|
3 |
CDR |
10 |
CDR/DVD +RW |
|
4 |
CD Read/Write |
11 |
CDR/DVD +/-R |
|
5 |
CD DVD |
12 |
CDR/DVD +/-RW |
|
6 |
DVD RAM |
|
|
FK references:
FK_CDROM_CompOID: ComponentOID references NC_CdromComp.ComponentOID.