ÀÌ Å×ÀÌºí¿¡´Â WebSphere Commerce ½Ã½ºÅÛ¿¡ Á¤ÀÇµÈ ±¸¼º¿ø ±×·ìÀÌ ÀúÀåµË´Ï´Ù. ±¸¼º¿ø ±×·ìÀº ±¸¼º¿øÀÇ ±×·ìÀÔ´Ï´Ù. ¸â¹ö½±Àº ±¸¼º¿ø ±×·ì ³»ÀÇ »ç¿ëÀÚ·Î Á¦Çѵ˴ϴÙ.
¿ À̸§ | ¿ À¯Çü | ¿ ¼³¸í |
---|---|---|
DESCRIPTION | VARCHAR (512) NULL |
±¸¼º¿ø ±×·ìÀÇ ¼³¸í. |
DN | VARCHAR (1000) NULL |
IBM ³»ºÎ¿ëÀ¸·Î ¿¹¾à.. |
FIELD1 | VARCHAR (254) NULL |
»ç¿ëÀÚ Á¤ÀÇ °¡´É.. WebSphere Commerce ¶Ç´Â WebSphere Commerce SuiteÀÇ ÀÌÀü ¹öÀü¿¡¼ »ç¿ëµÈ SHOPGRP Å×À̺íÀÇ SGFIELD1 ¿°ú ºñ±³ÇϽʽÿÀ. |
FIELD2 | VARCHAR (254) NULL |
»ç¿ëÀÚ Á¤ÀÇ °¡´É.. WebSphere Commerce ¶Ç´Â WebSphere Commerce SuiteÀÇ ÀÌÀü ¹öÀü¿¡¼ »ç¿ëµÈ SHOPGRP Å×À̺íÀÇ SGFIELD2 ¿°ú ºñ±³ÇϽʽÿÀ. |
FIELD3 | VARCHAR (254) NULL |
»ç¿ëÀÚ Á¤ÀÇ °¡´É. |
LASTUPDATE | TIMESTAMP NULL |
ÀÌ ±¸¼º¿ø ±×·ìÀÌ ¸¶Áö¸·À¸·Î °»½ÅµÈ ³¯Â¥ |
LASTUPDATEDBY | VARCHAR (254) NULL |
ÀÌ ±¸¼º¿ø ±×·ìÀ» ¸¶Áö¸·À¸·Î °»½ÅÇÑ »ç¿ëÀÚÀÇ ·Î±×¿Â ID. |
MBRGRPNAME | VARCHAR (254) NOT NULL |
ÀÌ ±¸¼º¿ø ±×·ìÀÇ À̸§. |
MBRGRP_ID | BIGINT NOT NULL |
ÀÌ ±¸¼º¿ø ±×·ì¿¡ ´ëÇÑ MEMBER Å×À̺íÀÇ foreign key. |
OID | VARCHAR (64) NULL |
IBM ³»ºÎ¿ëÀ¸·Î ¿¹¾à.. |
OWNER_ID | BIGINT NOT NULL |
WebSphere Commerce ¶Ç´Â WebSphere Commerce SuiteÀÇ ÀÌÀü ¹öÀü¿¡¼ »ç¿ëµÈ SHOPGRP Å×À̺íÀÇ SGMENBR ¿°ú ºñ±³ÇϽʽÿÀ. ÀÌ ±¸¼º¿ø ±×·ìÀÇ ¼ÒÀ¯ÀÚ¿¡ ´ëÇÑ MEMBER Å×À̺íÀÇ foreign key. |
»öÀÎ À̸§ | »öÀÎÈµÈ ¿ À̸§ | »öÀÎ À¯Çü |
---|---|---|
I0000152 | OWNER_ID, MBRGRPNAME | °íÀ¯ »öÀÎ |
SQL030416034957420 | MBRGRP_ID | 1Â÷ Ű |
Á¦ÇÑÁ¶°Ç | ¿ À̸§ | ¿ÜºÎ Å×À̺í À̸§ | ¿ÜºÎ ¿ À̸§ | ]Á¦ÇÑÁ¶°Ç À¯Çü |
---|---|---|---|---|
F_443 | MBRGRP_ID | MEMBER | MEMBER_ID | °è´Ü½Ä |
F_444 | OWNER_ID | MEMBER | MEMBER_ID | °è´Ü½Ä |
Á¦ÇÑÁ¶°Ç | ÂüÁ¶µÇ´Â ¿ À̸§ | ¿ÜºÎ Å×À̺í À̸§ | ¿ÜºÎ ¿ À̸§ | ]Á¦ÇÑÁ¶°Ç À¯Çü |
---|---|---|---|---|
F_1030 | MBRGRP_ID | MBRGRPDESC | MBRGRP_ID | °è´Ü½Ä |
F_12 | MBRGRP_ID | ACCCMDGRP | MBRGRP_ID | °è´Ü½Ä |
F_140 | MBRGRP_ID | BUYSUPMAP | MBRGRP_ID | °è´Ü½Ä |
F_159 | MBRGRP_ID | CALCODEMGP | MBRGRP_ID | °è´Ü½Ä |
F_173 | MBRGRP_ID | CALRULEMGP | MBRGRP_ID | °è´Ü½Ä |
F_20 | MBRGRP_ID | ACCMBRGRP | MBRGRP_ID | °è´Ü½Ä |
F_301 | MBRGRP_ID | DISPCGPREL | MBRGRP_ID | °è´Ü½Ä |
F_305 | MBRGRP_ID | DISPENTREL | MBRGRP_ID | °è´Ü½Ä |
F_31 | MBRGRP_ID | ACPOLICY | MBRGRP_ID | °è´Ü½Ä |
F_349 | MBRGRP_ID | FORUM | MBRGRP_ID | °è´Ü½Ä |
F_445 | MBRGRP_ID | MBRGRPCOND | MBRGRP_ID | °è´Ü½Ä |
F_447 | MBRGRP_ID | MBRGRPMBR | MBRGRP_ID | °è´Ü½Ä |
F_448 | MBRGRP_ID | MBRGRPUSG | MBRGRP_ID | °è´Ü½Ä |
F_461 | MBRGRP_ID | MGPTRDPSCN | MBRGRP_ID | °è´Ü½Ä |
F_510 | MBRGRP_ID | ORDERMGP | MBRGRP_ID | °è´Ü½Ä |
F_63 | MBRGRP_ID | APRVSTATUS | MBRGRP_ID | °è´Ü½Ä |
F_801 | MBRGRP_ID | STOREMBRGP | MBRGRP_ID | °è´Ü½Ä |
F_82 | MBRGRP_ID | AUCTION | MBRGRP_ID | °è´Ü½Ä |
F_88 | MBRGRP_ID | AUCTIONLOG | MBRGRP_ID | °è´Ü½Ä |
F_964 | MBRGRP_ID | EMLGRPREL | MBRGRP_ID | °è´Ü½Ä |