WebSphere Commerce database table: DISPENTREL

This table holds the page names used to display CatalogEntries. The selection is based on Store, MemberGroup, DeviceType, CatalogEntryType, CatalogEntry, AuctionState, Language, or any combination of the above.

Column Descriptions
Column Name Column Type Description
CATENTRY_ID BIGINT NOT NULL The reference number of the CatalogEntry for which this page name displays. A value of 0 indicates that this page name will be used for for all CatalogEntries.
DISPENTREL_ID BIGINT NOT NULL The reference number of this entry.
LANGUAGE_ID INTEGER The language in which this page displays. For a list of language components, see the LANGUAGE table.
DEVICEFMT_ID INTEGER NOT NULL The reference number of the device type that the page will be displayed on. Foreign key to the DEVICEFMT table.
STOREENT_ID INTEGER NOT NULL The reference number of the Store for which this page will be displayed.
PAGENAME VARCHAR(254) NOT NULL The name and path of the display template page. The path is relative to the application document root.
CATENTTYPE_ID CHAR(16) NOT NULL The type of CatalogEntry that this page will be used to display. Foreign key to the CATENTTYPE table. For example, if this column is designated as "BundleBean", then this page will be used to display Bundles.
AUCTIONSTATE INTEGER NOT NULL DEFAULT 0 The flag that indicates that this template page displays a CatalogEntry that is on auction. A value of 0 indicates that it is not an auction template, while a value of 1 indicates that it is.
MBRGRP_ID BIGINT NOT NULL The reference number of the MemberGroup for which this template page will be displayed. A value of 0 indicates that this template page will be used for for all MemberGroups.
DESCRIPTION VARCHAR(254) A description of this display page.
FIELD1 VARCHAR(254) Customizable.
RANK DOUBLE A sequence number used to break ties when more than one page satisfies the selection criteria. The larger the rank, the lower the precedence of the page.
FIELD2 VARCHAR(254) Customizable.
OID VARCHAR(64) Reserved for IBM internal use.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
I0000092 DEVICEFMT_ID+STOREENT_ID+CATENTRY_ID+CATENTTYPE_ID+MBRGRP_ID+AUCTIONSTATE+RANK+LANGUAGE_ID Unique Index
SQL060903235150510 DISPENTREL_ID Primary Key
I0000093 AUCTIONSTATE+MBRGRP_ID+CATENTRY_ID+STOREENT_ID Non-Unique Index
I0000094 CATENTRY_ID+CATENTTYPE_ID+STOREENT_ID+MBRGRP_ID Non-Unique Index
I0000557 CATENTTYPE_ID Non-Unique Index
I0000558 MBRGRP_ID Non-Unique Index
I0000559 STOREENT_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_303 CATENTRY_ID CATENTRY CATENTRY_ID Cascade
F_307 CATENTTYPE_ID CATENTTYPE CATENTTYPE_ID Cascade
F_306 DEVICEFMT_ID DEVICEFMT DEVICEFMT_ID Cascade
F_302 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
F_305 MBRGRP_ID MBRGRP MBRGRP_ID Cascade
F_304 STOREENT_ID STOREENT STOREENT_ID Cascade