2.5 NC_CDROM Table

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.