technically logo

Learn

Company Breakdowns
What technical products actually do and why the companies that make them are valuable
Knowledge Bases
In-depth, networked guides to learning specific concepts
Posts Archive
All Technically posts on software concepts since the dawn of time
Terms Universe
The dictionary of software terms you've always wanted

Explore knowledge bases

AI, it's not that ComplicatedAnalyzing Software CompaniesBuilding Software ProductsWorking with Data Teams
Loading...

Meet Technically

Technically exists to help you get better at your job by becoming more technically literate.

Learn more →

Solutions for Teams

For GTM Teams
Sell more software to developers by becoming technically fluent.
For Finance Professionals
Helping both buy-side and sell-side firms ask better technical questions.
General Team Inquiries
Volume discounts on Technically knowledge bases.
Loading...
Pricing
Sign In
← Back to Universe

Schema

databasesintermediate

A schema is like the blueprint for a relational database. It lays out which tables you have, which columns are in them, what data type those columns are, and which columns in one table map to columns in another table. Developers design schemas to enforce rigidity on their data: when you specify exactly what data needs to be where, you prevent errant (or missing) data from breaking your application.

Read the full post ↗

The Excel User's Guide to Databases: Schemas

Why that schema change is going to take your engineers two weeks.

Read in the Knowledge Base →

Mentioned in

The Excel User's Guide to Databases: Migrations

Why your feature is held up by a migration and why this is actually good.

Applieddatabases
The Excel User's Guide to Databases: Schemas

Why that schema change is going to take your engineers two weeks.

Applieddatabases
What's an ORM?

An ORM translates database talk into application talk.

Foundationaldatabases
How does a feature get made?

Walking practically through how an engineer builds something.

Bill Becomes A Lawdevops

Related terms

Blockchain

Database

GraphQL

Metadata

Migration

Multi-tenant

Support
Sponsorships
Twitter
Linkedin
Privacy + ToS