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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416034955460 | MASSOCTYPE_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_430 | MASSOCTYPE_ID | MASSOCCECE | MASSOCTYPE_ID | Cascade |
F_434 | MASSOCTYPE_ID | MASSOCGPGP | MASSOCTYPE_ID | Cascade |