WebSphere Commerce database table: MASSOCTYPE

This table holds all of the possible types of associations that can exist between CatalogObjects.

Column Descriptions
Column Name Column Type Description
MASSOCTYPE_ID CHAR(32) NOT NULL The Identifier of the association type. For example, the type can be "X-SELL", "UPSELL", or "ACCESSORY".
DESCRIPTION VARCHAR(254) A description of the association type.
FIELD1 INTEGER Customizable.
OID VARCHAR(64) Reserved for IBM internal use.
FIELD2 DECIMAL (20,5) Customizable.
FIELD3 VARCHAR(254) Customizable.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235212000 MASSOCTYPE_ID Primary Key

Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_430 MASSOCTYPE_ID MASSOCCECE MASSOCTYPE_ID Cascade
F_434 MASSOCTYPE_ID MASSOCGPGP MASSOCTYPE_ID Cascade
Related reference