Reference > Database > WebSphere Commerce database tables > M
WebSphere Commerce database table: MASSOCGPGP
This table holds the merchandising associations that exist between CatalogGroups.
Column Name Column Type Description MASSOCGPGP_ID BIGINT NOT NULL The reference number of this entry. CATGROUP_ID_TO BIGINT NOT NULL The CatalogGroup that is the target of the association. CATGROUP_ID_FROM BIGINT NOT NULL The CatalogGroup that is the source of the association. MASSOCTYPE_ID CHAR(32) NOT NULL The Identifier of the association type. Foreign key to the MASSOCTYPE table. RANK DECIMAL (20,5) The sequence number used for display order. MASSOC_ID CHAR(32) NOT NULL The Identifier of the semantic specifier. Foreign key to the MASSOC table. QUANTITY DOUBLE The quantity related to this association. RULE CHAR(254) Reserved for IBM internal use. GROUPNAME VARCHAR(254) Reserved for IBM internal use. FIELD1 VARCHAR(254) Customizable. FIELD2 INTEGER Customizable. FIELD3 DECIMAL (20,5) Customizable. OID VARCHAR(64) Reserved for IBM internal use. DATE1 TIMESTAMP Customizable. STORE_ID INTEGER NOT NULL DEFAULT 0 The store in which this merchandising association applies. A value of 0 (zero) indicates that this relationship is valid in all stores. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type I0000149 STORE_ID+MASSOCTYPE_ID+MASSOC_ID+CATGROUP_ID_FROM+CATGROUP_ID_TO Unique Index SQL100520030352690 MASSOCGPGP_ID Primary Key I0000611 CATGROUP_ID_FROM Non-Unique Index I0000612 CATGROUP_ID_TO Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_435 CATGROUP_ID_TO CATGROUP CATGROUP_ID Cascade F_436 CATGROUP_ID_FROM CATGROUP CATGROUP_ID Cascade F_433 MASSOC_ID MASSOC MASSOC_ID Cascade F_434 MASSOCTYPE_ID MASSOCTYPE MASSOCTYPE_ID Cascade F_944 STORE_ID STORE STORE_ID Cascade
Related reference
_vcc_freeselect_bottom_