Custom Catalog Tables

The following database tables store information related to the custom catalogs.

dcs_catalog

This table contains information that describes catalogs.

Column	Data Type	Constraint
`catalog_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier associated with the custom catalog.
`version`	INTEGER	NOT NULL
	The integer incremented with each revision to prevent version conflict.
`display_name`	VARCHAR(254)	NULL
	The name of the custom catalog displayed in the ACC.
`creation_date`	TIMESTAMP	NULL
	The date the catalog was created.
`last_mod_date`	TIMESTAMP	NULL
	The last date the catalog was modified.
`migration_status`	INTEGER	NULL
	If the catalog was migrated from a standard product, this represents the status of the migration.
`migration_index`	INTEGER	NULL
	This is the index of the last successful migration step. Used if `CatalogMigration` needs to restart.
`item_acl`	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
`catalog_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier associated with the custom catalog. References `dcs_catalog(catalog_id)`.
`root_cat_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier associated with the category. References `dcs_category(category_id)`.

dcs_allroot_cats

This table contains a list of all root categories

Column	Data Type	Constraint
`catalog_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier associated with the custom catalog. References `dcs_catalog(catalog_id)`.
`root_cat_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier associated with the category. References `dcs_category(category_id)`.

dcs_root_subcats

This table contains a list of custom catalog root sub-catalogs.

Column	Data Type	Constraint
`catalog_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier associated with the custom catalog. References `dcs_catalog(catalog_id)`
`sub_catalog_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier associated with the subcatalog. References `dcs_catalog(catalog_id)`.

dcs_sub_catalogs

This table contains a list of all custom catalog sub catalogs (and their sub catalogs).

Column	Data Type	Constraint
`catalog_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier associated with the custom catalog.
`sub_catalog_id`	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
`category_info_id`	VARCHAR(40)	NOT NULL
(primary key)	Unique identifier associated with the `categoryInfo` object.
`version`	INTEGER	NOT NULL
	The integer incremented with each revision to prevent version conflict.
`item_acl`	LONG VARCHAR	NULL
	The security for the `category_info`.

dcs_product_info

This table contains information about the products in custom catalogs.

Column	Data Type	Constraint
`product_info_id`	VARCHAR(40)	NOT NULL
(primary key)	Unique identifier associated with the `productInfo` object.
`version`	INTEGER	NOT NULL
	The integer incremented with each revision to prevent version conflict.
`parent_cat_id`	VARCHAR(40)	NULL
	Identifier for the parent category of the `productInfo`.
`item_acl`	LONG VARCHAR	NULL
	The security for the `product_info`.

dcs_sku_info

This table contains information about the SKUs in custom catalogs.

Column	Data Type	Constraint
`sku_info_id`	VARCHAR(40)	NOT NULL
(primary key)	Unique identifier associated with the `skuInfo` object.
`version`	INTEGER	NOT NULL
	The integer incremented with each revision to prevent version conflict.
`item_acl`	LONG VARCHAR	NULL
	The security for the `sku_info`.

dcs_cat_subcats

This table contains information about the sub-categories for a specific category in the custom catalog.

Column	Data Type	Constraint
`category_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier associated with the category. References `dcs_category(category_id)`.
`sequence_num`	INTEGER	NOT NULL
(primary key)	This number is used to order the sub catalogs.
`catalog_id`	VARCHAR(40)	NOT NULL
	The unique identifier associated with the catalog. References `dcs_catalog(catalog_id)`.

dcs_cat_subroots

This table contains information about the root subcategories for a specific category in the custom catalog.

Column	Data Type	Constraint
`category_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier associated with the category. References `dcs_category(category_id)`.
`sequence_num`	INTEGER	NOT NULL
(primary key)	This number is used to order the sub catalogs.
`sub_category_id`	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
`category_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier associated with the category. References `dcs_category(category_id)`.
`catalog_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier associated with the catalog.
`category_info_id`	VARCHAR(40)	NOT NULL
	Unique identifier of the `categoryInfo` to associate with this category when it is viewed as part of this catalog.

dcs_catinfo_anc

This table contains information about ancestor categories for categoryInfo objects.

Column	Data Type	Constraint
`category_info_id`	VARCHAR(40)	NOT NULL
(primary key)	Identifier for the `categoryInfo`.
`anc_cat_id`	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
`product_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier associated with the product. References `dcs_product(product_id)`.
`catalog_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier associated with a catalog.
`product_info_id`	VARCHAR(40)	NOT NULL
	The unique identifier of the `productInfo` to associate with this product when it is viewed from this catalog.

dcs_prdinfo_rdprd

This table contains information about related products.

Column	Data Type	Constraint
`product_info_id`	VARCHAR(40)	NOT NULL
(primary key)	References `dcs_product_info(product_info_id)`.
`sequence_num`	INTEGER	NOT NULL
(primary key)	This number is used to order the related products.
`related_prd_id`	VARCHAR(40)	NOT NULL
	References `dcs_product(product_id)`.

dcs_prdinfo_anc

This table contains information about the ancestor categories to associate with productInfos in custom catalogs.

Column	Data Type	Constraint
`product_info_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier of the `productInfo` item.
`anc_cat_id`	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
`sku_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier associated with the SKU. References `dcs_sku(sku_id)`.
`catalog_id`	VARCHAR(40)	NOT NULL
(primary key)	Unique identifier associated with the catalog.
`sku_info_id`	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
`sku_info_id`	VARCHAR(40)	NOT NULL
(primary key)	References `dcs_sku_info(sku_info_id)`.
`sequence_num`	INTEGER	NOT NULL
(primary key)	This number is used to order the replacement products.
`replacement`	VARCHAR(40)	NOT NULL
	Identifier for the replacement item to associate with this `skuInfo`.

dcs_gen_fol_cat

This table contains information about the base folders for a specific custom catalog.

Column	Data Type	Constraint
`folder_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier of the folder item.
`type`	INTEGER	NOT NULL
	The type of folder.
`name`	VARCHAR(40)	NOT NULL
	The name of the folder that is displayed in the ACC.
`parent`	VARCHAR(40)	NULL
	The parent folder of the folder described in this table.
`description`	VARCHAR(254)	NULL
	A description of this folder.
`item_acl`	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
`folder_id`	VARCHAR(40)	NOT NULL
(primary key)	References `dcs_gen_fol_cat(folder_id)`.
`sequence_num`	INTEGER	NOT NULL,
(primary key)	This number is used to order the child folders.
`child_folder_id`	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
`catfol_id`	VARCHAR(40)	NOT NULL
(primary key)	References `dcs_gen_fol_cat(folder_id)`.
`sequence_num`	INTEGER	NOT NULL
(primary key)	This number is used to order the catalogs.
`catalog_id`	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
`catalog_id`	VARCHAR(40)	not null
(primary key)	The ID of the catalog whose direct ancestor is defined in the `anc_catalog_id` column.
`sequence_num`	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.
`anc_catalog_id`	VARCHAR(40)	not null
	The direct ancestor catalog of the catalog defined in the `catalog_id` column.

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
`catalog_id`	VARCHAR(40)	not null
(primary key)	The ID of the catalog whose indirect ancestor is defined by the `anc_catalog_id` column.
`sequence_num`	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.
`anc_catalog_id`	VARCHAR(40)	not null
	The ID of the indirect ancestor catalog of the catalog defined by the `catalog_id` column.

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
`catalog_id`	VARCHAR(40)	not null
(primary key)	The ID of the catalog whose ancestor category is defined by the `anc_category_id` column.
`sequence_num`	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.
`category_id`	VARCHAR(40)	not null
	The ID of the ancestor category of the catalog defined in the `catalog_id` column.

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
`category_id`	VARCHAR(40)	not null
(primary key)	The ID of the category whose parent catalog is defined in the `parent_ctlg_id` column.
`parent_ctlg_id`	VARCHAR(40)	not null
	The ID of the parent catalog of the category defined in the `category_id` column.

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
`category_id`	VARCHAR(40)	not null
(primary key)	The ID of the category whose ancestor category is defined by the `anc_category_id` column.
`sequence_num`	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.
`anc_category_id`	VARCHAR(40)	not null
	The ID of the ancestor category of the category defined by the `category_id` column.

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
`product_id`	VARCHAR(40)	not null
(primary key)	The ID of the product whose parent category in the catalog defined by the `catalog_id` column is defined in the `category_id` column.
`catalog_id`	VARCHAR(40)	not null
(primary key)	The ID of the catalog within which the category defined by the `category_id` column is the parent category of the product defined in the `product_id` column.
`category_id`	VARCHAR(40)	not null
	The ID of the parent category of the product defined by the `product_id` column within the catalog defined by the `catalog_id` column.

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
`product_id`	VARCHAR(40)	not null
(primary key)	The ID of the product whose ancestor category is defined in the `category_id` column.
`sequence_num`	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.
`category_id`	VARCHAR(40)	not null
	The ancestor category of the product defined in the `product_id` column.

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
`category_id`	VARCHAR(40)	not null
(primary key)	The ID of the category that can be viewed in the catalog defined by the `catalog_id` column
`catalog_id`	VARCHAR(40)	not null
(primary key)	The ID of the catalog within which the category defined in the `category_id` column can be viewed

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
`product_id`	VARCHAR(40)	not null
(primary key)	The ID of the product that can be viewed in the catalog defined by the `catalog_id` column
`catalog_id`	VARCHAR(40)	not null
(primary key)	The ID of the catalog within which the product defined by the `product_id` column can be viewed

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
`sku_id`	VARCHAR(40)	not null
(primary key)	The ID of the SKU that can be viewed within the catalog defined by the `catalog_id` column
`catalog_id`	VARCHAR(40)	not null
(primary key)	The ID of the catalog within which the SKU defined by the `sku_id` column can be viewed

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
`user_id`	VARCHAR(40)	not null
(primary key)	The ID of the user profile whose catalog is defined in the `user_catalog` column
`user_catalog`	VARCHAR(40)	null
	The ID of the catalog that is used by the user defined by the `user_id` column

ATG Commerce Programming Guide