淘宝商城数据库实训
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
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