Å×ÀÌºí ¼³¸í:
ÀÌ Å×À̺íÀÇ °¢ ÇàÀº °è¾àÀ» ³ªÅ¸³À´Ï´Ù. °è¾àÀº »óÁ¡ÀÇ ÀϺημ, °¡°Ý, ÃÖ¼Ò ¼ö·® ¹× °è¾àÀ» »ç¿ëÇÒ ¼ö ÀÖ´Â »ç¶÷°ú °°ÀÌ OrderItems¿¡ ¿¬°üµÉ ¼ö ÀÖ´Â Á¶°ÇÀ» ³ªÅ¸³À´Ï´Ù.
¿ ¼³¸í:
¿ À̸§ | ¿ À¯Çü | ¿ ¼³¸í |
COMMENTS |
LONG VARCHAR
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 = 2Â÷ Çù»ó |
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 = Ưº° ÀÔÂû |
»öÀÎ:
»öÀÎ À̸§ | »öÀÎµÈ ¿ À̸§ | »öÀÎ À¯Çü |
I0000078 | NAME, MEMBER_ID, MAJORVERSION, MINORVERSION, ORIGIN | °íÀ¯ »öÀÎ |
SQL020206020611500 | CONTRACT_ID | 1Â÷ Ű |
Á¦ÇÑ»çÇ×:
Á¦ÇÑÀÚ À̸§ | ¿ À̸§ | Foreign Å×À̺í À̸§ | Foreign ¿ À̸§ | Á¦ÇÑÀÚ À¯Çü |
F_252 | CONTRACT_ID | TRADING | TRADING_ID | °è´Ü½Ä |
F_253 | MEMBER_ID | MEMBER | MEMBER_ID | °è´Ü½Ä |
ÂüÁ¶:
Á¦ÇÑÀÚ À̸§ | ÂüÁ¶µÈ ¿ À̸§ | Foreign Å×À̺í À̸§ | Foreign ¿ À̸§ | Á¦ÇÑÀÚ À¯Çü |
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 | °è´Ü½Ä |
![]() |