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 Descriptions:
Name | 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 NOT NULL DEFAULT 0 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
Name | Column Names | Type |
<SYSTEM-GENERATED> | PROFILE_ID | Primary Key |
I0000192 | STORE_ID+TRANSPORT_ID+MSGTYPE_ID | Unique Index |
I0000701 | MSGTYPE_ID | Non-Unique Index |
Constrained By Parent Tables:
Constraint | Columns | Parent Table | Parent Columns | Type |
F_623 | STORE_ID | STORE | STORE_ID | Cascade |
F_624 | TRANSPORT_ID | TRANSPORT | TRANSPORT_ID | Cascade |
F_625 | MSGTYPE_ID | MSGTYPES | MSGTYPE_ID | Cascade |
F_626 | DEVICEFMT_ID | DEVICEFMT | DEVICEFMT_ID | Cascade |
Referenced By Child Tables:
Constraint | Columns | Child Table | Child Columns | 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 |