Foreign key
A column that points at a row in another table by its ID: orders.dishid → dishes.id
Words that go with it
- ColumnOne kind of information, with a type: name (text), quantity (whole number)
- MCP server / toolThe connector a service provides, and the actions it offers the AI
- PostgresThe database Supabase is built on
- Primary key (ID)A value that's unique for every row
- Read-only modeAn MCP setting that lets the AI look but never change anything
- Row (record)One thing in a table: one dish, one order
- SQLThe language databases understand. Cursor writes it; you read it
- SupabaseA service that gives you a Postgres database, a dashboard, logins and more
- TableOne sheet about one kind of thing: dishes, orders