ER · Diagram Design

Content platform · data model

Content platform · data model Entity-relationship diagram showing authors writing articles and articles connecting to tags and categories. 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