ÀÌ Å×À̺íÀÇ °¢ ÇàÀº °è¾àÀ» ³ªÅ¸³À´Ï´Ù. °è¾àÀº »óÁ¡ÀÇ ÀϺημ, °¡°Ý, ÃÖ¼Ò ¼ö·® ¹× °è¾àÀ» »ç¿ëÇÒ ¼ö ÀÖ´Â »ç¶÷°ú °°ÀÌ OrderItems¿¡ ¿¬°üµÉ ¼ö ÀÖ´Â Á¶°ÇÀ» ³ªÅ¸³À´Ï´Ù.
¿ À̸§ | ¿ À¯Çü | ¿ ¼³¸í |
---|---|---|
COMMENTS | VARCHAR (4000) NULL |
Àå±â ±¸¸Å °è¾à°ú ¿¬°üµÈ ¼³¸í. |
CONTRACT_ID | BIGINT NOT NULL |
Àå±â ±¸¸Å °è¾à¿¡ ´ëÇÑ °íÀ¯ ½Äº°ÀÚ. TRADING µ¥ÀÌÅͺ£À̽º Å×ÀÌºí¿¡ ÀÖ´Â TRADING_ID¿¡ ´ëÇÑ foreign key. |
MAJORVERSION | INTEGER NOT NULL, DEFAULT 1 |
Àå±â ±¸¸Å °è¾àÀÇ ÁÖ ¹öÀü ¹øÈ£. |
MARKFORDELETE | INTEGER NOT NULL, DEFAULT 0 |
ÀÌ Àå±â ±¸¸Å °è¾àÀÌ »èÁ¦ ´ë»óÀ¸·Î Ç¥½ÃµÇ¾ú´ÂÁö ¿©ºÎ¸¦ ³ªÅ¸³À´Ï´Ù. 0 = ¾Æ´Ï¿À 1 = ¿¹. ÀÌ Àå±â ±¸¸Å °è¾àÀÌ »èÁ¦ ´ë»óÀ¸·Î Ç¥½ÃµÊ |
MEMBER_ID | BIGINT NOT NULL |
Àå±â ±¸¸Å °è¾àÀÇ ¼ÒÀ¯ÀÚ |
MINORVERSION | INTEGER NOT NULL, DEFAULT 0 |
Àå±â ±¸¸Å °è¾àÀÇ ºÎ ¹öÀü ¹øÈ£. |
NAME | VARCHAR (200) NOT NULL |
ƯÁ¤ ¼ÒÀ¯ÀÚÀÇ Æ¯Á¤ ÃâóÀÇ Àå±â ±¸¸Å °è¾à ¹öÀüÀ» °íÀ¯ÇÏ°Ô ½Äº°ÇÕ´Ï´Ù. |
ORIGIN | INTEGER NOT NULL, DEFAULT 0 |
Àå±â ±¸¸Å °èȹÀÌ ÀÛ¼ºµÈ ÀÌÀ¯¸¦ ³ªÅ¸³À´Ï´Ù. 0 = Á¤»ó 1 = ¹ÝÀÔµÊ 2 = RFQ 3 = ÀͽºÃ¼ÀÎÁö(exchange) 4 = °æ¸Å 5 = ¾ç Ãø Çù»ó 6 = Àü°³ |
STATE | INTEGER NOT NULL, DEFAULT 0 |
Àå±â ±¸¸Å °è¾à »óŸ¦ ³ªÅ¸³À´Ï´Ù. 0 = ÃÊ¾È 1 = ½ÂÀÎ º¸·ù Áß 2 = ½ÂÀÎµÊ 3 = Ȱ¼ºÈ 4 = °ÅºÎ 5 = Ãë¼Ò 6 = Á¾·á 7 = ÁßÁö -1 = Àü°³ ÁøÇà Áß -2 = Àü°³ ½ÇÆÐ |
TIMEACTIVATED | TIMESTAMP NULL |
Àå±â ±¸¸Å °è¾àÀÌ È°¼ºµÈ ½Ã°£. |
TIMEAPPROVED | TIMESTAMP NULL |
Àå±â ±¸¸Å °è¾àÀÌ ½ÂÀÎµÈ ½Ã°£. |
TIMECREATED | TIMESTAMP NULL |
Àå±â ±¸¸Å °è¾àÀÌ ÀÛ¼ºµÈ ½Ã°£. |
TIMEDEPLOYED | TIMESTAMP NULL |
Àå±â ±¸¸Å °è¾àÀÌ ¹èÄ¡µÈ ½Ã°£. |
TIMEUPDATED | TIMESTAMP NULL |
¸¶Áö¸·À¸·Î ÀÌ Àå±â ±¸¸Å °è¾àÀÌ °»½ÅµÈ ½Ã°£. |
USAGE | INTEGER NOT NULL, DEFAULT 0 |
Àå±â ±¸¸Å °è¾àÀÌ »ç¿ëµÈ ¹æ¹ýÀ» ³ªÅ¸³À´Ï´Ù. 0 = ±âº»°ª 1 = Á¶Á÷ ±¸¸ÅÀÚ 2 = ÀçÆÇ¸ÅÀÚ 3 = Ưº° ÀÔÂû 4 = ÂüÁ¶ 5 = °ø±ÞÀÚ |
»öÀÎ À̸§ | »öÀÎÈµÈ ¿ À̸§ | »öÀÎ À¯Çü |
---|---|---|
I0000078 | NAME, MEMBER_ID, MAJORVERSION, MINORVERSION, ORIGIN | °íÀ¯ »öÀÎ |
SQL030416034912060 | CONTRACT_ID | 1Â÷ Ű |
Á¦ÇÑÁ¶°Ç À̸§ | ¿ À̸§ | ¿ÜºÎ Å×À̺í À̸§ | ¿ÜºÎ ¿ À̸§ | ]Á¦ÇÑÁ¶°Ç À¯Çü |
---|---|---|---|---|
F_252 | CONTRACT_ID | TRADING | TRADING_ID | °è´Ü½Ä |
F_253 | MEMBER_ID | MEMBER | MEMBER_ID | °è´Ü½Ä |
Á¦ÇÑÁ¶°Ç À̸§ | ÂüÁ¶µÇ´Â ¿ À̸§ | ¿ÜºÎ Å×À̺í À̸§ | ¿ÜºÎ ¿ À̸§ | ]Á¦ÇÑÁ¶°Ç À¯Çü |
---|---|---|---|---|
F_139 | CONTRACT_ID | BUYSUPMAP | CONTRACT_ID | °è´Ü½Ä |
F_188 | CONTRACT_ID | CATCNTR | CONTRACT_ID | °è´Ü½Ä |
F_246 | CONTRACT_ID | CNTRDISPLY | CONTRACT_ID | °è´Ü½Ä |
F_785 | CONTRACT_ID | STORECNTR | CONTRACT_ID | °è´Ü½Ä |
F_788 | CONTRACT_ID | STOREDEF | CONTRACT_ID | °è´Ü½Ä |
F_833 | CONTRACT_ID | TDPSCNCNTR | CONTRACT_ID | °è´Ü½Ä |
F_912 | CONTRACT_ID | CNTRSTORE | CONTRACT_ID | °è´Ü½Ä |
F_925 | CONTRACT_ID | STORE | CRTDBYCNTR_ID | °è´Ü½Ä |