µ¥ÀÌÅͺ£À̽º Å×À̺í: ORDERS


Å×ÀÌºí ¼³¸í:

ÀÌ Å×À̺íÀÇ °¢ ÇàÀº »óÁ¡ÀÇ ÁÖ¹®À» ³ªÅ¸³À´Ï´Ù.

¿­ ¼³¸í:

¿­ À̸§ ¿­ À¯Çü ¿­ ¼³¸í
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 °è´Ü½Ä
IBM copyright