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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416034954340 | MASSOC_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
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 |