º¸±â ¼³¸í:
ÀÌ º¸±â´Â 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 Å×ÀÌºí¿¡¼ |
BID_ID |
BIGINT
NOT NULL |
BID Å×ÀÌºí¿¡¼ |
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 Å×ÀÌºí¿¡¼ |
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 Å×ÀÌºí¿¡¼ |
»öÀÎ:
»öÀÎ À̸§ | »öÀÎµÈ ¿ À̸§ | »öÀÎ À¯Çü |
|
Á¦ÇÑ»çÇ×:
Á¦ÇÑÀÚ À̸§ | ¿ À̸§ | Foreign Å×À̺í À̸§ | Foreign ¿ À̸§ | Á¦ÇÑÀÚ À¯Çü |
ÂüÁ¶:
Á¦ÇÑÀÚ À̸§ | ÂüÁ¶µÈ ¿ À̸§ | Foreign Å×À̺í À̸§ | Foreign ¿ À̸§ | Á¦ÇÑÀÚ À¯Çü |
![]() |