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:

NameTypeDescription
CSEDITATT_IDINTEGER NOT NULLKey to the table. Represents a unique entry.
TRANSPORT_IDINTEGER NOT NULLForeign key to the TRANSPORT table. Indicates which transport these attributes are for.
STORE_IDINTEGERThe store to which this record is applicable. If NULL, then this record is applicable at a profile or site level.
PROFILE_IDINTEGERThe profile to which this record is applicable. If NULL, then this record is applicable at a store or site level.
INSTANCE_NUMINTEGER NOT NULLReserved for HCL internal use.
CUSTOMIZABLEINTEGER NOT NULLReserved for HCL internal use.
CONNSPECATTNAMEVARCHAR (254) NOT NULLName of the attribute for this transport (as specified in the Configuration Manager).
CONNSPECATTVALUEVARCHAR (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.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>CSEDITATT_IDPrimary Key
I0000082 TRANSPORT_ID+STORE_ID+PROFILE_ID+CONNSPECATTNAMEUnique Index
I0001253PROFILE_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_282TRANSPORT_ID+STORE_IDSTORETRANSTRANSPORT_ID+STORE_IDCascade
F_283PROFILE_IDPROFILEPROFILE_IDCascade