This table holds the page names used to display CatalogEntries. Selection is based on Store, MemberGroup, DeviceType, CatalogEntryType, CatalogEntry, AuctionState, Language, or any combination of the above.
Column Name | Column Type | Column Description |
---|---|---|
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. |
CATENTRY_ID | BIGINT NOT NULL |
The reference number of the CatalogEntry for which this page name will be displayed. A value of 0 indicates that this page name will be used for for all CatalogEntries. |
CATENTTYPE_ID | CHARACTER (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. |
DESCRIPTION | VARCHAR (254) NULL |
A descriptive comment of this entry. |
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. |
DISPENTREL_ID | BIGINT NOT NULL |
The reference number of this entry. |
FIELD1 | VARCHAR (254) NULL |
Customizable. |
FIELD2 | VARCHAR (254) NULL |
Customizable. |
LANGUAGE_ID | INTEGER NULL |
The language that this page displays. For a list of language components, see the LANGUAGE table. |
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. |
OID | VARCHAR (64) NULL |
Reserved for IBM internal use. |
PAGENAME | VARCHAR (254) NOT NULL |
The name and path of the display template page. The path is relative to the application document root. |
RANK | DOUBLE NULL |
A sequence number used to break ties when more than one page satisfies the selection criteria. The smaller the rank, the higher the precedence of the page. |
STOREENT_ID | INTEGER NOT NULL |
The reference number of the Store for which this page will be displayed. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
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 |
SQL030416034922190 | DISPENTREL_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint 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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|