Some basic information about catalog data model tables

STORECAT
This table holds the relationship between StoreEntities and the Catalogs that they offer.
Column Name    Column Type    Description
CATALOG_ID     BIGINT NOT NULL     The reference number of the Catalog.
STOREENT_ID     INTEGER NOT NULL     The reference number of the StoreEntity.
MASTERCATALOG     CHAR(1)     Specifies a master catalog for the Store. A value of 1 indicates that this Catalog is designated as a master catalog.
LASTUPDATE     TIMESTAMP     Indicates the last time that this relationship was updated.
OPTCOUNTER     SMALLINT     Reserved for IBM internal use.


CATGPENREL

This table relates catalog groups (or categories) to the catalog entries that are inside them. You can also use this table to dictate the navigational flow from catalog groups to catalog entries. Each relationship is also qualified by a Catalog ID.

CATGROUP_ID     BIGINT NOT NULL     The source catalog group of this relationship.
CATALOG_ID     BIGINT NOT NULL     The catalog inside of which this relationship is found.
CATENTRY_ID     BIGINT NOT NULL     The target catalog entry of this relationship.
RULE     VARCHAR(254)     Reserved for IBM internal use.
SEQUENCE     DOUBLE NOT NULL DEFAULT 0     The sequence number that determines the display order of the contents of the catalog group.
LASTUPDATE     TIMESTAMP     Indicates the last time that this relationship was updated.
OPTCOUNTER     SMALLINT     Reserved for IBM internal use.

CATGROUP

This table hold the information related to a catalog group. A catalog group is similar to a generic category that can contain both other catalog groups and also catalog entries.

CATGROUP_ID     BIGINT NOT NULL     The internal reference number of the catalog group.
MEMBER_ID     BIGINT NOT NULL     The internal reference number that identifies the owner of the catalog group. Along with IDENTIFIER, these columns are a unique index.
IDENTIFIER     VARCHAR(254)     The external name that is used to identify the catalog group. Along with MEMBER_ID, these columns are a unique index.
MARKFORDELETE     INTEGER NOT NULL     Indicates if this catalog group has been marked for deletion:
0 = No.
1 = Yes.
LASTUPDATE     TIMESTAMP     Indicates the last time that this catalog group was updated.
FIELD1     VARCHAR(254)     Customizable.
FIELD2     VARCHAR(254)     Customizable.
OID     VARCHAR(64)     Reserved for IBM internal use.
RANK     DOUBLE     Reserved for IBM internal use.
OPTCOUNTER     SMALLINT     Reserved for IBM internal use.


CATGRPREL

This tables relates catalog groups(or categories) to child catalog group (or child categories). You can use this table to dictate the navigational flow from catalog groups to child catalog groups. Each relationship is also qualified by a Catalog ID.

CATGROUP_ID_PARENT     BIGINT NOT NULL     The source catalog group of this relationship.
CATGROUP_ID_CHILD     BIGINT NOT NULL     The target catalog group of this relationship.
CATALOG_ID     BIGINT NOT NULL     The catalog in which this relationship is found.
RULE     VARCHAR(254)     Reserved for IBM internal use.
SEQUENCE     DOUBLE NOT NULL DEFAULT 0     The sequence number that determines the display order of the contents of the catalog group.
LASTUPDATE     TIMESTAMP     Indicates the last time that this relationship was updated.
CATALOG_ID_LINK     BIGINT     Reserved for IBM internal use.
OPTCOUNTER     SMALLINT     Reserved for IBM internal use.

STORECGRP

This table holds the relationship between StoreEntities and the CatalogGroups that they can display and process.

Column Name    Column Type    Description
STOREENT_ID     INTEGER NOT NULL     The reference number of the Store Entity.
CATGROUP_ID     BIGINT NOT NULL     The reference number of the Catalog Group.
OPTCOUNTER     SMALLINT     Reserved for IBM internal use.



CATENTREL

This table holds containment relationships between catalog entries. Examples of these relationships are Product-Item, Bundle, and Package relationships. This table should not be used for peer-to-peer catalog relationships, such as cross-sells.
Column Name    Column Type    Description
CATENTRY_ID_PARENT     BIGINT NOT NULL     The reference number of the source catalog entry in this relationship.
CATRELTYPE_ID     CHAR(32) NOT NULL     The type of relationship:

    PRODUCT_ITEM
    PACKAGE_COMPONENT
    BUNDLE_COMPONENT
    DYNAMIC_KIT_COMPONENT

Foreign key to the CATRELTYPE table.
CATENTRY_ID_CHILD     BIGINT NOT NULL     The reference number of the target catalog entry in this relationship.
SEQUENCE     DOUBLE NOT NULL DEFAULT 0     The sequence number used to determine the display order.
QUANTITY     DOUBLE     A quantity that can be associated with the relationship.
GROUPNAME     VARCHAR(254)     Reserved for IBM internal use.
FIELD1     VARCHAR(254)     Customizable.
FIELD2     INTEGER     Customizable.
FIELD3     DECIMAL (20,5)     Customizable.
OID     VARCHAR(64)     Reserved for IBM internal use.
OPTCOUNTER     SMALLINT     Reserved for IBM internal use.
MANDATORY     CHAR(3)     Reserved for IBM internal use.