Å×ÀÌºí ¼³¸í:
ÀÌ Å×ÀÌºí¿¡´Â ProductSetÀÇ Á¤Àǰ¡ µé¾î ÀÖ½À´Ï´Ù. ProductSetÀÇ ½ÇÁ¦ Ç¥½Ã´Â PRSETCEREL Å×ÀÌºí¿¡ º¸À¯µË´Ï´Ù.
¿ ¼³¸í:
¿ À̸§ | ¿ À¯Çü | ¿ ¼³¸í |
MARKFORDELETE |
INTEGER
NOT NULL, DEFAULT 0 |
ÀÌ ProductSetÀÌ »èÁ¦ ´ë»óÀ¸·Î Ç¥½ÃµÇ¾ú´ÂÁö ¿©ºÎ¸¦ ³ªÅ¸³À´Ï´Ù. 0 = ¾Æ´Ï¿À 1 = »èÁ¦ Ç¥½Ã |
MEMBER_ID |
BIGINT
NOT NULL |
ÀÌ ProductSetÀÇ ¼ÒÀ¯ÀÚ. |
NAME |
VARCHAR (32)
NULL |
ÀÌ ProductSet¿¡ ºÎ¿©µÈ À̸§ |
PRODUCTSET_ID |
INTEGER
NOT NULL |
³»ºÎ ÂüÁ¶ ¹øÈ£ |
PUBLISHTIME |
TIMESTAMP
NULL |
ProductSet°¡ PRSETCEREL Å×ÀÌºí¿¡ °ø°³µÈ ½Ã°£. |
STATIC |
CHARACTER (1)
NULL |
ÀÌ ProductSetÀÌ º¯°æµÉ ¼ö ÀÖ´ÂÁö ¿©ºÎ¸¦ ³ªÅ¸³À´Ï´Ù. ÀÌ ¿À» "1"·Î ¼³Á¤Çϸé, ÀÌ PoductSetÀÌ ´Ù½Ã °ø°³µÇ°Å³ª µ¿±âȵÇÁö ¾Ê½À´Ï´Ù. |
XMLDEFINITION |
LONG VARCHAR
NULL |
B2BProductSet.dtd¿¡ ÇØ´çµÇ´Â ProductSetÀÇ XML Á¤ÀǸ¦ º¸À¯ÇÕ´Ï´Ù. |
»öÀÎ:
»öÀÎ À̸§ | »öÀÎµÈ ¿ À̸§ | »öÀÎ À¯Çü |
I0000191 | NAME, MEMBER_ID | °íÀ¯ »öÀÎ |
SQL020206020726690 | PRODUCTSET_ID | 1Â÷ Ű |
Á¦ÇÑ»çÇ×:
Á¦ÇÑÀÚ À̸§ | ¿ À̸§ | Foreign Å×À̺í À̸§ | Foreign ¿ À̸§ | Á¦ÇÑÀÚ À¯Çü |
F_622 | MEMBER_ID | MEMBER | MEMBER_ID | °è´Ü½Ä |
ÂüÁ¶:
Á¦ÇÑÀÚ À̸§ | ÂüÁ¶µÈ ¿ À̸§ | Foreign Å×À̺í À̸§ | Foreign ¿ À̸§ | Á¦ÇÑÀÚ À¯Çü |
F_221 | PRODUCTSET_ID | CATGRPPS | PRODUCTSET_ID | °è´Ü½Ä |
F_621 | PRODUCTSET_ID | PRODSETDSC | PRODUCTSET_ID | °è´Ü½Ä |
F_628 | PRODUCTSET_ID | PRSETCEREL | PRODUCTSET_ID | °è´Ü½Ä |
F_864 | PRODUCTSET_ID | TRADEPOSCN | PRODUCTSET_ID | °è´Ü½Ä |
![]() |