OpenVaultDB database

Northwind small-business sample database

The classic Northwind sample database for customers, orders, products, suppliers, shippers, territories and employees. The pinned SQLite build is read-only; the native schema includes 13 tables and 17 views.

Explore the database site Read-only API Server directory

Published collections

13 read-only collections

13 declared foreign-key relationships. Names and keys preserve the source database schema. The database site includes the complete native schema, including views.

Explore complete schema and exports ↗

Machine-readable database descriptor ↗

Published recordsets

Read-only collections

13 collections

table

CustomerCustomerDemo

2 columns · 0 rows

CustomerIDTEXT · PKCustomerTypeIDTEXT · PK

References CustomerDemographics.CustomerTypeID, Customers.CustomerID

table

CustomerDemographics

2 columns · 0 rows

CustomerTypeIDTEXT · PKCustomerDescTEXT · nullable

table

Customers

11 columns · 93 rows

CustomerIDTEXT · PKCompanyNameTEXT · nullableContactNameTEXT · nullableContactTitleTEXT · nullableAddressTEXT · nullableCityTEXT · nullableRegionTEXT · nullablePostalCodeTEXT · nullableCountryTEXT · nullablePhoneTEXT · nullableFaxTEXT · nullable

table

EmployeeTerritories

2 columns · 49 rows

EmployeeIDINTEGER · PKTerritoryIDTEXT · PK

References Territories.TerritoryID, Employees.EmployeeID

table

Employees

18 columns · 9 rows

EmployeeIDINTEGER · PKLastNameTEXT · nullableFirstNameTEXT · nullableTitleTEXT · nullableTitleOfCourtesyTEXT · nullableBirthDateDATE · nullableHireDateDATE · nullableAddressTEXT · nullableCityTEXT · nullableRegionTEXT · nullablePostalCodeTEXT · nullableCountryTEXT · nullableHomePhoneTEXT · nullableExtensionTEXT · nullablePhotoBLOB · nullableNotesTEXT · nullableReportsToINTEGER · nullablePhotoPathTEXT · nullable

References Employees.EmployeeID

table

Order Details

5 columns · 2,155 rows

OrderIDINTEGER · PKProductIDINTEGER · PKUnitPriceNUMERICQuantityINTEGERDiscountREAL

References Products.ProductID, Orders.OrderID

table

Orders

14 columns · 830 rows

OrderIDINTEGER · PKCustomerIDTEXT · nullableEmployeeIDINTEGER · nullableOrderDateDATETIME · nullableRequiredDateDATETIME · nullableShippedDateDATETIME · nullableShipViaINTEGER · nullableFreightNUMERIC · nullableShipNameTEXT · nullableShipAddressTEXT · nullableShipCityTEXT · nullableShipRegionTEXT · nullableShipPostalCodeTEXT · nullableShipCountryTEXT · nullable

References Shippers.ShipperID, Customers.CustomerID, Employees.EmployeeID

table

Products

10 columns · 77 rows

ProductIDINTEGER · PKProductNameTEXTSupplierIDINTEGER · nullableCategoryIDINTEGER · nullableQuantityPerUnitTEXT · nullableUnitPriceNUMERIC · nullableUnitsInStockINTEGER · nullableUnitsOnOrderINTEGER · nullableReorderLevelINTEGER · nullableDiscontinuedTEXT

References Suppliers.SupplierID, Categories.CategoryID

table

Regions

2 columns · 4 rows

RegionIDINTEGER · PKRegionDescriptionTEXT

table

Shippers

3 columns · 3 rows

ShipperIDINTEGER · PKCompanyNameTEXTPhoneTEXT · nullable

table

Suppliers

12 columns · 29 rows

SupplierIDINTEGER · PKCompanyNameTEXTContactNameTEXT · nullableContactTitleTEXT · nullableAddressTEXT · nullableCityTEXT · nullableRegionTEXT · nullablePostalCodeTEXT · nullableCountryTEXT · nullablePhoneTEXT · nullableFaxTEXT · nullableHomePageTEXT · nullable

table

Territories

3 columns · 53 rows

TerritoryIDTEXT · PKTerritoryDescriptionTEXTRegionIDINTEGER

References Regions.RegionID

Provenance

Published data

Source: https://github.com/jpwhite3/northwind-SQLite3 at 4f56e7f5906dfd23b25244c5bfe8fb5da6402efd.

Source licence: MIT. Model licence: MIT. Meaning licence: CC0-1.0.

Published by DemoDB; provider repository ↗.

Upstream describes this as the Microsoft Access 2000 Northwind sample converted to SQLite. This repository reproducibly rebuilds the classic seed by executing the pinned create.sql and update.sql in order. The upstream 24.7 MB dist/northwind.db is excluded because it incorporates random rows added by populate.py (16,282 orders and 609,283 order details); the chosen classic seed contains 830 orders and 2,155 order details. Empty CustomerDemographics and CustomerCustomerDemo tables and all 17 upstream views are retained. Upstream SQLite foreign-key declarations are introspected; these are not a claim that SQLite enforces them for every connection. The sha256 identifies the generated fixture at data-source/source.sqlite; recipe inputs are listed by the provider manifest.

Semantic references

Published models

ModelSpec: modelspec://github.com/demo-db/northwind/northwind ↗ · HCL source ↗

MeaningGraph: meaning://github.com/demo-db/northwind ↗

Browse model and meaning files ↗