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. |
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 |
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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|