Å×ÀÌºí ¼³¸í:
ÀÌ Å×À̺íÀº RMA¸¦ ÅëÇØ ¹Ýǰ Ç׸ñÀÌ ¼ö·ÉµÇ¾úÀ½À» ³ªÅ¸³»°í ¼ö·ÉµÈ Ç׸ñ¿¡ ´ëÇÑ Á¤º¸¸¦ ÁöÁ¤ÇÏ´Â ¼ö·É ·¹Äڵ带 ÀúÀåÇÕ´Ï´Ù.
¿ ¼³¸í:
¿ À̸§ | ¿ À¯Çü | ¿ ¼³¸í |
DATERECEIVED |
TIMESTAMP
NOT NULL |
¹Ýǰ Ç׸ñÀÌ ¼ö·ÉµÈ ³¯Â¥ |
DISPOSITIONEDQTY |
INTEGER
NOT NULL, DEFAULT 0 |
ó¸®µÈ ÀÌ ¹Ýǰ ¼ö·É ¼ö·® |
LASTUPDATE |
TIMESTAMP
NOT NULL |
·¹Äڵ尡 ¸¶Áö¸·À¸·Î º¯°æµÈ ½Ã°£¼ÒÀÎ |
QUANTITY |
INTEGER
NOT NULL |
Àç°í ¼ö·® ´ÜÀ§ |
RMA_ID |
BIGINT
NOT NULL |
ÀÌ ¹Ýǰ ¼ö·ÉÀÌ ¼ÓÇÏ´Â RMA |
RMAITEMCMP_ID |
BIGINT
NOT NULL |
ÀÌ ¹Ýǰ ¼ö·ÉÀÌ ³ªÅ¸³»´Â RMA Ç׸ñ ±¸¼º¿ä¼Ò |
RTNRECEIPT_ID |
BIGINT
NOT NULL |
»ý¼ºµÈ °íÀ¯ Ű |
VERSIONSPC_ID |
BIGINT
NOT NULL |
IBM ³»ºÎ¿ëÀ¸·Î ¿¹¾à |
»öÀÎ:
»öÀÎ À̸§ | »öÀÎµÈ ¿ À̸§ | »öÀÎ À¯Çü |
I0000222 | RMAITEMCMP_ID, RTNRECEIPT_ID, DATERECEIVED | °íÀ¯ÇÏÁö ¾ÊÀº »öÀÎ |
SQL020206020741050 | RTNRECEIPT_ID | 1Â÷ Ű |
Á¦ÇÑ»çÇ×:
Á¦ÇÑÀÚ À̸§ | ¿ À̸§ | Foreign Å×À̺í À̸§ | Foreign ¿ À̸§ | Á¦ÇÑÀÚ À¯Çü |
F_729 | VERSIONSPC_ID | VERSIONSPC | VERSIONSPC_ID | °è´Ü½Ä |
F_730 | RMA_ID | RMA | RMA_ID | °è´Ü½Ä |
F_731 | RMAITEMCMP_ID | RMAITEMCMP | RMAITEMCMP_ID | °è´Ü½Ä |
ÂüÁ¶:
Á¦ÇÑÀÚ À̸§ | ÂüÁ¶µÈ ¿ À̸§ | Foreign Å×À̺í À̸§ | Foreign ¿ À̸§ | Á¦ÇÑÀÚ À¯Çü |
F_727 | RTNRECEIPT_ID | RTNRCPTDSP | RTNRECEIPT_ID | °è´Ü½Ä |
![]() |