/*
Navicat Premium Data Transfer
Source Server : fangxu
Source Server Type : MySQL
Source Server Version : 50744 (5.7.44-log)
Source Host : localhost:3306
Source Schema : library_management_system
Target Server Type : MySQL
Target Server Version : 50744 (5.7.44-log)
File Encoding : 65001
Date: 29/04/2024 16:07:46
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for books
-- ----------------------------
DROP TABLE IF EXISTS `books`;
CREATE TABLE `books` (
`book_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '图书唯一标识符，自增长主键',
`ISBN` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '国际标准书号',
`title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '书名',
`author` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '作者',
`publisher` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '出版社',
`publication_year` year NULL DEFAULT NULL COMMENT '出版年份',
`category_id` int(11) NULL DEFAULT NULL COMMENT '图书分类ID，关联categories表的category_id（外键）',
`price` decimal(10, 2) NULL DEFAULT NULL COMMENT '价格',
`stock_quantity` int(11) NULL DEFAULT NULL COMMENT '库存量',
`available_to_borrow` int(11) NULL DEFAULT NULL COMMENT '可借数量',
`barcode_id` int(11) NULL DEFAULT NULL COMMENT '条形码id,关联barcodes表barcode_id',
PRIMARY KEY (`book_id`) USING BTREE,
INDEX `book_catagory_key`(`category_id`) USING BTREE,
INDEX `barcodes_id`(`barcode_id`) USING BTREE,
CONSTRAINT `book_catagory_key` FOREIGN KEY (`category_id`) REFERENCES `book_category` (`categroy_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `barcodes_id` FOREIGN KEY (`barcode_id`) REFERENCES `barcodes` (`barcodes_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
SET FOREIGN_KEY_CHECKS = 1;
