Database Table: MASSOCCECE

This table holds the merchandising associations that exist between CatalogEntries.

Column Name Column Type Column Description
CATENTRY_ID_FROM BIGINT
NOT NULL
The CatalogEntry that is the source of the association.
CATENTRY_ID_TO BIGINT
NOT NULL
The CatalogEntry 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.
MASSOCCECE_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 VARCHAR (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
I0000148 STORE_ID, MASSOCTYPE_ID, MASSOC_ID, CATENTRY_ID_FROM, CATENTRY_ID_TO Unique Index
SQL030416034954780 MASSOCCECE_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_429 MASSOC_ID MASSOC MASSOC_ID Cascade
F_430 MASSOCTYPE_ID MASSOCTYPE MASSOCTYPE_ID Cascade
F_431 CATENTRY_ID_FROM CATENTRY CATENTRY_ID Cascade
F_432 CATENTRY_ID_TO CATENTRY CATENTRY_ID Cascade
F_943 STORE_ID STORE STORE_ID Cascade

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