Databases

chinook

Album

AlbumId, Title, ArtistId

347 rows

Artist

ArtistId, Name

275 rows

Customer

CustomerId, FirstName, LastName, Company, Address, City, State, Country, PostalCode, Phone, Fax, Email, SupportRepId

59 rows

Employee

EmployeeId, LastName, FirstName, Title, ReportsTo, BirthDate, HireDate, Address, City, State, Country, PostalCode, Phone, Fax, Email

8 rows

Genre

GenreId, Name

25 rows

Invoice

InvoiceId, CustomerId, InvoiceDate, BillingAddress, BillingCity, BillingState, BillingCountry, BillingPostalCode, Total

412 rows

InvoiceLine

InvoiceLineId, InvoiceId, TrackId, UnitPrice, Quantity

2,240 rows

MediaType

MediaTypeId, Name

5 rows

Playlist

PlaylistId, Name

18 rows

PlaylistTrack

PlaylistId, TrackId

8,715 rows

Track

TrackId, Name, AlbumId, MediaTypeId, GenreId, Composer, Milliseconds, Bytes, UnitPrice

3,503 rows

demo

authors

id, name, country

3 rows

books

id, title, author_id, year, genre

4 rows

northwind

Categories

CategoryID, CategoryName, Description, Picture

8 rows

CustomerCustomerDemo

CustomerID, CustomerTypeID

0 rows

CustomerDemographics

CustomerTypeID, CustomerDesc

0 rows

Customers

CustomerID, CompanyName, ContactName, ContactTitle, Address, City, Region, PostalCode, Country, Phone, Fax

93 rows

Employees

EmployeeID, LastName, FirstName, Title, TitleOfCourtesy, BirthDate, HireDate, Address, City, Region, PostalCode, Country, HomePhone, Extension, Photo, Notes, ReportsTo, PhotoPath

9 rows

EmployeeTerritories

EmployeeID, TerritoryID

49 rows

Order Details

OrderID, ProductID, UnitPrice, Quantity, Discount

609,283 rows

Orders

OrderID, CustomerID, EmployeeID, OrderDate, RequiredDate, ShippedDate, ShipVia, Freight, ShipName, ShipAddress, ShipCity, ShipRegion, ShipPostalCode, ShipCountry

16,282 rows

Products

ProductID, ProductName, SupplierID, CategoryID, QuantityPerUnit, UnitPrice, UnitsInStock, UnitsOnOrder, ReorderLevel, Discontinued

77 rows

Regions

RegionID, RegionDescription

4 rows

Shippers

ShipperID, CompanyName, Phone

3 rows

Suppliers

SupplierID, CompanyName, ContactName, ContactTitle, Address, City, Region, PostalCode, Country, Phone, Fax, HomePage

29 rows

Territories

TerritoryID, TerritoryDescription, RegionID

53 rows