Home Content ManagementWiki Platform

Wiki Platform

Knowledge base with spaces, page hierarchies, revision history, inter-page linking, and permissions like Confluence

SchemaVerse

Content ManagementPostgreSQLCMSNormalizedHierarchical

wiki.dbml

12 tables|23 relations

users

idinteger

usernamevarchar(50)

*UQ

emailvarchar(255)

*UQ

password_hashvarchar(255)

display_namevarchar(100)

avatar_urlvarchar(500)

biotext

timezonevarchar(50)

is_activeboolean

created_attimestamp

updated_attimestamp

spaces

idinteger

keyvarchar(50)

*UQ

namevarchar(100)

descriptiontext

homepage_idinteger

iconvarchar(50)

is_privateboolean

created_byinteger

page_countinteger

created_attimestamp

updated_attimestamp

pages

idinteger

space_idinteger

FK*

parent_idinteger

titlevarchar(255)

slugvarchar(255)

contenttext

statusvarchar(20)

positioninteger

view_countinteger

revision_countinteger

created_byinteger

updated_byinteger

created_attimestamp

updated_attimestamp

page_revisions

idinteger

page_idinteger

FK*

version_numberinteger

titlevarchar(255)

contenttext

change_summaryvarchar(500)

created_byinteger

created_attimestamp

page_links

idinteger

source_page_idinteger

FK*

target_page_idinteger

FK*

link_textvarchar(255)

created_attimestamp

attachments

idinteger

page_idinteger

FK*

filenamevarchar(255)

original_filenamevarchar(255)

mime_typevarchar(100)

file_sizeinteger

file_pathvarchar(500)

uploaded_byinteger

download_countinteger

created_attimestamp

updated_attimestamp

comments

idinteger

page_idinteger

FK*

parent_idinteger

author_idinteger

FK*

contenttext

is_resolvedboolean

resolved_byinteger

resolved_attimestamp

created_attimestamp

updated_attimestamp

labels

idinteger

namevarchar(100)

*UQ

colorvarchar(7)

descriptiontext

usage_countinteger

created_attimestamp

updated_attimestamp

page_labels

page_idinteger

FK*

label_idinteger

FK*

created_attimestamp

permissions

idinteger

space_idinteger

FK*

user_idinteger

group_idinteger

permission_typevarchar(20)

created_attimestamp

search_index

idinteger

page_idinteger

FK*UQ

title_vectortext

content_vectortext

last_indexed_attimestamp

favorites

idinteger

user_idinteger

FK*

page_idinteger

FK*

created_attimestamp

React Flow

About this Schema

Overview

Wiki platform schema similar to Confluence or MediaWiki. Organizes knowledge into spaces with hierarchical pages, comprehensive revision tracking, inter-page linking, and granular permissions.

Key Design Decisions

Space Organization: Isolated namespaces for different projects
Page Hierarchy: Tree structure for content organization
Revision History: Complete edit tracking with diff support
Link Graph: Track inter-page references

Tables

12 tables covering spaces, pages, revisions, links, attachments, permissions, and search indexes. Enterprise knowledge management foundation.

Comments

Loading comments...