Database Schema
A database schema is the structure of a database — its tables, columns, types, relationships, and constraints — that defines how data is organized and validated.
The schema is the blueprint of your data. In PostgreSQL it includes tables and columns, data types, primary and foreign keys, indexes, and constraints that enforce integrity.
A well-designed relational schema models real relationships with foreign keys, preventing inconsistent data at the source instead of relying on application code.
With PostgREST-style tooling, the schema also becomes the API surface — adding a table instantly exposes a corresponding endpoint.
Related terms
See it in practice
Kolaybase gives you PostgreSQL, auth, storage, and a REST API in minutes.