Field Type Extra
cataloguename varchar(20)
catalogueparent int
parentid int Allow Null
Index Fields Extra PK__catalogu__FDB2087CE8600F55 catalogueid Unique
Field Type Extra
P commentid int Auto Increment
userid int
username varchar(16)
statnum char(1)
commentcontent varchar(300)
orderid int
goodid int
imgs text Allow Null
status char(1)
Index Fields Extra
PK__comment__CDA84BC5F6BACA7B commentid Unique
Field Type Extra
P districtid int Auto Increment
parent_id varchar(1) Allow Null
districtname varchar(20) Allow Null
zipcode char(6) Allow Null
Index Fields Extra PK__district__2BD06FC8620DD611 districtid Unique
Field Type Extra
username varchar(16)
userpassword varchar(100) Allow Null
userphone varchar(16) Allow Null
userregdate datetime
shopid int Allow Null
idcard varchar(18) Allow Null
userrealname varchar(10) Allow Null
email varchar(20)
gender char(4)
birth datetime
psdquestion varchar(50) Allow Null
psdanser varchar(50) Allow Null
balance int Allow Null
Index Fields Extra
PK__eshopuse__CBA1B257CFF1F496 userid Unique
UQ__eshopuse__F3DBC572987697CA username Unique
Field Type Extra
typename varchar(8)
Index Fields Extra
PK__evaluate__F0528D0293D7338A typeid Unique
expressname varchar(20)
expresscode varchar(20)
accesskey varchar(30)
link varchar(50) Allow Null
Index Fields Extra
PK__express__A6BD6311E71F424A expressid Unique
P favoriteid int
userid int Allow Null
content varchar(300)
shopid int
goodsid int
Index Fields Extra PK__favorite__87770BCDF4D589E9 favoriteid Unique
Field Type Extra
goodsname varchar(30)
goodsprice int Allow Null
goodsdescripition varchar(2000) Allow Null
goodspic varchar(30)
goodstcatalogue int
Index Fields Extra
PK__goods__1105F62A9F062F20 goodsid Unique
UQ__goods__36BC4E33BD36D36D goodsname Unique
Field Type Extra
P messageid int Auto Increment
userid int Allow Null
content varchar(300)
shopid int
evaluatetype int
toid int
goodsid int Allow Null
Index Fields Extra
Field Type Extra
P orderid int
goodsid int
userid int
goodsnumber int
ordertime datetime
orderstate varchar(10)
realprice int
messagestate varchar(10)
address varchar(100)
express int
payment int
Index Fields Extra
typename varchar(15)
byname varchar(50)
introduction varchar(100)
authkey varchar(100)
Index Fields Extra
PK__payment__082D8EEBCDA65E20 payid Unique
promoid int Auto Increment
promocode varchar(20)
promovalue int
useshopid int
Field Type Extra
P carid int
addgoodstime date
userid int Allow Null
goodsid int Allow Null
goodsnumber int
Index Fields Extra
PK__shopping__1439FCAC4DE2FB95 carid Unique
Field Type Extra
shopname varchar(30)
shopdiscribe varchar(200) Allow Null
userid int Allow Null
Index Fields Extra
PK__shops__E5C52144ED5923ED shopid Unique
Field Type Extra
P shopsid int
goodsid int Allow Null
goodsnumber int
goodssaled int
Index Fields Extra
PK__shopsand__AC09F41C2422F950 shopsid Unique
P addressid int Auto Increment
userid int Allow Null
districtid int
zipcode char(6)
address varchar(100)
Index Fields Extra PK__useraddr__26A01585F16D65CB addressid Unique。