Reference > Database > WebSphere Commerce database tables > M
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 Name Column Type 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. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030356470 TRADEPOSCN_ID+MBRGRP_ID Primary Key I0000620 MBRGRP_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_461 MBRGRP_ID MBRGRP MBRGRP_ID Cascade F_460 TRADEPOSCN_ID TRADEPOSCN TRADEPOSCN_ID Cascade
Related reference
_vcc_freeselect_bottom_