Database Table: ORDITRD

Each row of this table indicates a TradingAgreement that was searched to obtain the price for an OrderItem. These rows are created by the OrderItemAdd and OrderItemUpdate commands.

Column Name Column Type Column Description
ORDERITEMS_ID BIGINT
NOT NULL
The OrderItem.
TRADING_ID BIGINT
NOT NULL
The TradingAgreement.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416035021100 ORDERITEMS_ID, TRADING_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_530 TRADING_ID TRADING TRADING_ID Cascade
F_531 ORDERITEMS_ID ORDERITEMS ORDERITEMS_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable