Database Table: MASSOC

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

Column Name Column Type Column Description
DESCRIPTION VARCHAR (254)
NULL
A description of the semantic specifier.
MASSOC_ID CHARACTER (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.
OID VARCHAR (64)
NULL
Reserved for IBM internal use.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416034954340 MASSOC_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_429 MASSOC_ID MASSOCCECE MASSOC_ID Cascade
F_433 MASSOC_ID MASSOCGPGP MASSOC_ID Cascade