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 CONSTRAINT blog_id REFERENCES blog(id)
);
CREATE TABLE "tag" (
	"id" int,
	"name" varchar(255),
	"blog_id" int CONSTRAINT blog_id REFERENCES blog(id)
);
CREATE TABLE "post_tags" (
	"post_id" int CONSTRAINT post_id REFERENCES post(id),
	"tag_id" int CONSTRAINT 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 CONSTRAINT author_id REFERENCES author(id)
);