Å×ÀÌºí ¼³¸í:
ÀÌ ÆäÀÌÁö¿¡´Â CatalogEntries¸¦ Ç¥½ÃÇÏ´Â µ¥ »ç¿ëµÇ´Â ÆäÀÌÁö°¡ µé¾î ÀÖ½À´Ï´Ù. ¿É¼ÇÀ¸·Î´Â »óÁ¡, MemberGroup, DeviceType, CatalogEntryType, CatalogEntry, AuctionState ¶Ç´Â À̵éÀÇ Á¶ÇÕÀ» ±âº»À¸·Î ÀÌ·ç¾îÁý´Ï´Ù.
¿ ¼³¸í:
¿ À̸§ | ¿ À¯Çü | ¿ ¼³¸í |
AUCTIONSTATE |
INTEGER
NOT NULL, DEFAULT 0 |
ÀÌ ÅÛÇø®Æ® ÆäÀÌÁö¿¡ °æ¸Å ÁßÀΠīŻ·Î±× Ç׸ñÀÌ Ç¥½ÃµÊÀ» ³ªÅ¸³»´Â Ç÷¡±×. °ªÀÌ 0À̸é À̰ÍÀÌ °æ¸Å ÅÛÇø®Æ®°¡ ¾Æ´Ï¸ç °ªÀÌ 1ÀÌ¸é °æ¸Å ÅÛÇø®Æ®ÀÓÀ» ³ªÅ¸³À´Ï´Ù. |
CATENTRY_ID |
BIGINT
NOT NULL |
ÀÌ ÆäÀÌÁö À̸§À» Ç¥½ÃÇÒ CatalogEntryÀÇ ÂüÁ¶ ¹øÈ£. °ªÀÌ 0ÀÌ¸é ¸ðµç CatalogEntries¿¡ ´ëÇØ ÀÌ ÆäÀÌÁö À̸§ÀÌ »ç¿ëµÊÀ» ³ªÅ¸³À´Ï´Ù. |
CATENTTYPE_ID |
CHARACTER (16)
NOT NULL |
ÀÌ ÆäÀÌÁö¸¦ Ç¥½ÃÇÏ´Â µ¥ »ç¿ëµÉ CatalogEntry À¯Çü. CATENTTYPE Å×À̺íÀÇ foreign key. ¿¹¸¦ µé¾î, ÀÌ ¿ÀÌ "BundleBean"À¸·Î ÁöÁ¤µÇ¾î ÀÖÀ¸¸é, ÀÌ ÆäÀÌÁö´Â ¹øµéÀ» Ç¥½ÃÇÏ´Â µ¥ »ç¿ëµË´Ï´Ù. |
DESCRIPTION |
VARCHAR (254)
NULL |
ÀÌ Ç׸ñ¿¡ ´ëÇÑ ¼³¸í. |
DEVICEFMT_ID |
INTEGER
NOT NULL |
ÆäÀÌÁö¸¦ Ç¥½ÃÇÒ ÀåÄ¡ À¯ÇüÀÇ ÂüÁ¶ ¹øÈ£. DEVICEFMT Å×À̺íÀÇ foreign key. |
DISPENTREL_ID |
BIGINT
NOT NULL |
ÀÌ Ç׸ñÀÇ ÂüÁ¶ ¹øÈ£. |
FIELD1 |
VARCHAR (254)
NULL |
»ç¿ëÀÚ Á¤ÀÇ °¡´É |
FIELD2 |
VARCHAR (254)
NULL |
»ç¿ëÀÚ Á¤ÀÇ °¡´É |
LANGUAGE_ID |
INTEGER
NULL |
ÀÌ ÆäÀÌÁö°¡ Ç¥½ÃÇÏ´Â ¾ð¾î. ¾ð¾î ±¸¼º¿ä¼Ò´Â LANGUAGE Å×À̺íÀ» ÂüÁ¶ÇϽʽÿÀ. |
MBRGRP_ID |
BIGINT
NOT NULL |
ÀÌ ÅÛÇø®Æ® ÆäÀÌÁö¸¦ Ç¥½ÃÇÒ MemberGroupÀÇ ÂüÁ¶ ¹øÈ£. °ªÀÌ 0ÀÌ¸é ¸ðµç MemberGroup¿¡ ´ëÇØÀÌ ÅÛÇø®Æ® ÆäÀÌÁö°¡ Ç¥½ÃµÊÀ» ³ªÅ¸³À´Ï´Ù. |
OID |
VARCHAR (64)
NULL |
IBM ³»ºÎ¿ëÀ¸·Î ¿¹¾à |
PAGENAME |
VARCHAR (254)
NOT NULL |
Ç¥½Ã ÅÛÇø®Æ® ÆäÀÌÁöÀÇ À̸§ ¹× °æ·Î, ÀÌ °æ·Î´Â ÀÀ¿ëÇÁ·Î±×·¥ ¹®¼ ·çÆ®¿Í °ü·ÃµË´Ï´Ù. |
RANK |
DOUBLE
NULL |
Çϳª ÀÌ»óÀÇ ÆäÀÌÁö°¡ ¼±Åà ±âÁØÀ» ¸¸Á·ÇÒ ¶§ ¿¬°áÀ» ²÷´Â µ¥ »ç¿ëµÇ´Â ¼ø¼ ¹øÈ£. ¹øÈ£°¡ ÀÛÀ»¼ö·Ï, ÆäÀÌÁöÀÇ ¿ì¼±¼øÀ§°¡ Ä¿Áý´Ï´Ù. |
STOREENT_ID |
INTEGER
NOT NULL |
ÀÌ ÆäÀÌÁö¸¦ Ç¥½ÃÇÒ »óÁ¡ÀÇ ÂüÁ¶ ¹øÈ£. |
»öÀÎ:
»öÀÎ À̸§ | »öÀÎµÈ ¿ À̸§ | »öÀÎ À¯Çü |
I0000092 | DEVICEFMT_ID, STOREENT_ID, CATENTRY_ID, CATENTTYPE_ID, MBRGRP_ID, AUCTIONSTATE, RANK, LANGUAGE_ID | °íÀ¯ »öÀÎ |
I0000093 | AUCTIONSTATE, MBRGRP_ID, CATENTRY_ID, STOREENT_ID | °íÀ¯ÇÏÁö ¾ÊÀº »öÀÎ |
I0000094 | CATENTRY_ID, CATENTTYPE_ID, STOREENT_ID, MBRGRP_ID | °íÀ¯ÇÏÁö ¾ÊÀº »öÀÎ |
SQL020226020645960 | DISPENTREL_ID | 1Â÷ Ű |
Á¦ÇÑ»çÇ×:
Á¦ÇÑÀÚ À̸§ | ¿ À̸§ | Foreign Å×À̺í À̸§ | Foreign ¿ À̸§ | Á¦ÇÑÀÚ À¯Çü |
F_302 | LANGUAGE_ID | LANGUAGE | LANGUAGE_ID | °è´Ü½Ä |
F_303 | CATENTRY_ID | CATENTRY | CATENTRY_ID | °è´Ü½Ä |
F_304 | STOREENT_ID | STOREENT | STOREENT_ID | °è´Ü½Ä |
F_305 | MBRGRP_ID | MBRGRP | MBRGRP_ID | °è´Ü½Ä |
F_306 | DEVICEFMT_ID | DEVICEFMT | DEVICEFMT_ID | °è´Ü½Ä |
F_307 | CATENTTYPE_ID | CATENTTYPE | CATENTTYPE_ID | °è´Ü½Ä |
ÂüÁ¶:
Á¦ÇÑÀÚ À̸§ | ÂüÁ¶µÈ ¿ À̸§ | Foreign Å×À̺í À̸§ | Foreign ¿ À̸§ | Á¦ÇÑÀÚ À¯Çü |
![]() |