CREATE TABLE `books` (
	`id` int,
	`name` varchar(255),
	`author_id` int,
	`pages` int,
	`state` bool,
	FOREIGN KEY(`author_id`) REFERENCES `authors` (`id`)
);
CREATE TABLE `authors` (
	`id` int PRIMARY KEY,
	`first_name` varchar(255),
	`last_name` varchar(255),
	FOREIGN KEY(`last_name`) REFERENCES `last` (`name`)
);
CREATE TABLE `users` (
	`id` int PRIMARY KEY,
	`first_name` varchar(255),
	`last_name` varchar(255),
	`phone_number` varchar(255),
	`email` varchar(255)
);
CREATE TABLE `deposits` (
	`depozit_date` datetime,
	`deadline` datetime,
	`book_id` int,
	`user_id` int,
	`due_date` datetime,
	FOREIGN KEY(`book_id`) REFERENCES `books` (`id`),
	FOREIGN KEY(`user_id`) REFERENCES `users` (`id`),
	FOREIGN KEY(`due_date`) REFERENCES `due` (`date`)
);
CREATE TABLE `categories` (
	`id` int PRIMARY KEY,
	`name` varchar(255)
);
CREATE TABLE `books_categories` (
	`book_id` int,
	`category_id` int,
	FOREIGN KEY(`book_id`) REFERENCES `books` (`id`),
	FOREIGN KEY(`category_id`) REFERENCES `categories` (`id`)
);