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:
| Name | 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 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
| Name | Column Names | Type |
| <SYSTEM-GENERATED> | DISPENTREL_ID | Primary Key |
| I0000092 |
DEVICEFMT_ID+STOREENT_ID+CATENTRY_ID+CATENTTYPE_ID+MBRGRP_ID+AUCTIONSTATE+RANK+LANGUAGE_ID | Unique Index |
| 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 |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | Type |
| F_302 | LANGUAGE_ID | LANGUAGE | LANGUAGE_ID | Cascade |
| F_303 | CATENTRY_ID | CATENTRY | CATENTRY_ID | Cascade |
| F_304 | STOREENT_ID | STOREENT | STOREENT_ID | Cascade |
| F_305 | MBRGRP_ID | MBRGRP | MBRGRP_ID | Cascade |
| F_306 | DEVICEFMT_ID | DEVICEFMT | DEVICEFMT_ID | Cascade |
| F_307 | CATENTTYPE_ID | CATENTTYPE | CATENTTYPE_ID | Cascade |