WebSphere Commerce 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 Description(s):
Column NameColumn TypeDescription
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.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031240230 TRADEPOSCN_ID+MBRGRP_ID Primary Key
I0000620 MBRGRP_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_461 MBRGRP_ID MBRGRP MBRGRP_ID Cascade
F_460 TRADEPOSCN_ID TRADEPOSCN TRADEPOSCN_ID Cascade

Feedback