TRDATTACH

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


Column Descriptions:

Name Type Description
TRADING_ID BIGINT NOT NULL TradingAgreement ID.
ATTACHMENT_ID BIGINT NOT NULL Attachment ID.
OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 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> TRADING_ID+ATTACHMENT_ID Primary Key
I0001292 ATTACHMENT_ID Non-Unique Index


Constrained By Parent Tables:

Constraint Columns Parent Table Parent Columns Type
F_867 TRADING_ID TRADING TRADING_ID Cascade
F_868 ATTACHMENT_ID ATTACHMENT ATTACHMENT_ID Cascade


Related reference
Contract data model
Request for Quote (RFQ) data model