2.4 NC_Category Table

The NC_Category table tracks product categories.

Column

Key

Type

Null

Description

CategoryOID

PK

binary(16)

No

An internal ID number used as a primary key.

CategoryName

nvarchar(32)

No

The name of the product category.

CategoryType

smallint

No

The product type to which the category belongs. See "Note" below.

IsTally

smallint

No

True(1) indicates if the category was defined by Novell; else 0.

IsDeleted

DateTime

The date and time the record was deleted; else null.

NOTE:The CategoryType can be one of the following:

1

BIOS

17

Printer

2

CPU

18

BUS Adapter

3

CD/DVD Drive

19

Serial Port

4

DMI

20

Sound Card

5

Diskette Drive

21

Software

6

Hard Disk

22

System

7

Keyboard

23

System Board

8

LAN Adapter

24

Video Adapter

9

Memory Module Socket

25

Removable Media Drive

10

Modem

26

Other

11

Monitor

29

Hot Fix

12

Mouse

30

USB Port

13

Network Driver

31

Docking Station

14

Operating System

15

Parallel Port

16

Partition