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


Å×ÀÌºí ¼³¸í:

ÀÌ Å×ÀÌºí¿¡¼­´Â °æ¸Å¿¡ »ç¿ëµÇ´Â ÀÔÂû Á¦¾î ±ÔÄ¢¿¡ ´ëÇÑ Á¤º¸¸¦ Æ÷ÇÔÇϰí ÀÖ½À´Ï´Ù.

¿­ ¼³¸í:

¿­ À̸§ ¿­ À¯Çü ¿­ ¼³¸í
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 °è´Ü½Ä
IBM copyright