代码拉取完成,页面将自动刷新
同步操作将从 刘伟/SSMBookSystem 强制同步,此操作会覆盖自 Fork 仓库以来所做的任何修改,且无法恢复!!!
确定后同步将在后台操作,完成时将刷新页面,请耐心等待。
图书分类表
CREATE TABLE tb_category (
id int(10),
manager_id int(10),
catName varchar(50),
parent_id int(10),
is_parent int(1) UNSIGNED ,
createDate bigint(30),
PRIMARY KEY (id) USING BTREE,
INDEX mid ( manager_id ) USING BTREE,
INDEX parent_id (parent_id) USING BTREE,
CONSTRAINT mid FOREIGN KEY (manager_id) REFERENCES tb_manager (id)
);
图书信息表
CREATE TABLE tb_library (
id int(10),
cate_id int(10),
manager_id int(10),
bookName varchar(255),
description varchar(255),
author varchar(50),
press varchar(255),
img varchar(255),
price float(10, 2),
publishDate bigint(30),
createDate bigint(30) ,
bookNum int(11),
barcode varchar(255) ,
PRIMARY KEY (id) ,
INDEX cate_id(cate_id) USING BTREE,
INDEX manager_id (manager_id) USING BTREE,
CONSTRAINT tb_library_ibfk_1 FOREIGN KEY (cate_id) REFERENCES tb_category (id) ,
CONSTRAINT tb_library_ibfk_2 FOREIGN KEY (manager_id) REFERENCES tb_manager (id)
) ;
图书评论回复表
CREATE TABLE tb_reply (
id int(11),
comment_id int(11) ,
content CHARACTER ,
replyDate bigint(30) ,
PRIMARY KEY (id) USING BTREE,
INDEX comment_id (comment_id) USING BTREE,
CONSTRAINT tb_reply_ibfk_1 FOREIGN KEY (comment_id) REFERENCES tb_comment (id)
) ;
图书评论表
CREATE TABLE tb_comment (
id int(11) NOT NULL AUTO_INCREMENT,
user_id int(11) NULL DEFAULT NULL,
book_id int(11) NOT NULL ,
content text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
commentDate bigint(30) NOT NULL ,
top int(11) UNSIGNED ZEROFILL NULL DEFAULT NULL,
PRIMARY KEY (id) USING BTREE,
INDEX user_id (user_id) USING BTREE,
INDEX book_id (book_id) USING BTREE
);
管理员表
CREATE TABLE tb_manager (
id int(10) NOT NULL AUTO_INCREMENT,
managerName varchar(30),
password varchar(32),
PRIMARY KEY ( id ) USING BTREE
);
图书预定表
CREATE TABLE tb_order (
id int(10),
user_id int(10),
book_id int(10),
orderDate bigint(30),
deadline bigint(11),
PRIMARY KEY (id) USING BTREE,
INDEX user_id (user_id) USING BTREE,
INDEX book_id (book_id) USING BTREE
);
图书借阅表
CREATE TABLE tb_record (
id int(10),
user_id int(10),
book_id int(10),
recordDate bigint(30),
backDate bigint(30),
returnbook int(1),
ticketFfee float NULL DEFAULT NULL,
PRIMARY KEY (id) USING BTREE,
INDEX user_id (user_id) USING BTREE,
INDEX book_id (book_id) USING BTREE
) ;
学生用户表
CREATE TABLE tb_user (
id int(10),
userName varchar(30),
password varchar(32),
registerDate bigint(30) ,
afterdate bigint(30) ,
realName varchar(30),
age int(11) ,
sex char(1) ,
telNum varchar(13),
email varchar(50),
idcard varchar(18),
headimg varchar(255) ,
isOnline int(1),
grade varchar(255) ,
PRIMARY KEY (id)
);
此处可能存在不合适展示的内容,页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容,可点击提交进行申诉,我们将尽快为您处理。