º¸±â ¼³¸í:
ÀÌ º¸±â´Â 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 ¿ À̸§ | Á¦ÇÑÀÚ À¯Çü |
![]() |