Tables


SchemaSpy Analysis of northwind.db

Generated on Sun Jul 25 17:51 CEST 2021

XML Representation
Insertion Order Deletion Order
TABLES 14
VIEWS 16
COLUMNS 191
Constraints 7
Anomalies 3
Routines 0

Database Properties

Database Type: SQLite - 3.36.0

Tables

Table / View Children Parents Columns Rows Type Comments
CustomerDemographics 1 0 2 0 Table
Order Details 0 2 5 2155 Table
Territories 1 1 3 53 Table
Categories 4 0 4 8 Table
Shippers 1 0 3 3 Table
Customers 5 0 11 93 Table
Employees 4 1 18 9 Table
Products 5 3 10 77 Table
android_metadata 0 0 1 1 Table
CustomerCustomerDemo 0 2 2 0 Table
Regions 1 0 2 4 Table
Orders 8 3 14 830 Table
EmployeeTerritories 0 2 2 49 Table
Suppliers 2 0 12 29 Table
Sales Totals by Amount 0 1 4 0 View
Alphabetical list of products 0 3 11 0 View
Category Sales for 1997 0 0 2 0 View
Order Details Extended 0 2 7 0 View
Summary of Sales by Year 0 1 3 0 View
Current Product List 0 1 2 0 View
Customer and Suppliers by City 0 0 4 0 View
Summary of Sales by Quarter 0 1 3 0 View
Products Above Average Price 0 0 2 0 View
Order Subtotals 0 1 2 0 View
Sales by Category 0 1 4 0 View
Products by Category 0 0 5 0 View
Quarterly Orders 0 1 4 0 View
Invoices 0 3 26 0 View
Orders Qry 0 3 20 0 View
Product Sales for 1997 0 0 3 0 View