Content platform · ER model

ER · Diagram Design

# Content platform · data model

The four entities behind the site. Article is the aggregate root — everything else exists to describe or classify it. `#` marks primary keys, `→` marks foreign keys.

THE HEADLINE

### Article is the root

Author, Tag, and the join table only exist to describe Article. If you're thinking about a feature, start here and trace outward.

### Many-to-many via a join

- Tags aren't embedded on Article
- ArticleTag is a pure join — no metadata
- Dashed border signals it's not a primary entity

### Cardinality over arrows

Plain lines with 1/N at the ends read cleaner than crow's feet at this size. Every relationship carries both numbers.