This table is used by the messaging system to store profile data. Specifically, it defines what transports are to be used for particular stores, message types, and priorities. It also holds other administrative information
Column Description(s):
Column Name | Column Type | Description |
PROFILE_ID |
INTEGER NOT NULL |
Unique key to profile table. |
STORE_ID |
INTEGER NOT NULL |
Foreign key to STORE table. Represents the store this profile is valid for. |
DEVICEFMT_ID |
INTEGER NOT NULL |
Foreign Key to DEVICEFMT table. Indicates what default format to use for this profile element. |
TRANSPORT_ID |
INTEGER NOT NULL |
Foreign key to TRANSPORT table. Represents the transport this entry is valid for. |
MSGTYPE_ID |
INTEGER NOT NULL |
Foreign key to MSGTYPE table. Indicates which message type this profile entry refers to. |
USERSVIEW |
CHAR(1) NOT NULL |
Flag specifying whether USER view preferences are available and should be accessed for this profile. |
LOWPRIORITY |
INTEGER NOT NULL DEFAULT 0 |
The lowest priority for which this profile entry is valid (default is 0). |
HIGHPRIORITY |
INTEGER NOT NULL DEFAULT 0 |
The highest priority for which this profile entry is valid (default is 0). |
ARCHIVEMSG |
INTEGER NOT NULL DEFAULT 0 |
If set to 1, messages of this message type will be archived after being successfully sent. |
OPTCOUNTER |
SMALLINT |
Reserved for IBM internal use. |
Index(es):
Index Name | Indexed Column Names | Index Type |
I0000192 |
STORE_ID+TRANSPORT_ID+MSGTYPE_ID |
Unique Index |
SQL050212031259090 |
PROFILE_ID |
Primary Key |
I0000701 |
MSGTYPE_ID |
Non-Unique Index |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_626 |
DEVICEFMT_ID |
DEVICEFMT |
DEVICEFMT_ID |
Cascade |
F_625 |
MSGTYPE_ID |
MSGTYPES |
MSGTYPE_ID |
Cascade |
F_623 |
STORE_ID |
STORE |
STORE_ID |
Cascade |
F_624 |
TRANSPORT_ID |
TRANSPORT |
TRANSPORT_ID |
Cascade |
Referenced By:
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_283 |
PROFILE_ID |
CSEDITATT |
PROFILE_ID |
Cascade |
F_402 |
PROFILE_ID |
ISEDITATT |
PROFILE_ID |
Cascade |
F_627 |
PROFILE_ID |
PROFNVSTRG |
PROFILE_ID |
Cascade |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.