да это норм.
Вот есчё (на беларускай мове нет буквы на клавіатуре справа возле ш) схема:
CREATE TABLE "public.Languages" (
"ID" serial NOT NULL,
"Name" TEXT NOT NULL,
CONSTRAINT "Languages_pk" PRIMARY KEY ("ID")
) WITH (
OIDS=FALSE
);
CREATE TABLE "public.Users" (
"ID" serial NOT NULL,
"TelegramID" bigint UNIQUE,
"LanguageID" int NOT NULL,
"Mail" TEXT UNIQUE,
"Login" TEXT UNIQUE,
"Password" TEXT,
CONSTRAINT "Users_pk" PRIMARY KEY ("ID")
) WITH (
OIDS=FALSE
);
CREATE TABLE "public.Books" (
"ID" serial NOT NULL,
"OwnerID" int NOT NULL,
"BookTitle" TEXT NOT NULL,
CONSTRAINT "Books_pk" PRIMARY KEY ("ID")
) WITH (
OIDS=FALSE
);
CREATE TABLE "public.Pages" (
"ID" serial NOT NULL,
"BookID" int NOT NULL,
"Page" serial NOT NULL,
"Text" TEXT,
"Picture" TEXT,
CONSTRAINT "Pages_pk" PRIMARY KEY ("ID")
) WITH (
OIDS=FALSE
);
ALTER TABLE "Users" ADD CONSTRAINT "Users_fk0" FOREIGN KEY ("LanguageID") REFERENCES "Languages"("ID");
ALTER TABLE "Books" ADD CONSTRAINT "Books_fk0" FOREIGN KEY ("OwnerID") REFERENCES "Users"("ID");
ALTER TABLE "Pages" ADD CONSTRAINT "Pages_fk0" FOREIGN KEY ("BookID") REFERENCES "Books"("ID");
Она точно не говно?