Å×ÀÌºí ¼³¸í:
Àç°í Å×À̺í. Ãß°¡ Á¤º¸´Â INVENTORY Å×À̺í: Á¤º¸¸¦ ÂüÁ¶ÇϽʽÿÀ.
¿ ¼³¸í:
¿ À̸§ | ¿ À¯Çü | ¿ ¼³¸í |
CATENTRY_ID |
BIGINT
NOT NULL |
CatalogEntry. |
FFMCENTER_ID |
INTEGER
NOT NULL |
The FulfillmentCenter. |
INVENTORYFLAGS |
INTEGER
NOT NULL, DEFAULT 0 |
QUANTITY°¡ »ç¿ëµÇ´Â ¹æ¹ýÀ» ³ªÅ¸³»´Â ºñÆ® Ç÷¡±×(³·Àº ¼ø¼¿¡¼ ³ôÀº ¼ø¼·Î Á¤·Ä) 1 = noUpdate. ±âº» UpdateInventory ŽºÅ© ¸í·ÉÀº QUANTITY¸¦ °»½ÅÇÏÁö ¾Ê½À´Ï´Ù. 2 = noCheck. ±âº» CheckInventory ¹× UpdateInventory ŽºÅ© ¸í·ÉÀº QUANTITY¸¦ È®ÀÎÇÏÁö ¾Ê½À´Ï´Ù. |
QUANTITY |
DOUBLE
NOT NULL, DEFAULT 0 |
QUANTITYMEASURE¿¡ ÁöÁ¤µÈ ´ÜÀ§·Î Ç¥½ÃµÈ ¼ö·®. |
QUANTITYMEASURE |
CHARACTER (16)
NOT NULL, DEFAULT 'C62' |
QUANTITYÀÇ ÃøÁ¤ ´ÜÀ§. |
STORE_ID |
INTEGER
NOT NULL |
»óÁ¡. |
»öÀÎ:
»öÀÎ À̸§ | »öÀÎµÈ ¿ À̸§ | »öÀÎ À¯Çü |
SQL020206020643840 | CATENTRY_ID, FFMCENTER_ID, STORE_ID | 1Â÷ Ű |
Á¦ÇÑ»çÇ×:
Á¦ÇÑÀÚ À̸§ | ¿ À̸§ | Foreign Å×À̺í À̸§ | Foreign ¿ À̸§ | Á¦ÇÑÀÚ À¯Çü |
F_393 | STORE_ID | STORE | STORE_ID | °è´Ü½Ä |
F_394 | QUANTITYMEASURE | QTYUNIT | QTYUNIT_ID | °è´Ü½Ä |
F_395 | CATENTRY_ID | CATENTRY | CATENTRY_ID | °è´Ü½Ä |
F_396 | FFMCENTER_ID | FFMCENTER | FFMCENTER_ID | °è´Ü½Ä |
ÂüÁ¶:
Á¦ÇÑÀÚ À̸§ | ÂüÁ¶µÈ ¿ À̸§ | Foreign Å×À̺í À̸§ | Foreign ¿ À̸§ | Á¦ÇÑÀÚ À¯Çü |
![]() |