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