CREATE DATABASE `db_libraryms` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */;

CREATE TABLE `tb_admin` (
  `id` varchar(50) NOT NULL COMMENT '管理员编号\n',
  `name` varchar(50) DEFAULT NULL COMMENT '管理员名称',
  `pwd` varchar(30) DEFAULT NULL COMMENT '密码',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='管理员信息表';

CREATE TABLE `tb_bookcase` (
  `id` varchar(30) NOT NULL COMMENT '书架编号',
  `name` varchar(50) DEFAULT NULL COMMENT '书架名称',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='书架表';

CREATE TABLE `tb_bookinfo` (
  `bookcode` varchar(30) NOT NULL COMMENT '图书条形码',
  `bookname` varchar(45) DEFAULT NULL COMMENT '图书名称',
  `type` varchar(45) DEFAULT NULL,
  `author` varchar(45) DEFAULT NULL,
  `translator` varchar(50) DEFAULT NULL,
  `pubname` varchar(45) DEFAULT NULL,
  `price` decimal(10,0) DEFAULT NULL,
  `page` int DEFAULT NULL,
  `bcase` varchar(45) DEFAULT NULL COMMENT '书架',
  `storage` int DEFAULT NULL COMMENT '存储数量',
  `inTime` date DEFAULT NULL,
  `oper` varchar(45) DEFAULT NULL COMMENT '操作员',
  `borrownum` int DEFAULT NULL COMMENT '被借次数',
  PRIMARY KEY (`bookcode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='图书档案表';

CREATE TABLE `tb_booktype` (
  `id` int NOT NULL COMMENT '图书类型编号',
  `name` varchar(45) DEFAULT NULL COMMENT '图书名称',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='图书类型表';

CREATE TABLE `tb_borrowwandback` (
  `id` varchar(30) NOT NULL COMMENT '借书编号',
  `readerid` varchar(45) DEFAULT NULL COMMENT '读者编号',
  `bookcode` varchar(45) DEFAULT NULL,
  `borrowTime` date DEFAULT NULL COMMENT '借书时间',
  `ygbackTime` date DEFAULT NULL COMMENT '应归还时间',
  `sjbackTime` date DEFAULT NULL COMMENT '实际还书时间',
  `borrowoper` varchar(45) DEFAULT NULL COMMENT '借书操作员',
  `backoper` varchar(45) DEFAULT NULL COMMENT '还书操作员',
  `isback` bit(1) DEFAULT NULL COMMENT '是否归还',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='图书借还表';

CREATE TABLE `tb_library` (
  `libraryname` varchar(50) NOT NULL,
  `curator` varchar(45) DEFAULT NULL COMMENT '馆长',
  `tel` varchar(45) DEFAULT NULL,
  `address` varchar(100) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `url` varchar(45) DEFAULT NULL COMMENT '网址',
  `createDate` date DEFAULT NULL,
  `introduce` text,
  PRIMARY KEY (`libraryname`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='图书馆信息表';

CREATE TABLE `tb_purview` (
  `id` varchar(50) NOT NULL COMMENT '管理员编号',
  `sysset` bit(1) DEFAULT NULL,
  `readset` bit(1) DEFAULT NULL,
  `bookset` bit(1) DEFAULT NULL,
  `borrowback` bit(1) DEFAULT NULL,
  `sysquery` bit(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='权限时间表';

CREATE TABLE `tb_readertype` (
  `id` int NOT NULL,
  `name` varchar(45) DEFAULT NULL,
  `number` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='读者类型表';