Å×ÀÌºí ¼³¸í:
ÀÌ Å×ÀÌºí¿¡¼´Â °æ¸Å¿¡ »ç¿ëµÇ´Â ÀÔÂû Á¦¾î ±ÔÄ¢¿¡ ´ëÇÑ Á¤º¸¸¦ Æ÷ÇÔÇϰí ÀÖ½À´Ï´Ù.
¿ ¼³¸í:
¿ À̸§ | ¿ À¯Çü | ¿ ¼³¸í |
ADMIN_ID |
BIGINT
NULL |
ÀÔÂû Á¦¾î ±ÔÄ¢À» ÀÛ¼ºÇÑ ¿î¿µÀÚ ID. |
CLASS_ID |
BIGINT
NOT NULL |
±ÔÄ¢ ÅØ½ºÆ®¸¦ ÇØ¼®ÇÏ´Â µ¥ »ç¿ëµÇ´Â ±ÔÄ¢ Ŭ·¡½ºÀÇ ID. ÀÌ´Â RULECLSREG Å×ÀÌºí¿¡ ´ëÇÑ Æ÷ÀÎÅÍÀÔ´Ï´Ù. |
FIELD1 |
BIGINT
NULL |
»ç¿ëÀÚ Á¤ÀÇ °¡´É |
FIELD2 |
DECIMAL(20,5)
NULL |
»ç¿ëÀÚ Á¤ÀÇ °¡´É |
FIELD3 |
VARCHAR (254)
NULL |
»ç¿ëÀÚ Á¤ÀÇ °¡´É |
MINQUANT |
DOUBLE
NULL |
ÀÌ °æ¸Å¿¡ Çã¿ëµÈ ÃÖ¼Ò ÀÔÂû ¼ö·®. ÃÖ¼Ò ÀÌÇÏÀÇ ¼ö·®À» °¡Áø ÀÔÂûÀº Çã¿ëµÇÁö ¾Ê½À´Ï´Ù. |
MINVALUE |
DECIMAL(20,5)
NULL |
°æ¸Å¿¡ Çã¿ëµÈ ÃÖ¼Ò°ª. ÃÖ¼Ò ÀÌÇÏÀÇ °ªÀ» °¡Áø °æ¸Å´Â Çã¿ëµÇÁö ¾Ê½À´Ï´Ù. |
OWNER_ID |
BIGINT
NOT NULL |
ÀÔÂû Á¦¾î ±ÔÄ¢ÀÇ ¼ÒÀ¯ÀÚ ID. |
RULE_ID |
BIGINT
NOT NULL |
ÀÔÂû Á¦¾î ±ÔÄ¢ ID. Å×À̺íÀÇ 1Â÷ Ű. |
RULEDESC |
VARCHAR (254)
NULL |
ÀÔÂû Á¦¾î ±ÔÄ¢ ¼³¸í. |
RULENAME |
CHARACTER (30)
NOT NULL |
ÀÔÂû Á¦¾î ±ÔÄ¢ À̸§. |
RULETEXT |
LONG VARCHAR
NULL |
±ÔÄ¢ ÅØ½ºÆ®. ÀÌ ÅØ½ºÆ®´Â ÀÔÂû ¹üÀ§ ¹× Áõ°¡ºÐÀ» Æ÷ÇÔÇÕ´Ï´Ù. RULECLSREG Å×ÀÌºí¿¡ Á¤ÀÇµÈ ±ÔÄ¢ Á¦¾î ÇØ¼®±â¿¡ ÀÇÇØ 󸮵˴ϴÙ. |
RULETYPE |
CHARACTER (4)
NOT NULL |
ÀÌ ±ÔÄ¢¿¡ ´ëÇÑ °æ¸Å À¯Çü. ¿Ã¹Ù¸¥ °ª: O=°ø°³ °æ¸Å, SB=ºñ°ø°³ ÀÔÂû, D=´õÄ¡ °æ¸Å. |
»öÀÎ:
»öÀÎ À̸§ | »öÀÎµÈ ¿ À̸§ | »öÀÎ À¯Çü |
I0000080 | RULENAME, OWNER_ID | °íÀ¯ »öÀÎ |
I0000081 | RULETYPE | °íÀ¯ÇÏÁö ¾ÊÀº »öÀÎ |
SQL020206020611800 | RULE_ID | 1Â÷ Ű |
Á¦ÇÑ»çÇ×:
Á¦ÇÑÀÚ À̸§ | ¿ À̸§ | Foreign Å×À̺í À̸§ | Foreign ¿ À̸§ | Á¦ÇÑÀÚ À¯Çü |
F_254 | CLASS_ID | RULECLSREG | RULECLASS_ID | °è´Ü½Ä |
F_255 | OWNER_ID | MEMBER | MEMBER_ID | °è´Ü½Ä |
F_256 | ADMIN_ID | MEMBER | MEMBER_ID | °è´Ü½Ä |
ÂüÁ¶:
Á¦ÇÑÀÚ À̸§ | ÂüÁ¶µÈ ¿ À̸§ | Foreign Å×À̺í À̸§ | Foreign ¿ À̸§ | Á¦ÇÑÀÚ À¯Çü |
F_81 | RULE_ID | AUCTION | BIDRULE_ID | °è´Ü½Ä |
F_94 | RULE_ID | AUCTSTYLE | RULE_ID | °è´Ü½Ä |
![]() |