Database Table: DISPCGPREL

This table holds the page names used to display CatalogGroups. Selection is based on Store, MemberGroup, DeviceType, CatalogGroup, Language, or any combination of the above. If many pages satisfy the criteria, the page that best fits will be chosen.

Column Name Column Type Column Description
CATGROUP_ID BIGINT
NOT NULL
The reference number of the CatalogGroup for which this page name will be displayed. A value of 0 indicates that this page name will be used for for all CatalogGroups.
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.
DISPCGPREL_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 page template. 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.
Indexes:
Index Name Indexed Column Names Index Type
I0000091 DEVICEFMT_ID, STOREENT_ID, CATGROUP_ID, MBRGRP_ID, RANK, LANGUAGE_ID Unique Index
SQL030416034921810 DISPCGPREL_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_297 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
F_298 CATGROUP_ID CATGROUP CATGROUP_ID Cascade
F_299 STOREENT_ID STOREENT STOREENT_ID Cascade
F_300 DEVICEFMT_ID DEVICEFMT DEVICEFMT_ID Cascade
F_301 MBRGRP_ID MBRGRP MBRGRP_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable