Å×ÀÌºí ¼³¸í:
ÀÌ Å×À̺íÀÇ ÇàÀº CalculationCode°¡ ÁöÁ¤µÈ »óÁ¡ ¹× TradingAgreement(¶Ç´Â ¸ðµç TradingAgreements)¿¡ ´ëÇÑ CatalogEntry ¹× PRODUCT_ITEM ÇÏÀ§(¶Ç´Â ¸ðµç CatalogEntries)¿¡ Ãß°¡µÊÀ» ³ªÅ¸³À´Ï´Ù.
¿ ¼³¸í:
¿ À̸§ | ¿ À¯Çü | ¿ ¼³¸í |
CALCODE_ID |
INTEGER
NOT NULL |
CalculationCode. |
CATENCALCD_ID |
BIGINT
NOT NULL |
»ý¼ºµÈ °íÀ¯ Ű |
CATENTRY_ID |
BIGINT
NULL |
CatalogEntry. ³Î(Null)°ªÀº ¸ðµç CatalogEntries¸¦ ÀǹÌÇÕ´Ï´Ù. CATRELTYPE_ID°¡ "PRODUCT_ITEM"ÀÎ CATENTREL Å×ÀÌºí¿¡ CatalogEntryÀÇ ÇÏÀ§°¡ ÀÖÀ¸¸é, CalculationCode°¡ ÇØ´ç ÇÏÀ§¿¡ Ãß°¡µË´Ï´Ù. |
STORE_ID |
INTEGER
NOT NULL |
»óÁ¡. |
TRADING_ID |
BIGINT
NULL |
TradingAgreement. ³Î(Null)°ªÀº ¸ðµç TradingAgreements¸¦ ÀǹÌÇÕ´Ï´Ù. |
»öÀÎ:
»öÀÎ À̸§ | »öÀÎµÈ ¿ À̸§ | »öÀÎ À¯Çü |
I0000062 | STORE_ID, CATENTRY_ID, CALCODE_ID, TRADING_ID | °íÀ¯ »öÀÎ |
SQL020206020601200 | CATENCALCD_ID | 1Â÷ Ű |
Á¦ÇÑ»çÇ×:
Á¦ÇÑÀÚ À̸§ | ¿ À̸§ | Foreign Å×À̺í À̸§ | Foreign ¿ À̸§ | Á¦ÇÑÀÚ À¯Çü |
F_190 | TRADING_ID | TRADING | TRADING_ID | °è´Ü½Ä |
F_191 | STORE_ID | STORE | STORE_ID | °è´Ü½Ä |
F_192 | CATENTRY_ID | CATENTRY | CATENTRY_ID | °è´Ü½Ä |
F_193 | CALCODE_ID | CALCODE | CALCODE_ID | °è´Ü½Ä |
ÂüÁ¶:
Á¦ÇÑÀÚ À̸§ | ÂüÁ¶µÈ ¿ À̸§ | Foreign Å×À̺í À̸§ | Foreign ¿ À̸§ | Á¦ÇÑÀÚ À¯Çü |
![]() |