Oracle ATG Web Commerce - Product Catalog Tables

Product Catalog Tables

Oracle ATG Web Commerce uses the following tables to store product catalog information:

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 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_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_cat_ancestors

This table contains information about category ancestors.

Column	Data Type	Constraint
`category_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier associated with the category.
`anc_cat_id`	VARCHAR(40)	NOT NULL
(primary key)	The ID of a category that is an ancestor in the category. A category has multiple rows in this table representing all the ancestors of a category. A query of this value determines whether a category is a child of another category.

dcs_cat_aux_media

This table contains information about an auxiliary media image associated with a category.

Column	Data Type	Constraint
`category_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier associated with the category. References `dcs_category(category_id)`
`tag`	VARCHAR(42)	NOT NULL
(primary key)	Represents the key.
`media_id`	VARCHAR(40)	NOT NULL
	The value that points to a media item. References `dcs_media(media_id)`

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_cat_catinfo

This table contains information about a specific category in the 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_cat_groups

This table contains information about groups in a category.

Column	Data Type	Constraint
`category_id`	VARCHAR(40)	NOT NULL UNIQUE
(primary key)	The unique identifier associated with the category. References `dcs_category(category_id)`
`child_prd_group`	VARCHAR(254)	NULL
	Stores the name of a Content Group that should return a list of products that should be children of this category.
`child_cat_group`	VARCHAR(254)	NULL
	Stores the name of a Content Group that should return a list of categories that should be children of this category.
`related_cat_group`	VARCHAR(254)	NULL
	Stores the name of a Content Group that should return a list of categories that are related to this category.

dcs_cat_chldcat

This table contains information about children of categories.

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)	Used to order rows in this table.
`child_cat_id`	VARCHAR(40)	NOT NULL
	A category ID that should be considered a child of this category. References `dcs_category(category_id)`

dcs_cat_chldprd

This table contains information about child products within a category.

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)	Used to order rows in the table.
`child_prd_id`	VARCHAR(40)	NOT NULL
	A product ID that should be considered a child of this category. References `dcs_product(product_id)`

dcs_cat_keywrds

This table contains information about category keywords.

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)	Used to order rows in this table.
`Keyword`	VARCHAR(254)	NOT NULL
	A String value used in searches.

dcs_cat_media

This table contains information about media in a category.

Column	Data Type	Constraint
`category_id`	VARCHAR(40)	NOT NULL UNIQUE
(primary key)	The unique identifier associated with the category. References `dcs_category(category_id)`
`template_id`	VARCHAR(40)	NULL
	The ID of a media item that represents the template that renders the category. References `dcs_media(media_id)`
`thumbnail_image_id`	VARCHAR(40)	NULL References `dcs_media(media_id)`
	The ID of a media item that represents a thumbnail image of a category that can be displayed in the template.
`small_image_id`	VARCHAR(40)	NULL
	The ID of a media item that represents a small image of a category that can be displayed in the template. References `dcs_media(media_id)`
`large_image_id`	VARCHAR(40)	NULL
	The ID of a media item that represents a large image of a category that can be displayed in the template. References `dcs_media(media_id)`

dcs_cat_prnt_cats

This table stores information related to a catalog’s parent categories.

Column	Data Type	Constraint
`Category_id`	VARCHAR(40)	not null
(primary key)	The ID of a category
`Catlog_id`	VARCHAR(40)	not null
(primary key)	The ID of a catalog.
`parent_ctgy_id`	VARCHAR(40)	not null
	The ID of the catalog’s parent category.

dcs_cat_rltdcat

This table contains information about category relationships.

Column	Data Type	Constraint
`category_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier associated with the category.
`sequence_num`	INTEGER	NOT NULL
(primary key)	Used to order rows in this table.
`related_cat_id`	VARCHAR(40)	NOT NULL
	A category ID that should be considered related to the category. References `dcs_category(category_id)`

dcs_cat_subcats

This table contains information about the sub-categories for a specific category in the 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 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_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 catalog.
`version`	INTEGER	NOT NULL
	The integer incremented with each revision to prevent version conflict.
`display_name`	VARCHAR(254)	NULL
	The name of the 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_catalog_sites

This table stores information related to site ownership of catalogs. Used by the multisite feature.

Column	Data Type	Constraint
`catalog_id`	VARCHAR(40)	not null
(primary key)	The ID of a catalog.
`site_id`	VARCHAR(40)	not null
(primary key)	The ID of a site to which the catalog is associated.

dcs_category

This table contains information that describes a category.

Column	Data Type	Constraint
`category_id`	VARCHAR(40)	NOT NULL UNIQUE
(primary key)	The unique identifier associated with the category.
`catalog_id`	VARCHAR(40)
	The unique identifier associated with the catalog that contains this category.
`version`	INTEGER	NOT NULL
	Manages the optimistic locking feature of the SQL Repository. This value is automatically incremented by the SQL Repository when any value of the item is modified. If you change rows directly outside of the Oracle ATG Web Commerce framework, you should also increment the version number.
`creation_date`	DATE	NULL
	The date this category was created.
`start_date`	DATE	NULL
	The date on which this category will become available. This is an optional field that can be used by the SQL Repository as part of an RQL filter to prevent items from being loaded from the database.
`end_date`	DATE	NULL
	The last date on which this category will be available. This is an optional field that can be used by the SQL Repository as part of an RQL filter to prevent items from being loaded from the database.
`display_name`	VARCHAR(254)	NULL
	The name of the category that displays in the ACC.
`description`	VARCHAR(254)	NULL
	A text description of the category.
`long_description`	LONG VARCHAR	NULL
	A long text description of the category.
`parent_cat_id`	VARCHAR(40)	NULL
	The ID of the immediate and default parent category. References `dcs_category(category_id)`
`parent_cat_id`	VARCHAR(40)	NULL
	The ID of the immediate and default parent category.
`category_type`	INTEGER	NULL
	An enumerated value used for defining sub-types of the initial Oracle ATG Web Commerce category item descriptor.
`root_category`	NUMERIC(1)	NULL CHECK`(root_category in (01))`
	A boolean (1 or 0) indicator that represents which categories should be considered the root of the catalog hierarchy.

dcs_category_info

This table contains information about categories in 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_category_sites

This table stores information related to site ownership of categories. Used by the multisite feature.

Column	Data Type	Constraint
`category_id`	VARCHAR(40)	not null
(primary key)	The ID of a category.
`site_id`	VARCHAR(40)	not null
(primary key)	The ID of a site to which the category is associated.

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_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_catfol_sites

This table contains information about the sites with which catalog folders are associated.

Column	Data Type	Constraint
`catfol_id`	VARCHAR(40)	NOT NULL
(primary key)	References `dcs_gen_fol_cat(folder_id)`.
`site_id`	VARCHAR(40)	NOT NULL
(primary key)	References the ID of the site with with the catalog folder is associated.

dcs_child_fol_cat

This table contains information about the child folders for a specific 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_conf_options

The following table contains information related to configuration options.

Column	Data Type	Constraint
`config_prop_id`	VARCHAR(40)	NOT NULL
(primary key)	References `dcs_config_prop(config_prop_id)`
`config_options`	VARCHAR(40)	NOT NULL
	The configuration options associated with the configurable property.
`sequence_num`	INTEGER	NOT NULL
(primary key)	The sequence number of the configurable option in a list.

dcs_config_prop

The following table contains information related to configurable properties.

Column	Data Type	Constraint
`config_prop_id`	VARCHAR(40)	NOT NULL
(primary key)	The repository configurable property ID.
`version`	INTEGER	NOT NULL
	The repository version number.
`display_name`	VARCHAR(40)	NULL
	The display name of the configurable property.
`description`	VARCHAR(255)	NULL
	A description of the configurable property.
`item_acl`	LONG VARCHAR	NULL
	The item access control list for this item.

dcs_config_opt

The following table contains information related to configuration options.

Column	Data Type	Constraint
`config_opt_id`	VARCHAR(40)	NOT NULL
(primary key)	The repository configuration option ID.
`Version`	INTEGER	NOT NULL
	The repository version number.
`display_name`	VARCHAR(40)	NULL
	The configuration option display name.
`description`	VARCHAR(255)	NULL
	The configuration option description.
`sku`	VARCHAR(40)	NULL
	The configuration option SKU.
`product`	VARCHAR(40)	NULL
	The configuration option product.
`price`	DOUBLE PRECISION	NULL
	The configuration option price.
`item_acl`	LONG VARCHAR	NULL
	The item access control list for this item.

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_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_folder

This table contains information that describes a folder.

Column	Data Type	Constraint
`folder_id`	VARCHAR(40)	NOT NULL UNIQUE
(primary key)	The unique identifier associated with the folder.
`version`	INTEGER	NOT NULL
	Manages the optimistic locking feature of the SQL Repository. This value is automatically incremented by the SQL Repository when any value of the item is modified. If you change rows directly outside of the Oracle ATG Web Commerce platform, you should also increment the version number.
`creation_date`	DATE	NULL
	The date this folder was created.
`start_date`	DATE	NULL
	The date on which this folder will become available. This is an optional field that can be used by the SQL Repository as part of an RQL filter to prevent items from being loaded from the database.
`end_date`	DATE	NULL
	The last date on which this folder will be available. This is an optional field that can be used by the SQL Repository as part of an RQL filter to prevent items from being loaded from the database.
`description`	VARCHAR(254)	NULL
	A text description of the folder.
`name`	VARCHAR(254)	NOT NULL
	The name of the folder.
`path`	VARCHAR(254)	NOT NULL
	A String that represents the folder in the context of all the ancestor folders. This value is similar to the complete absolute path of a file.
`parent_folder_id`	VARCHAR(40)	NOT NULL
	The ID of the folder that contains this folder in the catalog hierarchy. References `dcs_folder(folder_id)`.

dcs_foreign_cat

The following table contains information related to a foreign catalog (remote catalog) that Oracle ATG Web Commerce would integrate with to support configurable commerce items.

Column	Data Type	Constraint
`catalog_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique repository ID of the catalog.
`type`	INTEGER	NOT NULL
	The type field is used for sub-typing this catalog.
`version`	INTEGER	NOT NULL
	Version property that is used internally by the Repository to maintain data consistency.
`name`	VARCHAR(100)	NULL
	The name for this catalog that will appear in the ACC.
`description`	VARCHAR(255)	NULL
	A description of this catalog that is appropriate in a UI context.
`host`	VARCHAR(100)	NULL
	The host that this foreign catalog lives at.
`port`	INTEGER	NULL
	The port that this catalog can be located on at the host.
`base_url`	VARCHAR(255)	NULL
	The base URL to locate this catalog, at a given host.
`return_url`	VARCHAR(255)	NULL
	The URL that can be used for return.
`item_acl`	LONG VARCHAR	NULL
	Maintains an ACL for security information purposes on instances of this item-descriptor.

dcs_gen_fol_cat

This table contains information about the base folders for a specific 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_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_media

This table contains information that describes a media item.

Column	Data Type	Constraint
`media_id`	VARCHAR(40)	NOT NULL UNIQUE
(primary key)	The unique identifier associated with the media item.
`version`	INTEGER	NOT NULL
	Manages the optimistic locking feature of the SQL Repository. This value is automatically incremented by the SQL Repository when any value of the item is modified. If you change rows directly outside of the Oracle ATG Web Commerce framework, you should also increment the version number.
`creation_date`	DATE	NULL
	The date this media item was created.
`start_date`	DATE	NULL
	The date on which this media item will become available. This is an optional field that can be used by the SQL Repository as part of an RQL filter to prevent items from being loaded from the database.
`end_date`	DATE	NULL
	The last date on which this media item will be available. This is an optional field that can be used by the SQL Repository as part of an RQL filter to prevent items from being loaded from the database.
`description`	VARCHAR(254)	NULL
	A text description of the media item.
`name`	VARCHAR(254)	NOT NULL
	The name of the media item.
`path`	VARCHAR(254)	NOT NULL
	A String, which represents the folder in the context of all the ancestor folders. This value is similar to the complete absolute path of a file.
`parent_folder_id`	VARCHAR(40)	NOT NULL
	The ID of the folder that contains this media item in the catalog hierarchy. References `dcs_folder(folder_id)`
`media_type`	INTEGER	NULL
	Used as an enumerated data type that indicates what form of media is stored. By default this includes external, internal binary, and internal text media items.

dcs_media_ext

This table contains information that describes extended attributes of a media item.

Column	Data Type	Constraint
`media_id`	VARCHAR(40)	NOT NULL UNIQUE
(primary key)	The unique identifier associated with the media. References `dcs_media(media_id)`.
`url`	VARCHAR(254)	NOT NULL
	The external URL that references media content.

dcs_media_bin

This table contains information that describes the size of a media item.

Column	Data Type	Constraint
`media_id`	VARCHAR(40)	NOT NULL UNIQUE
(primary key)	The unique identifier associated with the media. References `dcs_media(media_id)`.
`length`	INTEGER	NOT NULL
	The number of bytes of data stored in the data column.
`last_modified`	DATE	NOT NULL
	The date this item was last modified.
`data`	LONG VARBINARY	NOT NULL
	The raw bytes of content.

dcs_media_txt

This table contains information about the text features of a media item.

Column	Data Type	Constraint
`media_id`	VARCHAR(40)	NOT NULL UNIQUE
(primary key)	The unique identifier associated with the media. References `dcs_media(media_id)`.
`length`	INTEGER	NOT NULL
	The number of bytes of data stored in the data column.
`last_modified`	DATE	NOT NULL
	The date this item was last modified.
`data`	LONG VARCHAR	NOT NULL
	Text content that can be indexed by a search engine.

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_prd_ancestors

Column	Data Type	Constraint
`product_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier associated with the product.
`anc_cat_id`	VARCHAR(40)	NOT NULL
(primary key)	The ID of a category that is an ancestor of the product. A product has multiple rows in this table representing all the ancestors of the product. . A query of this value determines whether a product is a child of another category.

dcs_prd_aux_media

This table contains information about an auxiliary media image associated with a product.

Column	Data Type	Constraint
`product_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier associated with the product. References `dcs_product(product_id)`
`tag`	VARCHAR(42)	NOT NULL
(primary key)	Represents the key.
`media_id`	VARCHAR(40)	NOT NULL
	The value that points to a media item. References `dcs_media(media_id)`

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_prd_keywrds

This table contains information about product keywords.

Column	Data Type	Constraint
`product_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier associated with the product. References `dcs_product(product_id)`
`sequence_num`	INTEGER	NOT NULL
(primary key)	Used to order rows in this table.
`keyword`	VARCHAR(254)	NOT NULL
	A String value used in searches.

dcs_prd_media

This table contains information about product media items.

Column	Data Type	Constraint
`product_id`	VARCHAR(40)	NOT NULL UNIQUE
(primary key)	The unique identifier associated with the product. References `dcs_product(product_id)`
`template_id`	VARCHAR(40)	NULL
	The ID of a media item that represents the template that renders the product. References `dcs_media(media_id)`
`thumbnail_image_id`	VARCHAR(40)	NULL
	The ID of a media item that represents a thumbnail image of a product that can be displayed in the template. References `dcs_media(media_id)`
`small_image_id`	VARCHAR(40)	NULL
	The ID of a media item that represents a small image of a category that can be displayed in the template. References `dcs_media(media_id)`
`large_image_id`	VARCHAR(40)	NULL
	The ID of a media item that represents a large image of a category that can be displayed in the template. References `dcs_media(media_id)`

dcs_prd_chldsku

This table contains information about children of products.

Column	Data Type	Constraint
`product_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier associated with the product. References `dcs_product(product_id)`
`sequence_num`	INTEGER	NOT NULL
(primary key)	Used to order rows in the table.
`sku_id`	VARCHAR(40)	NOT NULL
	The ID of a SKU that is a child of this product. References `dcs_sku(sku_id)`

dcs_prd_groups

This table contains information about related product groups.

Column	Data Type	Constraint
`product_id`	VARCHAR(40)	NOT NULL UNIQUE
(primary key)	The unique identifier associated with the product. References `dcs_product(product_id)`
`related_prd_group`	VARCHAR(254)	NULL
	Stores the name of a Content Group that should return a list of products that are related to this product.

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_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_rltdprd

This table contains information about related products.

Column	Data Type	Constraint
`product_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier associated with the product. References `dcs_product(product_id)`
`sequence_num`	INTEGER	NOT NULL
	Used to order rows in the table.
`related_prd_id`	VARCHAR(40)	NOT NULL
	A product ID that should be considered related to the product. References `dcs_product(product_id)`

dcs_prd_skuattr

This table contains information about which attributes of a SKU should be displayed.

Column	Data Type	Constraint
`product_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier associated with the product. References `dcs_product(product_id)`
`sequence_num`	INTEGER	NOT NULL
(primary key)	Used to order rows in the table.
`attribute_name`	VARCHAR(40)	NOT NULL
	The name of a SKU property that should be used to display relevant information about a SKU. For example not all the attributes of a SKU need to be displayed, perhaps only color, size, and display-name are necessary.

dcs_prdinfo_anc

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

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_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_product

This table contains information that describes a product item.

Column	Data Type	Constraint
`product_id`	VARCHAR(40)	NOT NULL UNIQUE
(primary key)	The unique identifier associated with the product.
`version`	INTEGER	NOT NULL
	Manages the optimistic locking feature of the SQL Repository. This value is automatically incremented by the SQL Repository when any value of the item is modified. If you change rows directly outside of the Oracle ATG Web Commerce framework, you should also increment the version number.
`creation_date`	DATE	NULL
	The date this product was created.
`start_date`	DATE	NULL
	The date on which this product will become available. This is an optional field that can be used by the SQL Repository as part of an RQL filter to prevent items from being loaded from the database.
`end_date`	DATE	NULL
	The last date on which this product will be available. This is an optional field that can be used by the SQL Repository as part of an RQL filter to prevent items from being loaded from the database.
`display_name`	VARCHAR(254)	NULL
	The name of the product that displays in the ACC.
`description`	VARCHAR(254)	NULL
	A text description of the product.
`long_description`	LONG VARCHAR	NULL
	A long text description of the product.
`parent_cat_id`	VARCHAR(40)	NULL
	The ID of the immediate and default parent category. References `dcs_category(category_id)`
`parent_cat_id`	VARCHAR(40)	NULL
	The ID of the immediate and default parent category.
`product_type`	INTEGER	NULL
	An enumerated value used for defining sub-types of the initial Oracle ATG Web Commerce product item descriptor.
`manufacturer`	VARCHAR 40	NULL
	A reference to the manufacturer of this particular product. References `dcs_manufacturer(manufacturer_id)`.

dcs_product_acl

The table stores security information for each product repository item.

Column	Data Type	Constraint
`product_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier associated with the product.
`item_acl`	LONG VARCHAR	NULL
	Stores the actual access control list. The access control list defines who can read, edit and delete an item.

dcs_product_info

This table contains information about the products in 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_product_sites

This table stores information related to site ownership of catalogs. Used by the multisite feature.

Column	Data Type	Constraint
`product_id`	VARCHAR(40)	not null
(primary key)	The ID of a product.
`site_id`	VARCHAR(40)	not null
(primary key)	The ID of a site to which the product is associated.

dcs_root_cats

This table contains a list of root categories.

Column	Data Type	Constraint
`catalog_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier associated with the 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 root sub-catalogs.

Column	Data Type	Constraint
`catalog_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier associated with the 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_sku

This table contains information that describes a SKU item.

Column	Data Type	Constraint
`sku_id`	VARCHAR(40)	NOT NULL UNIQUE
(primary key)	The unique identifier associated with the SKU.
`version`	INTEGER	NOT NULL
	Manages the optimistic locking feature of the SQL Repository. This value is automatically incremented by the SQL Repository when any value of the item is modified. If you change rows directly outside of the Oracle ATG Web Commerce framework, you should also increment the version number.
`creation_date`	DATE	NULL
	The date this SKU was created.
`start_date`	DATE	NULL
	The date on which this SKU will become available. This optional field can be used by the SQL Repository as part of an RQL filter to prevent items from being loaded from the database.
`end_date`	DATE	NULL
	The last date on which this SKU will be available. This is an optional field that can be used by the SQL Repository as part of an RQL filter to prevent items from being loaded from the database.
`display_name`	VARCHAR(254)	NULL
	The name of the SKU that displays in the ACC.
`description`	VARCHAR(254)	NULL
	A text description of the SKU.
`sku_type`	INTEGER	NULL
	An enumerated value used for defining sub-types of the initial Oracle ATG Web Commerce SKU item descriptor.
`wholesale_price`	DOUBLE PRECISION	NULL
	The wholesale price of the SKU.
`list_price`	DOUBLE PRECISION	NULL
	The list price of the SKU.
`sale_price`	DOUBLE PRECISION	NULL
	The sale price of the SKU.
`on_sale`	NUMERIC(1)	NULL CHECK`(on_sale in (01))`
	Determines whether the SKU is on sale.
`tax_status`	INTEGER	NULL
	An optional field that may be used to determine the taxable status of the SKU.
`fulfiller`	INTEGER	NULL
	An enumerated value that indicates which Oracle ATG Web Commerce fulfiller should attempt to process the SKU in the submitted order.
`manuf_part_num`	WVARCHAR(254)	NULL
	A String property that represents the manufacturers part number for this SKU.

dcs_sku_attr

This table holds information about an attribute map associated with a SKU.

Column	Data Type	Constraint
`sku_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier associated with the SKU. References `dcs_sku(sku_id)`
`attribute_name`	VARCHAR(42)	NOT NULL
(primary key)	Represents the key.
`attribute_value`	VARCHAR(254)	NOT NULL
	The value that allows arbitrary name property values to be associated with a SKU.

dcs_sku_aux_media

This table contains information about an auxiliary media image associated with a SKU.

Column	Data Type	Constraint
`sku_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier associated with the SKU. References `dcs_sku(sku_id)`
`tag`	VARCHAR(42)	NOT NULL
(primary key)	Represents the key.
`media_id`	VARCHAR(40)	NOT NULL
	The value that points to a SKU. References `dcs_media(media_id)`

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_sku_link

This table describes SKU links, which are used to represent SKU bundles.

Column	Data Type	Constraint
`sku_link_id`	VARCHAR(40)	NOT NULL UNIQUE
(primary key)	The unique identifier of the SKU link, which represents a bundle of SKUs.
`version`	INTEGER	NOT NULL
	Manages the optimistic locking feature of the SQL Repository. This value is automatically incremented by the SQL Repository when any value of the item is modified. If you change rows directly outside of the Oracle ATG Web Commerce framework, you should also increment the version number.
`creation_date`	DATE	NULL
	The date this SKU was created.
`start_date`	DATE	NULL
	The date on which this SKU will become available. This is an optional field that can be used by the SQL Repository as part of an RQL filter to prevent items from being loaded from the database.
`end_date`	DATE	NULL
	The last date on which this SKU will become available. This is an optional field that can be used by the SQL Repository as part of an RQL filter to prevent items from being loaded from the database.
`display_name`	VARCHAR(254)	NULL
	The name of the SKU link that displays in the ACC.
`description`	VARCHAR(254)	NULL
	A text description of the SKU.
`quantity`	INTEGER	NOT NULL
	The number of items to include in the bundle.
`bundle_item`	VARCHAR(40)	NOT NULL
	The specific SKU to include in the bundle. References `dcs_sku(sku_id)`

dcs_sku_bndllnk

This table contains information that associated SKU links with SKU objects.

Column	Data Type	Constraint
`sku_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier associated with the SKU. References `dcs_sku(sku_id)`
`sequence_num`	INTEGER	NOT NULL
(primary key)	Used to order rows in the table.
`sku_link_id`	VARCHAR(40)	NOT NULL
	The ID of the SKU link that should be included in the SKU bundle. References `dcs_sku_link(sku_link_id)`

dcs_sku_conf

The following table contains information related to configurable SKUs.

Column	Data Type	Constraint
`sku_id`	VARCHAR(40)	NOT NULL
(primary key)	References `dcs_sku(sku_id)`.
`config_props`	VARCHAR(40)	NOT NULL
	The configurable properties associated with this configurable SKU.
`sequence_num`	INTEGER	NOT NULL
(primary key)	The sequence number of the configurable properties in a list.

dcs_sku_media

This table contains information about SKU media items.

Column	Data Type	Constraint
`sku_id`	VARCHAR(40)	NOT NULL UNIQUE
(primary key)	The unique identifier associated with the SKU. References `dcs_sku(sku_id)`
`template_id`	VARCHAR(40)	NULL
	The ID of a SKU that represents the template that renders the category. References `dcs_media(media_id)`
`thumbnail_image_id`	VARCHAR(40)	NULL
	The ID of a media item that represents a thumbnail image of a category that can be displayed in the template. References `dcs_media(media_id)`
`small_image_id`	VARCHAR(40)	NULL
	The ID of a media item that represents a small image of a product that can be displayed in the template. References `dcs_media(media_id)`
`large_image_id`	VARCHAR(40)	NULL
	The ID of a media item that represents a large image of a SKU that can be displayed in the template. References `dcs_media(media_id)`

dcs_sku_replace

This table contains information about replacing SKUs.

Column	Data Type	Constraint
`sku_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier associated with the SKU. References `dcs_sku(sku_id)`
`sequence_num`	INTEGER	NOT NULL
(primary key)	Used to order the rows in the table.
`replacement`	VARCHAR(40)	NOT NULL
	The ID of a SKU that should be used as a replacement for another SKU if it is not available for purchase.

dcs_sku_sites

This table stores information related to site ownership of catalogs. Used by the multisite feature.

Column	Data Type	Constraint
`sku_id`	VARCHAR(40)	not null
(primary key)	The ID of a SKU.
`site_id`	VARCHAR(40)	not null
(primary key)	The ID of a site to which the SKU is associated.

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_sku_info

This table contains information about the SKUs in 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_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_sub_catalogs

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

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

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

dcs_manufacturer

The following table contains information related to manufacturers. Each product that appears in the product catalog can be associated with a particular manufacturer. These tables are used for information purposes by the buyer.

Column	Data Type	Constraint
`manufacturer_id`	VARCHAR(40)	NOT NULL
(primary key)	The repository ID of the manufacturer.
`manufacturer_name`	WVARCHAR(254)	NULL
	A string name that identifies the manufacturer.
`Description`	WVARCHAR(254)	NULL
	A short description of this manufacturer.
`long_description`	LONG WVARCHAR	NULL
	A long description of this manufacturer.
`Email`	VARCHAR(30)	NULL
	An e-mail address for this manufacturer.

dcs_measurement

The following table contains information related to the measurements of a particular item.

Column	Data Type	Constraint
`sku_id`	VARCHAR(40)	NOT NULL
(primary key	The unique SKU ID for an item
`unit_of_measure`	INT	NULL
	The unit of measurement that is used to quantify this item. Meters, liters etc.
`quantity`	DOUBLE PRECISION	NULL
	The quantity of the particular unit of measurement.

Legal Notices

ATG Commerce Programming Guide