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