TERMCOND ¿ À̸§ |
¿ À¯Çü | ¿ ¼³¸í |
---|---|---|
trading_id | BigInt, ³Î(Null)°ªÀÌ ¾Æ´Ô |
1Â÷ Ű. °Å·¡ °è¾à(TRADING) Å×ÀÌºí¿¡ ´ëÇÑ foreign key |
termcond_id | BigInt, ³Î(Null)°ªÀÌ ¾Æ´Ô |
1Â÷ Ű ID. |
tcSubType_id | Char(64) | ±ÔÁ¤ À¯Çü. TCSUBTYPE
Å×ÀÌºí¿¡ ´ëÇÑ foreign key ¿ °ªÀº PriceTCPriceListWithSelectiveAdjustmentÀ̾î¾ß ÇÕ´Ï´Ù. |
mandatory | Á¤¼ö, ±âº»°ª 0 |
0 - ¾Æ´Ï¿À 1 - ¿¹(Çù»ó Áß Âü°¡ÀÚ°¡ ÀÌ ±ÔÁ¤¿¡ ´ëÇØ ÀÀ´äÇØ¾ß ÇÕ´Ï´Ù.) |
changeable | Á¤¼ö, ±âº»°ª 0 |
0 - ¾Æ´Ï¿À 1 - ¿¹(Âü°¡ÀÚ°¡ ±ÔÁ¤À» º¯°æÇÒ ¼ö ÀÖ½À´Ï´Ù.) |
timeCreated | TimeStamp | ÀÛ¼ºµÈ ½Ã°£ |
timeUpdated | TimeStamp | °»½ÅµÈ ½Ã°£ |
elementData | LongVarChar, ±âº»°ª ³Î(Null) |
|
StringField1 | VARChar (3000) | adjustmentProductSetName. |
StringField2 | VARChar (254) | |
StringField3 | VARChar (254) | |
IntegerField1 | Á¤¼ö | productSetId. PRODUCTSET Å×ÀÌºí¿¡ ´ëÇÑ foreign key |
IntegerField2 | Á¤¼ö | adjustmentProductSetId. PRODUCTSET Å×ÀÌºí¿¡ ´ëÇÑ foreign key |
IntegerField3 | Á¤¼ö | customProductSetFlag. |
FloatField1 | Double | signedPercentage |
FloatField2 | Double | |
FloatField3 | Double | |
BigIntField1 | BigInt | priceListId |
BigIntField2 | BigInt | adjustmentProductSetOwnerId. |
BigIntField3 | BigInt | |
DecimalField1 | Decimal (20,5) | |
DecimalField2 | Decimal (20,5) | |
DecimalField3 | Decimal (20,5) | |
TimeField1 | TimeStamp | |
TimeField2 | TimeStamp | |
TimeField3 | TimeStamp |
![]() |