µ¥ÀÌÅͺ£À̽º ºä: AUCTBIDVW

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

¿­ À̸§ ¿­ À¯Çü ¿­ ¼³¸í
ADMIN_ID BIGINT
NULL
AUCTVIEW Å×ÀÌºí¿¡¼­
AUCT_ID BIGINT
NOT NULL
AUCTVIEW Å×ÀÌºí¿¡¼­
AUQUANT DOUBLE
NOT NULL
AUCTVIEW Å×ÀÌºí¿¡¼­
AUREFCODE CHARACTER (36)
NOT NULL
AUCTVIEW Å×ÀÌºí¿¡¼­
AUSTATUS CHARACTER (4)
NOT NULL
AUCTVIEW Å×ÀÌºí¿¡¼­
AUTOBID_ID BIGINT
NULL
BID Å×ÀÌºí¿¡¼­
AUTYPE CHARACTER (4)
NOT NULL
AUCTVIEW Å×ÀÌºí¿¡¼­
BESTBID_ID BIGINT
NULL
AUCTVIEW Å×ÀÌºí¿¡¼­
BIDMSG VARCHAR (254)
NULL
BID Å×ÀÌºí¿¡¼­
BIDPRICE DECIMAL(20,5)
NOT NULL
BID Å×ÀÌºí¿¡¼­
BIDQUANT DOUBLE
NOT NULL
BID Å×ÀÌºí¿¡¼­
BIDROOT BIGINT
NULL
BID Å×ÀÌºí¿¡¼­
BIDSTATUS CHARACTER (4)
NOT NULL
BID Å×ÀÌºí¿¡¼­
BIDTIME TIMESTAMP
NOT NULL
BID Å×ÀÌºí¿¡¼­
BID_ID BIGINT
NOT NULL
BID Å×ÀÌºí¿¡¼­
BKNAME VARCHAR (254)
NULL
BID Å×ÀÌºí¿¡¼­
CLOSEPR CHARACTER (4)
NULL
AUCTVIEW Å×ÀÌºí¿¡¼­
CLOSETYPE INTEGER
NULL
AUCTVIEW Å×ÀÌºí¿¡¼­
CURRENCY CHARACTER (4)
NULL
AUCTVIEW Å×ÀÌºí¿¡¼­
CURRPRICE DECIMAL(20,5)
NULL
AUCTVIEW Å×ÀÌºí¿¡¼­
CURRQUANT DOUBLE
NULL
AUCTVIEW Å×ÀÌºí¿¡¼­
DEPOSIT DECIMAL(20,5)
NULL
AUCTVIEW Å×ÀÌºí¿¡¼­
DEVICE VARCHAR (64)
NOT NULL
BID Å×ÀÌºí¿¡¼­
DURATION TIMESTAMP
NULL
AUCTVIEW Å×ÀÌºí¿¡¼­
ENCRYPT INTEGER
NOT NULL
BID Å×ÀÌºí¿¡¼­
ENDTIME TIMESTAMP
NULL
AUCTVIEW Å×ÀÌºí¿¡¼­
EXPDATE TIMESTAMP
NOT NULL
BID Å×ÀÌºí¿¡¼­
FIELD1 BIGINT
NULL
AUCTVIEW Å×ÀÌºí¿¡¼­
FIELD2 DECIMAL(20,5)
NULL
AUCTVIEW Å×ÀÌºí¿¡¼­
FIELD3 VARCHAR (254)
NULL
AUCTVIEW Å×ÀÌºí¿¡¼­
HIGHBID_ID BIGINT
NULL
AUCTVIEW Å×ÀÌºí¿¡¼­
ITEMPAGE VARCHAR (254)
NULL
AUCTVIEW Å×ÀÌºí¿¡¼­
LASTBKTIME TIMESTAMP
NULL
AUCTVIEW Å×ÀÌºí¿¡¼­
LOCKFLAG INTEGER
NULL
AUCTVIEW Å×ÀÌºí¿¡¼­
OPENPRICE DECIMAL(20,5)
NULL
AUCTVIEW Å×ÀÌºí¿¡¼­
OWNER_ID BIGINT
NOT NULL
AUCTVIEW Å×ÀÌºí¿¡¼­
PAYMETHODS CHARACTER (254)
NULL
AUCTVIEW Å×ÀÌºí¿¡¼­
PAYTYPE CHARACTER (64)
NOT NULL
BID Å×ÀÌºí¿¡¼­
PRECEDENCE INTEGER
NULL
AUCTVIEW Å×ÀÌºí¿¡¼­
QUANTSCALE INTEGER
NULL
AUCTVIEW Å×ÀÌºí¿¡¼­
REALENDTIME TIMESTAMP
NULL
AUCTVIEW Å×ÀÌºí¿¡¼­
REFCODE CHARACTER (36)
NOT NULL
AUCTVIEW Å×ÀÌºí¿¡¼­
RESRVPRICE DECIMAL(20,5)
NULL
AUCTVIEW Å×ÀÌºí¿¡¼­
RULEPAGE VARCHAR (254)
NULL
AUCTVIEW Å×ÀÌºí¿¡¼­
SHIPMODE INTEGER
NULL
BID Å×ÀÌºí¿¡¼­
SHIPTO_ID BIGINT
NULL
BID Å×ÀÌºí¿¡¼­
STARTTIME TIMESTAMP
NULL
AUCTVIEW Å×ÀÌºí¿¡¼­
STORE_ID INTEGER
NULL
BID Å×ÀÌºí¿¡¼­
SUPPLIER_ID BIGINT
NULL
AUCTVIEW Å×ÀÌºí¿¡¼­
UPDATETIME TIMESTAMP
NULL
AUCTVIEW Å×ÀÌºí¿¡¼­
WINOPT CHARACTER (4)
NOT NULL
BID Å×ÀÌºí¿¡¼­
WINPRICE DECIMAL(20,5)
NULL
BID Å×ÀÌºí¿¡¼­
WINQUANT DOUBLE
NULL
BID Å×ÀÌºí¿¡¼­
»öÀÎ:
»öÀÎ À̸§ »öÀÎÈ­µÈ ¿­ À̸§ »öÀÎ À¯Çü
Àû¿ëµÇÁö ¾ÊÀ½
Á¦ÇÑÁ¶°Ç:
Á¦ÇÑÁ¶°Ç ¿­ À̸§ ¿ÜºÎ Å×À̺í À̸§ ¿ÜºÎ ¿­ À̸§ Á¦ÇÑÁ¶°Ç À¯Çü
Àû¿ëµÇÁö ¾ÊÀ½

´ÙÀ½¿¡ ÀÇÇØ ÂüÁ¶:
Á¦ÇÑÁ¶°Ç ÂüÁ¶µÇ´Â ¿­ À̸§ ¿ÜºÎ Å×À̺í À̸§ ¿ÜºÎ ¿­ À̸§ Á¦ÇÑÁ¶°Ç À¯Çü
Àû¿ëµÇÁö ¾ÊÀ½