ÀÌ Å×À̺íÀº ±¸¼º¿øÀÇ ÁÖ¼Ò¸¦ WebSphere Commerce ½Ã½ºÅÛ¿¡ ÀúÀåÇÕ´Ï´Ù. ÁÖ¼Ò´Â ±¸¼º¿ø ÀÚ½Å, Ä£±¸, µ¿·á ¶Ç´Â Ŭ¶óÀ̾ðÆ®ÀÇ ÁÖ¼ÒÀÏ ¼ö ÀÖ½À´Ï´Ù. ¿©±â¿¡¼ ÀϺΠ¿Àº ÀÌÀü ¹öÀü¿¡¼ »ç¿ëµÈ ¿À» ´ëüÇÕ´Ï´Ù.
¿ À̸§ | ¿ À¯Çü | ¿ ¼³¸í |
---|---|---|
ADDRBOOK_ID | BIGINT NOT NULL |
ÀÌ ÁÖ¼Ò°¡ ¼ÓÇÏ´Â ÁÖ¼Ò·ÏÀÇ ADDRBOOK Å×ÀÌºí¿¡ ´ëÇÑ foreign key·Î, WebSphere Commerce ¶Ç´Â WebSphere Commerce SuiteÀÇ ÀÌÀü ¹öÀü¿¡¼ »ç¿ëµÈ SHADDR Å×À̺íÀÇ SASHNBR ¿À» ´ëüÇÕ´Ï´Ù. |
ADDRESS1 | VARCHAR (50) NULL |
ÁÖ¼Ò Çà 1·Î, WebSphere Commerce ¶Ç´Â WebSphere Commerce SuiteÀÇ ÀÌÀü ¹öÀü¿¡¼ »ç¿ëµÈ SAADDR1À» ´ëüÇÕ´Ï´Ù. |
ADDRESS2 | VARCHAR (50) NULL |
ÁÖ¼Ò Çà 2·Î, WebSphere Commerce ¶Ç´Â WebSphere Commerce SuiteÀÇ ÀÌÀü ¹öÀü¿¡¼ »ç¿ëµÈ SAADDR2¸¦ ´ëüÇÕ´Ï´Ù. |
ADDRESS3 | VARCHAR (50) NULL |
ÁÖ¼Ò Çà 3À¸·Î, WebSphere Commerce ¶Ç´Â WebSphere Commerce SuiteÀÇ ÀÌÀü ¹öÀü¿¡¼ »ç¿ëµÈ SAADDR3¸¦ ´ëüÇÕ´Ï´Ù. |
ADDRESSTYPE | CHARACTER (5) NULL |
ÁÖ¼Ò À¯Çü. Ư¼º ÆÄÀÏÀ» »ç¿ëÇÏ¿© ±¸¼ºÇÒ ¼ö ÀÖ´Â ¿Ã¹Ù¸¥ °ª: S(shipto), B(billto) ¹× SB(shipto ¹× billto µÑ´Ù). ´ÜÀÏ ÁÖ¼Òµµ ¿©·¯ °¡Áö À¯ÇüÀ» °¡Áú ¼ö ÀÖ½À´Ï´Ù. properties ÆÄÀÏÀ» ãÀ» ¼ö ¾øÀ¸¸é ±âº»°ªÀÎ SB°¡ »ç¿ëµË´Ï´Ù. |
ADDRESS_ID | BIGINT NOT NULL |
³»ºÎÀûÀ¸·Î »ý¼ºµÈ °íÀ¯ ÂüÁ¶ ¹øÈ£. À̰ÍÀº 1Â÷ Ű·Î¼, WebSphere Commerce ¶Ç´Â WebSphere Commerce SuiteÀÇ ÀÌÀü ¹öÀü¿¡¼ »ç¿ëµÈ SHADDR Å×À̺íÀÇ SASHNBR ¿À» ´ëüÇÕ´Ï´Ù. |
BESTCALLINGTIME | CHARACTER (1) NULL |
¼±È£ ¿¬¶ô ½Ã°£À¸·Î, WebSphere Commerce ¶Ç´Â WebSphere Commerce SuiteÀÇ ÀÌÀü ¹öÀü¿¡¼ »ç¿ëµÈ SABTCALLÀ» ´ëüÇÕ´Ï´Ù. ¿Ã¹Ù¸¥ °ªÀº D(¾ÆÄ§) ¹× E(¾ß°£). |
BILLINGCODE | VARCHAR (17) NULL |
¿î¼Û ¶Ç´Â ÁöºÒ û±¸ Á¤º¸¸¦ ³ªÅ¸³»´Â ÄÚµå. |
BILLINGCODETYPE | CHARACTER (2) NULL |
ÁöºÒ û±¸¿¡ »ç¿ëµÇ´Â ÄÚµå ±¸Á¶ÀÇ ½Ã½ºÅÛ ¶Ç´Â ¹æ¹ýÀ» ³ªÅ¸³»´Â ÄÚµå. |
BUSINESSTITLE | VARCHAR (128) NULL |
ȸ»ç Á÷À§. ¿¹¸¦ µé¾î, °ü¸®ÀÚ ¶Ç´Â CEOÀÔ´Ï´Ù. LDAP´Â ePerson¿¡¼ Á÷À§ ¼Ó¼º¿¡ 128ÀÚ¸¦ »ç¿ëÇÕ´Ï´Ù. BUCONT Å×À̺íÀÇ BCTITLE ¿°ú ºñ±³ÇϽʽÿÀ. |
CITY | VARCHAR (128) NULL |
±¸/±º/½Ã·Î, WebSphere Commerce ¶Ç´Â WebSphere Commerce SuiteÀÇ ÀÌÀü ¹öÀü¿¡¼ »ç¿ëµÈ SACITY¸¦ ´ëüÇÕ´Ï´Ù. |
COUNTRY | VARCHAR (128) NULL |
±¹°¡/Áö¿ªÀ¸·Î, WebSphere Commerce ¶Ç´Â WebSphere Commerce SuiteÀÇ ÀÌÀü ¹öÀü¿¡¼ »ç¿ëµÈ SACNTRY¸¦ ´ëüÇÕ´Ï´Ù. |
EMAIL1 | VARCHAR (256) NULL |
ÀüÀÚ ¿ìÆí ÁÖ¼Ò (1)·Î, WebSphere Commerce ¶Ç´Â WebSphere Commerce SuiteÀÇ ÀÌÀü ¹öÀü¿¡¼ »ç¿ëµÈ SAEMAIL1À» ´ëüÇÕ´Ï´Ù. |
EMAIL2 | VARCHAR (256) NULL |
ÀüÀÚ ¿ìÆí ÁÖ¼Ò (2). |
FAX1 | VARCHAR (32) NULL |
ÆÑ½º ¹øÈ£ (1)·Î, WebSphere Commerce ¶Ç´Â WebSphere Commerce SuiteÀÇ ÀÌÀü ¹öÀü¿¡¼ »ç¿ëµÈ SAFAX¸¦ ´ëüÇÕ´Ï´Ù. |
FAX2 | VARCHAR (32) NULL |
ÆÑ½º ¹øÈ£ (2). |
FIELD1 | VARCHAR (64) NULL |
»ç¿ëÀÚ Á¤ÀÇ °¡´É.. ÀÌ ¿Àº SHADDR Å×À̺í(WebSphere Commerce ¶Ç´Â WebSphere Commerce SuiteÀÇ ÀÌÀü ¹öÀü¿¡¼ »ç¿ëµÈ)ÀÇ SAFIELD1 ¿À» ¹Ù²Ù°í ÃÖ´ë 3ÀÚ±îÁö ½ÂÀÎÇÕ´Ï´Ù. |
FIELD2 | VARCHAR (64) NULL |
»ç¿ëÀÚ Á¤ÀÇ °¡´É.. ÀÌ ¿Àº SHADDR Å×À̺í(WebSphere Commerce ¶Ç´Â WebSphere Commerce SuiteÀÇ ÀÌÀü ¹öÀü¿¡¼ »ç¿ëµÈ)ÀÇ SAFIELD2 ¿À» ¹Ù²Ù°í ÃÖ´ë 1ÀÚ±îÁö ½ÂÀÎÇÕ´Ï´Ù. |
FIELD3 | VARCHAR (64) NULL |
BUCONT Å×À̺íÀÇ BCFIELD3 ¿°ú ºñ±³ÇϽʽÿÀ. |
FIRSTNAME | VARCHAR (128) NULL |
ÀÌ ÁÖ¼Ò°¡ Àû¿ëµÇ´Â »ç¶÷ÀÇ À̸§À¸·Î, WebSphere Commerce ¶Ç´Â WebSphere Commerce SuiteÀÇ ÀÌÀü ¹öÀü¿¡¼ »ç¿ëµÈ SAFNAMEÀ» ´ëüÇÕ´Ï´Ù. |
ISPRIMARY | INTEGER NULL |
ÁöÁ¤µÈ ÁÖ¼Ò°¡ »ç¿ëÀÚÀÇ ÁÖ¼Ò (1)ÀÎÁö ¿©ºÎ. ¿Ã¹Ù¸¥ °ªÀº 1(ÁÖ¼Ò 1) ¶Ç´Â 0(ÁÖ¼Ò 1ÀÌ ¾Æ´Ô). ÀÌ´Â °¢ ADDRESSTYPET¸¶´Ù ¿©·¯ °³ÀÇ ÁÖ¼Ò¸¦ Çã¿ëÇϸç ÀÌ Áß Çϳª´Â 1Â÷ Ű·Î ÁöÁ¤µË´Ï´Ù. |
LASTCREATE | TIMESTAMP NULL |
ÇàÀÌ ÀÛ¼ºµÈ ³¯Â¥ ¹× ½Ã°£À¸·Î, WebSphere Commerce ¶Ç´Â WebSphere Commerce SuiteÀÇ ÀÌÀü ¹öÀü¿¡¼ »ç¿ëµÈ SASTMP¸¦ ´ëüÇÕ´Ï´Ù. |
LASTNAME | VARCHAR (128) NULL |
ÀÌ ÁÖ¼Ò°¡ Àû¿ëµÇ´Â »ç¶÷ÀÇ ¼ºÀ¸·Î, WebSphere Commerce ¶Ç´Â WebSphere Commerce SuiteÀÇ ÀÌÀü ¹öÀü¿¡¼ »ç¿ëµÈ SALNAMEÀ» ´ëüÇÕ´Ï´Ù. |
MEMBER_ID | BIGINT NOT NULL |
ÀÌ ÁÖ¼Ò¸¦ ¼ÒÀ¯ÇÏ´Â ±¸¼º¿øÀÇ MEMBER Å×ÀÌºí¿¡ ´ëÇÑ foreign key. |
MIDDLENAME | VARCHAR (128) NULL |
ÀÌ ÁÖ¼Ò°¡ Àû¿ëµÇ´Â »ç¶÷ÀÇ Áß°£ À̸§ ¶Ç´Â À̴ϼȷÎ, WebSphere Commerce ¶Ç´Â WebSphere Commerce SuiteÀÇ ÀÌÀü ¹öÀü¿¡¼ »ç¿ëµÈ SAMNAMEÀ» ´ëüÇÕ´Ï´Ù. |
NICKNAME | VARCHAR (254) NOT NULL |
ÁÖ¼ÒÀÇ º°¸í ¶Ç´Â ½Äº°ÀÚ·Î, WebSphere Commerce ¶Ç´Â WebSphere Commerce SuiteÀÇ ÀÌÀü ¹öÀü¿¡¼ »ç¿ëµÈ SANICK¸¦ ´ëüÇÕ´Ï´Ù. ±¸¼º¿øÀÌ ¼ÒÀ¯ÇÏ´Â ¸ðµç ÁÖ¼ÒÀÇ º°¸íÀº °íÀ¯ÇØ¾ß ÇÕ´Ï´Ù. |
OFFICEADDRESS | VARCHAR (128) NULL |
¹®Àü ¹è´Þ ¶Ç´Â ¿î¼Û ÁÖ¼Ò¿Í ¿¬°üµÈ »ç¹«½Ç ÁÖ¼Ò. |
ORGNAME | VARCHAR (128) NULL |
»ç¹«½Ç ÁÖ¼ÒÀÎ °æ¿ì, ÀÌ ÁÖ¼Ò¿¡ ´ëÇÑ Á¶Á÷ÀÇ À̸§. ÀÌ ÁÖ¼Ò°¡ ÀÖ´Â ÁÖ¼Ò·ÏÀ» ¼ÒÀ¯ÇÏ´Â Á¶Á÷ÀÇ À̸§°ú µ¿ÀÏÇÏÁö´Â ¾Ê½À´Ï´Ù. ÀÌ ¿Àº WebSphere Commerce ¶Ç´Â WebSphere Commerce SuiteÀÇ ÀÌÀü ¹öÀü¿¡¼ »ç¿ëµÈ SAREPCOMÀ» ´ëüÇÕ´Ï´Ù. |
ORGUNITNAME | VARCHAR (128) NULL |
ºñÁö´Ï½º ÁÖ¼ÒÀÎ °æ¿ì, ÀÌ ÁÖ¼Ò Á¤º¸°¡ Àû¿ëµÇ´Â ºÎ¼ ´ÜÀ§ÀÇ À̸§. À§ÀÇ ORGNAME¿¡ ´ëÇÑ ¼³¸í ÂüÁ¶. |
PACKAGESUPPRESSION | INTEGER NULL |
ÆÐŰÁö »ðÀÔÀ» Æ÷ÇÔ½ÃųÁö ¿©ºÎ¸¦ ÁöÁ¤ÇÕ´Ï´Ù. ¿Ã¹Ù¸¥ °ªÀº 1(Æ÷ÇÔ) ¶Ç´Â 0(Æ÷ÇÔµÇÁö ¾ÊÀ½) |
PERSONTITLE | VARCHAR (50) NULL |
ÀÌ ÁÖ¼Ò°¡ Àû¿ëµÇ´Â »ç¶÷ÀÇ Á÷À§·Î, WebSphere Commerce ¶Ç´Â WebSphere Commerce SuiteÀÇ ÀÌÀü ¹öÀü¿¡¼ »ç¿ëµÈ SATITLEÀ» ´ëüÇÕ´Ï´Ù. LDAP´Â ±æÀÌ 50À» »ç¿ëÇÕ´Ï´Ù. ¿Ã¹Ù¸¥ °ªÀº Dr, Prof, Rev, Mr, Mrs, Ms ¹× N(Á¦°øµÇÁö ¾ÊÀ½). ±âº»°ªÀº NÀÔ´Ï´Ù. |
PHONE1 | VARCHAR (32) NULL |
ÀüÈ ¹øÈ£ (1)·Î, WebSphere Commerce ¶Ç´Â WebSphere Commerce SuiteÀÇ ÀÌÀü ¹öÀü¿¡¼ »ç¿ëµÈ SAPHONE1À» ´ëüÇÕ´Ï´Ù. |
PHONE1TYPE | CHARACTER (3) NULL |
ÀüȹøÈ£ (1)ÀÇ ÀüÈ À¯Çü(¿¹: û°¢Àå¾ÖÀÚ¸¦ À§ÇÑ ÅÚ·¹Å¸ÀÌÇÁ¶óÀÌÅÍÀÇ °æ¿ì¿¡´Â TTY, ÀÏ¹Ý ÀüÈÀÇ °æ¿ì¿¡´Â PHN). ÀÌ ¿Àº SADPHTYPÀ» ´ëüÇÕ´Ï´Ù. |
PHONE2 | VARCHAR (32) NULL |
ÀüÈ ¹øÈ£ (2)·Î, WebSphere Commerce ¶Ç´Â WebSphere Commerce SuiteÀÇ ÀÌÀü ¹öÀü¿¡¼ »ç¿ëµÈ SAPHONE2¸¦ ´ëüÇÕ´Ï´Ù. |
PHONE2TYPE | CHARACTER (3) NULL |
ÀüȹøÈ£ (2)ÀÇ ÀüÈ À¯Çü(¿¹: û°¢Àå¾ÖÀÚ¸¦ À§ÇÑ ÅÚ·¹Å¸ÀÌÇÁ¶óÀÌÅÍÀÇ °æ¿ì¿¡´Â TTY, ÀÏ¹Ý ÀüÈÀÇ °æ¿ì¿¡´Â PHN). ÀÌ ¿Àº SAEPHTYPÀ» ´ëüÇÕ´Ï´Ù. |
PUBLISHPHONE1 | INTEGER NULL |
ÀüȹøÈ£ (1)ÀÇ ³ª¿ ¿©ºÎ¸¦ ÁöÁ¤ÇÕ´Ï´Ù. ¿Ã¹Ù¸¥ °ªÀº 1(³ª¿µÊ) ¶Ç´Â 0(³ª¿µÇÁö ¾ÊÀ½). |
PUBLISHPHONE2 | INTEGER NULL |
ÀüȹøÈ£ (2)ÀÇ ³ª¿ ¿©ºÎ¸¦ ÁöÁ¤ÇÕ´Ï´Ù. ¿Ã¹Ù¸¥ °ªÀº 1(³ª¿µÊ) ¶Ç´Â 0(³ª¿µÇÁö ¾ÊÀ½). |
SELFADDRESS | INTEGER NOT NULL, DEFAULT 0 |
ÁÖ¼Ò°¡ »ç¿ëÀÚÀÇ °ÍÀÎÁö ¿©ºÎ¸¦ ÁöÁ¤ÇÕ´Ï´Ù. ¿Ã¹Ù¸¥ °ªÀº 1(ÁÖ¼Ò°¡ »ç¿ëÀÚ¿¡°Ô ¼ÓÇÔ) ¶Ç´Â 0(¼ýÀÚ°¡ »ç¿ëÀÚ¿¡°Ô ¼ÓÇÏÁö ¾ÊÀ½. Ä£±¸, ¿¬°ü ¶Ç´Â »ó´ë¿¡ ¼ÓÇÒ ¼ö ÀÖÀ½)ÀÔ´Ï´Ù. |
SHIPPINGGEOCODE | VARCHAR (254) NULL |
Áö¿ªÀ» ±âº»À¸·Î ÇÏ´Â ¿î¼Û ÄÚµå. ÀÌ °ªÀº ¼¼±Ý¿¡ ÅëÇÕÇÏ´Â µ¥ »ç¿ëµË´Ï´Ù. |
STATE | VARCHAR (128) NULL |
½Ã/µµ·Î, WebSphere Commerce ¶Ç´Â WebSphere Commerce SuiteÀÇ ÀÌÀü ¹öÀü¿¡¼ »ç¿ëµÈ SASTATE¸¦ ´ëüÇÕ´Ï´Ù. |
STATUS | CHARACTER (1) NULL |
ÁÖ¼Ò »óŸ¦ ÁöÁ¤ÇÕ´Ï´Ù. ¿Ã¹Ù¸¥ °ªÀº ¿µ±¸(ÇöÀç ¶Ç´Â ÀÓ½Ã(ÀÌ·Â) ÁÖ¼Ò. ÀÌ ¿Àº WebSphere Commerce ¶Ç´Â WebSphere Commerce SuiteÀÇ ÀÌÀü ¹öÀü¿¡¼ »ç¿ëµÈ SAADRFLAG¸¦ ´ëüÇÕ´Ï´Ù. |
TAXGEOCODE | VARCHAR (254) NULL |
Áö¿ªÀ» ±âº»À¸·Î ÇÑ ¼¼±Ý ÄÚµå·Î, Taxware¿ÍÀÇ ÅëÇÕ¿¡ »ç¿ëµË´Ï´Ù. |
ZIPCODE | VARCHAR (40) NULL |
¿ìÆí¹øÈ£·Î, WebSphere Commerce ¶Ç´Â WebSphere Commerce SuiteÀÇ ÀÌÀü ¹öÀü¿¡¼ »ç¿ëµÈ SAZIPC¸¦ ´ëüÇÕ´Ï´Ù. |
»öÀÎ À̸§ | »öÀÎÈµÈ ¿ À̸§ | »öÀÎ À¯Çü |
---|---|---|
I0000015 | ADDRBOOK_ID, ADDRESSTYPE, ISPRIMARY, STATUS | °íÀ¯ÇÏÁö ¾ÊÀº »öÀÎ |
I0000016 | MEMBER_ID, STATUS, SELFADDRESS, ADDRESSTYPE, ISPRIMARY | °íÀ¯ÇÏÁö ¾ÊÀº »öÀÎ |
I0000346 | LASTNAME | °íÀ¯ÇÏÁö ¾ÊÀº »öÀÎ |
SQL030416034835120 | ADDRESS_ID | 1Â÷ Ű |
Á¦ÇÑÁ¶°Ç | ¿ À̸§ | ¿ÜºÎ Å×À̺í À̸§ | ¿ÜºÎ ¿ À̸§ | ]Á¦ÇÑÁ¶°Ç À¯Çü |
---|---|---|---|---|
F_58 | ADDRBOOK_ID | ADDRBOOK | ADDRBOOK_ID | °è´Ü½Ä |
F_59 | MEMBER_ID | MEMBER | MEMBER_ID | °è´Ü½Ä |
Á¦ÇÑÁ¶°Ç | ÂüÁ¶µÇ´Â ¿ À̸§ | ¿ÜºÎ Å×À̺í À̸§ | ¿ÜºÎ ¿ À̸§ | ]Á¦ÇÑÁ¶°Ç À¯Çü |
---|---|---|---|---|
F_499 | ADDRESS_ID | ORDERITEMS | ALLOCADDRESS_ID | °è´Ü½Ä |
F_503 | ADDRESS_ID | ORDERITEMS | ADDRESS_ID | °è´Ü½Ä |
F_515 | ADDRESS_ID | ORDERS | ADDRESS_ID | °è´Ü½Ä |
F_812 | ADDRESS_ID | SUBORDERS | ADDRESS_ID | °è´Ü½Ä |