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 Descriptions:

NameTypeDescription
PROFILE_IDINTEGER NOT NULLUnique key to profile table.
STORE_IDINTEGER NOT NULLForeign key to STORE table. Represents the store this profile is valid for.
DEVICEFMT_IDINTEGER NOT NULLForeign Key to DEVICEFMT table. Indicates what default format to use for this profile element.
TRANSPORT_IDINTEGER NOT NULLForeign key to TRANSPORT table. Represents the transport this entry is valid for.
MSGTYPE_IDINTEGER NOT NULLForeign key to MSGTYPE table. Indicates which message type this profile entry refers to.
USERSVIEWCHAR (1) NOT NULLFlag specifying whether USER view preferences are available and should be accessed for this profile.
LOWPRIORITYINTEGER NOT NULL DEFAULT 0The lowest priority for which this profile entry is valid (default is 0).
HIGHPRIORITYINTEGER NOT NULL DEFAULT 0The highest priority for which this profile entry is valid (default is 0).
ARCHIVEMSGINTEGER NOT NULL DEFAULT 0If set to 1, messages of this message type will be archived after being successfully sent.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>PROFILE_IDPrimary Key
I0000192STORE_ID+TRANSPORT_ID+MSGTYPE_IDUnique Index
I0000701MSGTYPE_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_623STORE_IDSTORESTORE_IDCascade
F_624TRANSPORT_IDTRANSPORTTRANSPORT_IDCascade
F_625MSGTYPE_IDMSGTYPESMSGTYPE_IDCascade
F_626DEVICEFMT_IDDEVICEFMTDEVICEFMT_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_283PROFILE_IDCSEDITATTPROFILE_IDCascade
F_402PROFILE_IDISEDITATTPROFILE_IDCascade
F_627PROFILE_IDPROFNVSTRGPROFILE_IDCascade