mysql数据库网上书店实训报告_mysql 网上书店系统数据库

create database bookStore;

use bookStore;

create table book(

bookid int auto_increment not null,

catalogid int not null,

bookname varchar(20) not null,

price int not null,

picture varchar(30) not null,

primary key(bookid)

);

create table catalog(

catalogid int auto_increment not null,

catalogname varchar(20) not null,

primary key(catalogid)

);

create table orderitem(

orderitemid int auto_increment not null,

bookid int not null,

orderid int not null,

quantity int not null,

primary key(orderitemid)

);

create table orders(

orderid int auto_increment not null,

userid int not null,

orderdate timestamp not null,

primary key (orderid)

);

create table user(

userid int auto_increment not null,

username varchar(20) not null,

password varchar(20) not null,

sex varchar(4),

age int,

primary key(userid)

);

alter table book add constraint FK_Relationship_3 foreign key(catalogid)

references catalog(catalogid) on delete restrict on update restrict;

alter table orderitem add constraint FK_Relationship_2 foreign key (orderid)

references orders(orderid) on delete restrict on update restrict;

alter table orderitem add constraint FK_Relationship_4 foreign key (bookid)

references book(bookid) on delete restrict on update restrict;

alter table orders add constraint FK_Relationship_1 foreign key (userid)

references user(userid) on delete restrict on update restrict;

  • 3
    点赞
  • 15
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值