Skip to content
Tutorials Center
My learning

Topics

Lesson 10 of 36 ยท Databases

Database Basics

Learn how Notion databases work: rows are pages, columns are properties, inline versus full-page databases, and how to create your first task database.

Databases are the feature that turns Notion from a note-taking app into a system. A Notion database is a collection of pages that all share the same set of fields. A task list, a reading log, a customer list and a content calendar are all databases; only the properties differ.

Once you see a database as "pages with columns", every later feature (views, filters, relations, formulas, automations) is a refinement of that one idea.

Rows are pages

In a spreadsheet, a row is only data. In a Notion database, each row is a full page. Click a row's title and it opens as a page with a body for notes, files, checklists and comments, plus a property panel at the top. That makes databases perfect for items that need both structured fields and free-form content, such as a project with a status, an owner and a long description.

Properties are columns

A property is a typed field such as Text, Number, Date or Select. Every database starts with a Title property (the page name) that cannot be removed. You add others with the + at the end of the header row. The next lesson, Property Types, covers all of them.

Database vocabulary

Row A page in the database.
Property A typed column such as Date or Status.
View A saved way to display the rows.
Filter and sort Rules a view applies.
1 / 2

Creating a database

Create one with the slash menu:

  • /table view or /database inline adds an inline database inside the current page, alongside text.
  • /table view full page (or choosing Table from a new page's options) creates a full-page database where the whole page is the database.
  • /linked view of database adds a linked view of one that already exists elsewhere (see Linked Databases and Views).

The exact wording of the menu entries shifts between versions; look for names such as "Table view," "Database - Inline" and "Database - Full page."

Inline versus full page

An inline database lives inside a page and shares it with headings, text and other blocks. A full-page database takes the whole page and its title is the database title. Both are the same database engine; the difference is placement. You can convert between them from the database's ... menu (Turn into inline / Turn into full page).

A first example

Imagine a Tasks database with these properties:

Property Type
Name Title
Status Status (Not started, In progress, Done)
Due Date
Priority Select (Low, Medium, High)

Add a few rows by clicking + New and typing names. Click a row to open it and write notes in the body. Notion creates a unique page for each task, which can be mentioned from anywhere.

Simulating a database

This stand-in models a database as a schema plus a list of rows, and checks that each new row has valid values. It illustrates the data model; Notion handles all of this for you.

JS A database as schema plus rows (stand-in)

Press Run (or Ctrl + Enter) to see the console output here.

No output.

JS Each row is a page with a body (stand-in)

Press Run (or Ctrl + Enter) to see the console output here.

No output.

Database versus table block

A /table block (a simple table) is just a grid of text cells; it has no property types, filters or views. A database is much more capable. Use a simple table for a small, static grid in a document and a database for anything you will sort, filter, or reuse.

Design questions before you build

  1. What is one row? (A task, a client, a meeting?) Pick one noun.
  2. Which properties will you actually filter or sort by?
  3. Does the data need free-form notes? If so, the row page body is perfect.
  4. Will other databases connect to this one? If so, plan relations early.

Start with few properties. You can always add more; removing a column people rely on is harder.

Check your understanding

Quick check ยท 4 questions

of 4 answered You scored / 4 ยท perfect!

  1. 1. What is each row in a Notion database?

    Rows are pages, so they can hold properties and free-form content.
  2. 2. Which property cannot be removed from a database?

    Every database has a Title property, which names each page.
  3. 3. What is the difference between an inline and a full-page database?

    Both are the same kind of database; they differ only in where they sit.
  4. 4. When should you use a simple /table block instead of a database?

    A simple table lacks types, views and filters; use it only for small, plain grids.

Summary

  • A database is a collection of pages sharing properties.
  • Rows are pages; columns are typed properties; views display them.
  • Databases can be inline, full-page or linked views.
  • Plan the row noun and a small set of properties first.

Next: Property Types