A table is just a spreadsheet

A table is a sheet. Each column is a kind of fact — name, email, price. Each row is one thing — one customer, one order.

One extra idea a spreadsheet does not have: every row needs a primary key — a value that is unique to that row, so you can point at exactly one. Usually it is an id the database fills in for you.

• Column = a kind of fact, the same type all the way down.
• Row = one actual thing.
• Primary key = the unique handle on one row.