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 Descriptions:

Name	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 HCL internal use.
CUSTOMIZABLE	INTEGER NOT NULL	Reserved for HCL 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. This value may be encrypted if encrypt="Yes" is specified in the ConnectionSpec 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>	CSEDITATT_ID	Primary Key
I0000082	TRANSPORT_ID+STORE_ID+PROFILE_ID+CONNSPECATTNAME	Unique Index
I0001253	PROFILE_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_282	TRANSPORT_ID+STORE_ID	STORETRANS	TRANSPORT_ID+STORE_ID	Cascade
F_283	PROFILE_ID	PROFILE	PROFILE_ID	Cascade