Northwind Database
Categories
| ColumnName |
|---|
| CategoryID |
| CategoryName |
| Description |
| Picture |
CustomerCustomerDemo
| ColumnName |
|---|
| CustomerID |
| CustomerTypeID |
CustomerDemographics
| ColumnName |
|---|
| CustomerTypeID |
| CustomerDesc |
Customers
| ColumnName |
|---|
| CustomerID |
| CompanyName |
| ContactName |
| ContactTitle |
| Address |
| City |
| Region |
| PostalCode |
| Country |
| Phone |
| Fax |
Employees
| ColumnName |
|---|
| EmployeeID |
| LastName + FirstName |
| Title |
| TitleOfCourtesy |
| BirthDate |
| HireDate |
| Address |
| City |
| Region |
| PostalCode |
| Country |
| HomePhone |
| Extension |
| Photo |
| notes |
| ReportsTo |
| PhotoPath |
EmployeeTerritories
| ColumnName |
|---|
| EmployeeID |
| TerritoryID |
Order Details
| ColumnName |
|---|
| OrderID |
| ProductID |
| UnitPrice |
| Quantity |
| Discount |
Orders
| ColumnName |
|---|
| OrderID |
| CustomerID |
| EmployeeID |
| OrderDate |
| RequiredDate |
| ShippedDate |
| ShipVia |
| Freight |
| ShipName |
| ShipAddress |
| ShipCity |
| ShipRegion |
| ShipPostalCode |
| ShipCountry |
Products
| ColumnName |
|---|
| ProductID |
| ProductName |
| SupplierID |
| CategoryID |
| QuantityPerUnit |
| UnitPrice |
| UnitsInStock |
| UnitsOnOrder |
| ReorderLevel |
| Discontinued |
Region
| ColumnName |
|---|
| RegionID |
| RegionDescription |
Shippers
| ColumnName |
|---|
| ShipperID |
| CompanyName |
| Phone |
Suppliers
| ColumnName |
|---|
| ShipperID |
| CompanyName |
| Phone |
Territories
| ColumnName |
|---|
| TerritoryID |
| TerritoryDescription |
| RegionID |