Database Table: MGPTRDPSCN

A row in this table associates a TradingPositionContainer with a MemberGroup.

Task commands can use this relationship to restrict use of the TradingPositionContainer to members of certain MemberGroups. (See also the STOREMBRGP table.)

This table is deprecated and is provided for backward compatibility only. Use TermAndCondition objects and Participant objects to limit the use of TradingPositionContainers to certain customers. See the TRADING, TERMCOND, and PARTICIPNT tables for current information.

Column Name Column Type Column Description
MBRGRP_ID BIGINT
NOT NULL
The MemberGroup. Task commands that find prices for customers should use the MemberGroup as well as TRADEPOSCN.FLAGS and the STOREMBRGP relationship table to determine which customers can use the TradingPositionContainer.
TRADEPOSCN_ID BIGINT
NOT NULL
The TradingPositionContainer.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416035004740 TRADEPOSCN_ID, MBRGRP_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_460 TRADEPOSCN_ID TRADEPOSCN TRADEPOSCN_ID Cascade
F_461 MBRGRP_ID MBRGRP MBRGRP_ID Cascade

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