Database Table: MASSOCGPGP

This table holds the merchandising associations that exist between CatalogGroups.

Column Name Column Type Column Description
CATGROUP_ID_FROM BIGINT
NOT NULL
The CatalogGroup that is the source of the association.
CATGROUP_ID_TO BIGINT
NOT NULL
The CatalogGroup that is the target of the association.
DATE1 TIMESTAMP
NULL
Customizable.
FIELD1 VARCHAR (254)
NULL
Customizable.
FIELD2 INTEGER
NULL
Customizable.
FIELD3 DECIMAL (20,5)
NULL
Customizable.
GROUPNAME VARCHAR (254)
NULL
Reserved for IBM internal use.
MASSOCGPGP_ID BIGINT
NOT NULL
The reference number of this entry.
MASSOCTYPE_ID CHARACTER (32)
NOT NULL
The Identifier of the association type. Foreign key to the MASSOCTYPE table.
MASSOC_ID CHARACTER (32)
NOT NULL
The Identifier of the semantic specifier. Foreign key to the MASSOC table.
OID VARCHAR (64)
NULL
Reserved for IBM internal use.
QUANTITY DOUBLE
NULL
The quantity related to this association.
RANK DECIMAL (20,5)
NULL
The sequence number used for display order.
RULE CHARACTER (254)
NULL
Reserved for IBM internal use.
STORE_ID INTEGER
NOT NULL, DEFAULT 0
The store in which this merchandising association applies. A value of NULL indicates that this relationship is valid in all stores.
Indexes:
Index Name Indexed Column Names Index Type
I0000149 STORE_ID, MASSOCTYPE_ID, MASSOC_ID, CATGROUP_ID_FROM, CATGROUP_ID_TO Unique Index
SQL030416034955100 MASSOCGPGP_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint 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

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable