ISEDITATT

This table holds the attributes of the transport in the form of name-value pairs. The attributes of this table refer to interaction-level (message) attributes of a transport. This table holds attribute information at the profile level.

Column Descriptions:

Name	Type	Description
ISEDITATT_ID	INTEGER NOT NULL	Key to the table. Represents a unique entry.
PROFILE_ID	INTEGER NOT NULL	Foreign key to the PROFILE table. Represents the profile this record is applicable to.
CUSTOMIZABLE	INTEGER NOT NULL	Reserved for IBM internal use.
INTERSPECATTNAME	VARCHAR (254) NOT NULL	Name of the attribute for this transport (as specified in the Configuration Manager).
INTERSPECATTVALUE	VARCHAR (254)	The value corresponding to the attribute name. This value may be encrypted if encrypt="Yes" is specified in the InteractionSpec definition in the instance configuration file. If the value is encrypted, DBUpdate.txt and AfterMerchantKeyChangeDBUpdater class also need to specify this attribute name.
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	ISEDITATT_ID	Primary Key
I0000137	PROFILE_ID+INTERSPECATTNAME	Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_402	PROFILE_ID	PROFILE	PROFILE_ID	Cascade

Related reference
Messaging data model