Database Table: MSGTYPES

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.
Indexes:
Index Name Indexed Column Names Index Type
I0000163 NAME Unique Index
SQL030416035007270 MSGTYPE_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_1022 MSGTYPE_ID NOTIFY MSGTYPE_ID Cascade
F_625 MSGTYPE_ID PROFILE MSGTYPE_ID Cascade