Å×ÀÌºí ¼³¸í:
ÀÌ Å×À̺íÀÇ °¢ ÇàÀº ShippingArrangement¸¦ ³ªÅ¸³»´Âµ¥, ÀÌ´Â FulfillmentCenter°¡ ShippingMode¸¦ »ç¿ëÇÏ¿© »óÁ¡ ´ë½Å »óǰÀ» ¿î¼ÛÇÒ ¼ö ÀÖÀ½À» ³ªÅ¸³À´Ï´Ù.
¿ ¼³¸í:
¿ À̸§ | ¿ À¯Çü | ¿ ¼³¸í |
ENDDATE |
TIMESTAMP
NULL |
ÀÌ ShippingArrangement°¡ ÁßÁöµÇ´Â ½Ã°£. |
FFMCENTER_ID |
INTEGER
NOT NULL |
The FulfillmentCenter. |
FIELD1 |
VARCHAR (254)
NULL |
»ç¿ëÀÚ Á¤ÀÇ °¡´É |
FIELD2 |
INTEGER
NULL |
»ç¿ëÀÚ Á¤ÀÇ °¡´É |
FLAGS |
INTEGER
NOT NULL, DEFAULT 0 |
ÇÏÀ§ ¼ø¼ ºñÆ® Ç÷¡±×¸¦ Æ÷ÇÔÇÕ´Ï´Ù. Ãß°¡ Á¤º¸´Â SHPARRANGE: Á¤º¸¸¦ ÂüÁ¶ÇϽʽÿÀ. |
PRECEDENCE |
DOUBLE
NOT NULL, DEFAULT 0 |
ƯÁ¤ ½Ã°£¿¡ ÇÑ ¹ø ÀÌ»óÀÇ ShippingArrangement (µ¿ÀÏÇÑ Store ¹× ShippingMode¿¡ ´ëÇØ)°¡ ½Ç½ÃµÉ °æ¿ì, ÃÖ°í PRECEDENCE ´ç Çϳª°¡ »ç¿ëµË´Ï´Ù. |
SHIPMODE_ID |
INTEGER
NULL |
¿î¼Û ¹æ¹ý ³Î(Null)°ªÀº ÀÌ ShippingArrangement°¡ ShippingMode¿Í »ó°ü ¾øÀÌ »ç¿ëµÉ ¼ö ÀÖÀ½À» ³ªÅ¸³À´Ï´Ù. |
SHPARRANGE_ID |
INTEGER
NOT NULL |
»ý¼ºµÈ °íÀ¯ Ű |
STARTDATE |
TIMESTAMP
NULL |
ÀÌ ShippingArrangement°¡ Àû¿ëµÇ´Â ½Ã°£. |
STORE_ID |
INTEGER
NOT NULL |
»óÁ¡. |
TRACKINGNUMBER |
VARCHAR (64)
NULL |
IBM ³»ºÎ¿ëÀ¸·Î ¿¹¾à |
»öÀÎ:
»öÀÎ À̸§ | »öÀÎµÈ ¿ À̸§ | »öÀÎ À¯Çü |
I0000229 | FFMCENTER_ID, SHIPMODE_ID, STORE_ID, STARTDATE, ENDDATE | °íÀ¯ »öÀÎ |
SQL020206020746320 | SHPARRANGE_ID | 1Â÷ Ű |
Á¦ÇÑ»çÇ×:
Á¦ÇÑÀÚ À̸§ | ¿ À̸§ | Foreign Å×À̺í À̸§ | Foreign ¿ À̸§ | Á¦ÇÑÀÚ À¯Çü |
F_748 | STORE_ID | STORE | STORE_ID | °è´Ü½Ä |
F_749 | SHIPMODE_ID | SHIPMODE | SHIPMODE_ID | °è´Ü½Ä |
F_750 | FFMCENTER_ID | FFMCENTER | FFMCENTER_ID | °è´Ü½Ä |
ÂüÁ¶:
Á¦ÇÑÀÚ À̸§ | ÂüÁ¶µÈ ¿ À̸§ | Foreign Å×À̺í À̸§ | Foreign ¿ À̸§ | Á¦ÇÑÀÚ À¯Çü |
F_747 | SHPARRANGE_ID | SHPARJURGP | SHPARRANGE_ID | °è´Ü½Ä |
![]() |