TRDATTACH

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

Column Descriptions:

NameTypeDescription
TRADING_IDBIGINT NOT NULLTradingAgreement ID.
ATTACHMENT_IDBIGINT NOT NULLAttachment ID.
OPTCOUNTERSMALLINTThe optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>TRADING_ID+ATTACHMENT_IDPrimary Key
I0001292ATTACHMENT_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_867TRADING_IDTRADINGTRADING_IDCascade
F_868ATTACHMENT_IDATTACHMENTATTACHMENT_IDCascade