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 Name | Column Type | Column Description |
---|---|---|
ARCHIVEMSG | INTEGER NOT NULL, DEFAULT 0 |
If set to 1, messages of this message type will be archived after being successfully sent. |
DEVICEFMT_ID | INTEGER NOT NULL |
Foreign Key to DEVICEFMT table. Indicates what default format to use for this profile element. |
HIGHPRIORITY | INTEGER NOT NULL, DEFAULT 0 |
The highest priority for which this profile entry is valid (default is 0). |
LOWPRIORITY | INTEGER NOT NULL, DEFAULT 0 |
The lowest priority for which this profile entry is valid (default is 0). |
MSGTYPE_ID | INTEGER NOT NULL |
Foreign key to MSGTYPE table. Indicates which message type this profile entry refers to. |
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. |
TRANSPORT_ID | INTEGER NOT NULL |
Foreign key to TRANSPORT table. Represents the transport this entry is valid for. |
USERSVIEW | CHARACTER (1) NOT NULL |
Flag specifying whether USER view preferences are available and should be accessed for this profile. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000192 | STORE_ID, TRANSPORT_ID, MSGTYPE_ID | Unique Index |
SQL030416035040520 | PROFILE_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint 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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | 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 |