The following database tables store information related to the custom catalogs.
dcs_catalog
This table contains information that describes catalogs.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier associated with the custom catalog. | |
| INTEGER | NOT NULL |
The integer incremented with each revision to prevent version conflict. | ||
| VARCHAR(254) | NULL |
The name of the custom catalog displayed in the ACC. | ||
| TIMESTAMP | NULL |
The date the catalog was created. | ||
| TIMESTAMP | NULL |
The last date the catalog was modified. | ||
| INTEGER | NULL |
If the catalog was migrated from a standard product, this represents the status of the migration. | ||
| INTEGER | NULL |
This is the index of the last successful migration step. Used if | ||
| LONG VARCHAR | NULL |
The security for the catalog. |
dcs_root_cats
This table contains a list of custom catalog root categories.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier associated with the custom catalog. References | |
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier associated with the category. References |
dcs_allroot_cats
This table contains a list of all root categories
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier associated with the custom catalog. References | |
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier associated with the category. References |
dcs_root_subcats
This table contains a list of custom catalog root sub-catalogs.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier associated with the custom catalog. References | |
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier associated with the subcatalog. References |
dcs_sub_catalogs
This table contains a list of all custom catalog sub catalogs (and their sub catalogs).
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier associated with the custom catalog. | |
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier associated with the custom catalog. |
dcs_category_info
This table contains information about categories in custom catalogs.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | Unique identifier associated with the | |
| INTEGER | NOT NULL |
The integer incremented with each revision to prevent version conflict. | ||
| LONG VARCHAR | NULL |
The security for the |
dcs_product_info
This table contains information about the products in custom catalogs.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | Unique identifier associated with the | |
| INTEGER | NOT NULL |
The integer incremented with each revision to prevent version conflict. | ||
| VARCHAR(40) | NULL |
Identifier for the parent category of the | ||
| LONG VARCHAR | NULL |
The security for the |
dcs_sku_info
This table contains information about the SKUs in custom catalogs.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | Unique identifier associated with the | |
| INTEGER | NOT NULL |
The integer incremented with each revision to prevent version conflict. | ||
| LONG VARCHAR | NULL |
The security for the |
dcs_cat_subcats
This table contains information about the sub-categories for a specific category in the custom catalog.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier associated with the category. References | |
| INTEGER | NOT NULL |
(primary key) | This number is used to order the sub catalogs. | |
| VARCHAR(40) | NOT NULL |
The unique identifier associated with the catalog. References |
dcs_cat_subroots
This table contains information about the root subcategories for a specific category in the custom catalog.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier associated with the category. References | |
| INTEGER | NOT NULL |
(primary key) | This number is used to order the sub catalogs. | |
| VARCHAR(40) | NOT NULL |
The unique identifier associated with the subcategory. |
dcs_cat_catinfo
This table contains information about a specific category in the custom catalog.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier associated with the category. References | |
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier associated with the catalog. | |
| VARCHAR(40) | NOT NULL |
Unique identifier of the |
dcs_catinfo_anc
This table contains information about ancestor categories for categoryInfo
objects.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | Identifier for the | |
| VARCHAR(40) | NOT NULL |
(primary key) | Identifier for the ancestor category. |
dcs_prd_prdinfo
This table contains information about the productInfos
to associate with a given product in a given catalog.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier associated with the product. References | |
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier associated with a catalog. | |
| VARCHAR(40) | NOT NULL |
The unique identifier of the |
dcs_prdinfo_rdprd
This table contains information about related products.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | References | |
| INTEGER | NOT NULL |
(primary key) | This number is used to order the related products. | |
| VARCHAR(40) | NOT NULL |
References |
dcs_prdinfo_anc
This table contains information about the ancestor categories to associate with productInfos
in custom catalogs.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier of the | |
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier of the ancestor category. |
dcs_sku_skuinfo
This table contains information about skuInfo
items associated with SKU items.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier associated with the SKU. References | |
| VARCHAR(40) | NOT NULL |
(primary key) | Unique identifier associated with the catalog. | |
| VARCHAR(40) | NOT NULL |
Unique identifier to associate with this SKU when viewed as part of this catalog. |
dcs_skuinfo_rplc
This table contains information about the replacement items to associate with a skuInfo
.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | References | |
| INTEGER | NOT NULL |
(primary key) | This number is used to order the replacement products. | |
| VARCHAR(40) | NOT NULL |
Identifier for the replacement item to associate with this |
dcs_gen_fol_cat
This table contains information about the base folders for a specific custom catalog.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier of the folder item. | |
| INTEGER | NOT NULL |
The type of folder. | ||
| VARCHAR(40) | NOT NULL |
The name of the folder that is displayed in the ACC. | ||
| VARCHAR(40) | NULL |
The parent folder of the folder described in this table. | ||
| VARCHAR(254) | NULL |
A description of this folder. | ||
| LONG VARCHAR | NULL |
Security information for this folder. |
dcs_child_fol_cat
This table contains information about the child folders for a specific custom catalog.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | References | |
| INTEGER | NOT NULL, |
(primary key) | This number is used to order the child folders. | |
| VARCHAR(40) | NOT NULL, |
The ID of the child folder. |
dcs_catfol_chld
This table contains information about the folders in which catalogs are located.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | References | |
| INTEGER | NOT NULL |
(primary key) | This number is used to order the catalogs. | |
| VARCHAR(40) | NOT NULL |
The ID of the catalog contained in the folder. |
dcs_dir_anc_ctlgs
This table contains information that defines a direct-ancestor relationship between two catalogs. A catalog is considered a direct ancestor of another catalog if there are no categories separating the two catalogs. In other words, the tree between the two catalogs will only include catalogs.
A “self” ancestor relationship is defined in this database table. Each catalog should have a row where the ancestor catalog is itself in the directAncestorCatalogsAndSelf
property of the catalog item.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | not null |
(primary key) | The ID of the catalog whose direct ancestor is defined in the | |
| INTEGER | not null |
(primary key) | Sequence number used to differentiate rows that are otherwise the same – an ancestor can appear more than once for a given catalog if there is more than one way to traverse up the catalog tree to reach the ancestor. | |
| VARCHAR(40) | not null |
The direct ancestor catalog of the catalog defined in the |
dcs_ind_anc_ctlgs
This table contains information that defines an indirect-ancestor relationship between two catalogs. A catalog is considered an indirect ancestor of another catalog if there is at least one category separating the two catalogs. This table defines the indirectAncestorCatalogs
property of the catalog item.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | not null |
(primary key) | The ID of the catalog whose indirect ancestor is defined by the | |
| INTEGER | not null |
(primary key) | Sequence number used to differentiate rows that are otherwise the same – an ancestor can appear more than once for a given catalog if there is more than one way to traverse up the catalog tree to reach the ancestor. | |
| VARCHAR(40) | not null |
The ID of the indirect ancestor catalog of the catalog defined by the |
dcs_ctlg_anc_cats
This table contains information that defines the ancestor categories of each catalog. Used for the ancestorCategories
property of the catalog item.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | not null |
(primary key) | The ID of the catalog whose ancestor category is defined by the | |
| INTEGER | not null |
(primary key) | Sequence number used to differentiate rows that are otherwise the same. An ancestor can appear more than once for a given catalog if there is more than one way to traverse up the catalog tree to reach the ancestor. | |
| VARCHAR(40) | not null |
The ID of the ancestor category of the catalog defined in the |
dcs_cat_prnt_ctlg
This table contains information that defines the parent catalog of each category (note: a category may not have a parent catalog if its direct parent is another category, or if the category is an orphan (not contained in a catalog)). Used for the parentCatalog
property of the category item.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | not null |
(primary key) | The ID of the category whose parent catalog is defined in the | |
| VARCHAR(40) | not null |
The ID of the parent catalog of the category defined in the |
dcs_cat_anc_cats
This table defines the ancestor categories of each category. Used by the ancestorCategories
property of the category item.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | not null |
(primary key) | The ID of the category whose ancestor category is defined by the | |
| INTEGER | not null |
(primary key) | Sequence number used to differentiate rows that are otherwise the same. An ancestor can appear more than once for a given category if there is more than one way to traverse up the catalog tree to reach the ancestor. | |
| VARCHAR(40) | not null |
The ID of the ancestor category of the category defined by the |
dcs_prd_prnt_cats
This table defines the parent category for each product within each catalog. It defines the parentCategoriesForCatalog
property of the product item.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | not null |
(primary key) | The ID of the product whose parent category in the catalog defined by the | |
| VARCHAR(40) | not null |
(primary key) | The ID of the catalog within which the category defined by the | |
| VARCHAR(40) | not null |
The ID of the parent category of the product defined by the |
dcs_prd_anc_cats
This table defines the ancestor categories of each product. Used by the ancestorCategories
property of the product item.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | not null |
(primary key) | The ID of the product whose ancestor category is defined in the | |
| INTEGER | not null |
(primary key) | Sequence number used to differentiate rows that are otherwise the same. An ancestor can appear more than once for a given product if there is more than one way to traverse up the catalog tree to reach the ancestor. | |
| VARCHAR(40) | not null |
The ancestor category of the product defined in the |
dcs_cat_catalogs
This table defines all the catalogs that a given category can be viewed in. Used by the catalogs
property of the category
item.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | not null |
(primary key) | The ID of the category that can be viewed in the catalog defined by the | |
| VARCHAR(40) | not null |
(primary key) | The ID of the catalog within which the category defined in the |
dcs_prd_catalogs
This table defines all the catalogs that a given product can be viewed in. Used by the catalogs
property of the product
item.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | not null |
(primary key) | The ID of the product that can be viewed in the catalog defined by the | |
| VARCHAR(40) | not null |
(primary key) | The ID of the catalog within which the product defined by the |
dcs_sku_catalogs
This table defines all the catalogs that a given SKU can be viewed in. Used by the catalogs
property of the sku
item.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | not null |
(primary key) | The ID of the SKU that can be viewed within the catalog defined by the | |
| VARCHAR(40) | not null |
(primary key) | The ID of the catalog within which the SKU defined by the |
dcs_user_catalog
This table defines the catalog assigned to a given user’s profile. Used by the catalog
property of the user
item in the profile repository.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | not null |
(primary key) | The ID of the user profile whose catalog is defined in the | |
| VARCHAR(40) | null |
The ID of the catalog that is used by the user defined by the |