← Back to problems

48. Hierarchical Block Document Store

MEDIUM
DatabaseSystem Design

Design the relational schema behind a Notion-style block editor - one generic block type, arranged in a tree.

Design the database schema for a block-based content system, the model tools like Notion use: every piece of content - text, headings, images, even embedded database rows - is stored as one generic 'block' type. Blocks are arranged hierarchically, each pointing at its parent, forming a tree per page. No architecture diagram or API design is required - this problem is purely about relational modeling.
Log in to submit a solution

Comments

Log into join the discussion.