Å×ÀÌºí ¼³¸í:
ÀÌ Å×À̺íÀÇ °¢ ÇàÀº »óÁ¡ÀÇ ÁÖ¹®À» ³ªÅ¸³À´Ï´Ù.
¿ ¼³¸í:
¿ À̸§ | ¿ À¯Çü | ¿ ¼³¸í |
ADDRESS_ID |
BIGINT
NULL |
¾Ë·ÁÁ® ÀÖ´Â °æ¿ì, ÁöºÒ û±¸ ÁÖ¼Ò. |
CURRENCY |
CHARACTER (10)
NULL |
ÀÌ ÁÖ¹®¿¡ ¿¬°üµÈ ±Ý¾×¿¡ ´ëÇÑ ÅëÈ. ISO 4217 Ç¥ÁØ¿¡ ¸Â´Â ÅëÈ ÄÚµå. |
DESCRIPTION |
VARCHAR (254)
NULL |
°í°´ÀÌ ÀÔ·ÂÇÏ´Â ÁÖ¹®¿¡ ÁÁÀº ¼³¸íÀ¸·Î, °í°´¿¡°Ô Ç¥½ÃÇÏ´Â µ¥ Àû´çÇÕ´Ï´Ù. |
FIELD1 |
INTEGER
NULL |
»ç¿ëÀÚ Á¤ÀÇ °¡´É |
FIELD2 |
DECIMAL(20,5)
NULL |
»ç¿ëÀÚ Á¤ÀÇ °¡´É |
FIELD3 |
VARCHAR (254)
NULL |
»ç¿ëÀÚ Á¤ÀÇ °¡´É |
LASTUPDATE |
TIMESTAMP
NULL |
¸¶Áö¸·À¸·Î ÀÌ ÁÖ¹®ÀÌ °»½ÅµÈ ½Ã°£. |
LOCKED |
CHARACTER (1)
NULL |
IBM ³»ºÎ¿ëÀ¸·Î ¿¹¾à |
MEMBER_ID |
BIGINT
NOT NULL |
ÁÖ¹® °í°´ |
ORDCHNLTYP_ID |
BIGINT
NULL |
IBM ³»ºÎ¿ëÀ¸·Î ¿¹¾à |
ORDERS_ID |
BIGINT
NOT NULL |
»ý¼ºµÈ °íÀ¯ Ű |
ORGENTITY_ID |
BIGINT
NULL |
ÀÛ¼ºÀÚÀÇ Á÷¼Ó »óÀ§ Á¶Á÷ ID |
ORMORDER |
CHARACTER (30)
NULL |
ÀÖÀ» °æ¿ì, ÆÇ¸ÅÀÚ°¡ ÁöÁ¤ÇÑ ÁÖ¹® ÂüÁ¶ ¹øÈ£. |
PROVIDERORDERNUM |
INTEGER
NULL |
IBM ³»ºÎ¿ëÀ¸·Î ¿¹¾à |
SEQUENCE |
DOUBLE
NOT NULL, DEFAULT 0 |
»ç¿ëÀÚ ÀÎÅÍÆäÀ̽º°¡ ¸ñ·ÏÀÇ ÁÖ¹® ¼ø¼¸¦ Á¦¾îÇϱâ À§ÇØ »ç¿ëÇÕ´Ï´Ù. |
SHIPASCOMPLETE |
CHARACTER (1)
NOT NULL, DEFAULT 'Y' |
IBM ³»ºÎ¿ëÀ¸·Î ¿¹¾à |
STATUS |
CHARACTER (1)
NULL |
ÁÖ¹® »óÅÂ. Ãß°¡ Á¤º¸´Â ORDERS Å×À̺í: Á¤º¸¸¦ ÂüÁ¶ÇϽʽÿÀ. |
STOREENT_ID |
INTEGER
NOT NULL |
ÁÖ¹®ÀÌ ÀϺκÐÀÎ StoreEntity. STATUS°¡ Q°¡ ¾Æ´Ò °æ¿ì ÀϹÝÀûÀ¸·Î StoreÀÔ´Ï´Ù(QÀ̸é StoreGroupÀÔ´Ï´Ù). |
TIMEPLACED |
TIMESTAMP
NULL |
OrderProcess ¸í·É¿¡ ÀÇÇØ ÀÌ ÁÖ¹®ÀÌ Ã³¸®µÈ ½Ã°£. |
TOTALADJUSTMENT |
DECIMAL(20,5)
NULL, DEFAULT 0 |
ÁÖ¹® ³»ÀÇ OrderItems¿¡ ´ëÇÑ ORDERITEMS.TOTALADJUSTMENTÀÇ ÇÕ. |
TOTALPRODUCT |
DECIMAL(20,5)
NULL, DEFAULT 0 |
ÁÖ¹®ÀÇ OrderItems¿¡ ´ëÇÑ ORDERITEMS.TOTALPRODUCTÀÇ ÇÕ. |
TOTALSHIPPING |
DECIMAL(20,5)
NULL, DEFAULT 0 |
ÁÖ¹®ÀÇ OrderItems¿¡ ´ëÇÑ ORDERITEMS.SHIPCHARGEÀÇ ÇÕ. |
TOTALTAX |
DECIMAL(20,5)
NULL, DEFAULT 0 |
ÁÖ¹®ÀÇ OrderItems¿¡ ´ëÇÑ ORDERITEMS.TAXAMOUNTÀÇ ÇÕ, |
TOTALTAXSHIPPING |
DECIMAL(20,5)
NULL, DEFAULT 0 |
ÁÖ¹®ÀÇ OrderItems¿¡ ´ëÇÑ ORDERITEMS.SHIPTAXAMOUNTÀÇ ÇÕ. |
»öÀÎ:
»öÀÎ À̸§ | »öÀÎµÈ ¿ À̸§ | »öÀÎ À¯Çü |
I0000176 | MEMBER_ID, STATUS, STOREENT_ID | °íÀ¯ÇÏÁö ¾ÊÀº »öÀÎ |
I173145 | TIMEPLACED | °íÀ¯ÇÏÁö ¾ÊÀº »öÀÎ |
SQL020206020706910 | ORDERS_ID | 1Â÷ Ű |
Á¦ÇÑ»çÇ×:
Á¦ÇÑÀÚ À̸§ | ¿ À̸§ | Foreign Å×À̺í À̸§ | Foreign ¿ À̸§ | Á¦ÇÑÀÚ À¯Çü |
F_513 | ORGENTITY_ID | ORGENTITY | ORGENTITY_ID | °è´Ü½Ä |
F_514 | ORDCHNLTYP_ID | ORDCHNLTYP | ORDCHNLTYP_ID | °è´Ü½Ä |
F_515 | ADDRESS_ID | ADDRESS | ADDRESS_ID | °è´Ü½Ä |
F_516 | MEMBER_ID | MEMBER | MEMBER_ID | °è´Ü½Ä |
F_517 | STOREENT_ID | STOREENT | STOREENT_ID | °è´Ü½Ä |
ÂüÁ¶:
Á¦ÇÑÀÚ À̸§ | ÂüÁ¶µÈ ¿ À̸§ | Foreign Å×À̺í À̸§ | Foreign ¿ À̸§ | Á¦ÇÑÀÚ À¯Çü |
F_120 | ORDERS_ID | BIDORDRREL | ORDERS_ID | °è´Ü½Ä |
F_129 | ORDERS_ID | BUACCTDET | ORDERS_ID | °è´Ü½Ä |
F_260 | ORDERS_ID | CPENDORDER | ORDERS_ID | °è´Ü½Ä |
F_397 | ORDERS_ID | INVOICE | ORDERS_ID | °è´Ü½Ä |
F_423 | ORDERS_ID | LPOPURAMT | ORDERS_ID | °è´Ü½Ä |
F_477 | ORDERS_ID | ONLOG | ORRFNBR | °è´Ü½Ä |
F_479 | ORDERS_ID | ONQUEUE | ORRFNBR | °è´Ü½Ä |
F_483 | ORDERS_ID | ORCOMMENT | ORDERS_ID | °è´Ü½Ä |
F_485 | ORDERS_ID | ORCPMAP | ORDERS_ID | °è´Ü½Ä |
F_490 | ORDERS_ID | ORDADJUST | ORDERS_ID | °è´Ü½Ä |
F_493 | ORDERS_ID | ORDBTB | ORDERS_ID | °è´Ü½Ä |
F_494 | ORDERS_ID | ORDCALCD | ORDERS_ID | °è´Ü½Ä |
F_496 | ORDERS_ID | ORDERITEMS | ORDERS_ID | °è´Ü½Ä |
F_511 | ORDERS_ID | ORDERMGP | ORDERS_ID | °è´Ü½Ä |
F_512 | ORDERS_ID | ORDERMSG | OMORNBR | °è´Ü½Ä |
F_519 | ORDERS_ID | ORDERTMPL | ORDERS_ID | °è´Ü½Ä |
F_532 | ORDERS_ID | ORDMEEXTN | ORDERS_ID | °è´Ü½Ä |
F_533 | ORDERS_ID | ORDOPTIONS | ORDERS_ID | °è´Ü½Ä |
F_534 | ORDERS_ID | ORDPAYINFO | ORDERS_ID | °è´Ü½Ä |
F_542 | ORDERS_ID | ORDPAYMTHD | ORDERS_ID | °è´Ü½Ä |
F_547 | ORDERS_ID | ORDRELEASE | ORDERS_ID | °è´Ü½Ä |
F_551 | ORDERS_ID | ORDTAX | ORDERS_ID | °è´Ü½Ä |
F_579 | ORDERS_ID | PAYSTATUS | SETSORNBR | °è´Ü½Ä |
F_60 | ORDERS_ID | ALCHARGE | ORDERS_ID | °è´Ü½Ä |
F_672 | ORDERS_ID | REFUNDMTHD | ORDERS_ID | °è´Ü½Ä |
F_740 | ORDERS_ID | SCHORDERS | ORDERS_ID | °è´Ü½Ä |
F_813 | ORDERS_ID | SUBORDERS | ORDERS_ID | °è´Ü½Ä |
F_863 | ORDERS_ID | TORCPMAP | ORDERS_ID | °è´Ü½Ä |
F_871 | ORDERS_ID | TRDDEPAMT | ORDERS_ID | °è´Ü½Ä |
F_877 | ORDERS_ID | TRDPURAMT | ORDERS_ID | °è´Ü½Ä |
F_880 | ORDERS_ID | TRDREFAMT | ORDERS_ID | °è´Ü½Ä |
![]() |