网上书城数据库设计

1、1.用户表(users)：字段名类型备注uidint(ll)主键uloginidvarchar(20)用户登录名upwdvarchar(40)用户密码unamevarchar(loo)用户真实姓名uphonevarchar( 100)用户电话uaddressvarchar( 100)用户住址umailvarchar(loo)用户邮箱uregistertimevarchar(loo)用户注册时间ulastlogintimevarchar(loo)最后一次登录时间upicturevarchar(200)用户头像otherlvarchar(loo)备用1other2int(ll)备用2other3i

2、nt(ll)备用32.订单表(orders)：字段名类型备注oidvarcahr( 100)主键otimevarchar( 100)产生订单的时间ouidint(ll)下订单用户oreceivevarchar(200)收单人oaddressvarchar( 1000)收单地址ophonevarchar(loo)收单人电话opricevarchar(loo)总金额opaymethodvarchar(20)支付方式opaybankvarchar(20)银行ostateint(ll)处理状态(0未处理1- 已处理)3.评论表(commen ts):字段名类型备注cidint(ll)主键cconten

3、tsvarchar(400)评论内容ctimevarchar(loo)评论吋间cstarvarchar( 100)评论级别(星星)cbidint(ll)书的idcuidint(ll)用户idotherlvarchar(200)备用1other2int(ll)备用2/*创建表评论引create table comments(cid int(11) autojncrement primary key, ccontents varchar(400) not null, ctime varchar(ioo) not null, cstarvarchar(loo),cbid int(11)not nul

4、l,cuid int(ll) not null,other 1 varchar(200),other2 int(11)4.书店表(bookshop)：字段名类型备注bsidint(ll)主键bloginidvarchar(20)登录账号bpwdvarchar(40)登录密码bnamevarchar(loo)书店名称baddressvarchar( 100)书店地址bphonevarchar(loo)联系电话bmailvarchar(loo)书店emailbbusinesstimevarchar(loo)书店经营时间blawmanvarchar(loo)法人代表other 1int(ll)备用1

5、other2varcahr(loo)备用2other3varchar(loo)备用35.书信息表(books):字段名类型备注bidint(ll)主键bnamevarchar( 100)书名bpricevarchar(50)价格bauthorvarchar(50)作者bdiscountfloat折扣bdiscriptionvarchar(400)说明bimgvarchar(200)照片路径bcategoryint(ll)书类别bbsidint(ll)书店主键other1int( 11)备用1other2varchar(20)备用26.订单详细表(orderbooks)字段名类型备注obidva

6、rcahr(loo)主键bidint(ll)书idonumint(ll)数量oidvarcahr( 100)订单idobstateint(ll)处理状态（0未处理1 已处理）obpayint(ll)支付状态（0未支付1 已支付）严*创建表订单详情*/create table orderbooks(obid varchar(ioo) primary key, bidint(ll)not null, onum int(ll) default * 1 oid varchar(ioo) not null, obstate int(11) default 0； obpay int(ll) default

7、 o)sql语句：create database bookshop;/*创建表用户引create table users(uid int( 11) auto .increment primary key, uloginid varchar(20) not null, upwd varchar(40) not null, uname varchar(ioo) not null, uphone varchar(ioo) not null, uaddress varchar(ioo) not null, umail varchar(ioo), uregistertime varchar(ioo),

8、ulastlogintime varchar(ioo), upicture varchar(200), other 1 varchar(ioo),other2 int(ll), other3 int(ll)/*创建表一订单勺create table orders(oid varchar(ioo) primary key, otime varchar(ioo) not null, ouid int(ll) not null, oreceive varchar(200), oaddress varchar(iooo) not null, ophone varchar(ioo) not null,

9、oprice varchar(ioo) not null, opaymethod varchar(20) not null, opaybank varchar(20) not null, ostate int(ll) default '01)严*创建表书店勺create table bookshop(bsid int( 11) autojncrement primary key, bloginid varchar(20) not null, bpwd varchar(20) not null, bname varchar(ioo) not null, baddress varchar(

10、ioo) not null, bphone varchar(ioo) not null, bmail varchar(ioo),bbusinesstime varchar(ioo), blawman varchar(ioo), other 1 int(11),other2 varchar(ioo), other3 varchar(ioo)/*创建书信息表勺create table books(bid int( 11) autojncrement primary key, bname varchar(ioo) not null, bprice varchar(50) not null, bauthor varchar(50) not null, bdiscount float default t, bdiscription varchar(400) defaulth, bimg varchar(200) not null, bcategory int(11),bbsid int(ll) not null,other 1 int( 11), other2 varchar(20)7.书籍分类表(category)字段类型备注cidint(ll