Å×ÀÌºí ¼³¸í:
ÀÌ Å×ÀÌºí¿¡´Â 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 |
»ç¿ëÀÚ µî·Ï À¯Çü. Ãß°¡ Á¤º¸´Â USERS Å×À̺í: Á¤º¸¸¦ ÂüÁ¶ÇϽʽÿÀ. |
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. |
»öÀÎ:
»öÀÎ À̸§ | »öÀÎµÈ ¿ À̸§ | »öÀÎ À¯Çü |
I348145 | PROFILETYPE, REGISTERTYPE, USERS_ID | °íÀ¯ÇÏÁö ¾ÊÀº »öÀÎ |
SQL020206020819750 | USERS_ID | 1Â÷ Ű |
Á¦ÇÑ»çÇ×:
Á¦ÇÑÀÚ À̸§ | ¿ À̸§ | Foreign Å×À̺í À̸§ | Foreign ¿ À̸§ | Á¦ÇÑÀÚ À¯Çü |
F_896 | USERS_ID | MEMBER | MEMBER_ID | °è´Ü½Ä |
F_897 | LANGUAGE_ID | LANGUAGE | LANGUAGE_ID | °è´Ü½Ä |
F_898 | SETCCURR | SETCURR | SETCCURR | °è´Ü½Ä |
ÂüÁ¶:
Á¦ÇÑÀÚ À̸§ | ÂüÁ¶µÈ ¿ À̸§ | Foreign Å×À̺í À̸§ | Foreign ¿ À̸§ | Á¦ÇÑÀÚ À¯Çü |
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 | °è´Ü½Ä |
![]() |