ÀÌ Å×ÀÌºí¿¡´Â CatalogEntry¿¡ ¿¬°üµÈ Á¤º¸°¡ µé¾î ÀÖ½À´Ï´Ù. CatalogEntriesÀÇ ¿¹·Î´Â »óǰ, Ç׸ñ, ¹øµé ¹× ÆÐŰÁö°¡ µé¾î ÀÖ½À´Ï´Ù.
¿ À̸§ | ¿ À¯Çü | ¿ ¼³¸í |
---|---|---|
BASEITEM_ID | BIGINT NULL |
ÀÌ CatalogEntry¿Í ¿¬°üµÇ¾î ÀÖ´Â BaseItem. ÀÌ ¿Àº "ProductBean" ¶Ç´Â "PackageBean" À¯ÇüÀÇ CatalogEntryÀÇ °æ¿ì¿¡¸¸ ´ë·® ÀÚ·á ¹ÝÀ﵃ ¼ö ÀÖ½À´Ï´Ù. BaseItems´Â ¼ºñ½º ¼¾ÅÍ¿¡¼ »ç¿ëµË´Ï´Ù. |
BUYABLE | INTEGER NULL |
ÀÌ CatalogEntry¸¦ °³º°ÀûÀ¸·Î ±¸ÀÔÇÒ ¼ö ÀÖ´ÂÁö ¿©ºÎ¸¦ ³ªÅ¸³À´Ï´Ù(1=¿¹, 0=¾Æ´Ï¿À). |
CATENTRY_ID | BIGINT NOT NULL |
CatalogEntryÀÇ ³»ºÎ ÂüÁ¶ ¹øÈ£. |
CATENTTYPE_ID | CHARACTER (16) NOT NULL |
CatalogEntryÀÇ À¯ÇüÀ» ½Äº°ÇÕ´Ï´Ù. CATENTTYPE Å×À̺íÀÇ foreign key. Áö¿øµÇ´Â ±âº» À¯ÇüÀº ProductBean, ItemBean, PackageBean, BundleBean, DynamicKitBeanÀÔ´Ï´Ù. |
ENDDATE | TIMESTAMP NULL |
ÀÌ Ä«Å»·Î±× Ç׸ñÀÌ ÃÖ¼ÒµÈ ³¯Â¥. |
FIELD1 | INTEGER NULL |
»ç¿ëÀÚ Á¤ÀÇ °¡´É. |
FIELD2 | INTEGER NULL |
»ç¿ëÀÚ Á¤ÀÇ °¡´É. |
FIELD3 | DECIMAL(20,5) NULL |
»ç¿ëÀÚ Á¤ÀÇ °¡´É. |
FIELD4 | VARCHAR (254) NULL |
»ç¿ëÀÚ Á¤ÀÇ °¡´É. |
FIELD5 | VARCHAR (254) NULL |
»ç¿ëÀÚ Á¤ÀÇ °¡´É. |
ITEMSPC_ID | BIGINT NULL |
ÀÌ CatalogEntry¿Í ¿¬°üµÇ¾î ÀÖ´Â SpecifiedItem. ÀÌ ¿Àº "ItemBean", "PackageBean" ¶Ç´Â "DynamicKitBean" À¯ÇüÀÇ CatalogEntryÀÇ °æ¿ì¿¡¸¸ ´ë·® ÀÚ·á ¹ÝÀ﵃ ¼ö ÀÖ½À´Ï´Ù. SpecifiedItems´Â ¼ºñ½º ¼¾ÅÍ¿¡¼ »ç¿ëµË´Ï´Ù. |
LASTUPDATE | TIMESTAMP NULL |
CatalogEntry°¡ ¸¶Áö¸·À¸·Î °»½ÅµÈ ½Ã°£À» ³ªÅ¸³À´Ï´Ù. |
MARKFORDELETE | INTEGER NOT NULL |
ÀÌ CatalogEntry°¡ »èÁ¦ ´ë»óÀ¸·Î Ç¥½ÃµÇ¾ú´ÂÁö ¿©ºÎ¸¦ ³ªÅ¸³À´Ï´Ù. 0 = ¾Æ´Ï¿À 1 = ¿¹ |
MEMBER_ID | BIGINT NOT NULL |
CatalogEntryÀÇ ¼ÒÀ¯ÀÚ¸¦ ½Äº°ÇÏ´Â ÂüÁ¶ ¹øÈ£. PARTNUMBER¿Í ÇÔ²², ÀÌ ¿Àº °íÀ¯ÇÑ »öÀÎÀÔ´Ï´Ù. |
MFNAME | VARCHAR (64) NULL |
CatalogEntryÀÇ Á¦Á¶¾÷ü À̸§ |
MFPARTNUMBER | VARCHAR (64) NULL |
ÀÌ CatalogEntry¸¦ ½Äº°Çϱâ À§ÇØ Á¦Á¶¾÷ü¿¡¼ »ç¿ëÇÏ´Â ºÎǰ ¹øÈ£. |
OID | VARCHAR (64) NULL |
IBM ³»ºÎ¿ëÀ¸·Î ¿¹¾à.. |
ONAUCTION | INTEGER NULL |
ÀÌ Ç÷¡±×´Â ÀÌ CatalogEntry°¡ °æ¸Å ÁßÀÎÁö¸¦ ½Äº°ÇÕ´Ï´Ù. |
ONSPECIAL | INTEGER NULL |
ÀÌ Ç÷¡±×´Â ÀÌ CatalogEntry°¡ Ư¼öÇÑ °æ¿ìÀÎÁö¸¦ ½Äº°ÇÕ´Ï´Ù. |
PARTNUMBER | VARCHAR (64) NOT NULL |
CatalogEntryÀÇ ºÎǰ ¹øÈ£¸¦ ½Äº°ÇÏ´Â ÂüÁ¶ ¹øÈ£. MEMBER_ID¿Í ÇÔ²² ÀÌ ¿Àº °íÀ¯ »öÀÎÀÔ´Ï´Ù. |
STARTDATE | TIMESTAMP NULL |
ÀÌ Ä«Å»·Î±× Ç׸ñÀÌ µµÀÔµÈ ³¯Â¥. |
STATE | CHARACTER (1) NULL, DEFAULT '1' |
IBM ³»ºÎ¿ëÀ¸·Î ¿¹¾à.. |
URL | VARCHAR (254) NULL |
¼ÒÇÁÆ® »óǰ¿¡ ´ëÇÑ ´Ù¿î·Îµå URL·Î »ç¿ëµÉ ¼ö ÀÖ´Â ÀÌ Ä«Å»·Î±× Ç׸ñ¿¡ ´ëÇÑ URL |
»öÀÎ À̸§ | »öÀÎÈµÈ ¿ À̸§ | »öÀÎ À¯Çü |
---|---|---|
I0000064 | PARTNUMBER, MEMBER_ID | °íÀ¯ »öÀÎ |
I0000065 | CATENTRY_ID, MARKFORDELETE | °íÀ¯ÇÏÁö ¾ÊÀº »öÀÎ |
I0000305 | BUYABLE, CATENTRY_ID, CATENTTYPE_ID | °íÀ¯ÇÏÁö ¾ÊÀº »öÀÎ |
I263103 | CATENTRY_ID, CATENTTYPE_ID | °íÀ¯ÇÏÁö ¾ÊÀº »öÀÎ |
I263121 | ITEMSPC_ID | °íÀ¯ÇÏÁö ¾ÊÀº »öÀÎ |
I263122 | BASEITEM_ID | °íÀ¯ÇÏÁö ¾ÊÀº »öÀÎ |
SQL030416034900700 | CATENTRY_ID | 1Â÷ Ű |
Á¦ÇÑÁ¶°Ç À̸§ | ¿ À̸§ | ¿ÜºÎ Å×À̺í À̸§ | ¿ÜºÎ ¿ À̸§ | ]Á¦ÇÑÁ¶°Ç À¯Çü |
---|---|---|---|---|
F_201 | ITEMSPC_ID | ITEMSPC | ITEMSPC_ID | °è´Ü½Ä |
F_202 | BASEITEM_ID | BASEITEM | BASEITEM_ID | °è´Ü½Ä |
F_203 | MEMBER_ID | MEMBER | MEMBER_ID | °è´Ü½Ä |
F_204 | CATENTTYPE_ID | CATENTTYPE | CATENTTYPE_ID | °è´Ü½Ä |
Á¦ÇÑÁ¶°Ç À̸§ | ÂüÁ¶µÇ´Â ¿ À̸§ | ¿ÜºÎ Å×À̺í À̸§ | ¿ÜºÎ ¿ À̸§ | ]Á¦ÇÑÁ¶°Ç À¯Çü |
---|---|---|---|---|
F_186 | CATENTRY_ID | CATCLSFCOD | CATENTRY_ID | °è´Ü½Ä |
F_189 | CATENTRY_ID | CATCONFINF | CATENTRY_ID | °è´Ü½Ä |
F_192 | CATENTRY_ID | CATENCALCD | CATENTRY_ID | °è´Ü½Ä |
F_194 | CATENTRY_ID | CATENTATTR | CATENTRY_ID | °è´Ü½Ä |
F_196 | CATENTRY_ID | CATENTDESC | CATENTRY_ID | °è´Ü½Ä |
F_199 | CATENTRY_ID | CATENTREL | CATENTRY_ID_PARENT | °è´Ü½Ä |
F_200 | CATENTRY_ID | CATENTREL | CATENTRY_ID_CHILD | °è´Ü½Ä |
F_205 | CATENTRY_ID | CATENTSHIP | CATENTRY_ID | °è´Ü½Ä |
F_214 | CATENTRY_ID | CATGPENREL | CATENTRY_ID | °è´Ü½Ä |
F_274 | CATENTRY_ID | CPPMNPROD | CATENTRY_ID | °è´Ü½Ä |
F_303 | CATENTRY_ID | DISPENTREL | CATENTRY_ID | °è´Ü½Ä |
F_378 | CATENTRY_ID | ICTPRICES | CATENTRY_ID | °è´Ü½Ä |
F_382 | CATENTRY_ID | IITEM | CATENTRY_ID | °è´Ü½Ä |
F_395 | CATENTRY_ID | INVENTORY | CATENTRY_ID | °è´Ü½Ä |
F_419 | CATENTRY_ID | LISTPRICE | CATENTRY_ID | °è´Ü½Ä |
F_431 | CATENTRY_ID | MASSOCCECE | CATENTRY_ID_FROM | °è´Ü½Ä |
F_432 | CATENTRY_ID | MASSOCCECE | CATENTRY_ID_TO | °è´Ü½Ä |
F_468 | CATENTRY_ID | OFFER | CATENTRY_ID | °è´Ü½Ä |
F_475 | CATENTRY_ID | OICOMPLIST | CATENTRY_ID | °è´Ü½Ä |
F_505 | CATENTRY_ID | ORDERITEMS | CATENTRY_ID | °è´Ü½Ä |
F_568 | CATENTRY_ID | PATTRPROD | CATENTRY_ID | °è´Ü½Ä |
F_588 | CATENTRY_ID | PKGATTR | CATENTRY_ID | °è´Ü½Ä |
F_592 | CATENTRY_ID | PKGATTRVAL | CATENTRY_ID | °è´Ü½Ä |
F_594 | CATENTRY_ID | PKGITEMREL | CATENTRY_ID_ITEM | °è´Ü½Ä |
F_595 | CATENTRY_ID | PKGITEMREL | CATENTRY_ID_PKG | °è´Ü½Ä |
F_596 | CATENTRY_ID | PKGITEMREL | CATENTRY_ID_PARENT | °è´Ü½Ä |
F_629 | CATENTRY_ID | PRSETCEREL | CATENTRY_ID | °è´Ü½Ä |
F_630 | CATENTRY_ID | PURCHASELT | CATENTRY_ID | °è´Ü½Ä |
F_681 | CATENTRY_ID | RFQPROD | CATENTRY_ID | °è´Ü½Ä |
F_686 | CATENTRY_ID | RFQRSPPROD | CATENTRY_ID | °è´Ü½Ä |
F_69 | CATENTRY_ID | ATTRIBUTE | CATENTRY_ID | °è´Ü½Ä |
F_708 | CATENTRY_ID | RMAITEM | CATENTRY_ID | °è´Ü½Ä |
F_714 | CATENTRY_ID | RMAITEMCMP | CATENTRY_ID | °è´Ü½Ä |
F_74 | CATENTRY_ID | ATTRVALUE | CATENTRY_ID | °è´Ü½Ä |
F_781 | CATENTRY_ID | STORECENT | CATENTRY_ID | °è´Ü½Ä |
F_83 | CATENTRY_ID | AUCTION | CATENTRY_ID | °è´Ü½Ä |
F_938 | CATENTRY_ID | USRTRAFFIC | CATENTRY_ID | °è´Ü½Ä |