WebSphere Commerce database table: PROFILE

Reference > Database > WebSphere Commerce database tables > P

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 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.

Indexes
Index Name Indexed Column Names Index Type
I0000192 STORE_ID+TRANSPORT_ID+MSGTYPE_ID Unique Index
SQL100520030414440 PROFILE_ID Primary Key
I0000701 MSGTYPE_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names 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 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

Related reference

Messaging data model

_vcc_freeselect_bottom_

+
Search Tips | Advanced Search

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 Name	Indexed Column Names	Index Type
I0000192	STORE_ID+TRANSPORT_ID+MSGTYPE_ID	Unique Index
SQL100520030414440	PROFILE_ID	Primary Key
I0000701	MSGTYPE_ID	Non-Unique Index

Constraint Name	Column Names	Foreign Table Name	Foreign Column Names	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

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