Å×ÀÌºí ¼³¸í:
ÀÌ Å×À̺íÀÇ °¢ ÇàÀº CatalogEntry¿¡ ÀÇÇØ ½Äº°µÇ´Â »óǰÀ» ÆÈ±â À§ÇÑ ÆÇ¸Å ¼³Á¤À» ³ªÅ¸³À´Ï´Ù.
¿ ¼³¸í:
¿ À̸§ | ¿ À¯Çü | ¿ ¼³¸í |
CATENTRY_ID |
BIGINT
NOT NULL |
ÆÇ¸Å¿ëÀ¸·Î Á¦°øµÈ CatalogEntry. |
ENDDATE |
TIMESTAMP
NULL |
ÀÌ ÆÇ¸Å ¼³Á¤ÀÌ ½Ç½ÃµÇ´Â ±â°£ÀÇ Á¾·á ½Ã°£. |
FIELD1 |
CHARACTER (30)
NULL |
»ç¿ëÀÚ Á¤ÀÇ °¡´É |
FIELD2 |
CHARACTER (1)
NULL |
»ç¿ëÀÚ Á¤ÀÇ °¡´É |
FLAGS |
INTEGER
NOT NULL, DEFAULT 1 |
´ÙÀ½°ú °°Àº ºñÆ® Ç÷¡±× °ªÀÌ µé¾î ÀÖ½À´Ï´Ù. 1 - ¿î¼Û ÁÖ¼Ò ÇÊ¿ä - 1ÀÏ °æ¿ì, OrderItemÀÌ ÀÌ ÆÇ¸Å ¼³Á¤À» ÂüÁ¶Çϳª ¿î¼Û ÁÖ¼Ò°¡ ¾øÀ¸¸é OrderPrepare¿¡¼ ¿À·ù°¡ ¸®Åϵ˴ϴÙ. |
IDENTIFIER |
BIGINT
NULL |
ÁöÁ¤µÈ CatalogEntry ¹× TradingPositionContainer¿Í ÇÔ²² ÀÌ ÆÇ¸Å ¼³Á¤À» °íÀ¯ÇÏ°Ô ½Äº°ÇÏ´Â ¹øÈ£. |
LASTUPDATE |
TIMESTAMP
NULL |
¸¶Áö¸·À¸·Î ÆÇ¸Å ¼³Á¤ÀÌ °»½ÅµÈ ½Ã°£. |
MAXIMUMQUANTITY |
DOUBLE
NULL |
ÀÌ ÆÇ¸Å ¼³Á¤¿¡¼ ÇÑ ¹øÀÇ ÁÖ¹®À¸·Î ±¸ÀÔÇÒ ¼ö ÀÖ´Â ÃÖ´ë ¼ö·®. |
MINIMUMQUANTITY |
DOUBLE
NULL |
ÀÌ ÆÇ¸Å ¼³Á¤¿¡¼ ÇÑ ¹øÀÇ ÁÖ¹®À¸·Î ±¸ÀÔÇÒ ¼ö ÀÖ´Â ÃÖ¼Ò ¼ö·®. |
OFFER_ID |
BIGINT
NOT NULL |
»ý¼ºµÈ °íÀ¯ Ű |
OID |
VARCHAR (64)
NULL |
IBM ³»ºÎ¿ëÀ¸·Î ¿¹¾à |
PRECEDENCE |
DOUBLE
NOT NULL, DEFAULT 0 |
ƯÁ¤ ½Ã°£¿¡ ÇÑ ¹ø ÀÌ»óÀÇ ÆÇ¸Å ¼³Á¤ÀÌ ÁøÇàµÉ °æ¿ì, ÃÖ°í PRECEDENCE ´ç Çϳª°¡ »ç¿ëµË´Ï´Ù. |
PUBLISHED |
INTEGER
NOT NULL, DEFAULT 0 |
´ÙÀ½°ú °°ÀÌ ÆÇ¸Å ¼³Á¤ÀÇ °ø°³ ¿©ºÎ¸¦ ¼³¸íÇÕ´Ï´Ù. 0 = °ø°³µÇÁö ¾ÊÀ½(ÀϽÃÀûÀ¸·Î »ç¿ë ¾ÈÇÔ) 1 = °ø°³ 2 = »èÁ¦ Ç¥½Ã(°ø°³µÇÁö ¾ÊÀ½) |
QTYUNIT_ID |
CHARACTER (16)
NULL |
MINIMUMQUANTITY ¹× MAXIMUMQUANTITYÀÇ Æ¯Á¤ ´ÜÀ§. ÀÌ ´ÜÀ§°¡ ³Î(Null)°ªÀ̸é, MINIMUMQUANTITY ¹× MAXIMUMQUANTITY¿¡ CATENTSHIP.NOMINALQUANTITY¸¦ °öÇÏ°í °á°úÀÇ ÃøÁ¤ ´ÜÀ§´Â CATENTSHIP.QUANTITYMEASUREÀÔ´Ï´Ù. |
STARTDATE |
TIMESTAMP
NULL |
ÀÌ ÆÇ¸Å ¼³Á¤ÀÌ ½Ç½ÃµÇ´Â ±â°£ÀÇ ½ÃÀÛ ½Ã°£. |
TRADEPOSCN_ID |
BIGINT
NOT NULL |
ÆÇ¸Å ¼³Á¤ÀÌ ÀϺκÐÀÎ TradingPositionContainer. |
»öÀÎ:
»öÀÎ À̸§ | »öÀÎµÈ ¿ À̸§ | »öÀÎ À¯Çü |
I0000165 | CATENTRY_ID, IDENTIFIER, TRADEPOSCN_ID | °íÀ¯ »öÀÎ |
I0000167 | CATENTRY_ID, PUBLISHED, TRADEPOSCN_ID | °íÀ¯ÇÏÁö ¾ÊÀº »öÀÎ |
SQL020206020701170 | OFFER_ID | 1Â÷ Ű |
Á¦ÇÑ»çÇ×:
Á¦ÇÑÀÚ À̸§ | ¿ À̸§ | Foreign Å×À̺í À̸§ | Foreign ¿ À̸§ | Á¦ÇÑÀÚ À¯Çü |
F_467 | TRADEPOSCN_ID | TRADEPOSCN | TRADEPOSCN_ID | °è´Ü½Ä |
F_468 | CATENTRY_ID | CATENTRY | CATENTRY_ID | °è´Ü½Ä |
F_469 | QTYUNIT_ID | QTYUNIT | QTYUNIT_ID | °è´Ü½Ä |
ÂüÁ¶:
Á¦ÇÑÀÚ À̸§ | ÂüÁ¶µÈ ¿ À̸§ | Foreign Å×À̺í À̸§ | Foreign ¿ À̸§ | Á¦ÇÑÀÚ À¯Çü |
F_470 | OFFER_ID | OFFERDESC | OFFER_ID | °è´Ü½Ä |
F_472 | OFFER_ID | OFFERPRICE | OFFER_ID | °è´Ü½Ä |
F_506 | OFFER_ID | ORDERITEMS | OFFER_ID | °è´Ü½Ä |
F_525 | OFFER_ID | ORDIOFFER | OFFER_ID | °è´Ü½Ä |
![]() |