Data Modeling

8 pages in this section.

How conceptual, logical, and physical modeling layers relate to each other, and why every table you write in PostgreSQL is the last step of a longer design process, not the first.

Explainer Data Modeling Schema Design Conceptual Modeling

Data Modeling Basics

Learn data modeling basics with 8 examples, including conceptual entity sketching and logical table creation with surrogate keys.

Sql Data Modeling Architecture Basics Data

Entity-Relationship Modeling

Learn to model database entities, relationships, and cardinality. Design PostgreSQL tables, handle optionalities, and apply naming conventions.

Sql Data Modeling Architecture Erd Relationships

Domain-Driven Schema Boundaries

Map bounded contexts to PostgreSQL schemas to achieve namespace isolation and clear ownership for multiple teams sharing a database.

Sql Data Modeling Architecture Ddd Schemas

ADR: Single Database vs Per-Service DB

Sql Data Modeling Architecture Adr Microservices

Schema Evolution Strategy

Sql Data Modeling Architecture Migrations Expand Contract

Data Modeling Best Practices

Apply data modeling best practices for SQL schema reviews and migrations. Learn to name tables, encode invariants, use proper keys, and manage relationships.

Sql Data Modeling Architecture Best Practices List

Data Modeling Highlights Summary

A single-page roundup of every highlight bullet from the 7 pages in the Data Modeling section, grouped by source page so you can scan all 40 takeaways without opening each article individually.

Highlights Summary Data Modeling Architecture

Data Modeling

Search Documentation

Data Modeling