Å×ÀÌºí ¼³¸í:
±¸ÀÔ ÇѰè Å×À̺í
¿ ¼³¸í:
¿ À̸§ | ¿ À¯Çü | ¿ ¼³¸í |
CATENTRY_ID |
BIGINT
NOT NULL |
ÆÇ¸Å¿ëÀ¸·Î Á¦°øµÈ CatalogEntry |
CURRENCY |
CHARACTER (3)
NULL |
ÃÖ¼Ò ¶Ç´Â ÃÖ´ë ±Ý¾×ÀÇ ÅëÈ. ISO 4217 Ç¥ÁØ¿¡ ¸Â´Â ÅëÈ ÄÚµå. |
CURRENTAMOUNT |
DECIMAL(20,5)
NULL |
ÇöÀç ±¸ÀÔ ÃѰè |
CURRENTQUANTITY |
DOUBLE
NULL |
ÇöÀç ±¸ÀÔ ¼ö·® |
LIMITTYPE |
CHARACTER (1)
NOT NULL |
ÇѰèÀÇ À¯ÇüÀ» Ç¥½ÃÇÕ´Ï´Ù. 0 = ¼ö·®º° ¶Ç´Â 1 = ÃѰ躰. |
MAXAMOUNT |
DECIMAL(20,5)
NULL |
ÃÖ´ë ±¸ÀÔ ÃѰè |
MAXQUANTITY |
DOUBLE
NULL |
ÃÖ´ë ±¸ÀÔ ¼ö·® |
MINAMOUNT |
DECIMAL(20,5)
NULL |
ÃÖ¼Ò ±¸ÀÔ ÃѰè |
MINQUANTITY |
DOUBLE
NULL |
ÃÖ¼Ò ±¸ÀÔ ¼ö·® |
PURCHASELT_ID |
BIGINT
NOT NULL |
³»ºÎ ÂüÁ¶ ¹øÈ£ ¹× 1Â÷ Ű |
TERMCOND_ID |
BIGINT
NOT NULL |
±ÔÁ¤ ID |
TRADEPOSCN_ID |
BIGINT
NOT NULL |
±¸ÀÔ ÇѰè´Â ÀÌ TradingPositionContainerÀÇ ºÎºÐÀÔ´Ï´Ù. |
»öÀÎ:
»öÀÎ À̸§ | »öÀÎµÈ ¿ À̸§ | »öÀÎ À¯Çü |
I0000194 | TERMCOND_ID, TRADEPOSCN_ID, CATENTRY_ID | °íÀ¯ »öÀÎ |
SQL020206020727940 | PURCHASELT_ID | 1Â÷ Ű |
Á¦ÇÑ»çÇ×:
Á¦ÇÑÀÚ À̸§ | ¿ À̸§ | Foreign Å×À̺í À̸§ | Foreign ¿ À̸§ | Á¦ÇÑÀÚ À¯Çü |
F_630 | CATENTRY_ID | CATENTRY | CATENTRY_ID | °è´Ü½Ä |
F_631 | TRADEPOSCN_ID | TRADEPOSCN | TRADEPOSCN_ID | °è´Ü½Ä |
F_632 | TERMCOND_ID | TERMCOND | TERMCOND_ID | °è´Ü½Ä |
ÂüÁ¶:
Á¦ÇÑÀÚ À̸§ | ÂüÁ¶µÈ ¿ À̸§ | Foreign Å×À̺í À̸§ | Foreign ¿ À̸§ | Á¦ÇÑÀÚ À¯Çü |
![]() |