Vibe Launchpad
Supabase· Step 3 of 40 cleared in this quest
Step 3 · about 3 minutes

A table is just a spreadsheet

Think of a database as a collection of spreadsheets. Here are the few words you need.

  • Database: the place your app keeps information, such as a shop’s products and orders.
  • Table: one group of similar information, like a spreadsheet named products.
  • Column: one kind of information, such as name or price.
  • Row: one item in that table, such as a blue shirt.
  • Value: the information in one cell, such as Blue shirt or 49.
  • Primary key: a unique label, usually called id, that identifies one row. Two shirts can have the same name but different IDs.

Example: a products table could have the columns id, name and price. One row could contain 1, Blue shirt and 49. Another could contain 2, Red shirt and 59.

A products table with two rows. The id, name, and price columns describe Blue Shirt (49) and Red Shirt (59). This is an example; you do not need to create it for this lesson.
A products table with two rowsOpen full-size image