Blog ER (posts ↔ tags)

Authors publish posts, posts are tagged through a join entity, comments are threaded.

Template previewERD

Rendering…

Make it your own.

[Author]
*id
handle
display_name

[Post]
*id
+author_id
slug
title
body

[Tag]
*id
name

[PostTag]
*post_id
*tag_id

[Comment]
*id
+post_id
+parent_id
body
created_at

Author 1--* Post     {label: "writes"}
Post   1--* PostTag  {label: "tagged"}
Tag    1--* PostTag  {label: "tags"}
Post   1--* Comment  {label: "has"}
Comment ?--* Comment {label: "replies to"}