This table holds the merchandising associations that exist between CatalogGroups.
Column Description(s):
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. |
Index(es):
Index Name | Indexed Column Names | Index Type |
I0000149 |
STORE_ID+MASSOCTYPE_ID+MASSOC_ID+CATGROUP_ID_FROM+CATGROUP_ID_TO |
Unique Index |
SQL050212031237570 |
MASSOCGPGP_ID |
Primary Key |
I0000611 |
CATGROUP_ID_FROM |
Non-Unique Index |
I0000612 |
CATGROUP_ID_TO |
Non-Unique Index |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | 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
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.