ER diagram
Blog database
Authors, posts, comments and tags with a join table.
- Category
- Technical
- Diagram type
- ER diagram
- Elements
- 5
- Connectors
- 4
What it is for
Includes post_tag as a genuine join table, so the many-to-many relationship is modelled rather than hand-waved. Comments hang off posts with a nullable parent for threading.
More about the er diagram makerWhen it helps
- Designing a first content schema
- Teaching many-to-many relationships
- Reviewing a blog backend
