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 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.
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 | 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 |