CREATE TABLE "users" (
	"id" int PRIMARY KEY,
	"name" varchar(255),
	"fullname" varchar(255),
	"email" varchar(255),
	"password" varchar(255),
	"is_active" bool,
	"is_block" bool,
	"age" int,
	"contry_city" varchar(255),
	"social_urls" varchar(255)
);
CREATE TABLE "articles" (
	"id" int PRIMARY KEY,
	"users_id" int FOREIGN KEY("users_id") REFERENCES "users" ("id"),
	"categories_id" int FOREIGN KEY("categories_id") REFERENCES "categories" ("id"),
	"head_image_url" varchar(255),
	"title_ge" varchar(255),
	"title_en" varchar(255),
	"title_ru" varchar(255),
	"title_desc_ge" varchar(255),
	"title_desc_ru" varchar(255),
	"title_desc_en" varchar(255),
	"text_ge" varchar(255),
	"text_en" varchar(255),
	"text_ru" varchar(255),
	"quote_ge" varchar(255),
	"quote_en" varchar(255),
	"quote_ru" varchar(255),
	"stars" int,
	"watched" int,
	"sheared_count" int,
	"is_pending" bool,
	"is_publiched" bool,
	"is_video_content" bool
);
CREATE TABLE "categories" (
	"id" int PRIMARY KEY,
	"title_ge" varchar(255),
	"title_en" varchar(255),
	"title_ru" varchar(255),
	"icon" varchar(255)
);
CREATE TABLE "article_tag" (
	"id" int PRIMARY KEY,
	"articles_id" int FOREIGN KEY("articles_id") REFERENCES "articles" ("id"),
	"tags_id" int FOREIGN KEY("tags_id") REFERENCES "tags" ("id")
);
CREATE TABLE "tags" (
	"id" int PRIMARY KEY,
	"name_ge" varchar(255),
	"name_en" varchar(255),
	"name_ru" varchar(255) FOREIGN KEY("name_ru") REFERENCES "name" ("ru")
);
CREATE TABLE "videos" (
	"id" int,
	"categories_id" int FOREIGN KEY("categories_id") REFERENCES "categories" ("id"),
	"url" varchar(255),
	"title_ge" varchar(255),
	"title_en" varchar(255),
	"title_ru" varchar(255),
	"text_ge" varchar(255),
	"text_en" varchar(255),
	"text_ru" varchar(255),
	"quote_ge" varchar(255),
	"quote_en" varchar(255),
	"quote_ru" varchar(255),
	"watched" varchar(255),
	"sheared_count" varchar(255),
	"is_panding" bool,
	"is_published" bool FOREIGN KEY("is_published") REFERENCES "is" ("published")
);
CREATE TABLE "author_requests" (
	"id" int,
	"users_id" int FOREIGN KEY("users_id") REFERENCES "users" ("id"),
	"is_author" bool,
	"is_readed" bool FOREIGN KEY("is_readed") REFERENCES "is" ("readed")
);
CREATE TABLE "subscribers" (
	"id" int,
	"email" varchar(255)
);