Å×ÀÌºí ¼³¸í:
ÀÌ Å×À̺íÀº »óǰ¿¡ ´ëÇÑ °í°´ ¹Ýǰ ÀÌÀ¯¸¦ ÀúÀåÇÕ´Ï´Ù.
¿ ¼³¸í:
¿ À̸§ | ¿ À¯Çü | ¿ ¼³¸í |
CODE |
CHARACTER (30)
NOT NULL |
¹Ýǰ ÀÌÀ¯¸¦ ³ªÅ¸³»´Â ÄÚµå |
MARKFORDELETE |
INTEGER
NOT NULL, DEFAULT 0 |
ÀÌ ¹Ýǰ ÀÌÀ¯°¡ »èÁ¦ ´ë»óÀ¸·Î Ç¥½ÃµÇ¾ú´ÂÁö ¿©ºÎ¸¦ ³ªÅ¸³À´Ï´Ù. 0 = ¾Æ´Ï¿À 1 = ¿¹. ÀÌ ¹Ýǰ ÀÌÀ¯°¡ »èÁ¦ ´ë»óÀ¸·Î Ç¥½ÃµÊ. |
REASONTYPE |
CHARACTER (1)
NOT NULL, DEFAULT 'B' |
´ÙÀ½°ú °°Àº ¹Ýǰ ÀÌÀ¯ Àû¿ë ¹æ½Ä: C = °í°´ M = ÆÇ¸ÅÀÚ ¶Ç´Â ó¸® B = °í°´ ¹× ÆÇ¸ÅÀÚ |
RTNREASON_ID |
INTEGER
NOT NULL |
»ý¼ºµÈ °íÀ¯ Ű |
STOREENT_ID |
INTEGER
NOT NULL |
¹Ýǰ ÀÌÀ¯°¡ Àû¿ëµÈ StoreEntity |
»öÀÎ:
»öÀÎ À̸§ | »öÀÎµÈ ¿ À̸§ | »öÀÎ À¯Çü |
I0000221 | CODE, STOREENT_ID | °íÀ¯ »öÀÎ |
SQL020206020740740 | RTNREASON_ID | 1Â÷ Ű |
Á¦ÇÑ»çÇ×:
Á¦ÇÑÀÚ À̸§ | ¿ À̸§ | Foreign Å×À̺í À̸§ | Foreign ¿ À̸§ | Á¦ÇÑÀÚ À¯Çü |
F_728 | STOREENT_ID | STOREENT | STOREENT_ID | °è´Ü½Ä |
ÂüÁ¶:
Á¦ÇÑÀÚ À̸§ | ÂüÁ¶µÈ ¿ À̸§ | Foreign Å×À̺í À̸§ | Foreign ¿ À̸§ | Á¦ÇÑÀÚ À¯Çü |
F_712 | RTNREASON_ID | RMAITEM | RTNREASON_ID | °è´Ü½Ä |
F_726 | RTNREASON_ID | RTNRCPTDSP | RTNREASON_ID | °è´Ü½Ä |
F_733 | RTNREASON_ID | RTNRSNDESC | RTNREASON_ID | °è´Ü½Ä |
![]() |