书店管理系统（jap+sqlServer）

create table book(isbn varchar(20), name varchar(20), title varchar(20), price numeric(5,2), pubdate numeric(4), description varchar(50), saleAmount numeric(6), img varchar(20), category1 varchar(20), primary key(isbn)); create table customer(cid varchar(20) NOT NULL, cpasswd varchar(20) NOT NULL, cname varchar(10) NOT NULL, addr varchar(50) NOT NULL, tel varchar(13) NOT NULL, email varchar(20) NOT NULL, rank int not null, PRIMARY KEY(cid)); create table employee(eid varchar(20) NOT NULL, ename varchar(20) NOT Null, epasswd varchar(20) NOT NULL, rank int NOT NULL,--1为管理员，0为店员 PRIMARY KEY(eid)); create table orders(oid varchar(20) not null, odate varchar(20) not null, total float not null, ostate int not null, customer varchar(20) references customer(cid), PRIMARY KEY(oid)) ; create table item( isbn varchar(20) not null references book(isbn), quantity int, cid varchar(20) NOT NULL references customer(cid), oid varchar(20) NOT NULL references orders(oid), );