CREATE TABLE `post` ( `id` int, `title` varchar(255), `slug` varchar(255), `description` varchar(255), `body` varchar(255), `date_created` datetime, `author_id` int, `is_published` bool, FOREIGN KEY(`author_id`) REFERENCES `author` (`id`) ); CREATE TABLE `tag` ( `id` int, `name` varchar(255) ); 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 );