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 Column Description
CONNSPECATTNAME VARCHAR (254)
NOT NULL
Name of the attribute for this transport (as specified in the Configuration Manager).
CONNSPECATTVALUE VARCHAR (254)
NULL
The value corresponding to the attribute name.
CSEDITATT_ID INTEGER
NOT NULL
Key to the table. Represents a unique entry.
CUSTOMIZABLE INTEGER
NOT NULL
Reserved for IBM internal use.
INSTANCE_NUM INTEGER
NOT NULL
Reserved for IBM internal use.
PROFILE_ID INTEGER
NULL
The profile to which this record is applicable. If NULL, then this record is applicable at a store or site level.
STORE_ID INTEGER
NULL
The store to which this record is applicable. If NULL, then this record is applicable at a profile or site level.
TRANSPORT_ID INTEGER
NOT NULL
Foreign key to the TRANSPORT table. Indicates which transport these attributes are for.
Indexes:
Index Name Indexed Column Names Index Type
I0000082 TRANSPORT_ID, STORE_ID, PROFILE_ID, CONNSPECATTNAME Unique Index
SQL030416034919070 CSEDITATT_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_282 TRANSPORT_ID, STORE_ID STORETRANS TRANSPORT_ID, STORE_ID Cascade
F_283 PROFILE_ID PROFILE PROFILE_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable