Database Table: MASSOCTYPE

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

Column Name Column Type Column Description
DESCRIPTION VARCHAR (254)
NULL
A description of the association type.
FIELD1 INTEGER
NULL
Customizable.
FIELD2 DECIMAL (20,5)
NULL
Customizable.
FIELD3 VARCHAR (254)
NULL
Customizable.
MASSOCTYPE_ID CHARACTER (32)
NOT NULL
The Identifier of the association type. For example, the type can be "X-SELL", "UPSELL", or "ACCESSORY".
OID VARCHAR (64)
NULL
Reserved for IBM internal use.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416034955460 MASSOCTYPE_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
Not Applicable

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