Reference > Database > WebSphere Commerce database tables > M
WebSphere Commerce database table: MASSOCTYPE
This table holds all of the possible types of associations that can exist between CatalogObjects.
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 SQL100520030353020 MASSOCTYPE_ID Primary Key
Referenced By 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
_vcc_freeselect_bottom_