µ¥ÀÌÅͺ£À̽º º¸±â: AUCTVIEW


º¸±â ¼³¸í:

ÀÌ º¸±â´Â AUCTION ¹× AUCTSTREL Å×À̺íÀ» °áÇÕÇÑ °ÍÀÔ´Ï´Ù. °áÇÕÀº AUCT_ID¸¦ ±âº»À¸·Î ÀÌ·ç¾îÁý´Ï´Ù. ¿­¿¡ ´ëÇÑ ¼³¸íÀº AUCTION ¶Ç´Â AUCTSTREL Å×À̺íÀ» ÂüÁ¶ÇϽʽÿÀ.

¿­ ¼³¸í:

¿­ À̸§ ¿­ À¯Çü ¿­ ¼³¸í
ADMIN_ID BIGINT
NULL
AUCTION Å×ÀÌºí¿¡¼­
AUCMODE CHARACTER (4)
NULL
IBM ³»ºÎ¿ëÀ¸·Î ¿¹¾à
AUCPAYINFO_ID BIGINT
NULL
IBM ³»ºÎ¿ëÀ¸·Î ¿¹¾à
AUCT_ID BIGINT
NOT NULL
AUCTION Å×ÀÌºí¿¡¼­
AUQUANT DOUBLE
NOT NULL
AUCTION Å×ÀÌºí¿¡¼­
AUSTATUS CHARACTER (4)
NOT NULL
AUCTION Å×ÀÌºí¿¡¼­
AUTYPE CHARACTER (4)
NOT NULL
AUCTION Å×ÀÌºí¿¡¼­
BESTBID_ID BIGINT
NULL
AUCTION Å×ÀÌºí¿¡¼­
BIDRULE_ID BIGINT
NULL
AUCTION Å×ÀÌºí¿¡¼­
CATENTRY_ID BIGINT
NOT NULL
AUCTION Å×ÀÌºí¿¡¼­
CLOSEPR CHARACTER (4)
NULL
AUCTION Å×ÀÌºí¿¡¼­
CLOSETYPE INTEGER
NULL
AUCTION Å×ÀÌºí¿¡¼­
CURRENCY CHARACTER (4)
NULL
AUCTION Å×ÀÌºí¿¡¼­
CURRPRICE DECIMAL(20,5)
NULL
AUCTION Å×ÀÌºí¿¡¼­
CURRQUANT DOUBLE
NULL
AUCTION Å×ÀÌºí¿¡¼­
DEPOSIT DECIMAL(20,5)
NULL
AUCTION Å×ÀÌºí¿¡¼­
DURATION TIMESTAMP
NULL
AUCTION Å×ÀÌºí¿¡¼­
DURDAYS INTEGER
NULL
AUCTION Å×ÀÌºí¿¡¼­
DURLENGTH INTEGER
NULL
IBM ³»ºÎ¿ëÀ¸·Î ¿¹¾à
ENDTIME TIMESTAMP
NULL
AUCTION Å×ÀÌºí¿¡¼­
FFMCENTER_ID INTEGER
NULL
AUCTION Å×ÀÌºí¿¡¼­
FIELD1 BIGINT
NULL
AUCTION Å×ÀÌºí¿¡¼­
FIELD2 BIGINT
NULL
AUCTION Å×ÀÌºí¿¡¼­
FIELD3 DECIMAL(20,5)
NULL
AUCTION Å×ÀÌºí¿¡¼­
FIELD4 DECIMAL(20,5)
NULL
AUCTION Å×ÀÌºí¿¡¼­
FIELD5 VARCHAR (254)
NULL
AUCTION Å×ÀÌºí¿¡¼­
FIELD6 VARCHAR (254)
NULL
AUCTION Å×ÀÌºí¿¡¼­
HIGHBID_ID BIGINT
NULL
AUCTION Å×ÀÌºí¿¡¼­
INVRSRVID BIGINT
NULL
Àç°í ¿¹¾à ID.
ITEMPAGE VARCHAR (254)
NULL
AUCTSTRREL °æ¸Å-»óÁ¡ °ü°è Å×À̺í·ÎºÎÅÍ
LASTBKTIME TIMESTAMP
NULL
AUCTION Å×ÀÌºí¿¡¼­
LOCKFLAG INTEGER
NULL
AUCTION Å×ÀÌºí¿¡¼­
MBRGRP_ID BIGINT
NULL
AUCTION Å×ÀÌºí¿¡¼­
OPENPRICE DECIMAL(20,5)
NULL
AUCTION Å×ÀÌºí¿¡¼­
OWNER_ID BIGINT
NOT NULL
AUCTION Å×ÀÌºí¿¡¼­
PAYMETHODS CHARACTER (254)
NULL
AUCTION Å×ÀÌºí¿¡¼­
PRECEDENCE INTEGER
NULL
AUCTION Å×ÀÌºí¿¡¼­
PRICELIMIT DECIMAL(20,5)
NULL
IBM ³»ºÎ¿ëÀ¸·Î ¿¹¾à
QUANTLIMIT DOUBLE
NULL
IBM ³»ºÎ¿ëÀ¸·Î ¿¹¾à
QUANTSCALE INTEGER
NULL
AUCTION Å×ÀÌºí¿¡¼­
REALENDTIME TIMESTAMP
NULL
AUCTION Å×ÀÌºí¿¡¼­
REFCODE CHARACTER (36)
NOT NULL
AUCTION Å×ÀÌºí¿¡¼­
REFPRICE DECIMAL(20,5)
NULL
AUCTION Å×ÀÌºí¿¡¼­
RESRVPRICE DECIMAL(20,5)
NULL
AUCTION Å×ÀÌºí¿¡¼­
RETRACT_BID INTEGER
NULL
AUCTION Å×ÀÌºí¿¡¼­
RULEPAGE VARCHAR (254)
NULL
AUCTION Å×ÀÌºí¿¡¼­
STARTTIME TIMESTAMP
NULL
AUCTION Å×ÀÌºí¿¡¼­
STATE INTEGER
NULL
AUCTION Å×ÀÌºí¿¡¼­
STORE_ID INTEGER
NOT NULL
AUCTSTRREL °æ¸Å-»óÁ¡ °ü°è Å×À̺í·ÎºÎÅÍ
SUPPLIER_ID BIGINT
NULL
AUCTION Å×ÀÌºí¿¡¼­
UPDATETIME TIMESTAMP
NULL
AUCTION Å×ÀÌºí¿¡¼­

»öÀÎ:

»öÀÎ À̸§ »öÀÎµÈ ¿­ À̸§ »öÀÎ À¯Çü
¾øÀ½

Á¦ÇÑ»çÇ×:

Á¦ÇÑÀÚ À̸§ ¿­ À̸§ Foreign Å×À̺í À̸§ Foreign ¿­ À̸§ Á¦ÇÑÀÚ À¯Çü
¾øÀ½


ÂüÁ¶:

Á¦ÇÑÀÚ À̸§ ÂüÁ¶µÈ ¿­ À̸§ Foreign Å×À̺í À̸§ Foreign ¿­ À̸§ Á¦ÇÑÀÚ À¯Çü
¾øÀ½
IBM copyright