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`)
);