# Physical Data Model

> The data plan for one real database. It has exact column types and indexes.

**Field:** Data Engineering  
**Category:** Foundations  
**Also known as:** Physical Model

## Think of it like

It is like the builder's plan. It says which bricks, which pipes and how thick each wall is.

## Definition

A physical data model is the plan written for one real database. It turns each field into a column with an exact type, such as INT or VARCHAR(100). It adds indexes, partitions and other choices that make reads fast. You can run it as code to create the tables. A change of database means a new physical model.

## Example

The library builds Loan in PostgreSQL. Dates are DATE, IDs are BIGINT, and member ID gets an index.

## Example code

```sql
CREATE TABLE loan (
  loan_id   BIGINT PRIMARY KEY,
  member_id BIGINT NOT NULL REFERENCES member,
  book_id   BIGINT NOT NULL REFERENCES book,
  due_date  DATE NOT NULL
);
```

The library's Loan as a real table, with exact types and keys.

## Why it matters

This is the level that runs. Types, indexes and sizes set the speed and cost of every query.

## Common mistake

Starting here. Without the first two levels, the tables follow one database's habits. They should follow the business.

## Three principles

- **Exact types.** Each column gets a real type.
- **Built for speed.** Indexes and partitions are chosen.
- **Runs as code.** It creates the real tables.

## Related terms

- [Logical Data Model](https://learn.benibix.com/term/data/logical-data-model)
- [Data Model](https://learn.benibix.com/term/data/data-model)
- [Database Index](https://learn.benibix.com/term/development/database-index)
- [Database Table](https://learn.benibix.com/term/development/database-table)

## Told apart from

- [Logical Data Model vs Physical Data Model](https://learn.benibix.com/compare/logical-vs-physical-data-model): People think the logical and physical data models are the same drawing. The logical one lists every field and key. It fits any database. The physical one gives each field an exact type for one real database. It also picks the indexes. If you change the database, only the physical model changes.

## Taught in

- [Data Models and ER Diagrams](https://learn.benibix.com/learn/data-foundations/data-models-and-er-diagrams): Data Engineering Basics, 9/11

---

Source: https://learn.benibix.com/term/data/physical-data-model
Author: Behnia Zarei (a developer in Vienna, Austria, who builds and teaches data, AI and business intelligence at BENIBIX)
Publisher: BENIBIX Learn (https://learn.benibix.com/)
Last updated: 2026-11-20
Licence: CC BY 4.0 (https://creativecommons.org/licenses/by/4.0/). Quote freely with attribution.
