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


Å×ÀÌºí ¼³¸í:

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