CatalogRelationships Table
For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.
The CatalogRelationships table contains information about the relationships in the catalog to which the table refers. There is one CatalogRelationships 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>_CatalogRelationships.
The following table describes the columns in the CatalogRelationships table.
Column name |
Type |
Allow null |
Description |
|---|---|---|---|
From_CatalogName |
nvarchar(128) |
no |
The name of the source catalog for the relationship. This is a primary key. |
from_oid |
int |
no |
The object ID (OID) of the source catalog for the relationship. This is a primary key and a foreign key. |
To_CatalogName |
nvarchar(128) |
no |
The name of the destination catalog for the relationship. This is a primary key. |
To_BaseCatalogName |
nvarchar(128) |
no |
The name of the base destination catalog for the relationship. |
to_oid |
int |
no |
The object ID (OID) of the destination catalog for the relationship. This is a primary key. |
fVirtualCatalog |
bit |
no |
Specifies whether the destination catalog is a virtual catalog. |
Name |
nvarchar(128) |
no |
The name of the relationship. This is a primary key. |
Rank |
int |
no |
The rank of the relationship. |
Description_* |
nvarchar(256) |
yes |
The description of the relationship. There is one column for each language in the catalog. |