---如何编写订单---

--1.订单表--管理员操作后台

--2.订单详情--顾客操作

----------------------------------------------------------------

create table userinfo

(

id int identity(1,1) primary key,

username varchar(500),

password varchar(500),

email varchar(500),

phone varchar(500),

address varchar(500)

)

------------------

----------------

create table book

(

id int identity(1,1) primary key,

bookname varchar(200),

price decimal(12,0),

isbn varchar(200),

image varchar(200),

info varchar(200),

stock int,

count int,

)

------------

-------

create table cartitem

(

uid int not null ,

bid int not null,

count int,

bookname varchar(200),

price decimal(12,0),

image varchar(200),

primary key(uid,bid)

)

select * from book

--------------------------

create table orders

(

id int identity(1,1) primary key,

userid int foreign key references userinfo(id),

createtime datetime default(getdate()),

total decimal(12,2),

shipaddress varchar(200),

contactphone varchar(200),

status varchar(200),

)

create table orderdetails

(

id int identity(1,1) primary key,

oid int foreign key references orders(id),

bid int foreign key references orders(id),

amount int,

tranprice decimal(12,2),

)