This table holds the page names used to display CatalogGroups. The 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 Description(s):
Column Name | Column Type | 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. |
DISPCGPREL_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. |
PAGENAME |
VARCHAR(254) NOT NULL |
The name and path of the display page template. The path is relative to the application document root. |
STOREENT_ID |
INTEGER NOT NULL |
The reference number of the Store for which this page will be displayed. |
MBRGRP_ID |
BIGINT NOT NULL |
The reference number of the MemberGroup for which this template page will display. A value of 0 indicates that this template page will be used for for all MemberGroups. |
DESCRIPTION |
VARCHAR(254) |
A descriptive comment of this entry. |
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. |
FIELD1 |
VARCHAR(254) |
Customizable. |
FIELD2 |
VARCHAR(254) |
Customizable. |
OID |
VARCHAR(64) |
Reserved for IBM internal use. |
OPTCOUNTER |
SMALLINT |
Reserved for IBM internal use. |
Index(es):
Index Name | Indexed Column Names | Index Type |
I0000091 |
DEVICEFMT_ID+STOREENT_ID+CATGROUP_ID+MBRGRP_ID+RANK+LANGUAGE_ID |
Unique Index |
SQL050212031220790 |
DISPCGPREL_ID |
Primary Key |
I0000554 |
STOREENT_ID |
Non-Unique Index |
I0000555 |
CATGROUP_ID |
Non-Unique Index |
I0000556 |
MBRGRP_ID |
Non-Unique Index |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_298 |
CATGROUP_ID |
CATGROUP |
CATGROUP_ID |
Cascade |
F_300 |
DEVICEFMT_ID |
DEVICEFMT |
DEVICEFMT_ID |
Cascade |
F_297 |
LANGUAGE_ID |
LANGUAGE |
LANGUAGE_ID |
Cascade |
F_301 |
MBRGRP_ID |
MBRGRP |
MBRGRP_ID |
Cascade |
F_299 |
STOREENT_ID |
STOREENT |
STOREENT_ID |
Cascade |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.