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 |