Northwind Explorer

Products table

The catalogue: price, stock on hand, stock on order and the reorder level. 77 rows.

Columns

PRAGMA table_info

#	Name	Type	Not null	Default	Key	References
0	`ProductID`	`INTEGER`	no	—	PK
1	`ProductName`	`TEXT`	yes	—
2	`SupplierID`	`INTEGER`	no	—		Suppliers.SupplierID
3	`CategoryID`	`INTEGER`	no	—		Categories.CategoryID
4	`QuantityPerUnit`	`TEXT`	no	—
5	`UnitPrice`	`REAL`	no	`0`
6	`UnitsInStock`	`INTEGER`	no	`0`
7	`UnitsOnOrder`	`INTEGER`	no	`0`
8	`ReorderLevel`	`INTEGER`	no	`0`
9	`Discontinued`	`INTEGER`	yes	`0`

Indexes

PRAGMA index_list

Name	Columns	Unique	Created by
`Products_SupplierID`	`SupplierID`	no	CREATE INDEX
`Products_ProductName`	`ProductName`	no	CREATE INDEX
`Products_CategoryID`	`CategoryID`	no	CREATE INDEX

Referenced by

Order Details.ProductID → Products.ProductID

Definition

from sqlite_schema

CREATE TABLE Products (
    ProductID       INTEGER PRIMARY KEY,
    ProductName     TEXT NOT NULL,
    SupplierID      INTEGER REFERENCES Suppliers (SupplierID),
    CategoryID      INTEGER REFERENCES Categories (CategoryID),
    QuantityPerUnit TEXT,
    UnitPrice       REAL DEFAULT 0 CHECK (UnitPrice >= 0),
    UnitsInStock    INTEGER DEFAULT 0 CHECK (UnitsInStock >= 0),
    UnitsOnOrder    INTEGER DEFAULT 0 CHECK (UnitsOnOrder >= 0),
    ReorderLevel    INTEGER DEFAULT 0 CHECK (ReorderLevel >= 0),
    Discontinued    INTEGER NOT NULL DEFAULT 0 CHECK (Discontinued IN (0, 1))
)