Read-only Back to SQLite3 Guide
Northwind › Products › 1
Chai

Products row where ProductID = 1. Blue values are foreign keys: click one to jump to the row it points at.

Record
See the SQL ›
ProductIDPK
1
ProductName
Chai
SupplierIDFK
1
CategoryIDFK
1
QuantityPerUnit
10 boxes x 20 bags
UnitPrice
18.0
UnitsInStock
39
UnitsOnOrder
0
ReorderLevel
10
Discontinued
0
Order Details via ProductID
38 rows
row OrderIDProductIDUnitPriceQuantityDiscount
open › 10285 1 14.4 45 0.2
open › 10294 1 14.4 18 0.0
open › 10317 1 14.4 20 0.0
open › 10348 1 14.4 15 0.15
open › 10354 1 14.4 12 0.0
open › 10370 1 14.4 15 0.15
open › 10406 1 14.4 10 0.0
open › 10413 1 14.4 24 0.0
open › 10477 1 14.4 15 0.0
open › 10522 1 18.0 40 0.2
open › 10526 1 18.0 8 0.15
open › 10576 1 18.0 10 0.0
open › 10590 1 18.0 20 0.0
open › 10609 1 18.0 3 0.0
open › 10611 1 18.0 6 0.0
open › 10628 1 18.0 25 0.0
open › 10646 1 18.0 15 0.25
open › 10689 1 18.0 35 0.25
open › 10691 1 18.0 30 0.0
open › 10700 1 18.0 5 0.2
open › 10729 1 18.0 50 0.0
open › 10752 1 18.0 8 0.0
open › 10838 1 18.0 4 0.25
open › 10847 1 18.0 80 0.2
open › 10863 1 18.0 20 0.15
open › 10869 1 18.0 40 0.0
open › 10905 1 18.0 20 0.05
open › 10911 1 18.0 10 0.0
open › 10918 1 18.0 60 0.25
open › 10935 1 18.0 21 0.0
open › 11003 1 18.0 4 0.0
open › 11005 1 18.0 2 0.0
open › 11006 1 18.0 8 0.0
open › 11025 1 18.0 10 0.1
open › 11031 1 18.0 45 0.0
open › 11035 1 18.0 10 0.0
open › 11047 1 18.0 25 0.25
open › 11070 1 18.0 40 0.15