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 CONSTRAINT users_id REFERENCES users(id),
	"categories_id" int CONSTRAINT 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 CONSTRAINT articles_id REFERENCES articles(id),
	"tags_id" int CONSTRAINT tags_id REFERENCES tags(id)
);
CREATE TABLE "tags" (
	"id" int PRIMARY KEY,
	"name_ge" varchar(255),
	"name_en" varchar(255),
	"name_ru" varchar(255) CONSTRAINT name_ru REFERENCES name(ru)
);
CREATE TABLE "videos" (
	"id" int,
	"categories_id" int CONSTRAINT 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 CONSTRAINT is_published REFERENCES is(published)
);
CREATE TABLE "author_requests" (
	"id" int,
	"users_id" int CONSTRAINT users_id REFERENCES users(id),
	"is_author" bool,
	"is_readed" bool CONSTRAINT is_readed REFERENCES is(readed)
);
CREATE TABLE "subscribers" (
	"id" int,
	"email" varchar(255)
);