Å×ÀÌºí ¼³¸í:
ÀÌ Å×À̺íÀÇ °¢ Çà¿¡´Â CatalogEntryº°·Î Ç¥½ÃµÈ »óǰÀÌ ÆÐŰÁöµÇ´Â ¹æ¹ý¿¡ ´ëÇÑ Á¤º¸°¡ µé¾î ÀÖ½À´Ï´Ù. Á¤º¸´Â °¡°Ý, ÇÒÀÎ, ¿î¼Û °æºñ ¹× ¼¼±ÝÀ» °áÁ¤ÇÏ´Â µ¥ »ç¿ëµË´Ï´Ù.
¿ ¼³¸í:
¿ À̸§ | ¿ À¯Çü | ¿ ¼³¸í |
CATENTRY_ID |
BIGINT
NOT NULL |
CatalogEntry. |
HEIGHT |
DOUBLE
NULL |
»óǰ¿¡ ¿¬°üµÈ ¸í¸ñ»ó ³ôÀÌ. |
LENGTH |
DOUBLE
NULL |
»óǰ¿¡ ¿¬°üµÈ ¸í¸ñ»ó ±æÀÌ. |
NOMINALQUANTITY |
DOUBLE
NOT NULL, DEFAULT 1.0 |
»óǰÀÇ ¸í¸ñ»ó ¼ö·®À¸·Î, °¡°Ý Ã¥Á¤¿¡ »ç¿ëµË´Ï´Ù. Áï, »óǰ °¡°ÝÀÌ "1.000¿ø¿¡ 3°³"·Î °áÁ¤µÇ¸é, »óǰÀÇ ¸í¸ñ»ó ¼ö·®Àº 3ÀÌ¸ç »óǰÀÇ °¡°ÝÀº 1.000¿øÀÔ´Ï´Ù. |
QUANTITYMEASURE |
CHARACTER (16)
NOT NULL, DEFAULT 'C62' |
NOMINALQUANTITY ¹× QUANTITYMULTIPLEÀÇ ÃøÁ¤ ´ÜÀ§ |
QUANTITYMULTIPLE |
DOUBLE
NOT NULL, DEFAULT 1.0 |
»óǰÀº ÀÌ ¼ö·®ÀÇ ¹è¼ö·Î ÆÇ¸ÅµÉ ¼ö ÀÖ½À´Ï´Ù. |
SIZEMEASURE |
CHARACTER (16)
NULL |
±æÀÌ, Æø, ³ôÀÌ ÃøÁ¤ ´ÜÀ§. |
WEIGHT |
DOUBLE
NULL |
»óǰ¿¡ ¿¬°üµÈ ¸í¸ñ»ó Áß·®. |
WEIGHTMEASURE |
CHARACTER (16)
NULL |
Áß·® ÃøÁ¤ ´ÜÀ§. |
WIDTH |
DOUBLE
NULL |
»óǰ¿¡ ¿¬°üµÈ ¸í¸ñ»ó Æø. |
»öÀÎ:
»öÀÎ À̸§ | »öÀÎµÈ ¿ À̸§ | »öÀÎ À¯Çü |
SQL020206020603000 | CATENTRY_ID | 1Â÷ Ű |
Á¦ÇÑ»çÇ×:
Á¦ÇÑÀÚ À̸§ | ¿ À̸§ | Foreign Å×À̺í À̸§ | Foreign ¿ À̸§ | Á¦ÇÑÀÚ À¯Çü |
F_205 | CATENTRY_ID | CATENTRY | CATENTRY_ID | °è´Ü½Ä |
F_206 | QUANTITYMEASURE | QTYUNIT | QTYUNIT_ID | °è´Ü½Ä |
F_207 | SIZEMEASURE | QTYUNIT | QTYUNIT_ID | °è´Ü½Ä |
F_208 | WEIGHTMEASURE | QTYUNIT | QTYUNIT_ID | °è´Ü½Ä |
ÂüÁ¶:
Á¦ÇÑÀÚ À̸§ | ÂüÁ¶µÈ ¿ À̸§ | Foreign Å×À̺í À̸§ | Foreign ¿ À̸§ | Á¦ÇÑÀÚ À¯Çü |
![]() |