advancedTop 15 Database Design Questions

Design a content management system (CMS) supporting versioned documents.

documents(id, slug UNIQUE, title, status, created_by FK, created_at, updated_at) document_versions(id BIGSERIAL, document_id FK, version_number INT, content TEXT, created_by FK, created_at, PRIMARY KEY(id)) UNIQUE(document_id, version_number) — no duplicate versions per document published_versions(document_id FK PRIMARY KEY, version_id FK UNIQUE) — which version is live tags(id, name UNIQUE), docu

This is a Pro chapter

Sign in, then upgrade to Pro or Power to unlock this and the full Databases Mastery library.

Design a content management system (CMS) supporting versioned documents.

Next Step

Continue to Design a database for a ride-sharing platform (Uber-like).← Back to all SQL questions