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 | Description |
---|---|---|---|
| varchar(40) | not null | The unique identifier associated with the catalog. References |
| varchar(40) | not null | The unique identifier associated with the category. References |
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 | Description |
---|---|---|---|
| varchar(40) | not null | The ID of the category whose ancestor category is defined by the |
| integer | not null | 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_cat_ancestors
This table contains information about category ancestors.
Column | Data Type | Constraint | Description |
---|---|---|---|
| varchar(40) | not null | The unique identifier associated with the category. |
| varchar(40) | not null | 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 | Description |
---|---|---|---|
| varchar(40) | not null | The unique identifier associated with the category. References |
| varchar(42) | not null | Represents the key. |
media_id | varchar(40) | not null | The value that points to a media item. References |
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 | Description |
---|---|---|---|
| varchar(40) | not null | The ID of the category that can be viewed in the catalog defined by the |
| varchar(40) | not null | The ID of the catalog within which the category defined in the |
dcs_cat_catinfo
This table contains information about a specific category in the catalog.
Column | Data Type | Constraint | Description |
---|---|---|---|
| varchar(40) | not null | The unique identifier associated with the category. References |
| varchar(40) | not null | The unique identifier associated with the catalog. |
| varchar(40) | not null | Unique identifier of the |
dcs_cat_groups
This table contains information about groups in a category.
Column | Data Type | Constraint | Description |
---|---|---|---|
| varchar(40) | not null | The unique identifier associated with the category. References |
| varchar(254) | null | Stores the name of a Content Group that should return a list of products that should be children of this category. |
| varchar(254) | null | Stores the name of a Content Group that should return a list of categories that should be children of this category. |
| varchar(245) | 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 | Description |
---|---|---|---|
| varchar(40) | not null | The unique identifier associated with the category. References |
| integer | not null | Used to order rows in this table. |
| varchar(40) | not null | A category ID that should be considered a child of this category. References |
| varchar(245) | null | Stores the name of a Content Group that should return a list of categories that are related to this category. |
dcs_cat_chldprd
This table contains information about child products within a category.
Column | Data Type | Constraint | Description |
---|---|---|---|
| varchar(40) | not null | The unique identifier associated with the category. References |
| integer | not null | Used to order rows in this table. |
| varchar(40) | not null | A product ID that should be considered a child of this category. References |
dcs_cat_keywrds
This table contains information about category keywords.
Column | Data Type | Constraint | Description |
---|---|---|---|
| varchar(40) | not null | The unique identifier associated with the category. References |
| integer | not null | Used to order rows in this table. |
| 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 | Description |
---|---|---|---|
| varchar(40) | not null | The unique identifier associated with the category. References |
| varchar(40) | null | The ID of a media item that represents the template that renders the category. References |
| 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 |
| 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 |
| 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_cat_prnt_cats
This table stores information related to a catalog’s parent categories.
Column | Data Type | Constraint | Description |
---|---|---|---|
| varchar(40) | not null | The ID of a category. |
| varchar(40) | not null | The ID of a catalog. |
| 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 | Description |
---|---|---|---|
| varchar(40) | not null | The unique identifier associated with the category. |
| integer | not null | Used to order rows in this table. |
| varchar(40) | not null | A category ID that should be considered related to the category. References |
dcs_cat_subcats
This table contains information about the sub-categories for a specific category in the catalog.
Column | Data Type | Constraint | Description |
---|---|---|---|
| varchar(40) | not null | The unique identifier associated with the category. References |
| integer | not null | 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 catalog.
Column | Data Type | Constraint | Description |
---|---|---|---|
| varchar(40) | not null | The unique identifier associated with the category. References |
| integer | not null | This number is used to order the sub catalogs. |
| varchar(40) | not null | The unique identifier associated with the subcategory. |
dcs_catalog
This table contains information that describes catalogs.
Column | Data Type | Constraint | Description |
---|---|---|---|
| varchar(40) | not null | The unique identifier associated with the catalog. |
| integer | not null | The integer incremented with each revision to prevent version conflict. |
| varchar (254) | null | The name of the 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_catalog_sites
This table stores information related to site ownership of catalogs. Used by the multisite feature.
Column | Data Type | Constraint | Description |
---|---|---|---|
| varchar(40) | not null | The ID of a catalog. |
| varchar(40) | not null | 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 | Description |
---|---|---|---|
| varchar(40) | not null | The unique identifier associated with the category. |
| varchar (40) | The unique identifier associated with the catalog that contains this category. | |
| 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. |
| date | null | The date this category was created. |
| 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. |
| 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. |
| varchar (254) | null | The name of the category that displays in the ACC. |
| varchar (254) | null | A text description of the category. |
| long varchar | null | A long text description of the category. |
| varchar (40) | null | The ID of the immediate and default parent category. References |
| varchar (40) | null | The ID of the immediate and default parent category. |
| integer | null | An enumerated value used for defining sub-types of the initial Oracle ATG Web Commerce category item descriptor. |
| numeric(1) | null | A boolean (1 or 0) indicator that represents which categories should be considered the root of the catalog hierarchy. Checks |
dcs_category_info
This table contains information about categories in catalogs.
Column | Data Type | Constraint | Description |
---|---|---|---|
| varchar(40) | not null | 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_category_sites
This table stores information related to site ownership of categories. Used by the multisite feature.
Column | Data Type | Constraint | Description |
---|---|---|---|
| varchar(40) | not null | The ID of a category. |
| varchar(40) | not null | 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 | Description |
---|---|---|---|
| varchar(40) | not null | Identifier for the |
| varchar(40) | not null | Identifier for the ancestor category. |
dcs_catfol_chld
This table contains information about the folders in which catalogs are located.
Column | Data Type | Constraint | Description |
---|---|---|---|
| varchar (40) | not null | References |
| integer | not null | This number is used to order the catalogs. |
| 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 | Description |
---|---|---|---|
| varchar (40) | not null | References |
| varchar (40) | not null | References the ID of the site with which 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 | Description |
---|---|---|---|
| varchar (40) | not null | References |
| integer | not null | This number is used to order the child folders. |
| 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 | Description |
---|---|---|---|
| varchar (40) | not null | References |
| varchar (40) | not null | The configuration options associated with the configurable property. |
| integer | not null | 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 | Description |
---|---|---|---|
| varchar (40) | not null | The repository configurable property ID. |
| integer | not null | The repository version number. |
| varchar (40) | null | The display name of the configurable property. |
| varchar (255) | null | A description of the configurable property. |
| 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 | Description |
---|---|---|---|
| varchar (40) | not null | The repository configuration option ID. |
| integer | not null | The repository version number. |
| varchar (40) | null | The configuration option display name. |
| varchar (255) | null | The configuration option description. |
| varchar (40) | null | The configuration option SKU. |
| varchar (40) | null | The configuration option product. |
| double precision | null | The configuration option price. |
| 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 | Description |
---|---|---|---|
| varchar (40) | not null | The ID of the catalog whose ancestor category is defined by the |
| integer | not null | 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 c |
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 | Description |
---|---|---|---|
| varchar(40) | not null | The ID of the catalog whose direct ancestor is defined in the |
| integer | not null | 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_folder
This table contains information that describes a folder.
Column | Data Type | Constraint | Description |
---|---|---|---|
| varchar(40) | not null | The unique identifier associated with the folder. |
| 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. |
| date | null | The date this folder was created. |
| 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. |
| 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. |
| varchar (254) | null | A text description of the folder. |
| varchar (254) | not null | The name of the folder. |
| 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. |
| varchar (40) | not null | The ID of the folder that contains this folder in the catalog hierarchy. References |
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 | Description |
---|---|---|---|
catalog_id | varchar (40) | not null | The unique repository ID of the catalog. |
| integer | not null | The type field is used for sub-typing this catalog. |
| integer | not null | Version property that is used internally by the Repository to maintain data consistency. |
| varchar (100) | null | The name for this catalog that will appear in the ACC. |
| varchar (255) | null | A description of this catalog that is appropriate in a UI context. |
| varchar (100) | null | The host that this foreign catalog lives at. |
| integer | null | The port that this catalog can be located on at the host. |
| varchar (255) | null | The base URL to locate this catalog, at a given host. |
| varchar (255) | null | The URL that can be used for return. |
| 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 | Description |
---|---|---|---|
| varchar (40) | not null | 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_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 | Description |
---|---|---|---|
| varchar (40) | not null | The ID of the catalog whose indirect ancestor is defined by the |
| integer | not null | 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_media
This table contains information that describes a media item.
Column | Data Type | Constraint | Description |
---|---|---|---|
| varchar (40) | not null | The unique identifier associated with the media item. |
| 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. |
| date | null | The date this media item was created. |
| 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. |
| 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. |
| varchar (254) | null | A text description of the media item. |
| varchar (254) | not null | The name of the media item. |
| 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. |
| varchar (40) | not null | The ID of the folder that contains this media item in the catalog hierarchy. References |
| 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 | Description |
---|---|---|---|
| varchar(40) | not null | The unique identifier associated with the media. References |
| 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 | Description |
---|---|---|---|
| varchar(40) | not null | The unique identifier associated with the media. References |
| integer | not null | The number of bytes of data stored in the data column. |
| date | not null | The date this item was last modified. |
| long varchar | 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 | Description |
---|---|---|---|
| varchar (40) | not null | The unique identifier associated with the media. References |
| integer | not null | The number of bytes of data stored in the data column. |
| date | not null | The date this item was last modified. |
| 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 | Description |
---|---|---|---|
| varchar(40) | not null | The ID of the product whose ancestor category is defined in the |
| integer | not null | 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_prd_ancestors
Column | Data Type | Constraint | Description |
---|---|---|---|
| varchar(40) | not null | The unique identifier associated with the product. |
| varchar(40) | not null | 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 | Description |
---|---|---|---|
| varchar (40) | not null | The unique identifier associated with the product. References |
| varchar (42) | not null | Represents the key. |
| varchar (40) | not null | The value that points to a media item. References |
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 | Description |
---|---|---|---|
| varchar (40) | not null | The ID of the product that can be viewed in the catalog defined by the |
| varchar (40) | not null | The ID of the catalog within which the product defined by the |
dcs_prd_keywrds
This table contains information about product keywords.
Column | Data Type | Constraint | Description |
---|---|---|---|
| varchar (40) | not null | The unique identifier associated with the product. References |
| integer | not null | Used to order rows in this table. |
| 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 | Description |
---|---|---|---|
| varchar (40) | not null | The unique identifier associated with the product. References |
| varchar (40) | null | The ID of a media item that represents the template that renders the product. References |
| 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 |
| 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 |
| 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_prd_chldsku
This table contains information about children of products.
Column | Data Type | Constraint | Description |
---|---|---|---|
| varchar (40) | not null | The unique identifier associated with the product. References |
| integer | not null | Used to order rows in the table. |
| varchar (40) | not null | The ID of a SKU that is a child of this product. References |
dcs_prd_groups
This table contains information about related product groups.
Column | Data Type | Constraint | Description |
---|---|---|---|
| varchar(40) | not null | The unique identifier associated with the product. References |
| 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 | Description |
---|---|---|---|
| varchar(40) | not null | The unique identifier associated with the product. References |
| varchar (40) | not null | The unique identifier associated with a catalog. |
| varchar (40) | not null | The unique identifier of 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 | Description |
---|---|---|---|
| varchar(40) | not null | The ID of the product whose parent category in the catalog defined by the |
| varchar(40) | not null | 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_rltdprd
This table contains information about related products.
Column | Data Type | Constraint | Description |
---|---|---|---|
| varchar(40) | not null | The unique identifier associated with the product. References |
| integer | not null | Used to order rows in the table. |
| varchar(40) | not null | A product ID that should be considered related to the product. References |
dcs_prd_skuattr
This table contains information about which attributes of a SKU should be displayed.
Column | Data Type | Constraint | Description |
---|---|---|---|
| varchar(40) | not null | The unique identifier associated with the product. References |
| integer | not null | Used to order rows in the table. |
| 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 | Description |
---|---|---|---|
| varchar (40) | not null | The unique identifier of the |
| varchar (40) | not null | The unique identifier of the ancestor category. |
dcs_prdinfo_rdprd
This table contains information about related products.
Column | Data Type | Constraint | Description |
---|---|---|---|
| varchar(40) | not null | References |
| integer | not null | This number is used to order the related products. |
| varchar(40) | not null | References |
dcs_product
This table contains information that describes a product item.
Column | Data Type | Constraint | Description |
---|---|---|---|
| varchar (40) | not null | The unique identifier associated with the product. |
| 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. |
| date | null | The date this product was created. |
| 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. |
| 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. |
| varchar (254) | null | The name of the product that displays in the ACC. |
| varchar (254) | null | A text description of the product. |
| long varchar | null | A long text description of the product. |
| varchar (40) | null | The ID of the immediate and default parent category. References |
| varchar (40) | null | The ID of the immediate and default parent category. |
| integer | null | An enumerated value used for defining sub-types of the initial Oracle ATG Web Commerce product item descriptor. |
| varchar 40 | null | A reference to the manufacturer of this particular product. References |
| boolean | null | Indicates whether the product is eligible to receive discounts through promotions. The default is true. |
dcs_product_acl
The table stores security information for each product repository item.
Column | Data Type | Constraint | Description |
---|---|---|---|
| varchar(40) | not null | The unique identifier associated with the product. |
| 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 | Description |
---|---|---|---|
| varchar(40) | not null | 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_product_sites
This table stores information related to site ownership of catalogs. Used by the multisite feature.
Column | Data Type | Constraint | Description |
---|---|---|---|
| varchar(40) | not null | The ID of a product. |
| varchar(40) | not null | 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 | Description |
---|---|---|---|
| varchar(40) | not null | The unique identifier associated with the catalog. References |
| varchar (40) | not null | The unique identifier associated with the category. References |
dcs_root_subcats
This table contains a list of root sub-catalogs.
Column | Data Type | Constraint | Description |
---|---|---|---|
| varchar (40) | not null | The unique identifier associated with the catalog. References |
| varchar (40) | not null | The unique identifier associated with the sub-catalog. References |
dcs_sku
This table contains information that describes a SKU item.
Column | Data Type | Constraint | Description |
---|---|---|---|
| varchar (40) | not null | The unique identifier associated with the SKU. |
| 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. |
| date | null | The date this SKU was created. |
| 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. |
| 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. |
| varchar (254) | null | The name of the SKU that displays in the ACC. |
| varchar (254) | null | A text description of the SKU. |
| integer | null | An enumerated value used for defining sub-types of the initial Oracle ATG Web Commerce SKU item descriptor. |
| double precision | null | The wholesale price of the SKU. |
| double precision | null | The list price of the SKU. |
| double precision | null | The sale price of the SKU. |
| numeric(1) | null | Determines whether the SKU is on sale. Checks |
| INTEGER | null | An optional field that may be used to determine the taxable status of the SKU. |
| integer | null | An enumerated value that indicates which Oracle ATG Web Commerce fulfiller should attempt to process the SKU in the submitted order. |
| varchar (254) | null | A String property that represents the manufacturers part number for this SKU. |
| boolean | null | Indicates whether the SKU is eligible to receive discounts through promotions. The default is true. |
dcs_sku_attr
This table holds information about an attribute map associated with a SKU.
Column | Data Type | Constraint | Description |
---|---|---|---|
| varchar (40) | not null | The unique identifier associated with the SKU. References |
| varchar (42) | not null | Represents the key. |
| 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 | Description |
---|---|---|---|
| varchar (40) | not null | The unique identifier associated with the SKU. References |
| varchar (42) | not null | Represents the key. |
| varchar (40) | not null | The value that points to a SKU. References |
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 | Description |
---|---|---|---|
| varchar (40) | not null | The ID of the SKU that can be viewed within the catalog defined by the |
| varchar (40) | not null | The ID of the catalog within which the SKU defined by the |
dcs_sku_link
This table describes SKU links, which are used to represent SKU bundles.
Column | Data Type | Constraint | Description |
---|---|---|---|
| varchar (40) | not null | The unique identifier of the SKU link, which represents a bundle of SKUs. |
| 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. |
| date | null | The date this SKU was created. |
| 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. |
| 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. |
| varchar (254) | null | The name of the SKU link that displays in the ACC. |
| varchar (254) | null | A text description of the SKU. |
| integer | not null | The number of items to include in the bundle. |
| varchar (40) | not null | The specific SKU to include in the bundle. References |
dcs_sku_bndllnk
This table contains information that associated SKU links with SKU objects.
Column | Data Type | Constraint | Description |
---|---|---|---|
| varchar (40) | not null | The unique identifier associated with the SKU. References |
| integer | not null | Used to order rows in the table. |
| varchar (40) | not null | The ID of the SKU link that should be included in the SKU bundle. References |
dcs_sku_conf
The following table contains information related to configurable SKUs.
Column | Data Type | Constraint | Description |
---|---|---|---|
| varchar (40) | not null | References |
| varchar (40) | not null | The configurable properties associated with this configurable SKU. |
| integer | not null | 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 | Description |
---|---|---|---|
| varchar (40) | not null | The unique identifier associated with the SKU. References |
| varchar (40) | null | The ID of a SKU that represents the template that renders the category. References |
| 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 |
| 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 |
| 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_sku_replace
This table contains information about replacing SKUs.
Column | Data Type | Constraint | Description |
---|---|---|---|
| varchar (40) | not null | The unique identifier associated with the SKU. References |
| integer | not null | Used to order the rows in the table. |
| 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 | Description |
---|---|---|---|
| varchar(40) | not null | The ID of a SKU. |
| varchar(40) | not null | 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 | Description |
---|---|---|---|
| varchar(40) | not null | The unique identifier associated with the SKU. References |
| varchar(40) | not null | 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_sku_info
This table contains information about the SKUs in catalogs.
Column | Data Type | Constraint | Description |
---|---|---|---|
| varchar(40) | not null | 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_skuinfo_rplc
This table contains information about the replacement items to associate with a skuInfo
.
Column | Data Type | Constraint | Description |
---|---|---|---|
| varchar(40) | not null | References |
| integer | not null | This number is used to order the replacement products. |
| varchar(40) | not null | Identifier for the replacement item to associate with this |
dcs_sub_catalogs
This table contains a list of all sub catalogs (and their sub catalogs).
Column | Data Type | Constraint | Description |
---|---|---|---|
| varchar(40) | not null | The unique identifier associated with the catalog. |
| varchar(40) | not null | 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 | Description |
---|---|---|---|
| varchar(40) | not null | The ID of the user profile whose catalog is defined in the |
| varchar(40) | not null | The ID of the catalog that is used by the user defined by the |
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 | Description |
---|---|---|---|
| varchar(40) | not null | The repository ID of the manufacturer. |
| varchar (254) | null | A string name that identifies the manufacturer. |
| varchar (254) | null | A short description of this manufacturer. |
| long varchar | null | A long description of this manufacturer. |
| 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 | Description |
---|---|---|---|
| varchar(40) | not null | The unique SKU ID for an item. |
| integer | null | The unit of measurement that is used to quantify this item. Meters, liters etc. |
| double precision | null | The quantity of the particular unit of measurement. |