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

¿­ À̸§ ¿­ À¯Çü ¤±¿­ ¼³¸í
ACCOUNT_ID BIGINT
NOT NULL
ÀÌ ¿­Àº 1Â÷ ۸¦ Æ÷ÇÔÇÕ´Ï´Ù. °èÁ¤ ID. TRADING Å×À̺íÀÇ Foreign key.
COMMENTS VARCHAR (4000)
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 °íÀ¯ »öÀÎ
SQL030416034827380 ACCOUNT_ID 1Â÷ Ű
Á¦ÇÑÁ¶°Ç:
Á¦ÇÑÁ¶°Ç ¿­ À̸§ ¿ÜºÎ Å×À̺í À̸§ ¿ÜºÎ ¿­ À̸§ Á¦ÇÑÁ¶°Ç À¯Çü
F_22 ACCOUNT_ID TRADING TRADING_ID °è´Ü½Ä
F_23 STORE_ID STORE STORE_ID °è´Ü½Ä
F_24 MEMBER_ID MEMBER MEMBER_ID °è´Ü½Ä

´ÙÀ½¿¡ ÀÇÇØ ÂüÁ¶:
Á¦ÇÑÁ¶°Ç ÂüÁ¶µÇ´Â ¿­ À̸§ ¿ÜºÎ Å×À̺í À̸§ ¿ÜºÎ ¿­ À̸§ Á¦ÇÑÁ¶°Ç À¯Çü
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 °è´Ü½Ä
F_968 ACCOUNT_ID COLLABWS ACCOUNT_ID °è´Ü½Ä