µ¥ÀÌÅͺ£À̽º Å×À̺í: TAXCGRY


Å×ÀÌºí ¼³¸í:

ÀÌ Å×À̺íÀÇ °¢ ÇàÀº TaxCategory¸¦ ³ªÅ¸³À´Ï´Ù.

¿­ ¼³¸í:

¿­ À̸§ ¿­ À¯Çü ¿­ ¼³¸í
CALCULATIONSEQ DOUBLE
NOT NULL, DEFAULT 0
¼¼±ÝÀº CALCULATIONSEQÀÇ ¿À¸§Â÷¼øÀ¸·Î °è»êµË´Ï´Ù.
DISPLAYSEQ DOUBLE
NOT NULL, DEFAULT 0
»ç¿ëÀÚ ÀÎÅÍÆäÀ̽º´Â ÀÌ Çʵ带 »ç¿ëÇÏ¿© ÁÖ¹®¿¡ Ç¥½ÃÇÒ ¼¼±ÝÀÇ ¼ø¼­¸¦ Á¦¾îÇÒ ¼ö ÀÖ½À´Ï´Ù.
DISPLAYUSAGE INTEGER
NOT NULL, DEFAULT 0
´ÙÀ½°ú °°ÀÌ PriceDataBean°ú °ü·ÃµÈ ÀÌ ¼¼±Ý Ä«Å×°í¸®¸¦ ÁöÁ¤ÇÕ´Ï´Ù.
0 = °è»êµÇÁö ¾ÊÀ½,
1 = °è»êµÊ.
PriceDataBeanÀº »óǰ °¡°Ý°ú ÇÔ²² Ç¥½ÃµÇ¾î¾ß ÇÏ´Â ¼¼±ÝÀ» ±¸ÇÏ´Â µ¥ »ç¿ëµÉ ¼ö ÀÖ½À´Ï´Ù.
FIELD1 DECIMAL(20,5)
NULL
»ç¿ëÀÚ Á¤ÀÇ °¡´É
FIELD2 DECIMAL(20,5)
NULL
»ç¿ëÀÚ Á¤ÀÇ °¡´É
FIELD3 VARCHAR (254)
NULL
»ç¿ëÀÚ Á¤ÀÇ °¡´É
MARKFORDELETE INTEGER
NOT NULL, DEFAULT 0
IBM ³»ºÎ¿ëÀ¸·Î ¿¹¾à
NAME CHARACTER (15)
NULL
StoreEntity°ú ÇÔ²² ÀÌ TaxCategory¸¦ ½Äº°ÇÏ´Â À̸§.
STOREENT_ID INTEGER
NOT NULL
TaxCategory°¡ ÀϺÎÀÎ StoreEntity.
TAXCGRY_ID INTEGER
NOT NULL
»ý¼ºµÈ 1Â÷ Ű
TAXTYPE_ID INTEGER
NOT NULL
ÀÌ ¼¼±ÝÄ«Å×°í¸®ÀÇ ¼¼±ÝÀ¯Çü.

»öÀÎ:

»öÀÎ À̸§ »öÀÎµÈ ¿­ À̸§ »öÀÎ À¯Çü
I0000244 NAME, STOREENT_ID °íÀ¯ »öÀÎ
SQL020206020806210 TAXCGRY_ID 1Â÷ Ű

Á¦ÇÑ»çÇ×:

Á¦ÇÑÀÚ À̸§ ¿­ À̸§ Foreign Å×À̺í À̸§ Foreign ¿­ À̸§ Á¦ÇÑÀÚ À¯Çü
F_816 STOREENT_ID STOREENT STOREENT_ID °è´Ü½Ä
F_817 TAXTYPE_ID TAXTYPE TAXTYPE_ID °è´Ü½Ä


ÂüÁ¶:

Á¦ÇÑÀÚ À̸§ ÂüÁ¶µÈ ¿­ À̸§ Foreign Å×À̺í À̸§ Foreign ¿­ À̸§ Á¦ÇÑÀÚ À¯Çü
F_162 TAXCGRY_ID CALCODTXEX TAXCGRY_ID °è´Ü½Ä
F_170 TAXCGRY_ID CALRULE TAXCGRY_ID °è´Ü½Ä
F_489 TAXCGRY_ID ORDADJTXEX TAXCGRY_ID °è´Ü½Ä
F_529 TAXCGRY_ID ORDITAX TAXCGRY_ID °è´Ü½Ä
F_552 TAXCGRY_ID ORDTAX TAXCGRY_ID °è´Ü½Ä
F_717 TAXCGRY_ID RMATAX TAXCGRY_ID °è´Ü½Ä
F_815 TAXCGRY_ID SUBORDTAX TAXCGRY_ID °è´Ü½Ä
F_818 TAXCGRY_ID TAXCGRYDS TAXCGRY_ID °è´Ü½Ä
IBM copyright