MASSOCCECE

This table holds the merchandising associations that exist between CatalogEntries.

Column Descriptions:

Name	Type	Description
MASSOCCECE_ID	BIGINT NOT NULL	The reference number of this entry.
MASSOCTYPE_ID	CHAR (32) NOT NULL	The Identifier of the association type. Foreign key to the MASSOCTYPE table.
CATENTRY_ID_FROM	BIGINT NOT NULL	The CatalogEntry that is the source of the association.
RANK	DECIMAL (20,5)	The sequence number used for display order.
CATENTRY_ID_TO	BIGINT NOT NULL	The CatalogEntry that is the target of the association.
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	VARCHAR (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 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>	MASSOCCECE_ID	Primary Key
I0000148	STORE_ID+MASSOCTYPE_ID+MASSOC_ID+CATENTRY_ID_FROM+CATENTRY_ID_TO	Unique Index
I0000370	CATENTRY_ID_FROM	Non-Unique Index
I0000610	CATENTRY_ID_TO	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	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