Å×ÀÌºí ¼³¸í:
ÀÌ Å×À̺íÀÇ °¢ ÇàÀº QuantityUnit Æ÷¸ËÆÃ ±ÔÄ¢ÀÇ ¾ð¾î Á¾¼Ó ºÎºÐÀ» ³ªÅ¸³À´Ï´Ù. ¿©±â¼´Â ƯÁ¤ ¾ð¾î¸¦ »ç¿ëÇÏ¿© ƯÁ¤ QuantityUnit·Î ¼ö·®À» Æ÷¸Ë(Ç¥½Ã ¸ñÀû)ÇÏ´Â ¹æ¹ý¿¡ ´ëÇØ ¼³¸íÇÕ´Ï´Ù.
¿ ¼³¸í:
¿ À̸§ | ¿ À¯Çü | ¿ ¼³¸í |
CUSTOMIZEDQTYSTR |
VARCHAR (254)
NULL |
´ëü QuantityUnit ÄÚµå. WebSphere Commerce´Â ÀÌ °ªÀ» »ç¿ëÇÏÁö ¾Ê½À´Ï´Ù. °ªÀ» Á¦°øÇϰí JSP ¸ÅÅ©·Î¸¦ ÀÛ¼ºÇÏ¿© ÀÌ Äڵ带 »ç¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù. |
DESCRIPTION |
VARCHAR (254)
NULL |
QuantityUnit¿¡ ´ëÇÑ ¼³¸íÀ¸·Î QuantityUnit ¼±Åà ¸ñ·ÏÀÇ °í°´À» Ç¥½ÃÇÏ´Â µ¥ Àû´çÇÕ´Ï´Ù. |
DISPLAYLOCALE |
CHARACTER (16)
NULL |
Æ÷¸ËÆÃÀ» ¼öÇàÇÏ´Â µ¥ »ç¿ëµÇ´Â QuantityUnit NumberFormat ¿ÀºêÁ§Æ®¸¦ ÀÛ¼ºÇÏ´Â µ¥ »ç¿ëµÇ´Â Java ·ÎÄÉÀÏ. ÀÌ °ªÀÌ ³Î(Null)°ªÀ̸é, LANGUAGE_ID(LANGUAGE Å×À̺í ÂüÁ¶)¿¡ ¿¬°üµÈ ·ÎÄÉÀÏÀÌ »ç¿ëµË´Ï´Ù. |
GROUPINGCHAR |
CHARACTER (1)
NULL |
NumberFormat ¿ÀºêÁ§Æ®¿¡ ÀÇÇØ »ç¿ëµÇ´Â ±×·ìÈ ¹®ÀÚ. Ãß°¡ Á¤º¸´Â QTYFMTDESC Å×À̺í: Á¤º¸¸¦ ÂüÁ¶ÇϽʽÿÀ. |
LANGUAGE_ID |
INTEGER
NOT NULL |
¾ð¾î. ¾ð¾î ±¸¼º¿ä¼Ò´Â LANGUAGE Å×À̺íÀ» ÂüÁ¶ÇϽʽÿÀ. |
NUMBERPATTERN |
VARCHAR (254)
NULL |
NumberFormat ¿ÀºêÁ§Æ®¿¡ Àû¿ëµÉ ¼ýÀÚ ÆÐÅÏ. ¼ýÀÚ ÆÐÅÏÀº java.text.DecimalFormat Ŭ·¡½º¿¡ ´ëÇÑ JDK ¹®¼¿¡ ¼³¸íµÇ¾î ÀÖ½À´Ï´Ù. ÀÌ °ªÀÌ ³Î(Null)°ªÀ̸é, NumberFormat ¿ÀºêÁ§Æ®ÀÇ ±âº» ¼ýÀÚ ÆÐÅÏÀÌ »ç¿ëµË´Ï´Ù. |
NUMBRUSG_ID |
INTEGER
NOT NULL, DEFAULT -1 |
ÀÌ QuantityUnit Æ÷¸ËÆÃ ±ÔÄ¢Àº ÇØ´ç »ç¿ë¿¡ ¸Â°Ô ±Ý¾×À» Æ÷¸ËÆÃÇÒ ¶§ »ç¿ëÇØ¾ß ÇÕ´Ï´Ù. |
QTYUNIT_ID |
CHARACTER (16)
NOT NULL |
QuantityUnit. |
RADIXPOINT |
CHARACTER (1)
NULL |
NumberFormat ¿ÀºêÁ§Æ®¿¡ ´ëÇÑ radix Æ÷ÀÎÆ®. Ãß°¡ Á¤º¸´Â QTYFMTDESC Å×À̺í: Á¤º¸¸¦ ÂüÁ¶ÇϽʽÿÀ. |
STOREENT_ID |
INTEGER
NOT NULL |
ÀÌ Æ÷¸ËÆÃ ±ÔÄ¢ÀÌ ÀϺκÐÀÎ StoreEntity. |
UNITPREFIXNEG |
VARCHAR (254)
NULL |
±Ý¾×ÀÌ À½¼öÀÏ ¶§ »ç¿ëÇÏ´Â Á¢µÎ¾î. ÀÌ ÇÊµå ¹× UNITSUFFIXNEG°¡ ³Î(Null)°ªÀ̸é NumberFormatÀÇ negativePrefix°¡ »ç¿ëµË´Ï´Ù. |
UNITPREFIXPOS |
VARCHAR (254)
NULL |
±Ý¾×ÀÌ ¾ç¼öÀÏ ¶§ »ç¿ëÇÏ´Â Á¢µÎ¾î. ÀÌ ÇÊµå ¹× UNITSUFFIXPOS°¡ ³Î(Null)°ªÀ̸é, NumberFormatÀÇ positivePrefix°¡ »ç¿ëµË´Ï´Ù. |
UNITSUFFIXNEG |
VARCHAR (254)
NULL |
±Ý¾×ÀÌ À½¼öÀÏ ¶§ »ç¿ëÇÏ´Â Á¢¹Ì¾î. ÀÌ ÇÊµå ¹× UNITPREFIXNEG°¡ ³Î(Null)°ªÀ̸é, NumberFormatÀÇ negativeSuffix°¡ »ç¿ëµË´Ï´Ù. |
UNITSUFFIXPOS |
VARCHAR (254)
NULL |
±Ý¾×ÀÌ ¾ç¼öÀÏ ¶§ »ç¿ëÇÏ´Â Á¢¹Ì¾î. ÀÌ ÇÊµå ¹× UNITPREFIXPOS°¡ ³Î(Null)°ªÀ̸é, NumberFormatÀÇ positiveSuffix°¡ »ç¿ëµË´Ï´Ù. |
UNITSYMBOL |
VARCHAR (254)
NULL |
QuantityUnit ±âÈ£. |
»öÀÎ:
»öÀÎ À̸§ | »öÀÎµÈ ¿ À̸§ | »öÀÎ À¯Çü |
SQL020206020730490 | NUMBRUSG_ID, STOREENT_ID, QTYUNIT_ID, LANGUAGE_ID | 1Â÷ Ű |
Á¦ÇÑ»çÇ×:
Á¦ÇÑÀÚ À̸§ | ¿ À̸§ | Foreign Å×À̺í À̸§ | Foreign ¿ À̸§ | Á¦ÇÑÀÚ À¯Çü |
F_642 | LANGUAGE_ID | LANGUAGE | LANGUAGE_ID | °è´Ü½Ä |
F_643 | STOREENT_ID, QTYUNIT_ID, NUMBRUSG_ID | QTYFORMAT | STOREENT_ID, QTYUNIT_ID, NUMBRUSG_ID | °è´Ü½Ä |
ÂüÁ¶:
Á¦ÇÑÀÚ À̸§ | ÂüÁ¶µÈ ¿ À̸§ | Foreign Å×À̺í À̸§ | Foreign ¿ À̸§ | Á¦ÇÑÀÚ À¯Çü |
![]() |