Å×ÀÌºí ¼³¸í:
ÀÌ Å×ÀÌºí¿¡´Â WebSphere Commerce ½Ã½ºÅÛ¿¡ Á¤ÀÇµÈ ±¸¼º¿ø ±×·ìÀÌ ÀúÀåµË´Ï´Ù. ±¸¼º¿ø ±×·ìÀº ±¸¼º¿øÀÇ ±×·ìÀÔ´Ï´Ù. ¸â¹ö½±Àº ±¸¼º¿ø ±×·ì ³»ÀÇ »ç¿ëÀÚ·Î Á¦Çѵ˴ϴÙ.
¿ ¼³¸í:
¿ À̸§ | ¿ À¯Çü | ¿ ¼³¸í |
DESCRIPTION |
VARCHAR (512)
NULL |
±¸¼º¿ø ±×·ìÀÇ ¼³¸í |
DN |
VARCHAR (1000)
NULL |
IBM ³»ºÎ¿ëÀ¸·Î ¿¹¾à |
FIELD1 |
VARCHAR (254)
NULL |
»ç¿ëÀÚ Á¤ÀÇ °¡´É WebSphere Commerce SuiteÀÇ ÀÌÀü ¹öÀü¿¡¼ »ç¿ëµÈ SHOPGRP Å×À̺íÀÇ SGFIELD1 ¿°ú ºñ±³ÇϽʽÿÀ. |
FIELD2 |
VARCHAR (254)
NULL |
»ç¿ëÀÚ Á¤ÀÇ °¡´É WebSphere Commerce SuiteÀÇ ÀÌÀü ¹öÀü¿¡¼ »ç¿ëµÈ SHOPGRP Å×À̺íÀÇ SGFIELD2 ¿°ú ºñ±³ÇϽʽÿÀ. |
FIELD3 |
VARCHAR (254)
NULL |
»ç¿ëÀÚ Á¤ÀÇ °¡´É |
LASTUPDATE |
TIMESTAMP
NULL |
ÀÌ ±¸¼º¿ø ±×·ìÀÌ ¸¶Áö¸·À¸·Î °»½ÅµÈ ³¯Â¥ |
LASTUPDATEDBY |
VARCHAR (254)
NULL |
ÀÌ ±¸¼º¿ø ±×·ìÀ» ¸¶Áö¸·À¸·Î °»½ÅÇÑ »ç¿ëÀÚÀÇ ·Î±×¿Â ID |
MBRGRP_ID |
BIGINT
NOT NULL |
ÀÌ ±¸¼º¿ø ±×·ì¿¡ ´ëÇÑ MEMBER Å×À̺íÀÇ foreign key. |
MBRGRPNAME |
VARCHAR (254)
NOT NULL |
ÀÌ ±¸¼º¿ø ±×·ìÀÇ À̸§. |
OID |
VARCHAR (64)
NULL |
IBM ³»ºÎ¿ëÀ¸·Î ¿¹¾à |
OWNER_ID |
BIGINT
NOT NULL |
WebSphere Commerce SuiteÀÇ ÀÌÀü ¹öÀü¿¡¼ »ç¿ëµÈ SHOPGRP Å×À̺íÀÇ SGMENBR ¿°ú ºñ±³ÇϽʽÿÀ. ÀÌ ±¸¼º¿ø ±×·ìÀÇ ¼ÒÀ¯ÀÚ¿¡ ´ëÇÑ MEMBER Å×À̺íÀÇ foreign key. |
»öÀÎ:
»öÀÎ À̸§ | »öÀÎµÈ ¿ À̸§ | »öÀÎ À¯Çü |
I0000152 | OWNER_ID, MBRGRPNAME | °íÀ¯ »öÀÎ |
SQL020206020655220 | MBRGRP_ID | 1Â÷ Ű |
Á¦ÇÑ»çÇ×:
Á¦ÇÑÀÚ À̸§ | ¿ À̸§ | Foreign Å×À̺í À̸§ | Foreign ¿ À̸§ | Á¦ÇÑÀÚ À¯Çü |
F_443 | MBRGRP_ID | MEMBER | MEMBER_ID | °è´Ü½Ä |
F_444 | OWNER_ID | MEMBER | MEMBER_ID | °è´Ü½Ä |
ÂüÁ¶:
Á¦ÇÑÀÚ À̸§ | ÂüÁ¶µÈ ¿ À̸§ | Foreign Å×À̺í À̸§ | Foreign ¿ À̸§ | Á¦ÇÑÀÚ À¯Çü |
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 | °è´Ü½Ä |
![]() |