Å×ÀÌºí ¼³¸í:
ÀÌ Å×À̺íÀº TradingPositionContainer¸¦ ³ªÅ¸³»¸ç, TradingPositionÀ» Æ÷ÇÔÇÒ ¼ö ÀÖ°í, ¸ðµç ±¸¸ÅÀÚ ¶Ç´Â Àå±â ±¸¸Å °è¾àÀÇ °Å·¡ °è¾àÀ» ÅëÇØ ƯÁ¤ ±×·ìÀÇ ±¸¸ÅÀÚ°¡ »ç¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù.
¿ ¼³¸í:
¿ À̸§ | ¿ À¯Çü | ¿ ¼³¸í |
DESCRIPTION |
VARCHAR (254)
NULL |
TradingPositionContainer¿¡ ´ëÇÑ °£·«ÇÑ ¼³¸íÀ¸·Î, TradingPositionContainersÀ» °ü¸®ÇÏ´Â ¿î¿µÀÚ¿¡°Ô Ç¥½ÃÇÏ´Â µ¥ Àû´çÇÕ´Ï´Ù. |
FLAGS |
INTEGER
NOT NULL, DEFAULT 0 |
°í°´¿¡ ´ëÇÑ °¡°ÝÀ» ã´Â ŽºÅ© ¸í·É¿¡ ÀÇÇØ ¼öÇàµÉ Ư¼ö 󸮸¦ ³ªÅ¸³»´Â ºñÆ® Ç÷¡±×. Ãß°¡ Á¤º¸´Â TRADEPOSCN Å×À̺í: Á¤º¸¸¦ ÂüÁ¶ÇϽʽÿÀ. |
MARKFORDELETE |
INTEGER
NOT NULL, DEFAULT 0 |
ÀÌ TradingPositionContainer°¡ »èÁ¦ ´ë»óÀ¸·Î Ç¥½ÃµÇ¾ú´ÂÁö ¿©ºÎ¸¦ ³ªÅ¸³À´Ï´Ù. 0 = ¾Æ´Ï¿À 1 = ¿¹. TradingPositionContainer°¡ »èÁ¦ ´ë»óÀ¸·Î Ç¥½ÃµÇ¾úÀ¸¸ç »ç¿ëÇÒ ¼ö ¾ø½À´Ï´Ù. |
MEMBER_ID |
BIGINT
NOT NULL |
TradingPositionContainerÀÇ ¼ÒÀ¯ÀÚ. |
NAME |
VARCHAR (254)
NOT NULL |
TradingPositionContainerÀÇ ±â¾ïÇϱâ ÁÁÀº À̸§À¸·Î ƯÁ¤ ¼ÒÀ¯ÀÚ¿¡°Ô °íÀ¯ÇÕ´Ï´Ù. |
PRECEDENCE |
DOUBLE
NOT NULL, DEFAULT 0 |
ƯÁ¤ ½Ã°£¿¡ µÑ ÀÌ»óÀÇ °Å·¡ Æ÷Áö¼Ç ÄÁÅ×À̳ʰ¡ ±ÔÁ¤µÉ °æ¿ì, ÃÖ°í PRECEDENCE¸¦ °¡Áø °Å·¡ Æ÷Áö¼Ç ÄÁÅ×À̳ʰ¡ »ç¿ëµË´Ï´Ù. |
PRODUCTSET_ID |
INTEGER
NULL |
ProductSet´Â TradingPositionContainer¿¡ Æ÷ÇÔµÈ »óǰ ¸ñ·ÏÀ» ÁöÁ¤ÇÕ´Ï´Ù. |
TRADEPOSCN_ID |
BIGINT
NOT NULL |
»ý¼ºµÈ °íÀ¯ Ű |
TYPE |
CHARACTER (1)
NULL, DEFAULT 'S' |
°Å·¡ Æ÷Áö¼Ç ÄÁÅ×À̳ÊÀÇ Á¾·ù S = »óÁ¡ īŻ·Î±×ÀÇ »óǰ¿¡ ´ëÇÑ ±âº» °¡°ÝÀÌ µé¾î Àִ ǥÁØ °¡°Ý ¸ñ·Ï C = »óǰ ¹× ÇØ´ç »ç¿ëÀÚ Á¤ÀÇ °¡°Ý ¸ñ·ÏÀ» ÁöÁ¤ÇÏ´Â »ç¿ëÀÚ Á¤ÀÇ °¡°Ý ¸ñ·Ï |
»öÀÎ:
»öÀÎ À̸§ | »öÀÎµÈ ¿ À̸§ | »öÀÎ À¯Çü |
I0000255 | MEMBER_ID, NAME | °íÀ¯ »öÀÎ |
I442145 | TRADEPOSCN_ID, TYPE | °íÀ¯ÇÏÁö ¾ÊÀº »öÀÎ |
SQL020206020814320 | TRADEPOSCN_ID | 1Â÷ Ű |
Á¦ÇÑ»çÇ×:
Á¦ÇÑÀÚ À̸§ | ¿ À̸§ | Foreign Å×À̺í À̸§ | Foreign ¿ À̸§ | Á¦ÇÑÀÚ À¯Çü |
F_864 | PRODUCTSET_ID | PRODUCTSET | PRODUCTSET_ID | °è´Ü½Ä |
F_865 | MEMBER_ID | MEMBER | MEMBER_ID | °è´Ü½Ä |
ÂüÁ¶:
Á¦ÇÑÀÚ À̸§ | ÂüÁ¶µÈ ¿ À̸§ | Foreign Å×À̺í À̸§ | Foreign ¿ À̸§ | Á¦ÇÑÀÚ À¯Çü |
F_227 | TRADEPOSCN_ID | CATGRPTPC | TRADEPOSCN_ID | °è´Ü½Ä |
F_460 | TRADEPOSCN_ID | MGPTRDPSCN | TRADEPOSCN_ID | °è´Ü½Ä |
F_467 | TRADEPOSCN_ID | OFFER | TRADEPOSCN_ID | °è´Ü½Ä |
F_631 | TRADEPOSCN_ID | PURCHASELT | TRADEPOSCN_ID | °è´Ü½Ä |
F_832 | TRADEPOSCN_ID | TDPSCNCNTR | TRADEPOSCN_ID | °è´Ü½Ä |
F_913 | TRADEPOSCN_ID | TRDPSCNXML | TRADEPOSCN_ID | °è´Ü½Ä |
![]() |