Home Content ManagementBlog Platform

Blog Platform

WordPress-like blogging system with post revisions, hierarchical categories, tags, comments, and media library

SchemaVerse

Content ManagementPostgreSQLCMSNormalizedHierarchical

blog-platform.dbml

12 tables|18 relations

users

idinteger

usernamevarchar(50)

*UQ

emailvarchar(255)

*UQ

password_hashvarchar(255)

display_namevarchar(100)

biotext

avatar_urlvarchar(500)

rolevarchar(20)

statusvarchar(20)

created_attimestamp

updated_attimestamp

posts

idinteger

author_idinteger

FK*

titlevarchar(255)

slugvarchar(255)

*UQ

contenttext

excerpttext

featured_image_idinteger

statusvarchar(20)

visibilityvarchar(20)

password_hashvarchar(255)

published_attimestamp

scheduled_attimestamp

view_countinteger

comment_countinteger

created_attimestamp

updated_attimestamp

post_revisions

idinteger

post_idinteger

FK*

author_idinteger

FK*

titlevarchar(255)

contenttext

excerpttext

revision_notevarchar(500)

created_attimestamp

About this Schema

Overview

Full-featured blog platform schema inspired by WordPress. Supports post creation with revisions, hierarchical category organization, tagging, commenting, and media management.

Key Design Decisions

Post Revisions: Track editing history and enable rollback
Hierarchical Categories: Nested category structure
Media Library: Centralized asset management
Comment Threading: Nested comment discussions

Tables

12 tables covering posts, revisions, categories, tags, comments, media, pages, and custom menus. Complete blogging platform foundation.

Comments

Loading comments...