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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000082 | TRANSPORT_ID, STORE_ID, PROFILE_ID, CONNSPECATTNAME | Unique Index |
SQL030416034919070 | CSEDITATT_ID | Primary Key |
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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|