ÀÌ Å×ÀÌºí¿¡´Â WebSphere Commerce ½Ã½ºÅÛÀÇ ¸ðµç »ç¿ëÀÚ(µî·Ï »ç¿ëÀÚ, °Ô½ºÆ® »ç¿ëÀÚ ¹× ÀÏ¹Ý »ç¿ëÀÚ)°¡ µé¾î ÀÖ½À´Ï´Ù.
¿ À̸§ | ¿ À¯Çü | ¿ ¼³¸í |
---|---|---|
DN | VARCHAR (1000) NULL |
IBM ³»ºÎ¿ëÀ¸·Î ¿¹¾à.. |
FIELD1 | VARCHAR (254) NULL |
»ç¿ëÀÚ Á¤ÀÇ °¡´É. |
FIELD2 | VARCHAR (254) NULL |
»ç¿ëÀÚ Á¤ÀÇ °¡´É. |
FIELD3 | VARCHAR (254) NULL |
»ç¿ëÀÚ Á¤ÀÇ °¡´É. |
LANGUAGE_ID | INTEGER NULL |
¼±È£ ¾ð¾î. ¾ð¾î ±¸¼º¿ä¼Ò´Â LANGUAGE Å×À̺íÀ» ÂüÁ¶ÇϽʽÿÀ. LANGUAGE Å×À̺íÀÇ foreign key °ü°è. |
LASTORDER | TIMESTAMP NULL |
±¸¸ÅÀÚ°¡ ÀÌ »çÀÌÆ®¿¡¼ ¸¶Áö¸·À¸·Î ÁÖ¹®À» Á¦ÃâÇÑ ³¯Â¥ ¹× ½Ã°£. |
LASTSESSION | TIMESTAMP NULL |
±¸¸ÅÀÚ°¡ WebSphere Commerce »çÀÌÆ®¸¦ ¸¶Áö¸·À¸·Î ¹æ¹®ÇÑ ³¯Â¥¿Í ½Ã°£. ¸¶Áö¸· ¹æ¹® ³¯Â¥´Â ¸¶Áö¸·À¸·Î WebSphere Commerce »çÀÌÆ®¿¡ ·Î±×¿ÂÇÑ ³¯Â¥ÀÔ´Ï´Ù. |
PREVLASTSESSION | TIMESTAMP NULL |
IBM ³»ºÎ¿ëÀ¸·Î ¿¹¾à.. |
PROFILETYPE | CHARACTER (2) NULL |
ÇÁ·ÎÆÄÀÏÀÌ ÀÖ´ÂÁö¿Í ÀÌ »ç¿ëÀÚ°¡ °®°í ÀÖ´Â ÇÁ·ÎÆÄÀÏÀÇ À¯ÇüÀ» ½Äº°ÇÕ´Ï´Ù. À¯È¿ÇÑ °ªÀº ´ÙÀ½°ú °°½À´Ï´Ù. ³Î(Null) - ÇÁ·ÎÆÄÀÏ µ¥ÀÌÅÍ ¾øÀ½ C - ±âº» ÇÁ·ÎÆÄÀÏ µ¥ÀÌÅÍ B - ȸ»ç ÇÁ·ÎÆÄÀÏ µ¥ÀÌÅÍ |
REGISTERTYPE | CHARACTER (4) NOT NULL |
»ç¿ëÀÚ µî·Ï À¯Çü. À¯È¿ÇÑ °ªÀº ´ÙÀ½°ú °°½À´Ï´Ù. R - µî·ÏµÈ »ç¿ëÀÚ G - °Ô½ºÆ® »ç¿ëÀÚ ¿î¿µÀÚ¶ó°í ÇÏ´Â ±âº» ±¸¼º¿ø ±×·ìÀº °ü¸® ¿ªÇÒ ¸ñ·ÏÀ» Á¤ÀÇÇÕ´Ï´Ù. ´ÙÀ½ °ªÀº »ç¿ëµÇÁö ¾Ê½À´Ï´Ù. S(»çÀÌÆ® ¿î¿µÀÚr) ¶Ç´Â A(Administrators memberGroupÀ¸·Î Á¤ÀÇµÈ °ü¸® ¿ªÇÒ) |
REGISTRATION | TIMESTAMP NULL |
LDAP·ÎºÎÅÍ WebSphere Commerce µ¥ÀÌÅͺ£À̽º·Î µ¿±âÈÇÏ´Â µ¿¾È UserRegistrationAdd¸¦ ÅëÇØ Á÷Á¢ »ç¿ëÀÚ°¡ µî·ÏÇÑ ³¯Â¥³ª ½Ã°£. |
REGISTRATIONCANCEL | TIMESTAMP NULL |
IBM ³»ºÎ¿ëÀ¸·Î ¿¹¾à.. |
REGISTRATIONUPDATE | TIMESTAMP NULL |
µî·Ï Á¤º¸°¡ º¯°æµÈ ³¯Â¥/½Ã°£. ÀÌ °ªÀº ·Î±×¿Â½Ã LDAP¿Í UserRegistrationAdd ¹× UserRegistrationUpdate ResetPassword µ¿±âÈ Áß ¼³Á¤µË´Ï´Ù. |
SETCCURR | CHARACTER (3) NULL |
ISO 4217¿¡ µû¸¥ 3ÀÚÀÇ ¿µ¼ýÀÚ ¼±È£ ÅëÈ ÄÚµå. ÀÌ´Â ISO 4217 Ç¥ÁØ¿¡ µû¸¥ ÅëÈ ÄÚµåÀÔ´Ï´Ù. SHOPPER Å×À̺íÀÇ SHPREFERREDCURR ¿°ú ºñ±³ÇϽʽÿÀ. |
USERS_ID | BIGINT NOT NULL |
»ç¿ëÀÚ ±¸¼º¿øÀÇ ID. MEMBER Å×À̺íÀÇ MEMBER_ID¿¡ ´ëÇÑ foreign key. |
»öÀÎ À̸§ | »öÀÎÈµÈ ¿ À̸§ | »öÀÎ À¯Çü |
---|---|---|
I348118 | PROFILETYPE, REGISTERTYPE, USERS_ID | °íÀ¯ÇÏÁö ¾ÊÀº »öÀÎ |
SQL030416035142230 | USERS_ID | 1Â÷ Ű |
Á¦ÇÑÁ¶°Ç | ¿ À̸§ | ¿ÜºÎ Å×À̺í À̸§ | ¿ÜºÎ ¿ À̸§ | Á¦ÇÑÁ¶°Ç À¯Çü |
---|---|---|---|---|
F_896 | USERS_ID | MEMBER | MEMBER_ID | °è´Ü½Ä |
F_897 | LANGUAGE_ID | LANGUAGE | LANGUAGE_ID | °è´Ü½Ä |
F_898 | SETCCURR | SETCURR | SETCCURR | °è´Ü½Ä |
Á¦ÇÑÁ¶°Ç | ÂüÁ¶µÇ´Â ¿ À̸§ | ¿ÜºÎ Å×À̺í À̸§ | ¿ÜºÎ ¿ À̸§ | Á¦ÇÑÁ¶°Ç À¯Çü |
---|---|---|---|---|
F_134 | USERS_ID | BUSPROF | USERS_ID | °è´Ü½Ä |
F_16 | USERS_ID | ACCLOGMAIN | USERS_ID | °è´Ü½Ä |
F_17 | USERS_ID | ACCLOGSUB | USERS_ID | °è´Ü½Ä |
F_21 | USERS_ID | ACCMBRGRP | USERS_ID | °è´Ü½Ä |
F_232 | USERS_ID | CERT_X509 | USERS_ID | °è´Ü½Ä |
F_263 | USERS_ID | CPOFFER | USERS_ID | °è´Ü½Ä |
F_276 | USERS_ID | CPWALLET | USERS_ID | °è´Ü½Ä |
F_61 | USERS_ID | APRVSTATUS | SUBMITTER_ID | °è´Ü½Ä |
F_62 | USERS_ID | APRVSTATUS | APPROVER_ID | °è´Ü½Ä |
F_633 | USERS_ID | PVCBINDING | USERS_ID | °è´Ü½Ä |
F_635 | USERS_ID | PVCBUFFER | USERS_ID | °è´Ü½Ä |
F_639 | USERS_ID | PVCSESSION | REGISTER_ID | °è´Ü½Ä |
F_888 | USERS_ID | USERDEMO | USERS_ID | °è´Ü½Ä |
F_889 | USERS_ID | USERPROF | USERS_ID | °è´Ü½Ä |
F_891 | USERS_ID | USERPVCDEV | USERS_ID | °è´Ü½Ä |
F_895 | USERS_ID | USERREG | USERS_ID | °è´Ü½Ä |
F_899 | USERS_ID | USRTRAFFIC | USERS_ID | °è´Ü½Ä |
F_955 | USERS_ID | QUEUECSR | CSR_ID | °è´Ü½Ä |
F_961 | USERS_ID | EMLRPTEVTS | USERS_ID | °è´Ü½Ä |
F_966 | USERS_ID | EMLUSRRECV | USERS_ID | °è´Ü½Ä |