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


Å×ÀÌºí ¼³¸í:

ÀÌ Å×À̺íÀÇ °¢ ÇàÀº °èÁ¤ÀÇ ±¸¸ÅÀÚ Á¶Á÷°ú ÆÇ¸ÅÀÚ Á¶Á÷ °£ÀÇ ºñÁî´Ï½º °èÁ¤À» ³ªÅ¸³À´Ï´Ù. ºñÁî´Ï½º °èÁ¤À» »ç¿ëÇÏ¿© ¿©·¯ °Å·¡ °è¾àÀ» ±¸¼ºÇÏ°í Æ¯¼öÇÑ °Å·¡ ±ÔÁ¤À» ÁöÁ¤ÇÒ ¼ö ÀÖ½À´Ï´Ù.

¿­ ¼³¸í:

¿­ À̸§ ¿­ À¯Çü ¿­ ¼³¸í
ACCOUNT_ID BIGINT
NOT NULL
ÀÌ ¿­Àº 1Â÷ ۸¦ Æ÷ÇÔÇÕ´Ï´Ù. °èÁ¤ ID. TRADING Å×À̺íÀÇ Foreign key.
COMMENTS LONG VARCHAR
NULL
ÀÌ ¿­Àº ºñÁö´Ï½º °è¼ö¿¡ ´ëÇÑ ¼³¸íÀ» Æ÷ÇÔÇÕ´Ï´Ù.
CURRENCY CHARACTER (3)
NULL
IBM ³»ºÎ¿ëÀ¸·Î ¿¹¾à
DEFAULTCONTRACT INTEGER
NOT NULL, DEFAULT 0
»óÁ¡ ±âº» Àå±â ±¸¸Å °è¾àÀ» »ç¿ëÇÏ´Â ±¸¸Å°¡ Çã¿ëµÇ´ÂÁö ¿©ºÎ¸¦ ³ªÅ¸³À´Ï´Ù. 0 = Çã¿ë ¾ÈÇÔ, 1 = Çã¿ë.
MARKFORDELETE INTEGER
NOT NULL, DEFAULT 0
ºñÁî´Ï½º °èÁ¤ÀÌ »èÁ¦ ´ë»óÀ¸·Î Ç¥½ÃµÇ¾ú´ÂÁö ¿©ºÎ¸¦ ³ªÅ¸³À´Ï´Ù. 0 = ¾Æ´Ï¿À, 1 = »èÁ¦ Ç¥½Ã.
MEMBER_ID BIGINT
NOT NULL
°èÁ¤ÀÇ ¼ÒÀ¯ÀÚ. MEMBER Å×À̺íÀÇ foreign key.
NAME VARCHAR (200)
NOT NULL
ºñÁö´Ï½º °è¼ö¿¡ ´ëÇÑ °è¼ö À̸§ÀÔ´Ï´Ù.
STATE INTEGER
NOT NULL, DEFAULT 0
°èÁ¤ »óÅÂ. ´ÙÀ½ ½Ã/µµ¸¸ »ç¿ëµË´Ï´Ù.
0 - Ãʱâ
3 - Ȱ¼ºÈ­
6 - Á¾·á
STORE_ID INTEGER
NULL
°èÁ¤ÀÌ Ã³À½ ÀÛ¼ºµÈ »óÁ¡
TIMEACTIVATED TIMESTAMP
NULL
°èÁ¤ÀÌ È°¼ºÈ­µÈ ½Ã°£
TIMEAPPROVED TIMESTAMP
NULL
IBM ³»ºÎ¿ëÀ¸·Î ¿¹¾à
TIMECREATED TIMESTAMP
NULL
°èÁ¤ÀÌ ÀÛ¼ºµÈ ½Ã°£
TIMEUPDATED TIMESTAMP
NULL
°èÁ¤ÀÌ °»½ÅµÈ ½Ã°£

»öÀÎ:

»öÀÎ À̸§ »öÀÎµÈ ¿­ À̸§ »öÀÎ À¯Çü
I0000005 NAME, MEMBER_ID °íÀ¯ »öÀÎ
SQL020206020535920 ACCOUNT_ID 1Â÷ Ű

Á¦ÇÑ»çÇ×:

Á¦ÇÑÀÚ À̸§ ¿­ À̸§ Foreign Å×À̺í À̸§ Foreign ¿­ À̸§ Á¦ÇÑÀÚ À¯Çü
F_22 ACCOUNT_ID TRADING TRADING_ID °è´Ü½Ä
F_23 STORE_ID STORE STORE_ID °è´Ü½Ä
F_24 MEMBER_ID MEMBER MEMBER_ID °è´Ü½Ä


ÂüÁ¶:

Á¦ÇÑÀÚ À̸§ ÂüÁ¶µÈ ¿­ À̸§ Foreign Å×À̺í À̸§ Foreign ¿­ À̸§ Á¦ÇÑÀÚ À¯Çü
F_137 ACCOUNT_ID BUYERPO ACCOUNT_ID °è´Ü½Ä
F_279 ACCOUNT_ID CREDITLINE ACCOUNT_ID °è´Ü½Ä
F_541 ACCOUNT_ID ORDPAYMTHD ACCOUNT_ID °è´Ü½Ä
F_585 ACCOUNT_ID PAYSUMMARY ACCOUNT_ID °è´Ü½Ä
F_671 ACCOUNT_ID REFUNDMTHD TRADING_ID °è´Ü½Ä
IBM copyright