Reference > Database > WebSphere Commerce database tables > M
WebSphere Commerce database table: MSGTYPES
This table is used by the messaging system to store header information about the available message types.
Column Name Column Type Description MSGTYPE_ID INTEGER NOT NULL Message type ID. Unique, primary key. MSGTDIR INTEGER NOT NULL The direction of transmission this message is valid for. Valid values: 1=outgoing, 2=incoming, or 3=send-receive. 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. DESCRIPTION VARCHAR(254) Description of the message type. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type I0000163 NAME Unique Index SQL100520030357170 MSGTYPE_ID Primary Key
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
Related reference
_vcc_freeselect_bottom_