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 Related reference
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