notion (Study Case)

This ERD represents a simplified Notion-style collaborative workspace platform database structure. The schema supports core features including user accounts, workspaces, nested pages, block-based content, databases with custom properties, comments, and notifications. The users table stores account information and authentication data, while user_settings manages personal preferences such as theme, language, and timezone. Collaboration spaces are represented through the workspaces table, where users join via workspace_members and can be grouped further through teamspaces for sub-team organization. Content is structured through the pages table, which supports nested hierarchies via self-reference, and the blocks table, where each block (paragraph, heading, list, toggle, etc.) can also contain child blocks recursively. The note_databases table along with database_properties, database_rows, and database_cell_values implements Notion's flexible database feature, allowing users to define custom schemas and view data through multiple layouts defined in database_views.