northwind

Cookbook Diagram

_ address address.AddressID address.AddressLine1 address.AddressLine2 address.City address.StateProvinceID address.PostalCode address.SpatialLocation address.rowguid address.ModifiedDate businessentityaddress businessentityaddress.BusinessEntityID businessentityaddress.AddressID businessentityaddress.AddressTypeID businessentityaddress.rowguid businessentityaddress.ModifiedDate addresstype addresstype.AddressTypeID addresstype.Name addresstype.rowguid addresstype.ModifiedDate countryregion countryregion.CountryRegionCode countryregion.Name countryregion.ModifiedDate customer customer.CustomerID customer.PersonID customer.StoreID customer.TerritoryID customer.AccountNumber customer.rowguid customer.ModifiedDate department department.DepartmentID department.Name department.GroupName department.ModifiedDate employee employee.BusinessEntityID employee.NationalIDNumber employee.LoginID employee.OrganizationNode employee.OrganizationLevel employee.JobTitle employee.BirthDate employee.MaritalStatus employee.Gender employee.HireDate employee.SalariedFlag employee.VacationHours employee.SickLeaveHours employee.CurrentFlag employee.rowguid employee.ModifiedDate employeedepartmenthistory employeedepartmenthistory.BusinessEntityID employeedepartmenthistory.DepartmentID employeedepartmenthistory.ShiftID employeedepartmenthistory.StartDate employeedepartmenthistory.EndDate employeedepartmenthistory.ModifiedDate employeepayhistory employeepayhistory.BusinessEntityID employeepayhistory.RateChangeDate employeepayhistory.Rate employeepayhistory.PayFrequency employeepayhistory.ModifiedDate person person.BusinessEntityID person.PersonType person.NameStyle person.Title person.FirstName person.MiddleName person.LastName person.Suffix person.EmailPromotion person.AdditionalContactInfo person.Demographics person.rowguid person.ModifiedDate personphone personphone.BusinessEntityID personphone.PhoneNumber personphone.PhoneNumberTypeID personphone.ModifiedDate product product.ProductID product.Name product.ProductNumber product.MakeFlag product.FinishedGoodsFlag product.Color product.SafetyStockLevel product.ReorderPoint product.StandardCost product.ListPrice product.Size product.SizeUnitMeasureCode product.WeightUnitMeasureCode product.Weight product.DaysToManufacture product.ProductLine product.Class product.Style product.ProductSubcategoryID product.ProductModelID product.SellStartDate product.SellEndDate product.DiscontinuedDate product.rowguid product.ModifiedDate productinventory productinventory.ProductID productinventory.LocationID productinventory.Shelf productinventory.Bin productinventory.Quantity productinventory.rowguid productinventory.ModifiedDate purchaseorderdetail purchaseorderdetail.PurchaseOrderID purchaseorderdetail.PurchaseOrderDetailID purchaseorderdetail.DueDate purchaseorderdetail.OrderQty purchaseorderdetail.ProductID purchaseorderdetail.UnitPrice purchaseorderdetail.LineTotal purchaseorderdetail.ReceivedQty purchaseorderdetail.RejectedQty purchaseorderdetail.StockedQty purchaseorderdetail.ModifiedDate purchaseorderheader purchaseorderheader.PurchaseOrderID purchaseorderheader.RevisionNumber purchaseorderheader.Status purchaseorderheader.EmployeeID purchaseorderheader.VendorID purchaseorderheader.ShipMethodID purchaseorderheader.OrderDate purchaseorderheader.ShipDate purchaseorderheader.SubTotal purchaseorderheader.TaxAmt purchaseorderheader.Freight purchaseorderheader.TotalDue purchaseorderheader.ModifiedDate salesorderdetail salesorderdetail.SalesOrderID salesorderdetail.SalesOrderDetailID salesorderdetail.CarrierTrackingNumber salesorderdetail.OrderQty salesorderdetail.ProductID salesorderdetail.SpecialOfferID salesorderdetail.UnitPrice salesorderdetail.UnitPriceDiscount salesorderdetail.LineTotal salesorderdetail.rowguid salesorderdetail.ModifiedDate salesorderheader salesorderheader.SalesOrderID salesorderheader.RevisionNumber salesorderheader.OrderDate salesorderheader.DueDate salesorderheader.ShipDate salesorderheader.Status salesorderheader.OnlineOrderFlag salesorderheader.SalesOrderNumber salesorderheader.PurchaseOrderNumber salesorderheader.AccountNumber salesorderheader.CustomerID salesorderheader.SalesPersonID salesorderheader.TerritoryID salesorderheader.BillToAddressID salesorderheader.ShipToAddressID salesorderheader.ShipMethodID salesorderheader.CreditCardID salesorderheader.CreditCardApprovalCode salesorderheader.CurrencyRateID salesorderheader.SubTotal salesorderheader.TaxAmt salesorderheader.Freight salesorderheader.TotalDue salesorderheader.Comment salesorderheader.rowguid salesorderheader.ModifiedDate salestaxrate salestaxrate.SalesTaxRateID salestaxrate.StateProvinceID salestaxrate.TaxType salestaxrate.TaxRate salestaxrate.Name salestaxrate.rowguid salestaxrate.ModifiedDate specialoffer specialoffer.SpecialOfferID specialoffer.Description specialoffer.DiscountPct specialoffer.Type specialoffer.Category specialoffer.StartDate specialoffer.EndDate specialoffer.MinQty specialoffer.MaxQty specialoffer.rowguid specialoffer.ModifiedDate specialofferproduct specialofferproduct.ProductID specialofferproduct.SpecialOfferID specialofferproduct.rowguid specialofferproduct.ModifiedDate stateprovince stateprovince.StateProvinceID stateprovince.StateProvinceCode stateprovince.CountryRegionCode stateprovince.IsOnlyStateProvinceFlag stateprovince.Name stateprovince.TerritoryID stateprovince.rowguid stateprovince.ModifiedDate store store.BusinessEntityID store.Name store.SalesPersonID store.Demographics store.rowguid store.ModifiedDate address JOIN stateprovince ON address.StateProvinceID = stateprovince.StateProvinceID businessentityaddress JOIN address ON businessentityaddress.AddressID = address.AddressID businessentityaddress JOIN addresstype ON businessentityaddress.AddressTypeID = addresstype.AddressTypeID customer JOIN person ON customer.PersonID = person.BusinessEntityID customer JOIN store ON customer.StoreID = store.BusinessEntityID employee JOIN person ON employee.BusinessEntityID = person.BusinessEntityID employeedepartmenthistory JOIN employee ON employeedepartmenthistory.BusinessEntityID = employee.BusinessEntityID employeedepartmenthistory JOIN department ON employeedepartmenthistory.DepartmentID = department.DepartmentID employeepayhistory JOIN employee ON employeepayhistory.BusinessEntityID = employee.BusinessEntityID personphone JOIN person ON personphone.BusinessEntityID = person.BusinessEntityID productinventory JOIN product ON productinventory.ProductID = product.ProductID purchaseorderdetail JOIN purchaseorderheader ON purchaseorderdetail.PurchaseOrderID = purchaseorderheader.PurchaseOrderID purchaseorderdetail JOIN product ON purchaseorderdetail.ProductID = product.ProductID purchaseorderheader JOIN employee ON purchaseorderheader.EmployeeID = employee.BusinessEntityID salesorderdetail JOIN salesorderheader ON salesorderdetail.SalesOrderID = salesorderheader.SalesOrderID salesorderdetail JOIN specialofferproduct ON salesorderdetail.ProductID = specialofferproduct.ProductID and salesorderdetail.SpecialOfferID = specialofferproduct.SpecialOfferID salesorderheader JOIN customer ON salesorderheader.CustomerID = customer.CustomerID salesorderheader JOIN address ON salesorderheader.BillToAddressID = address.AddressID salesorderheader JOIN address ON salesorderheader.ShipToAddressID = address.AddressID salestaxrate JOIN stateprovince ON salestaxrate.StateProvinceID = stateprovince.StateProvinceID specialofferproduct JOIN specialoffer ON specialofferproduct.SpecialOfferID = specialoffer.SpecialOfferID specialofferproduct JOIN product ON specialofferproduct.ProductID = product.ProductID stateprovince JOIN countryregion ON stateprovince.CountryRegionCode = countryregion.CountryRegionCode