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


Å×ÀÌºí ¼³¸í:

ÀÌ Å×ÀÌºí¿¡´Â 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 °è´Ü½Ä
IBM copyright