Å×ÀÌºí ¼³¸í:
ƯÁ¤ Á¦Ç°¿¡ ´ëÇÑ Á¤º¸. ÁöÁ¤µÈ Ç׸ñÀº ¸ðµç ÇØ´ç ¼Ó¼º¿¡ ´ëÇÑ °ªÀ» °¡Áö°í ÀÖ´Â »óǰÀÔ´Ï´Ù. ÁöÁ¤µÈ Ç׸ñÀº 2% Áö¹æÀÌ ÇÔÀ¯µÈ 2Lº´ÀÇ ¿ìÀ¯ÀÏ ¼ö ÀÖ½À´Ï´Ù. ÁöÁ¤µÈ Ç׸ñÀº ÆÇ¸ÅÀÚ°¡ ÆÇ¸ÅÇÏ´Â Ç׸ñ¿¡ ´ëÇÑ °í°´ º¸±âÀÔ´Ï´Ù.
¿ ¼³¸í:
¿ À̸§ | ¿ À¯Çü | ¿ ¼³¸í |
BASEITEM_ID |
BIGINT
NOT NULL |
BaseItem »óǰ. |
DISCONTINUED |
CHARACTER (1)
NOT NULL, DEFAULT 'N' |
Y = ÀÌ Ç׸ñ ½ºÆåÀÌ ´ÜÀýµÇ¾ú½À´Ï´Ù. ÃæºÐÇÑ Àç°í°¡ ÀÖ´Â °æ¿ì¿¡´Â ÁÖ¹®ÇÒ ¼ö ÀÖÁö¸¸ ¹é¿À´õÇÒ ¼ö´Â ¾ø½À´Ï´Ù. N = ÀÌ Ç׸ñ ½ºÆåÀÌ È°¼ºÈµÇ¾úÀ¸¸ç Àç°í°¡ ¾ø´Â °æ¿ì ¹é¿À´õÇÒ ¼ö ÀÖ½À´Ï´Ù. |
ITEMSPC_ID |
BIGINT
NOT NULL |
»ý¼ºµÈ °íÀ¯ Ű |
LASTUPDATE |
TIMESTAMP
NULL |
¸¶Áö¸·À¸·Î °»½ÅµÈ ½Ã°£¼ÒÀÎ |
MARKFORDELETE |
INTEGER
NOT NULL, DEFAULT 0 |
ÁöÁ¤µÈ Ç׸ñÀÌ »èÁ¦ ´ë»óÀ¸·Î Ç¥½ÃµÇ¾ú´ÂÁö ¿©ºÎ¸¦ ³ªÅ¸³À´Ï´Ù. 0 = ¾Æ´Ï¿À. ÁÖ¹®ÇÒ ¼ö ÀÖÀ½. 1 = »èÁ¦ ´ë»óÀ¸·Î Ç¥½ÃµÇ¾úÀ¸¸ç ÁÖ¹®Çϰųª ¹é¿À´õÇÒ ¼ö ¾øÀ½. |
MEMBER_ID |
BIGINT
NOT NULL |
ƯÁ¤ Ç׸ñÀÇ ¼ÒÀ¯ÀÚ |
PARTNUMBER |
VARCHAR (64)
NOT NULL |
ƯÁ¤ ¼ÒÀ¯ÀÚÀÇ Ç׸ñÀ» °íÀ¯ÇÏ°Ô ½Äº°ÇÕ´Ï´Ù. |
»öÀÎ:
»öÀÎ À̸§ | »öÀÎµÈ ¿ À̸§ | »öÀÎ À¯Çü |
I0000138 | PARTNUMBER, MEMBER_ID | °íÀ¯ »öÀÎ |
I0000139 | BASEITEM_ID, ITEMSPC_ID | °íÀ¯ÇÏÁö ¾ÊÀº »öÀÎ |
I800140 | DISCONTINUED | °íÀ¯ÇÏÁö ¾ÊÀº »öÀÎ |
SQL020206020648110 | ITEMSPC_ID | 1Â÷ Ű |
Á¦ÇÑ»çÇ×:
Á¦ÇÑÀÚ À̸§ | ¿ À̸§ | Foreign Å×À̺í À̸§ | Foreign ¿ À̸§ | Á¦ÇÑÀÚ À¯Çü |
F_406 | MEMBER_ID | MEMBER | MEMBER_ID | °è´Ü½Ä |
F_407 | BASEITEM_ID | BASEITEM | BASEITEM_ID | °è´Ü½Ä |
ÂüÁ¶:
Á¦ÇÑÀÚ À̸§ | ÂüÁ¶µÈ ¿ À̸§ | Foreign Å×À̺í À̸§ | Foreign ¿ À̸§ | Á¦ÇÑÀÚ À¯Çü |
F_124 | ITEMSPC_ID | BKORDALLOC | ITEMSPC_ID | °è´Ü½Ä |
F_201 | ITEMSPC_ID | CATENTRY | ITEMSPC_ID | °è´Ü½Ä |
F_405 | ITEMSPC_ID | ITEMFFMCTR | ITEMSPC_ID | °è´Ü½Ä |
F_474 | ITEMSPC_ID | OICOMPLIST | ITEMSPC_ID | °è´Ü½Ä |
F_502 | ITEMSPC_ID | ORDERITEMS | ITEMSPC_ID | °è´Ü½Ä |
F_653 | ITEMSPC_ID | RABACKALLO | ITEMSPC_ID | °è´Ü½Ä |
F_656 | ITEMSPC_ID | RADETAIL | ITEMSPC_ID | °è´Ü½Ä |
F_711 | ITEMSPC_ID | RMAITEM | ITEMSPC_ID | °è´Ü½Ä |
F_715 | ITEMSPC_ID | RMAITEMCMP | ITEMSPC_ID | °è´Ü½Ä |
F_905 | ITEMSPC_ID | VERSIONSPC | ITEMSPC_ID | °è´Ü½Ä |
![]() |