WebSphere Commerce 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 Description(s):
Column NameColumn TypeDescription
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 NameIndexed Column NamesIndex Type
I0000192 STORE_ID+TRANSPORT_ID+MSGTYPE_ID Unique Index
SQL050212031259090 PROFILE_ID Primary Key
I0000701 MSGTYPE_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign 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 NameReferenced Column NameForeign Table NameForeign 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

Feedback