Northwind SQL playground

MySQL · database ID291816_northwind · read-only

Tables (13)

Categories

CategoryID int
CategoryName varchar(15)
Description mediumtext
Picture longblob

CustomerCustomerDemo

CustomerID varchar(5)
CustomerTypeID varchar(10)

CustomerDemographics

CustomerTypeID varchar(10)
CustomerDesc mediumtext

Customers

CustomerID varchar(5)
CompanyName varchar(40)
ContactName varchar(30)
ContactTitle varchar(30)
Address varchar(60)
City varchar(15)
Region varchar(15)
PostalCode varchar(10)
Country varchar(15)
Phone varchar(24)
Fax varchar(24)

EmployeeTerritories

EmployeeID int
TerritoryID varchar(20)

Employees

EmployeeID int
LastName varchar(20)
FirstName varchar(10)
Title varchar(30)
TitleOfCourtesy varchar(25)
BirthDate datetime
HireDate datetime
Address varchar(60)
City varchar(15)
Region varchar(15)
PostalCode varchar(10)
Country varchar(15)
HomePhone varchar(24)
Extension varchar(4)
Photo longblob
Notes mediumtext
ReportsTo int
PhotoPath varchar(255)
Salary float

OrderDetails

OrderID int
ProductID int
UnitPrice decimal(10,4)
Quantity smallint
Discount double(8,0)

Orders

OrderID int
CustomerID varchar(5)
EmployeeID int
OrderDate datetime
RequiredDate datetime
ShippedDate datetime
ShipVia int
Freight decimal(10,4)
ShipName varchar(40)
ShipAddress varchar(60)
ShipCity varchar(15)
ShipRegion varchar(15)
ShipPostalCode varchar(10)
ShipCountry varchar(15)

Products

ProductID int
ProductName varchar(40)
SupplierID int
CategoryID int
QuantityPerUnit varchar(20)
UnitPrice decimal(10,4)
UnitsInStock smallint
UnitsOnOrder smallint
ReorderLevel smallint
Discontinued bit(1)

Region

RegionID int
RegionDescription varchar(50)

Shippers

ShipperID int
CompanyName varchar(40)
Phone varchar(24)

Suppliers

SupplierID int
CompanyName varchar(40)
ContactName varchar(30)
ContactTitle varchar(30)
Address varchar(60)
City varchar(15)
Region varchar(15)
PostalCode varchar(10)
Country varchar(15)
Phone varchar(24)
Fax varchar(24)
HomePage mediumtext

Territories

TerritoryID varchar(20)
TerritoryDescription varchar(50)
RegionID int