Reference > Database > WebSphere Commerce database tables > C
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 Name Column Type Description 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.
Indexes Index Name Indexed Column Names Index Type I0000082 TRANSPORT_ID+STORE_ID+PROFILE_ID+CONNSPECATTNAME Unique Index SQL100520030322340 CSEDITATT_ID Primary Key I0001253 PROFILE_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_283 PROFILE_ID PROFILE PROFILE_ID Cascade F_282 TRANSPORT_ID STORE_ID STORETRANS TRANSPORT_ID Cascade
Related reference
_vcc_freeselect_bottom_