创建表 

create table Taobaoinfo
(
Id int primary key not null identity (1,1),
Tkspecialcampaignidratemap_name    varchar(25),
Tkspecialcampaignidratemap_value    float,
Eventcreatorid    bigint,
Rootcatid    bigint,
Leafcatid    bigint,
Debuginfo    varchar(255),
Rootcatscore    bigint,
Sellerid    nchar(10),
usertype    nchar(10),
shoptitle    nchar(10),
picturl    nchar(10),
shoptitle VARCHAR (20),
picturl VARCHAR (20) ,
title VARCHAR (20) ,
auctionid VARCHAR (20) ,
couponactivityid VARCHAR (20) ,
reserveprice VARCHAR (20) ,
dayleft VARCHAR (20) ,
tk3rdrate VARCHAR (20) ,
zkprice VARCHAR (20) ,
tkrate VARCHAR (20) ,
tkcommfee VARCHAR (20) ,
nick VARCHAR (20) ,
biz30day VARCHAR (20) ,
rlrate VARCHAR (20) ,
totalnum VARCHAR (20) ,
totalfee VARCHAR (20) ,
sameitempid VARCHAR (20) ,
hasrecommended VARCHAR (20) ,
hassame VARCHAR (20) ,
coupontotalcount VARCHAR (20) ,
couponleftcount VARCHAR (20) ,
auctionurl VARCHAR (20) ,
couponlink VARCHAR (20) ,
couponlinktaotoken VARCHAR (20) ,
includedxjh VARCHAR (20) ,
auctiontag VARCHAR (20) ,
couponstartfee VARCHAR (20) ,
couponamount VARCHAR (20) ,
couponeffectivestarttime VARCHAR (20) ,
couponeffectiveendtime VARCHAR (20) ,
hasumpbonus VARCHAR (20) ,
umpbonus VARCHAR (20) ,
isbizactivity VARCHAR (20) ,
eventrate VARCHAR (20) ,
couponshortlink VARCHAR (20) ,
couponinfo VARCHAR (20) ,
rootcategoryname VARCHAR (20) ,
couponorilink VARCHAR (20) ,
usertypename VARCHAR (20) 
)

 

posted on 2017-01-19 23:17  HOT SUMMER  阅读(171)  评论(0)  编辑  收藏  举报

导航