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:

NameTypeDescription
CATENTRY_IDBIGINT NOT NULLThe reference number of the CatalogEntry for which this page name displays. A value of 0 indicates that this page name will be used for all CatalogEntries.
DISPENTREL_IDBIGINT NOT NULLThe reference number of this entry.
LANGUAGE_IDINTEGERThe language in which this page displays. For a list of language components, see the LANGUAGE table.
DEVICEFMT_IDINTEGER NOT NULLThe reference number of the device type that the page will be displayed on. Foreign key to the DEVICEFMT table.
STOREENT_IDINTEGER NOT NULLThe reference number of the Store for which this page will be displayed.
PAGENAMEVARCHAR (254) NOT NULLThe name and path of the display template page. The path is relative to the application document root.
CATENTTYPE_IDCHAR (16) NOT NULLThe 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.
AUCTIONSTATEINTEGER NOT NULL DEFAULT 0The 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_IDBIGINT NOT NULLThe 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 all MemberGroups.
DESCRIPTIONVARCHAR (254)A description of this display page.
FIELD1VARCHAR (254)Customizable.
RANKDOUBLEA 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.
FIELD2VARCHAR (254)Customizable.
OIDVARCHAR (64)Reserved for HCL internal use.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>DISPENTREL_IDPrimary Key
I0000092 DEVICEFMT_ID+STOREENT_ID+CATENTRY_ID+CATENTTYPE_ID+MBRGRP_ID+AUCTIONSTATE+RANK+LANGUAGE_IDUnique Index
I0000093 AUCTIONSTATE+MBRGRP_ID+CATENTRY_ID+STOREENT_IDNon-Unique Index
I0000094 CATENTRY_ID+CATENTTYPE_ID+STOREENT_ID+MBRGRP_IDNon-Unique Index
I0000557CATENTTYPE_IDNon-Unique Index
I0000558MBRGRP_IDNon-Unique Index
I0000559STOREENT_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_302LANGUAGE_IDLANGUAGELANGUAGE_IDCascade
F_303CATENTRY_IDCATENTRYCATENTRY_IDCascade
F_304STOREENT_IDSTOREENTSTOREENT_IDCascade
F_305MBRGRP_IDMBRGRPMBRGRP_IDCascade
F_306DEVICEFMT_IDDEVICEFMTDEVICEFMT_IDCascade
F_307CATENTTYPE_IDCATENTTYPECATENTTYPE_IDCascade