Reference > Database > WebSphere Commerce database tables > I


WebSphere Commerce database table: 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 Name Column 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.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
I0000137 PROFILE_ID+INTERSPECATTNAME Unique Index
SQL100520030347190 ISEDITATT_ID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_402 PROFILE_ID PROFILE PROFILE_ID Cascade


Related reference

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search