CREATE TABLE `post` (
	`id` int,
	`title` varchar(255),
	`slug` varchar(255),
	`description` varchar(255),
	`body` varchar(255),
	`date_created` datetime,
	`is_published` bool,
	`blog_id` int,
	FOREIGN KEY(`blog_id`) REFERENCES `blog` (`id`)
);
CREATE TABLE `tag` (
	`id` int,
	`name` varchar(255),
	`blog_id` int,
	FOREIGN KEY(`blog_id`) REFERENCES `blog` (`id`)
);
CREATE TABLE `post_tags` (
	`post_id` int,
	`tag_id` int,
	FOREIGN KEY(`post_id`) REFERENCES `post` (`id`),
	FOREIGN KEY(`tag_id`) REFERENCES `tag` (`id`)
);
CREATE TABLE `author` (
	`id` varchar(255),
	`first_name` varchar(255),
	`last_name` varchar(255),
	`is_active` bool
);
CREATE TABLE `blog` (
	`title` varchar(255),
	`id` int,
	`summary` varchar(255),
	`author_id` int,
	FOREIGN KEY(`author_id`) REFERENCES `author` (`id`)
);