Database Table: PROFILE

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.
Indexes:
Index Name Indexed Column Names Index Type
I0000192 STORE_ID, TRANSPORT_ID, MSGTYPE_ID Unique Index
SQL030416035040520 PROFILE_ID Primary Key
Constraints:
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

Referenced By:
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