ER · kami diagram

{{Content platform · data model}}

1 N 1 N 1 N WRITES TAGGED ENTITY Author # id uuid handle text name text bio text site_url text ENTITY · AGGREGATE ROOT Article # id uuid title text slug text · unique body_mdx text published_at timestamp → author_id uuid status enum og_image text · url ENTITY Tag # id uuid slug text · unique name text description text JOIN ArticleTag → article_id uuid → tag_id uuid LEGEND Aggregate root Entity Join table # Primary key → Foreign key 1 / N Cardinality

The accent goes on the aggregate root. Join tables get the dashed border so the reader can see at a glance which boxes carry meaning and which only carry foreign keys.