CREATE TABLE "books" (
	"id" int,
	"name" varchar(255),
	"author_id" int CONSTRAINT authors_id REFERENCES authors(id),
	"pages" int,
	"state" bool
);
CREATE TABLE "authors" (
	"id" int PRIMARY KEY,
	"first_name" varchar(255),
	"last_name" varchar(255) CONSTRAINT 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 CONSTRAINT books_id REFERENCES books(id),
	"user_id" int CONSTRAINT users_id REFERENCES users(id),
	"due_date" datetime CONSTRAINT due_date REFERENCES due(date)
);
CREATE TABLE "categories" (
	"id" int PRIMARY KEY,
	"name" varchar(255)
);
CREATE TABLE "books_categories" (
	"book_id" int CONSTRAINT books_id REFERENCES books(id),
	"category_id" int CONSTRAINT categories_id REFERENCES categories(id)
);