MASSOCGPGP

This table holds the merchandising associations that exist between CatalogGroups.

Column Descriptions:

Name	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	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	MASSOCGPGP_ID	Primary Key
I0000149	STORE_ID+MASSOCTYPE_ID+MASSOC_ID+CATGROUP_ID_FROM+CATGROUP_ID_TO	Unique Index
I0000611	CATGROUP_ID_FROM	Non-Unique Index
I0000612	CATGROUP_ID_TO	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_433	MASSOC_ID	MASSOC	MASSOC_ID	Cascade
F_434	MASSOCTYPE_ID	MASSOCTYPE	MASSOCTYPE_ID	Cascade
F_435	CATGROUP_ID_TO	CATGROUP	CATGROUP_ID	Cascade
F_436	CATGROUP_ID_FROM	CATGROUP	CATGROUP_ID	Cascade
F_944	STORE_ID	STORE	STORE_ID	Cascade