WebSphere Commerce database table: MASSOC

This table holds all of the possible semantic specifiers that can be used when associating CatalogObjects.

Column Descriptions
Column Name Column Type Description
MASSOC_ID CHAR(32) NOT NULL The Identifier of the semantic specifier. For example, the semantic specifier may be "REQUIRED", "OPTIONAL", or "COMES WITH". Other types of specifier can be added.
DESCRIPTION VARCHAR(254) A description of the semantic specifier.
OID VARCHAR(64) Reserved for IBM internal use.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235211510 MASSOC_ID Primary Key

Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_429 MASSOC_ID MASSOCCECE MASSOC_ID Cascade
F_433 MASSOC_ID MASSOCGPGP MASSOC_ID Cascade
Related reference