WebSphere Commerce database table: CSEDITATT

This table holds the attributes of the transport in the form of name-value pairs. The attributes of this table refer to connection-specific attributes of a transport. This table holds attribute information at three levels - site, store and profile.


Column Description(s):
Column NameColumn TypeDescription
CSEDITATT_ID INTEGER NOT NULL Key to the table. Represents a unique entry.
TRANSPORT_ID INTEGER NOT NULL Foreign key to the TRANSPORT table. Indicates which transport these attributes are for.
STORE_ID INTEGER The store to which this record is applicable. If NULL, then this record is applicable at a profile or site level.
PROFILE_ID INTEGER The profile to which this record is applicable. If NULL, then this record is applicable at a store or site level.
INSTANCE_NUM INTEGER NOT NULL Reserved for IBM internal use.
CUSTOMIZABLE INTEGER NOT NULL Reserved for IBM internal use.
CONNSPECATTNAME VARCHAR(254) NOT NULL Name of the attribute for this transport (as specified in the Configuration Manager).
CONNSPECATTVALUE VARCHAR(254) The value corresponding to the attribute name.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000082 TRANSPORT_ID+STORE_ID+PROFILE_ID+CONNSPECATTNAME Unique Index
SQL050212031219080 CSEDITATT_ID Primary Key
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_283 PROFILE_ID PROFILE PROFILE_ID Cascade
F_282 TRANSPORT_ID STORE_ID STORETRANS TRANSPORT_ID Cascade

Feedback