CatalogHierarchy Table
For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.
The CatalogHierarchy table contains information about the hierarchy of the items in the catalog to which the table refers. There is one CatalogHierarchy table for each catalog in your system. The Catalog System creates this table when it creates the catalog. The table name has the format <CatalogName>_ CatalogHierarchy.
The following table describes the columns in the CatalogHierarchy table.
Column name |
Type |
Allow null |
Description |
|---|---|---|---|
oid |
int |
no |
The object ID (OID) of the catalog item. This is a primary key. |
child_oid |
int |
no |
The object ID (OID) of the child catalog item. This is a primary key and a foreign key. |
CatalogName |
nvarchar(85) |
no |
The name of the catalog. |
child_CatalogName |
nvarchar(85) |
no |
The name of the catalog to which the child catalog item belongs. |
fVirtualCatalog |
bit |
no |
Specifies if this is a virtual catalog. |
rank |
int |
no |
The rank of the catalog item in the hierarchy. |