Reference > Database > WebSphere Commerce database tables > D
WebSphere Commerce database table: DISPCGPREL
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 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.
Indexes Index Name Indexed Column Names Index Type I0000091 DEVICEFMT_ID+STOREENT_ID+CATGROUP_ID+MBRGRP_ID+RANK+LANGUAGE_ID Unique Index SQL100520030323930 DISPCGPREL_ID Primary Key I0000554 STOREENT_ID Non-Unique Index I0000555 CATGROUP_ID Non-Unique Index I0000556 MBRGRP_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names 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 _vcc_freeselect_bottom_