AdventureWorks – Data Dictionary

  • AdventureWorks
    • Modules
      • Business Entities
        • Tables
          • Person.Address
            • Person.AddressType
              • Person.BusinessEntity
                • Person.BusinessEntityAddress
                  • Person.BusinessEntityContact
                    • Person.ContactType
                      • Person.CountryRegion
                        • Person.Person
                          • Person.StateProvince
                        • Person
                          • Tables
                            • Person.ContactType
                              • Person.CountryRegion
                                • Person.EmailAddress
                                  • Person.Password
                                    • Person.Person
                                      • Person.PersonPhone
                                        • Person.PhoneNumberType
                                        • Views
                                          • Person.vAdditionalContactInfo
                                            • Person.vStateProvinceCountryRegion
                                          • Human Resources
                                            • Tables
                                              • HumanResources.Department
                                                • HumanResources.Employee
                                                  • HumanResources.EmployeeDepartmentHistory
                                                    • HumanResources.EmployeePayHistory
                                                      • HumanResources.JobCandidate
                                                        • HumanResources.Shift
                                                        • Views
                                                          • HumanResources.vEmployee
                                                            • HumanResources.vEmployeeDepartment
                                                              • HumanResources.vEmployeeDepartmentHistory
                                                                • HumanResources.vJobCandidate
                                                                  • HumanResources.vJobCandidateEducation
                                                                    • HumanResources.vJobCandidateEmployment
                                                                    • Procedures
                                                                      • dbo.uspGetEmployeeManagers
                                                                        • dbo.uspGetManagerEmployees
                                                                          • dbo.uspSearchCandidateResumes
                                                                            • HumanResources.uspUpdateEmployeeHireInfo
                                                                              • HumanResources.uspUpdateEmployeeLogin
                                                                                • HumanResources.uspUpdateEmployeePersonalInfo
                                                                                • Functions
                                                                                  • dbo.ufnGetContactInformation
                                                                                • Products
                                                                                  • Tables
                                                                                    • Production.Culture
                                                                                      • Production.Document
                                                                                        • Production.Illustration
                                                                                          • Production.Product
                                                                                            • Production.ProductCategory
                                                                                              • Production.ProductDescription
                                                                                                • Production.ProductDocument
                                                                                                  • Production.ProductModel
                                                                                                    • Production.ProductModelIllustration
                                                                                                      • Production.ProductModelProductDescriptionCulture
                                                                                                        • Production.ProductPhoto
                                                                                                          • Production.ProductProductPhoto
                                                                                                            • Production.ProductReview
                                                                                                              • Production.ProductSubcategory
                                                                                                                • Production.UnitMeasure
                                                                                                                • Views
                                                                                                                  • Production.vProductAndDescription
                                                                                                                    • Production.vProductModelCatalogDescription
                                                                                                                      • Production.vProductModelInstructions
                                                                                                                      • Procedures
                                                                                                                        • dbo.uspGetBillOfMaterials
                                                                                                                          • dbo.uspGetWhereUsedProductID
                                                                                                                          • Functions
                                                                                                                            • dbo.ufnGetDocumentStatusText
                                                                                                                              • dbo.ufnGetProductDealerPrice
                                                                                                                                • dbo.ufnGetProductListPrice
                                                                                                                                  • dbo.ufnGetProductStandardCost
                                                                                                                                    • dbo.ufnGetStock
                                                                                                                                  • Manufacturing
                                                                                                                                    • Tables
                                                                                                                                      • Production.BillOfMaterials
                                                                                                                                        • Production.ProductCostHistory
                                                                                                                                          • Production.ProductListPriceHistory
                                                                                                                                            • Production.ScrapReason
                                                                                                                                              • Production.TransactionHistory
                                                                                                                                                • Production.TransactionHistoryArchive
                                                                                                                                                  • Production.WorkOrder
                                                                                                                                                    • Production.WorkOrderRouting
                                                                                                                                                  • Purchasing
                                                                                                                                                    • Tables
                                                                                                                                                      • Purchasing.ProductVendor
                                                                                                                                                        • Purchasing.PurchaseOrderDetail
                                                                                                                                                          • Purchasing.PurchaseOrderHeader
                                                                                                                                                            • Purchasing.ShipMethod
                                                                                                                                                              • Purchasing.Vendor
                                                                                                                                                              • Views
                                                                                                                                                                • Purchasing.vVendorWithAddresses
                                                                                                                                                                  • Purchasing.vVendorWithContacts
                                                                                                                                                                  • Functions
                                                                                                                                                                    • dbo.ufnGetPurchaseOrderStatusText
                                                                                                                                                                  • Inventory
                                                                                                                                                                    • Tables
                                                                                                                                                                      • Production.Location
                                                                                                                                                                        • Production.ProductInventory
                                                                                                                                                                      • Sales
                                                                                                                                                                        • Tables
                                                                                                                                                                          • Sales.CountryRegionCurrency
                                                                                                                                                                            • Sales.CreditCard
                                                                                                                                                                              • Sales.Currency
                                                                                                                                                                                • Sales.CurrencyRate
                                                                                                                                                                                  • Sales.Customer
                                                                                                                                                                                    • Sales.PersonCreditCard
                                                                                                                                                                                      • Sales.SalesOrderDetail
                                                                                                                                                                                        • Sales.SalesOrderHeader
                                                                                                                                                                                          • Sales.SalesOrderHeaderSalesReason
                                                                                                                                                                                            • Sales.SalesPerson
                                                                                                                                                                                              • Sales.SalesPersonQuotaHistory
                                                                                                                                                                                                • Sales.SalesReason
                                                                                                                                                                                                  • Sales.SalesTaxRate
                                                                                                                                                                                                    • Sales.SalesTerritory
                                                                                                                                                                                                      • Sales.SalesTerritoryHistory
                                                                                                                                                                                                        • Sales.ShoppingCartItem
                                                                                                                                                                                                          • Sales.SpecialOffer
                                                                                                                                                                                                            • Sales.SpecialOfferProduct
                                                                                                                                                                                                              • Sales.Store
                                                                                                                                                                                                              • Views
                                                                                                                                                                                                                • Sales.vIndividualCustomer
                                                                                                                                                                                                                  • Sales.vPersonDemographics
                                                                                                                                                                                                                    • Sales.vSalesPerson
                                                                                                                                                                                                                      • Sales.vSalesPersonSalesByFiscalYears
                                                                                                                                                                                                                        • Sales.vStoreWithAddresses
                                                                                                                                                                                                                          • Sales.vStoreWithContacts
                                                                                                                                                                                                                            • Sales.vStoreWithDemographics
                                                                                                                                                                                                                            • Functions
                                                                                                                                                                                                                              • dbo.ufnGetAccountingEndDate
                                                                                                                                                                                                                                • dbo.ufnGetAccountingStartDate
                                                                                                                                                                                                                                  • dbo.ufnGetSalesOrderStatusText
                                                                                                                                                                                                                                    • dbo.ufnLeadingZeros
                                                                                                                                                                                                                                  • Admin
                                                                                                                                                                                                                                    • Tables
                                                                                                                                                                                                                                      • dbo.AWBuildVersion
                                                                                                                                                                                                                                        • dbo.DatabaseLog
                                                                                                                                                                                                                                          • dbo.ErrorLog
                                                                                                                                                                                                                                          • Procedures
                                                                                                                                                                                                                                            • dbo.uspLogError
                                                                                                                                                                                                                                              • dbo.uspPrintError
                                                                                                                                                                                                                                          • Tables
                                                                                                                                                                                                                                            • dbo.AWBuildVersion
                                                                                                                                                                                                                                              • dbo.DatabaseLog
                                                                                                                                                                                                                                                • dbo.ErrorLog
                                                                                                                                                                                                                                                  • HumanResources.Department
                                                                                                                                                                                                                                                    • HumanResources.Employee
                                                                                                                                                                                                                                                      • HumanResources.EmployeeDepartmentHistory
                                                                                                                                                                                                                                                        • HumanResources.EmployeePayHistory
                                                                                                                                                                                                                                                          • HumanResources.JobCandidate
                                                                                                                                                                                                                                                            • HumanResources.Shift
                                                                                                                                                                                                                                                              • Person.Address
                                                                                                                                                                                                                                                                • Person.AddressType
                                                                                                                                                                                                                                                                  • Person.BusinessEntity
                                                                                                                                                                                                                                                                    • Person.BusinessEntityAddress
                                                                                                                                                                                                                                                                      • Person.BusinessEntityContact
                                                                                                                                                                                                                                                                        • Person.ContactType
                                                                                                                                                                                                                                                                          • Person.CountryRegion
                                                                                                                                                                                                                                                                            • Person.EmailAddress
                                                                                                                                                                                                                                                                              • Person.Password
                                                                                                                                                                                                                                                                                • Person.Person
                                                                                                                                                                                                                                                                                  • Person.PersonPhone
                                                                                                                                                                                                                                                                                    • Person.PhoneNumberType
                                                                                                                                                                                                                                                                                      • Person.StateProvince
                                                                                                                                                                                                                                                                                        • Production.BillOfMaterials
                                                                                                                                                                                                                                                                                          • Production.Culture
                                                                                                                                                                                                                                                                                            • Production.Document
                                                                                                                                                                                                                                                                                              • Production.Illustration
                                                                                                                                                                                                                                                                                                • Production.Location
                                                                                                                                                                                                                                                                                                  • Production.Product
                                                                                                                                                                                                                                                                                                    • Production.ProductCategory
                                                                                                                                                                                                                                                                                                      • Production.ProductCostHistory
                                                                                                                                                                                                                                                                                                        • Production.ProductDescription
                                                                                                                                                                                                                                                                                                          • Production.ProductDocument
                                                                                                                                                                                                                                                                                                            • Production.ProductInventory
                                                                                                                                                                                                                                                                                                              • Production.ProductListPriceHistory
                                                                                                                                                                                                                                                                                                                • Production.ProductModel
                                                                                                                                                                                                                                                                                                                  • Production.ProductModelIllustration
                                                                                                                                                                                                                                                                                                                    • Production.ProductModelProductDescriptionCulture
                                                                                                                                                                                                                                                                                                                      • Production.ProductPhoto
                                                                                                                                                                                                                                                                                                                        • Production.ProductProductPhoto
                                                                                                                                                                                                                                                                                                                          • Production.ProductReview
                                                                                                                                                                                                                                                                                                                            • Production.ProductSubcategory
                                                                                                                                                                                                                                                                                                                              • Production.ScrapReason
                                                                                                                                                                                                                                                                                                                                • Production.TransactionHistory
                                                                                                                                                                                                                                                                                                                                  • Production.TransactionHistoryArchive
                                                                                                                                                                                                                                                                                                                                    • Production.UnitMeasure
                                                                                                                                                                                                                                                                                                                                      • Production.WorkOrder
                                                                                                                                                                                                                                                                                                                                        • Production.WorkOrderRouting
                                                                                                                                                                                                                                                                                                                                          • Purchasing.ProductVendor
                                                                                                                                                                                                                                                                                                                                            • Purchasing.PurchaseOrderDetail
                                                                                                                                                                                                                                                                                                                                              • Purchasing.PurchaseOrderHeader
                                                                                                                                                                                                                                                                                                                                                • Purchasing.ShipMethod
                                                                                                                                                                                                                                                                                                                                                  • Purchasing.Vendor
                                                                                                                                                                                                                                                                                                                                                    • Sales.CountryRegionCurrency
                                                                                                                                                                                                                                                                                                                                                      • Sales.CreditCard
                                                                                                                                                                                                                                                                                                                                                        • Sales.Currency
                                                                                                                                                                                                                                                                                                                                                          • Sales.CurrencyRate
                                                                                                                                                                                                                                                                                                                                                            • Sales.Customer
                                                                                                                                                                                                                                                                                                                                                              • Sales.PersonCreditCard
                                                                                                                                                                                                                                                                                                                                                                • Sales.SalesOrderDetail
                                                                                                                                                                                                                                                                                                                                                                  • Sales.SalesOrderHeader
                                                                                                                                                                                                                                                                                                                                                                    • Sales.SalesOrderHeaderSalesReason
                                                                                                                                                                                                                                                                                                                                                                      • Sales.SalesPerson
                                                                                                                                                                                                                                                                                                                                                                        • Sales.SalesPersonQuotaHistory
                                                                                                                                                                                                                                                                                                                                                                          • Sales.SalesReason
                                                                                                                                                                                                                                                                                                                                                                            • Sales.SalesTaxRate
                                                                                                                                                                                                                                                                                                                                                                              • Sales.SalesTerritory
                                                                                                                                                                                                                                                                                                                                                                                • Sales.SalesTerritoryHistory
                                                                                                                                                                                                                                                                                                                                                                                  • Sales.ShoppingCartItem
                                                                                                                                                                                                                                                                                                                                                                                    • Sales.SpecialOffer
                                                                                                                                                                                                                                                                                                                                                                                      • Sales.SpecialOfferProduct
                                                                                                                                                                                                                                                                                                                                                                                        • Sales.Store
                                                                                                                                                                                                                                                                                                                                                                                        • Views
                                                                                                                                                                                                                                                                                                                                                                                          • HumanResources.vEmployee
                                                                                                                                                                                                                                                                                                                                                                                            • HumanResources.vEmployeeDepartment
                                                                                                                                                                                                                                                                                                                                                                                              • HumanResources.vEmployeeDepartmentHistory
                                                                                                                                                                                                                                                                                                                                                                                                • HumanResources.vJobCandidate
                                                                                                                                                                                                                                                                                                                                                                                                  • HumanResources.vJobCandidateEducation
                                                                                                                                                                                                                                                                                                                                                                                                    • HumanResources.vJobCandidateEmployment
                                                                                                                                                                                                                                                                                                                                                                                                      • Person.vAdditionalContactInfo
                                                                                                                                                                                                                                                                                                                                                                                                        • Person.vStateProvinceCountryRegion
                                                                                                                                                                                                                                                                                                                                                                                                          • Production.vProductAndDescription
                                                                                                                                                                                                                                                                                                                                                                                                            • Production.vProductModelCatalogDescription
                                                                                                                                                                                                                                                                                                                                                                                                              • Production.vProductModelInstructions
                                                                                                                                                                                                                                                                                                                                                                                                                • Purchasing.vVendorWithAddresses
                                                                                                                                                                                                                                                                                                                                                                                                                  • Purchasing.vVendorWithContacts
                                                                                                                                                                                                                                                                                                                                                                                                                    • Sales.vIndividualCustomer
                                                                                                                                                                                                                                                                                                                                                                                                                      • Sales.vPersonDemographics
                                                                                                                                                                                                                                                                                                                                                                                                                        • Sales.vSalesPerson
                                                                                                                                                                                                                                                                                                                                                                                                                          • Sales.vSalesPersonSalesByFiscalYears
                                                                                                                                                                                                                                                                                                                                                                                                                            • Sales.vStoreWithAddresses
                                                                                                                                                                                                                                                                                                                                                                                                                              • Sales.vStoreWithContacts
                                                                                                                                                                                                                                                                                                                                                                                                                                • Sales.vStoreWithDemographics
                                                                                                                                                                                                                                                                                                                                                                                                                                • Procedures
                                                                                                                                                                                                                                                                                                                                                                                                                                  • dbo.uspGetBillOfMaterials
                                                                                                                                                                                                                                                                                                                                                                                                                                    • dbo.uspGetEmployeeManagers
                                                                                                                                                                                                                                                                                                                                                                                                                                      • dbo.uspGetManagerEmployees
                                                                                                                                                                                                                                                                                                                                                                                                                                        • dbo.uspGetWhereUsedProductID
                                                                                                                                                                                                                                                                                                                                                                                                                                          • dbo.uspLogError
                                                                                                                                                                                                                                                                                                                                                                                                                                            • dbo.uspPrintError
                                                                                                                                                                                                                                                                                                                                                                                                                                              • dbo.uspSearchCandidateResumes
                                                                                                                                                                                                                                                                                                                                                                                                                                                • HumanResources.uspUpdateEmployeeHireInfo
                                                                                                                                                                                                                                                                                                                                                                                                                                                  • HumanResources.uspUpdateEmployeeLogin
                                                                                                                                                                                                                                                                                                                                                                                                                                                    • HumanResources.uspUpdateEmployeePersonalInfo
                                                                                                                                                                                                                                                                                                                                                                                                                                                    • Functions
                                                                                                                                                                                                                                                                                                                                                                                                                                                      • dbo.ufnGetAccountingEndDate
                                                                                                                                                                                                                                                                                                                                                                                                                                                        • dbo.ufnGetAccountingStartDate
                                                                                                                                                                                                                                                                                                                                                                                                                                                          • dbo.ufnGetContactInformation
                                                                                                                                                                                                                                                                                                                                                                                                                                                            • dbo.ufnGetDocumentStatusText
                                                                                                                                                                                                                                                                                                                                                                                                                                                              • dbo.ufnGetProductDealerPrice
                                                                                                                                                                                                                                                                                                                                                                                                                                                                • dbo.ufnGetProductListPrice
                                                                                                                                                                                                                                                                                                                                                                                                                                                                  • dbo.ufnGetProductStandardCost
                                                                                                                                                                                                                                                                                                                                                                                                                                                                    • dbo.ufnGetPurchaseOrderStatusText
                                                                                                                                                                                                                                                                                                                                                                                                                                                                      • dbo.ufnGetSalesOrderStatusText
                                                                                                                                                                                                                                                                                                                                                                                                                                                                        • dbo.ufnGetStock
                                                                                                                                                                                                                                                                                                                                                                                                                                                                          • dbo.ufnLeadingZeros
                                                                                                                                                                                                                                                                                                                                                                                                                                                                        Generated with Dataedo
                                                                                                                                                                                                                                                                                                                                                                                                                                                                        Action cannot be finished