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.
