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