Data structure

Schema

13 tables and 17 views from the pinned source fixture. Names and relationships retain the source database’s native shape.

Download schema JSON Browse recordsets

Tables

13 native tables.

Categories4 columns · 8 rows0 foreign-key relationships CustomerCustomerDemo2 columns · 0 rows2 foreign-key relationships CustomerDemographics2 columns · 0 rows0 foreign-key relationships Customers11 columns · 93 rows0 foreign-key relationships EmployeeTerritories2 columns · 49 rows2 foreign-key relationships Employees18 columns · 9 rows1 foreign-key relationships Order Details5 columns · 2,155 rows2 foreign-key relationships Orders14 columns · 830 rows3 foreign-key relationships Products10 columns · 77 rows2 foreign-key relationships Regions2 columns · 4 rows0 foreign-key relationships Shippers3 columns · 3 rows0 foreign-key relationships Suppliers12 columns · 29 rows0 foreign-key relationships Territories3 columns · 53 rows1 foreign-key relationships

Views

17 database views.

Alphabetical list of products11 columns · 69 rowsNative view definition preserved Category Sales for 19972 columns · 0 rowsNative view definition preserved Current Product List2 columns · 69 rowsNative view definition preserved Customer and Suppliers by City4 columns · 122 rowsNative view definition preserved Invoices26 columns · 2,155 rowsNative view definition preserved Order Details Extended7 columns · 2,155 rowsNative view definition preserved Order Subtotals2 columns · 830 rowsNative view definition preserved Orders Qry20 columns · 830 rowsNative view definition preserved Product Sales for 19973 columns · 0 rowsNative view definition preserved ProductDetails_V14 columns · 77 rowsNative view definition preserved Products Above Average Price2 columns · 25 rowsNative view definition preserved Products by Category5 columns · 69 rowsNative view definition preserved Quarterly Orders4 columns · 0 rowsNative view definition preserved Sales Totals by Amount4 columns · 0 rowsNative view definition preserved Sales by Category4 columns · 0 rowsNative view definition preserved Summary of Sales by Quarter3 columns · 809 rowsNative view definition preserved Summary of Sales by Year3 columns · 809 rowsNative view definition preserved

Foreign keys

13 declared relationships.

Including self-references and composite-key tables.

CustomerCustomerDemoCustomerTypeID→CustomerDemographicsCustomerTypeID

CustomerCustomerDemoCustomerID→CustomersCustomerID

EmployeeTerritoriesTerritoryID→TerritoriesTerritoryID

EmployeeTerritoriesEmployeeID→EmployeesEmployeeID

EmployeesReportsTo→EmployeesEmployeeID

Order DetailsProductID→ProductsProductID

Order DetailsOrderID→OrdersOrderID

OrdersShipVia→ShippersShipperID

OrdersCustomerID→CustomersCustomerID

OrdersEmployeeID→EmployeesEmployeeID

ProductsSupplierID→SuppliersSupplierID

ProductsCategoryID→CategoriesCategoryID

TerritoriesRegionID→RegionsRegionID