Å×ÀÌºí ¼³¸í:
ÀÌ Å×ÀÌºí¿¡´Â °Å·¡ °è¾à¿¡ »ç¿ëµÈ ±ÔÁ¤ÀÌ µé¾î ÀÖ½À´Ï´Ù. ´Ù¸¥ ±ÔÁ¤¿¡¼ ¿À» »ç¿ëÇÏ´Â ¹æ¹ýÀ» º¸·Á¸é ¿Â¶óÀÎ µµ¿ò¸»¿¡¼ TERMCOND ¿ ¸ÊÇÎÀ» ÂüÁ¶ÇϽʽÿÀ.
¿ ¼³¸í:
¿ À̸§ | ¿ À¯Çü | ¿ ¼³¸í |
BIGINTFIELD1 |
BIGINT
NULL |
±ÔÁ¤ µ¥ÀÌÅ͸¦ ÀúÀåÇÏ´Â BIGINT Çʵå |
BIGINTFIELD2 |
BIGINT
NULL |
±ÔÁ¤ µ¥ÀÌÅ͸¦ ÀúÀåÇÏ´Â BIGINT Çʵå |
BIGINTFIELD3 |
BIGINT
NULL |
±ÔÁ¤ µ¥ÀÌÅ͸¦ ÀúÀåÇÏ´Â BIGINT Çʵå |
CHANGEABLE |
INTEGER
NOT NULL, DEFAULT 0 |
ÀÌ ¿Àº °Å·¡ °è¾à Âü¿©ÀÚ°¡ ±ÔÁ¤À» º¯°æÇÒ ¼ö ÀÖ´Â Áö¸¦ Ç¥½ÃÇÕ´Ï´Ù. (0 - ¾Æ´Ï¿À; 1 - ¿¹). |
DECIMALFIELD1 |
DECIMAL(20,5)
NULL |
±ÔÁ¤ µ¥ÀÌÅ͸¦ ÀúÀåÇÏ´Â DECIMAL Çʵå |
DECIMALFIELD2 |
DECIMAL(20,5)
NULL |
±ÔÁ¤ µ¥ÀÌÅ͸¦ ÀúÀåÇÏ´Â DECIMAL Çʵå |
DECIMALFIELD3 |
DECIMAL(20,5)
NULL |
±ÔÁ¤ µ¥ÀÌÅ͸¦ ÀúÀåÇÏ´Â DECIMAL Çʵå |
FLOATFIELD1 |
DOUBLE
NULL |
±ÔÁ¤ µ¥ÀÌÅ͸¦ ÀúÀåÇÏ´Â DOUBLE Çʵå |
FLOATFIELD2 |
DOUBLE
NULL |
±ÔÁ¤ µ¥ÀÌÅ͸¦ ÀúÀåÇÏ´Â DOUBLE Çʵå |
FLOATFIELD3 |
DOUBLE
NULL |
±ÔÁ¤ µ¥ÀÌÅ͸¦ ÀúÀåÇÏ´Â DOUBLE Çʵå |
INTEGERFIELD1 |
INTEGER
NULL |
±ÔÁ¤ µ¥ÀÌÅ͸¦ ÀúÀåÇÏ´Â INTEGER Çʵå |
INTEGERFIELD2 |
INTEGER
NULL |
±ÔÁ¤ µ¥ÀÌÅ͸¦ ÀúÀåÇÏ´Â INTEGER Çʵå |
INTEGERFIELD3 |
INTEGER
NULL |
±ÔÁ¤ µ¥ÀÌÅ͸¦ ÀúÀåÇÏ´Â INTEGER Çʵå |
MANDATORY |
INTEGER
NOT NULL, DEFAULT 0 |
ÀÌ ¿Àº °Å·¡ °è¾à Âü¿©ÀÚ°¡ Çù»ó Áß ÀÌ ±ÔÁ¤¿¡ ÀÀ´äÇØ¾ß ÇÏ´ÂÁö ¿©ºÎ¸¦ ³ªÅ¸³À´Ï´Ù. (0 - ¾Æ´Ï¿À; 1 - ¿¹). |
SEQUENCE |
INTEGER
NOT NULL |
ÀÌ ¿¿¡´Â °Å·¡ °è¾à ³»ÀÇ ÀÏ·ÃÀÇ ±ÔÁ¤À» ³ªÅ¸³»´Â ¹øÈ£°¡ µé¾î ÀÖ½À´Ï´Ù. ÀÌ ¹øÈ£´Â °Å·¡ °è¾à ³»¿¡¼ °íÀ¯ÇØ¾ß ÇÕ´Ï´Ù. |
STRINGFIELD1 |
VARCHAR (3200)
NULL |
±ÔÁ¤ µ¥ÀÌÅ͸¦ ÀúÀåÇÏ´Â STRING Çʵå |
STRINGFIELD2 |
VARCHAR (254)
NULL |
±ÔÁ¤ µ¥ÀÌÅ͸¦ ÀúÀåÇÏ´Â STRING Çʵå |
STRINGFIELD3 |
VARCHAR (254)
NULL |
±ÔÁ¤ µ¥ÀÌÅ͸¦ ÀúÀåÇÏ´Â STRING Çʵå |
TCSUBTYPE_ID |
CHARACTER (64)
NOT NULL |
TCSUBTYPE Å×À̺íÀÇ foreign key. ÀÌ ¿Àº ±ÔÁ¤ÀÇ ÇÏÀ§ À¯ÇüÀ» ³ªÅ¸³À´Ï´Ù. |
TERMCOND_ID |
BIGINT
NOT NULL |
ÀÌ ±ÔÁ¤¿¡ ´ëÇÑ 1Â÷ Ű ¹× ³»ºÎ ÂüÁ¶ ¹øÈ£ |
TIMECREATED |
TIMESTAMP
NULL |
ÀÛ¼ºµÈ ½Ã°£ |
TIMEFIELD1 |
TIMESTAMP
NULL |
±ÔÁ¤ µ¥ÀÌÅ͸¦ ÀúÀåÇÏ´Â TIMESTAMP Çʵå |
TIMEFIELD2 |
TIMESTAMP
NULL |
±ÔÁ¤ µ¥ÀÌÅ͸¦ ÀúÀåÇÏ´Â TIMESTAMP Çʵå |
TIMEFIELD3 |
TIMESTAMP
NULL |
±ÔÁ¤ µ¥ÀÌÅ͸¦ ÀúÀåÇÏ´Â TIMESTAMP Çʵå |
TIMEUPDATED |
TIMESTAMP
NULL |
°»½ÅµÈ ½Ã°£ |
TRADING_ID |
BIGINT
NOT NULL |
TRADING Å×À̺íÀÇ foreign key. ÀÌ ¿Àº ÀÌ ±ÔÁ¤ÀÌ ¼ÓÇÏ´Â °Å·¡ °è¾àÀ» ³ªÅ¸³À´Ï´Ù. |
»öÀÎ:
»öÀÎ À̸§ | »öÀÎµÈ ¿ À̸§ | »öÀÎ À¯Çü |
I0000246 | TRADING_ID, SEQUENCE | °íÀ¯ »öÀÎ |
SQL020206020809400 | TERMCOND_ID | 1Â÷ Ű |
Á¦ÇÑ»çÇ×:
Á¦ÇÑÀÚ À̸§ | ¿ À̸§ | Foreign Å×À̺í À̸§ | Foreign ¿ À̸§ | Á¦ÇÑÀÚ À¯Çü |
F_834 | TRADING_ID | TRADING | TRADING_ID | °è´Ü½Ä |
F_835 | TCSUBTYPE_ID | TCSUBTYPE | TCSUBTYPE_ID | °è´Ü½Ä |
ÂüÁ¶:
Á¦ÇÑÀÚ À̸§ | ÂüÁ¶µÈ ¿ À̸§ | Foreign Å×À̺í À̸§ | Foreign ¿ À̸§ | Á¦ÇÑÀÚ À¯Çü |
F_497 | TERMCOND_ID | ORDERITEMS | TERMCOND_ID | °è´Ü½Ä |
F_558 | TERMCOND_ID | PARTICIPNT | TERMCOND_ID | °è´Ü½Ä |
F_571 | TERMCOND_ID | PATTRVALUE | TERMCOND_ID | °è´Ü½Ä |
F_614 | TERMCOND_ID | POLICYTC | TERMCOND_ID | °è´Ü½Ä |
F_632 | TERMCOND_ID | PURCHASELT | TERMCOND_ID | °è´Ü½Ä |
F_691 | TERMCOND_ID | RFQRSPTCRL | RFQRSPTC_ID | °è´Ü½Ä |
F_692 | TERMCOND_ID | RFQRSPTCRL | RFQTC_ID | °è´Ü½Ä |
F_826 | TERMCOND_ID | TCDESC | TERMCOND_ID | °è´Ü½Ä |
![]() |