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. 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 auto-generated REST API tooling, the schema also becomes the API surface — adding a table instantly exposes a corresponding endpoint.
Related terms
See it in practice
basefyio gives you database, auth, storage, and a REST API in minutes.