CREATE TABLE "User" (
	"id" int PRIMARY KEY,
	"email" varchar(255),
	"password" varchar(255),
	"display_name" varchar(255),
	"image" varchar(255),
	"country_id" int,
	"location" varchar(255),
	"is_protected" bool,
	FOREIGN KEY("country_id") REFERENCES "Country" ("id")
);
CREATE TABLE "Country" (
	"id" int PRIMARY KEY,
	"name" varchar(255),
	"name_in_english" varchar(255),
	FOREIGN KEY("name_in_english") REFERENCES "name_in" ("english")
);
CREATE TABLE "Post" (
	"id" int PRIMARY KEY,
	"user_id" int,
	"body" varchar(255),
	"referenced_to" int,
	"registered_on" datetime,
	FOREIGN KEY("user_id") REFERENCES "User" ("id")
);
CREATE TABLE "Relationship" (
	"id" int PRIMARY KEY,
	"user_id" int,
	"follow_to" int,
	"is_blocked" bool,
	FOREIGN KEY("user_id") REFERENCES "User" ("id"),
	FOREIGN KEY("is_blocked") REFERENCES "is" ("blocked")
);