Skip to content
Designing your doc with schemas
One Big Table: Tracking made simple
Star: What to use when your data has data
Base/detail: Creating dashboards with formulas
Multidimensional: Data without hierarchy
More
Share
Explore

icon picker
Star: What to use when your data has data

We're scaling and connecting your data in part two of our schema series.
MM
Maria Marquis
|
Hannah Rochau
|
BL
Ben Lee
Last time, we chatted about the schema for all seasons—the One Big Table (OBT). As a refresher, OBT is a great schema for getting started and flexing into other schemas as your doc and data set evolve. If you want to get the most out of your OBT, make sure to read our tips in
One Big Table: Tracking made simple
⁠
.
Our next schema gives your data a bit more space and a whole new meaning to the word star chart.

Star schema

If you start to repeat data in your OBT, it’s time to scale up to a new schema. The logical progression for most makers is star, a schema that breaks your OBT down into smaller tables that reference each other.
Star is ideal for:
Larger scale projects or initiatives
Ensuring consistent data
Referencing the same data in multiple places
Data with 1-to-1 relationships
Summarizing all projects with a certain status

Learn more about star schema in this episode of Designing Docs:
⁠
⁠
⁠

Declutter your data with lookups.

Imagine you’re using the table below to keep track of your renovation project, with dedicated columns for tasks, room of the house, and vendors. You probably have additional information you’d like to track about each, like budget for each room and contact information. If you used OBT schema for your table, descriptions would repeat every time the task, room, or vendor was mentioned. While OBT keeps your data in a single place, the duplicate data in this instance clutters your view. And any changes needed would need to be made manually for every single mention of that description.
Remodel tasks
0
Room
Tasks
Owner
Vendor
Status
1
Bathroom
Buy drywall
MM
Maria Marquis
ABC Lumber
Not Started
2
Bathroom
Install drywall
Erin Dame
ABC Lumber
Not Started
3
General
Secure permit
LT
Laura Tsunoda
ABC Lumber
Done
4
Kitchen
Kitchen demolition
MM
Maria Marquis
Debris Demo Service
In Progress
5
Bathroom
Bathroom demolition
Erin Dame
Debris Demo Service
Not Started
6
Living room
Buy carpet
LT
Laura Tsunoda
Grasshopper Flooring
In Progress
7
Kitchen
Replace pipes
MM
Maria Marquis
Aplombers
In Progress
There are no rows in this table
⁠
The beauty of star schema is that it allows you to reference data located elsewhere in your doc. Your descriptions are still within arms reach when you need them, but they live in smaller tables that feed into the main table using
lookups
⁠
. And now that your tables are linked, updates are made to other tables automatically, even in your
display column
⁠
. So whatever typos you fix or context you appear wherever that data is referenced.
⁠
Loading…
⁠
⁠

Turning your OBT into a star is simple. Convert any select list into a table of its own using the “Convert to table” button in the select list options. Then add as much information to your new table as you’d like. From there, you can create as many connected tables as you need.
⁠
Screen Shot 2020-10-02 at 10.22.53 AM.png
⁠
⁠

And connect existing tables.

Star schema isn’t just an evolution of OBT. The lookup column type can also link two (or more) existing tables. Let’s say you want to connect the Room and Vendor tables below. Add a lookup column to the Room table, and select New Lookup > Vendor. Now you can select the vendor working in each room.
Make these tables talk to each other by adding a lookup column. 👇
Room
0
Room
Budget
1
Bathroom
$8,000.00
2
General
$5,000.00
3
Kitchen
$18,500.00
4
Living room
$3,750.00
There are no rows in this table
⁠
Vendor
0
Vendor
Primary contact
Phone number
Address
1
ABC Lumber
Betty Weiss
555-345-4444
123 Woodland Road
2
Debris Demo Service
Marina Carter
555-235-6676
533 Cluttery Ave
3
Aplombers
Leo Fishburne
555-477-7887
145 Flushing Fairway
4
Grasshopper Flooring
Ann Tennah
555-123-3452
333 Hoppe Drive
There are no rows in this table
⁠

A bit of inspiration.

Remember, there’s no right or wrong schema for your doc—you’re simply looking for the most efficient method to display and interact with your data.
Star schema is often the cleanest representation of what is in the real world. Your renovation has its own table, but because your rooms and vendors are different, with their own set of context, they need their own tables. Star schema allows you to cleanly organize all of this data while also keeping everything connected.
Looking for some stellar examples of the star schema? Here are two docs worth exploring:
⁠
Sales CRM
⁠
by
John Scrugham
⁠
- Star schema turns a simple contact list into a comprehensive sales pipeline.
⁠
An inside look at how Figma ships product
⁠
by
Yuhki Yamashita
⁠
- By reducing redundant data, star schema provides the framework for the Figma product team’s efficient single source of truth.
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.