µ¥ÀÌÅͺ£À̽º Å×À̺í: CONTRACT

ÀÌ Å×À̺íÀÇ °¢ ÇàÀº °è¾àÀ» ³ªÅ¸³À´Ï´Ù. °è¾àÀº »óÁ¡ÀÇ ÀϺημ­, °¡°Ý, ÃÖ¼Ò ¼ö·® ¹× °è¾àÀ» »ç¿ëÇÒ ¼ö ÀÖ´Â »ç¶÷°ú °°ÀÌ 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 °è´Ü½Ä