This table is used by the messaging system to store header information about the available message types.
Column Name | Column Type | Column Description |
---|---|---|
DESCRIPTION | VARCHAR (254) NULL |
Description of the message type. |
MSGTDIR | INTEGER NOT NULL |
The direction of transmission this message is valid for. Valid values: 1=outgoing, 2=incoming, or 3=send-receive. |
MSGTYPE_ID | INTEGER NOT NULL |
Message type ID. Unique, primary key. |
NAME | VARCHAR (254) NOT NULL |
Short name for message type. |
VIEWNAME | VARCHAR (254) NOT NULL |
Name of view associated with this message type. This view must be registered to be usable in message transmission. This is a mandatory field. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000163 | NAME | Unique Index |
SQL030416035007270 | MSGTYPE_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_1022 | MSGTYPE_ID | NOTIFY | MSGTYPE_ID | Cascade |
F_625 | MSGTYPE_ID | PROFILE | MSGTYPE_ID | Cascade |