Reference > Database > WebSphere Commerce database tables > T

WebSphere Commerce database table: TRDATTACH

This table stores information about the trading to attachment relationship for a TradingAgreement.

Column Name	Column Type	Description
TRADING_ID	BIGINT NOT NULL	TradingAgreement ID.
ATTACHMENT_ID	BIGINT NOT NULL	Attachment ID.
OPTCOUNTER	SMALLINT	Reserved for IBM internal use.

Indexes

Index Name	Indexed Column Names	Index Type
SQL100520030442770	TRADING_ID+ATTACHMENT_ID	Primary Key
I0001292	ATTACHMENT_ID	Non-Unique Index

Constraints

Constraint Name	Column Names	Foreign Table Name	Foreign Column Names	Constraint Type
F_868	ATTACHMENT_ID	ATTACHMENT	ATTACHMENT_ID	Cascade
F_867	TRADING_ID	TRADING	TRADING_ID	Cascade

Related reference

• Contract data model

• Request for Quote (RFQ) data model

_vcc_freeselect_bottom_

+

Search Tips   |   Advanced Search