Å×ÀÌºí ¼³¸í:
ÀÌ Å×À̺íÀÇ °¢ ÇàÀº 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 | °è´Ü½Ä |
![]() |