dbo dbo Sales Sales Person Person Purchasing Purchasing Production Production HumanResources HumanResources AdventureWorks OLTP Schema November 2005 AdventureWorks OLTP SchemaNovember 2005 Best Print Results if: 11X17 paper Landscape Fit to 1 sheet Best Print Results if:11X17 paperLandscapeFit to 1 sheet Address Address PK AddressID U2 AddressLine1 U2 AddressLine2 U2 City FK1,U2 S... PKAddressIDU2AddressLine1U2AddressLine2U2CityFK1,U2StateProvinceIDU2PostalCodeU1rowguid  ModifiedDate Contact Contact PK ContactID NameStyle Title FirstName MiddleName LastName Su... PKContactID  NameStyle  Title  FirstName  MiddleName  LastName  Suffix  EmailAddress  EmailPromotion  Phone  PasswordHash  PasswordSalt  AdditionalContactInfoU1rowguid  ModifiedDate AddressType AddressType PK AddressTypeID U1 Name U2 rowguid ModifiedDate PKAddressTypeIDU1NameU2rowguid  ModifiedDate ContactType ContactType PK ContactTypeID U1 Name ModifiedDate PKContactTypeIDU1Name  ModifiedDate StateProvince StateProvince PK StateProvinceID U3 StateProvinceCode FK1,U3 CountryRegionC... PKStateProvinceIDU3StateProvinceCodeFK1,U3CountryRegionCode  IsOnlyStateProvinceFlagU1NameFK2TerritoryIDU2rowguid  ModifiedDate CountryRegion CountryRegion PK CountryRegionCode U1 Name ModifiedDate PKCountryRegionCodeU1Name  ModifiedDate Store Store PK,FK1 CustomerID Name Demographics U1 rowguid ModifiedDate F... PK,FK1CustomerID  Name  DemographicsU1rowguid  ModifiedDateFK2SalesPersonID StoreContact StoreContact PK,FK3 CustomerID PK,FK1 ContactID FK2 ContactTypeID U1 rowgu... PK,FK3CustomerIDPK,FK1ContactIDFK2ContactTypeIDU1rowguid  ModifiedDate Individual Individual PK,FK2 CustomerID FK1 ContactID Demographics ModifiedDate PK,FK2CustomerIDFK1ContactID  Demographics  ModifiedDate Customer Customer PK CustomerID FK1 TerritoryID U1 AccountNumber CustomerType U... PKCustomerIDFK1TerritoryIDU1AccountNumber  CustomerTypeU2rowguid  ModifiedDate CustomerAddress CustomerAddress PK,FK3 CustomerID PK,FK1 AddressID FK2 AddressTypeID U1 rowgu... PK,FK3CustomerIDPK,FK1AddressIDFK2AddressTypeIDU1rowguid  ModifiedDate SalesTerritory SalesTerritory PK TerritoryID U1 Name CountryRegionCode Group SalesYTD Sales... PKTerritoryIDU1Name  CountryRegionCode  Group  SalesYTD  SalesLastYear  CostYTD  CostLastYearU2rowguid  ModifiedDate SalesTerritoryHistory SalesTerritoryHistory PK,FK1 SalesPersonID PK,FK2 TerritoryID PK StartDate EndDate ... PK,FK1SalesPersonIDPK,FK2TerritoryIDPKStartDate EndDateU1rowguid  ModifiedDate SalesPersonQuotaHistory SalesPersonQuotaHistory PK,FK1 SalesPersonID PK QuotaDate SalesQuota U1 rowguid Modif... PK,FK1SalesPersonIDPKQuotaDate  SalesQuotaU1rowguid  ModifiedDate SalesPerson SalesPerson PK,FK1 SalesPersonID FK2 TerritoryID SalesQuota Bonus Commiss... PK,FK1SalesPersonIDFK2TerritoryID  SalesQuota  Bonus  CommissionPct  SalesYTD  SalesLastYearU1rowguid  ModifiedDate ContactCreditCard ContactCreditCard PK,FK2 ContactID PK,FK1 CreditCardID ModifiedDate PK,FK2ContactIDPK,FK1CreditCardID  ModifiedDate SalesOrderHeader SalesOrderHeader PK SalesOrderID RevisionNumber OrderDate DueDate ShipDate Sta... PKSalesOrderID  RevisionNumber  OrderDate  DueDate  ShipDate  Status  OnlineOrderFlagU2SalesOrderNumber  PurchaseOrderNumber  AccountNumberFK6CustomerIDFK3ContactIDFK7SalesPersonIDFK8TerritoryIDFK1BillToAddressIDFK2ShipToAddressIDFK4ShipMethodID  CreditCardApprovalCodeFK5CurrencyRateID  SubTotal  TaxAmt  Freight  TotalDue  CommentU1rowguid  ModifiedDateFK9CreditCardID SalesOrderHeaderSalesReason SalesOrderHeaderSalesReason PK,FK1 SalesOrderID PK,FK2 SalesReasonID ModifiedDate PK,FK1SalesOrderIDPK,FK2SalesReasonID  ModifiedDate SalesTaxRate SalesTaxRate PK SalesTaxRateID FK1,U2 StateProvinceID U2 TaxType TaxRate N... PKSalesTaxRateIDFK1,U2StateProvinceIDU2TaxType  TaxRate  NameU1rowguid  ModifiedDate ShoppingCartItem ShoppingCartItem PK ShoppingCartItemID ShoppingCartID Quantity FK1 ProductID D... PKShoppingCartItemID  ShoppingCartID  QuantityFK1ProductID  DateCreated  ModifiedDate Product Product PK ProductID U1 Name U2 ProductNumber MakeFlag FinishedGoodsF... PKProductIDU1NameU2ProductNumber  MakeFlag  FinishedGoodsFlag  Color  SafetyStockLevel  ReorderPoint  StandardCost  ListPrice  SizeFK3SizeUnitMeasureCodeFK4WeightUnitMeasureCode  Weight  DaysToManufacture  ProductLine  Class  StyleFK2ProductSubcategoryIDFK1ProductModelID  SellStartDate  SellEndDate  DiscontinuedDateU3rowguid  ModifiedDate SalesOrderDetail SalesOrderDetail PK,FK1 SalesOrderID PK SalesOrderDetailID CarrierTrackingNumb... PK,FK1SalesOrderIDPKSalesOrderDetailID  CarrierTrackingNumber  OrderQtyFK2ProductIDFK2SpecialOfferID  UnitPrice  UnitPriceDiscount  LineTotalU1rowguid  ModifiedDate Currency Currency PK CurrencyCode U1 Name ModifiedDate PKCurrencyCodeU1Name  ModifiedDate CurrencyRate CurrencyRate PK CurrencyRateID U1 CurrencyRateDate FK1,U1 FromCurrencyCode... PKCurrencyRateIDU1CurrencyRateDateFK1,U1FromCurrencyCodeFK2,U1ToCurrencyCode  AverageRate  EndOfDayRate  ModifiedDate CreditCard CreditCard PK CreditCardID CardType U1 CardNumber ExpMonth ExpYear Modif... PKCreditCardID  CardTypeU1CardNumber  ExpMonth  ExpYear  ModifiedDate SalesReason SalesReason PK SalesReasonID Name ReasonType ModifiedDate PKSalesReasonID  Name  ReasonType  ModifiedDate SpecialOffer SpecialOffer PK SpecialOfferID Description DiscountPct Type Category Start... PKSpecialOfferID  Description  DiscountPct  Type  Category  StartDate  EndDate  MinQty  MaxQtyU1rowguid  ModifiedDate SpecialOfferProduct SpecialOfferProduct PK,FK2 SpecialOfferID PK,FK1 ProductID U1 rowguid ModifiedDate PK,FK2SpecialOfferIDPK,FK1ProductIDU1rowguid  ModifiedDate ProductListPriceHistory ProductListPriceHistory PK,FK1 ProductID PK StartDate EndDate ListPrice ModifiedDate PK,FK1ProductIDPKStartDate  EndDate  ListPrice  ModifiedDate ProductReview ProductReview PK ProductReviewID FK1 ProductID ReviewerName ReviewDate Emai... PKProductReviewIDFK1ProductID  ReviewerName  ReviewDate  EmailAddress  Rating  Comments  ModifiedDate BillOfMaterials BillOfMaterials PK BillOfMaterialsID FK1,U1 ProductAssemblyID FK2,U1 Componen... PKBillOfMaterialsIDFK1,U1ProductAssemblyIDFK2,U1ComponentIDU1StartDate  EndDateFK3UnitMeasureCode  BOMLevel  PerAssemblyQty  ModifiedDate ProductPhoto ProductPhoto PK ProductPhotoID ThumbNailPhoto ThumbnailPhotoFileName Large... PKProductPhotoID  ThumbNailPhoto  ThumbnailPhotoFileName  LargePhoto  LargePhotoFileName  ModifiedDate ProductProductPhoto ProductProductPhoto PK,FK1 ProductID PK,FK2 ProductPhotoID Primary ModifiedDate PK,FK1ProductIDPK,FK2ProductPhotoID  Primary  ModifiedDate ProductSubcategory ProductSubcategory PK ProductSubcategoryID FK1 ProductCategoryID U1 Name U2 rowg... PKProductSubcategoryIDFK1ProductCategoryIDU1NameU2rowguid  ModifiedDate ProductCategory ProductCategory PK ProductCategoryID U1 Name U2 rowguid ModifiedDate PKProductCategoryIDU1NameU2rowguid  ModifiedDate ProductDocument ProductDocument PK,FK2 ProductID PK,FK1 DocumentID ModifiedDate PK,FK2ProductIDPK,FK1DocumentID  ModifiedDate ProductModel ProductModel PK ProductModelID U1 Name CatalogDescription Instructions U2 ... PKProductModelIDU1Name  CatalogDescription  InstructionsU2rowguid  ModifiedDate ProductModelIllustration ProductModelIllustration PK,FK2 ProductModelID PK,FK1 IllustrationID ModifiedDate PK,FK2ProductModelIDPK,FK1IllustrationID  ModifiedDate Illustration Illustration PK IllustrationID Diagram ModifiedDate PKIllustrationID  Diagram  ModifiedDate ProductModelProductDescriptionCulture ProductModelProductDescriptionCulture PK,FK3 ProductModelID PK,FK2 ProductDescriptionID PK,FK1 Cult... PK,FK3ProductModelIDPK,FK2ProductDescriptionIDPK,FK1CultureID  ModifiedDate ProductDescription ProductDescription PK ProductDescriptionID Description U1 rowguid ModifiedDate PKProductDescriptionID  DescriptionU1rowguid  ModifiedDate Culture Culture PK CultureID U1 Name ModifiedDate PKCultureIDU1Name  ModifiedDate UnitMeasure UnitMeasure PK UnitMeasureCode U1 Name ModifiedDate PKUnitMeasureCodeU1Name  ModifiedDate WorkOrderRouting WorkOrderRouting PK,FK2 WorkOrderID PK ProductID PK OperationSequence FK1 Loca... PK,FK2WorkOrderIDPKProductIDPKOperationSequenceFK1LocationID  ScheduledStartDate  ScheduledEndDate  ActualStartDate  ActualEndDate  ActualResourceHrs  PlannedCost  ActualCost  ModifiedDate ProductInventory ProductInventory PK,FK2 ProductID PK,FK1 LocationID Shelf Bin Quantity rowguid... PK,FK2ProductIDPK,FK1LocationID  Shelf  Bin  Quantity  rowguid  ModifiedDate Location Location PK LocationID U1 Name CostRate Availability ModifiedDate PKLocationIDU1Name  CostRate  Availability  ModifiedDate ProductCostHistory ProductCostHistory PK,FK1 ProductID PK StartDate EndDate StandardCost ModifiedDate PK,FK1ProductIDPKStartDate  EndDate  StandardCost  ModifiedDate WorkOrder WorkOrder PK WorkOrderID FK1 ProductID OrderQty StockedQty ScrappedQty ... PKWorkOrderIDFK1ProductID  OrderQty  StockedQty  ScrappedQty  StartDate  EndDate  DueDateFK2ScrapReasonID  ModifiedDate ScrapReason ScrapReason PK ScrapReasonID U1 Name ModifiedDate PKScrapReasonIDU1Name  ModifiedDate TransactionHistory TransactionHistory PK TransactionID FK1 ProductID ReferenceOrderID TransactionDa... PKTransactionIDFK1ProductID  ReferenceOrderID  TransactionDate  TransactionType  Quantity  ActualCost  ModifiedDate  ReferenceOrderLineID TransactionHistoryArchive TransactionHistoryArchive PK TransactionID ProductID ReferenceOrderID TransactionDate T... PKTransactionID  ProductID  ReferenceOrderID  TransactionDate  TransactionType  Quantity  ActualCost  ModifiedDate  ReferenceOrderLineID Document Document PK DocumentID Title U1 FileName FileExtension U1 Revision Cha... PKDocumentID  TitleU1FileName  FileExtensionU1Revision  ChangeNumber  Status  DocumentSummary  Document  ModifiedDate PurchaseOrderDetail PurchaseOrderDetail PK,FK2 ShipMethodID PK,FK2 PurchaseOrderID PK PurchaseOrderDe... PK,FK2ShipMethodIDPK,FK2PurchaseOrderIDPKPurchaseOrderDetailID  DueDate  OrderQtyFK1ProductID  UnitPrice  LineTotal  ReceivedQty  RejectedQty  StockedQty  ModifiedDate PurchaseOrderHeader PurchaseOrderHeader PK PurchaseOrderID PK,FK3 ShipMethodID RevisionNumber Status ... PKPurchaseOrderIDPK,FK3ShipMethodID  RevisionNumber  StatusFK1EmployeeIDFK2VendorID  OrderDate  ShipDate  SubTotal  TaxAmt  Freight  TotalDue  ModifiedDate Vendor Vendor PK VendorID U1 AccountNumber Name CreditRating PreferredVendo... PKVendorIDU1AccountNumber  Name  CreditRating  PreferredVendorStatus  ActiveFlag  PurchasingWebServiceURL  ModifiedDate VendorAddress VendorAddress PK,FK3 VendorID PK,FK1 AddressID FK2 AddressTypeID ModifiedDate PK,FK3VendorIDPK,FK1AddressIDFK2AddressTypeID  ModifiedDate VendorContact VendorContact PK,FK3 VendorID PK,FK1 ContactID FK2 ContactTypeID ModifiedDate PK,FK3VendorIDPK,FK1ContactIDFK2ContactTypeID  ModifiedDate ShipMethod ShipMethod PK ShipMethodID U1 Name ShipBase ShipRate U2 rowguid Modified... PKShipMethodIDU1Name  ShipBase  ShipRateU2rowguid  ModifiedDate ProductVendor ProductVendor PK,FK1 ProductID PK,FK3 VendorID AverageLeadTime StandardPric... PK,FK1ProductIDPK,FK3VendorID  AverageLeadTime  StandardPrice  LastReceiptCost  LastReceiptDate  MinOrderQty  MaxOrderQty  OnOrderQtyFK2UnitMeasureCode  ModifiedDate AWBuildVersion AWBuildVersion PK SystemInformationID Database Version VersionDate ModifiedD... PKSystemInformationID  Database Version  VersionDate  ModifiedDate Employee Employee PK EmployeeID U2 NationalIDNumber FK2 ContactID U1 LoginID FK... PKEmployeeIDU2NationalIDNumberFK2ContactIDU1LoginIDFK1ManagerID  ShiftID  Title  BirthDate  MaritalStatus  Gender  HireDate  SalariedFlag  VacationHours  SickLeaveHours  CurrentFlagU3rowguid  ModifiedDate EmployeeDepartmentHistory EmployeeDepartmentHistory PK,FK2 EmployeeID PK,FK1 DepartmentID PK StartDate PK,FK3 Shi... PK,FK2EmployeeIDPK,FK1DepartmentIDPKStartDatePK,FK3ShiftID  EndDate  ModifiedDate Department Department PK DepartmentID U1 Name GroupName ModifiedDate PKDepartmentIDU1Name  GroupName  ModifiedDate JobCandidate JobCandidate PK JobCandidateID FK1 EmployeeID Resume ModifiedDate PKJobCandidateIDFK1EmployeeID  Resume  ModifiedDate Shift Shift PK ShiftID U1 Name U2 StartTime U2 EndTime ModifiedDate PKShiftIDU1NameU2StartTimeU2EndTime  ModifiedDate EmployeePayHistory EmployeePayHistory PK,FK1 EmployeeID PK RateChangeDate Rate PayFrequency Modifie... PK,FK1EmployeeIDPKRateChangeDate  Rate  PayFrequency  ModifiedDate EmployeeAddress EmployeeAddress PK,FK1 EmployeeID PK,FK2 AddressID U1 rowguid ModifiedDate PK,FK1EmployeeIDPK,FK2AddressIDU1rowguid  ModifiedDate DatabaseLog DatabaseLog PK DatabaseLogID PostTime DatabaseUser Event Schema Object TS... PKDatabaseLogID  PostTime  DatabaseUser  Event  Schema  Object  TSQL  XmlEvent Schemas Schemas Purchasing Purchasing Production Production HumanResources HumanResources Person Person Sales Sales dbo dbo ErrorLog ErrorLog PK ErrorLogID ErrorTime UserName ErrorNumber ErrorSeverity Er... PKErrorLogID  ErrorTime  UserName  ErrorNumber  ErrorSeverity  ErrorState  ErrorProcedure  ErrorLine  ErrorMessage