Database: AdventureWorks2008R2
name AdventureWorks2008R2
collation SQL_Latin1_General_CP1_CI_AS
compatibilityLevel 100
createDate Nov 13 2018 2:17PM
AdventureWorks2008R2_Data D:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\AdventureWorks2008R2_Data.mdf
AdventureWorks2008R2_Log D:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\AdventureWorks2008R2_log.LDF
Statistics
Total number of Tables 71
Total number of Empty Tables 1
Total number of Rows 760838
Total number of Columns 486
Total number of Foreign Keys 91
Total number of Views 20
Total number of Stored Procedures 10
Total number of Functions 11

Summary

Database: AdventureWorks2008R2
# Table Columns Relationships Rows
1 dbo.AWBuildVersion 4 0 1
2 dbo.DatabaseLog 8 0 1597
3 dbo.ErrorLog 9 0
4 HumanResources.Department 4 1 16
5 HumanResources.Employee 16 7 290
6 HumanResources.EmployeeDepartmentHistory 6 3 296
7 HumanResources.EmployeePayHistory 5 1 316
8 HumanResources.JobCandidate 4 1 13
9 HumanResources.Shift 5 1 3
10 Person.Address 9 4 19614
11 Person.AddressType 4 1 6
12 Person.BusinessEntity 3 5 20777
13 Person.BusinessEntityAddress 5 3 19614
14 Person.BusinessEntityContact 5 3 909
15 Person.ContactType 3 1 20
16 Person.CountryRegion 3 3 238
17 Person.EmailAddress 5 1 19972
18 Person.Password 5 1 19972
19 Person.Person 13 8 19972
20 Person.PersonPhone 4 2 19972
21 Person.PhoneNumberType 3 1 3
22 Person.StateProvince 8 4 181
23 Production.BillOfMaterials 9 3 2679
24 Production.Culture 3 1 8
25 Production.Document 14 2 13
26 Production.Illustration 3 1 5
27 Production.Location 5 2 14
28 Production.Product 25 18 504
29 Production.ProductCategory 4 1 4
30 Production.ProductCostHistory 5 1 395
31 Production.ProductDescription 4 1 762
32 Production.ProductDocument 3 2 32
33 Production.ProductInventory 7 2 1069
34 Production.ProductListPriceHistory 5 1 395
35 Production.ProductModel 6 3 128
36 Production.ProductModelIllustration 3 2 7
37 Production.ProductModelProductDescriptionCulture 4 3 762
38 Production.ProductPhoto 6 1 101
39 Production.ProductProductPhoto 4 2 504
40 Production.ProductReview 8 1 4
41 Production.ProductSubcategory 5 2 37
42 Production.ScrapReason 3 1 16
43 Production.TransactionHistory 9 1 113443
44 Production.TransactionHistoryArchive 9 0 89253
45 Production.UnitMeasure 3 4 38
46 Production.WorkOrder 10 3 72591
47 Production.WorkOrderRouting 12 2 67131
48 Purchasing.ProductVendor 11 3 460
49 Purchasing.PurchaseOrderDetail 11 2 8845
50 Purchasing.PurchaseOrderHeader 13 4 4012
51 Purchasing.ShipMethod 6 2 5
52 Purchasing.Vendor 8 3 104
53 Sales.CountryRegionCurrency 3 2 109
54 Sales.CreditCard 6 2 19118
55 Sales.Currency 3 3 105
56 Sales.CurrencyRate 7 3 13532
57 Sales.Customer 7 4 19820
58 Sales.PersonCreditCard 3 2 19118
59 Sales.SalesOrderDetail 11 3 121317
60 Sales.SalesOrderHeader 26 10 31465
61 Sales.SalesOrderHeaderSalesReason 3 2 27647
62 Sales.SalesPerson 9 6 17
63 Sales.SalesPersonQuotaHistory 5 1 163
64 Sales.SalesReason 4 1 10
65 Sales.SalesTaxRate 7 1 29
66 Sales.SalesTerritory 10 6 10
67 Sales.SalesTerritoryHistory 6 2 17
68 Sales.ShoppingCartItem 6 1 3
69 Sales.SpecialOffer 11 1 16
70 Sales.SpecialOfferProduct 4 4 538
71 Sales.Store 6 3 701
Database Relationships
Source

Tables

Table: Address 19614
# Column DataType
1 AddressID int
SalesOrderHeader SalesOrderHeader BusinessEntityAddress
2 AddressLine1 nvarchar(120)
3 AddressLine2 nvarchar(120)
4 City nvarchar(60)
5 StateProvinceID int
StateProvince
6 PostalCode nvarchar(30)
7 SpatialLocation geography
8 rowguid uniqueidentifier
9 ModifiedDate datetime
Relationships
Source
Table: AddressType 6
# Column DataType
1 AddressTypeID int
BusinessEntityAddress
2 Name Name
3 rowguid uniqueidentifier
4 ModifiedDate datetime
Relationships
Source
Table: AWBuildVersion 1
# Column DataType
1 SystemInformationID tinyint
2 Database Version nvarchar(50)
3 VersionDate datetime
4 ModifiedDate datetime
Relationships
Source
Table: BillOfMaterials 2679
# Column DataType
1 BillOfMaterialsID int
2 ProductAssemblyID int
Product
3 ComponentID int
Product
4 StartDate datetime
5 EndDate datetime
6 UnitMeasureCode nchar(6)
UnitMeasure
7 BOMLevel smallint
8 PerAssemblyQty decimal(8,2)
9 ModifiedDate datetime
Relationships
Source
Table: BusinessEntity 20777
# Column DataType
1 BusinessEntityID int
Person Store BusinessEntityAddress BusinessEntityContact Vendor
2 rowguid uniqueidentifier
3 ModifiedDate datetime
Relationships
Source
Table: BusinessEntityAddress 19614
# Column DataType
1 BusinessEntityID int
BusinessEntity
2 AddressID int
Address
3 AddressTypeID int
AddressType
4 rowguid uniqueidentifier
5 ModifiedDate datetime
Relationships
Source
Table: BusinessEntityContact 909
# Column DataType
1 BusinessEntityID int
BusinessEntity
2 PersonID int
Person
3 ContactTypeID int
ContactType
4 rowguid uniqueidentifier
5 ModifiedDate datetime
Relationships
Source
Table: ContactType 20
# Column DataType
1 ContactTypeID int
BusinessEntityContact
2 Name Name
3 ModifiedDate datetime
Relationships
Source
Table: CountryRegion 238
# Column DataType
1 CountryRegionCode nvarchar(6)
SalesTerritory StateProvince CountryRegionCurrency
2 Name Name
3 ModifiedDate datetime
Relationships
Source
Table: CountryRegionCurrency 109
# Column DataType
1 CountryRegionCode nvarchar(6)
CountryRegion
2 CurrencyCode nchar(6)
Currency
3 ModifiedDate datetime
Relationships
Source
Table: CreditCard 19118
# Column DataType
1 CreditCardID int
SalesOrderHeader PersonCreditCard
2 CardType nvarchar(100)
3 CardNumber nvarchar(50)
4 ExpMonth tinyint
5 ExpYear smallint
6 ModifiedDate datetime
Relationships
Source
Table: Culture 8
# Column DataType
1 CultureID nchar(12)
ProductModelProductDescriptionCulture
2 Name Name
3 ModifiedDate datetime
Relationships
Source
Table: Currency 105
# Column DataType
1 CurrencyCode nchar(6)
CountryRegionCurrency CurrencyRate CurrencyRate
2 Name Name
3 ModifiedDate datetime
Relationships
Source
Table: CurrencyRate 13532
# Column DataType
1 CurrencyRateID int
SalesOrderHeader
2 CurrencyRateDate datetime
3 FromCurrencyCode nchar(6)
Currency
4 ToCurrencyCode nchar(6)
Currency
5 AverageRate money
6 EndOfDayRate money
7 ModifiedDate datetime
Relationships
Source
Table: Customer 19820
# Column DataType
1 CustomerID int
SalesOrderHeader
2 PersonID int
Person
3 StoreID int
Store
4 TerritoryID int
SalesTerritory
5 AccountNumber varchar(10)
6 rowguid uniqueidentifier
7 ModifiedDate datetime
Relationships
ufnLeadingZeros Customer
Source
Table: DatabaseLog 1597
# Column DataType
1 DatabaseLogID int
2 PostTime datetime
3 DatabaseUser sysname
4 Event sysname
5 Schema sysname
6 Object sysname
7 TSQL nvarchar(-1)
8 XmlEvent xml
Relationships
Source
Table: Department 16
# Column DataType
1 DepartmentID smallint
EmployeeDepartmentHistory
2 Name Name
3 GroupName Name
4 ModifiedDate datetime
Relationships
Source
Table: Document 13
# Column DataType
1 DocumentNode hierarchyid
ProductDocument
2 DocumentLevel smallint
3 Title nvarchar(100)
4 Owner int
Employee
5 FolderFlag bit
6 FileName nvarchar(800)
7 FileExtension nvarchar(16)
8 Revision nchar(10)
9 ChangeNumber int
10 Status tinyint
11 DocumentSummary nvarchar(-1)
12 Document varbinary
13 rowguid uniqueidentifier
14 ModifiedDate datetime
Relationships
Document
Source
Table: EmailAddress 19972
# Column DataType
1 BusinessEntityID int
Person
2 EmailAddressID int
3 EmailAddress nvarchar(100)
4 rowguid uniqueidentifier
5 ModifiedDate datetime
Relationships
Source
Table: Employee 290
# Column DataType
1 BusinessEntityID int
EmployeeDepartmentHistory EmployeePayHistory SalesPerson JobCandidate PurchaseOrderHeader Document Person
2 NationalIDNumber nvarchar(30)
3 LoginID nvarchar(512)
4 OrganizationNode hierarchyid
5 OrganizationLevel smallint
6 JobTitle nvarchar(100)
7 BirthDate date
8 MaritalStatus nchar(2)
9 Gender nchar(2)
10 HireDate date
11 SalariedFlag Flag
12 VacationHours smallint
13 SickLeaveHours smallint
14 CurrentFlag Flag
15 rowguid uniqueidentifier
16 ModifiedDate datetime
Relationships
Employee
Source
Table: EmployeeDepartmentHistory 296
# Column DataType
1 BusinessEntityID int
Employee
2 DepartmentID smallint
Department
3 ShiftID tinyint
Shift
4 StartDate date
5 EndDate date
6 ModifiedDate datetime
Relationships
Source
Table: EmployeePayHistory 316
# Column DataType
1 BusinessEntityID int
Employee
2 RateChangeDate datetime
3 Rate money
4 PayFrequency tinyint
5 ModifiedDate datetime
Relationships
Source
Table: ErrorLog
# Column DataType
1 ErrorLogID int
2 ErrorTime datetime
3 UserName sysname
4 ErrorNumber int
5 ErrorSeverity int
6 ErrorState int
7 ErrorProcedure nvarchar(252)
8 ErrorLine int
9 ErrorMessage nvarchar(8000)
Relationships
Source
Table: Illustration 5
# Column DataType
1 IllustrationID int
ProductModelIllustration
2 Diagram xml
3 ModifiedDate datetime
Relationships
Source
Table: JobCandidate 13
# Column DataType
1 JobCandidateID int
2 BusinessEntityID int
Employee
3 Resume xml
4 ModifiedDate datetime
Relationships
Source
Table: Location 14
# Column DataType
1 LocationID smallint
ProductInventory WorkOrderRouting
2 Name Name
3 CostRate smallmoney
4 Availability decimal(8,2)
5 ModifiedDate datetime
Relationships
Source
Table: Password 19972
# Column DataType
1 BusinessEntityID int
Person
2 PasswordHash varchar(128)
3 PasswordSalt varchar(10)
4 rowguid uniqueidentifier
5 ModifiedDate datetime
Relationships
Source
Table: Person 19972
# Column DataType
1 BusinessEntityID int
Password PersonCreditCard PersonPhone BusinessEntityContact Customer EmailAddress Employee BusinessEntity
2 PersonType nchar(4)
3 NameStyle NameStyle
4 Title nvarchar(16)
5 FirstName Name
6 MiddleName Name
7 LastName Name
8 Suffix nvarchar(20)
9 EmailPromotion int
10 AdditionalContactInfo xml
11 Demographics xml
12 rowguid uniqueidentifier
13 ModifiedDate datetime
Relationships
Source
Table: PersonCreditCard 19118
# Column DataType
1 BusinessEntityID int
Person
2 CreditCardID int
CreditCard
3 ModifiedDate datetime
Relationships
Source
Table: PersonPhone 19972
# Column DataType
1 BusinessEntityID int
Person
2 PhoneNumber Phone
3 PhoneNumberTypeID int
PhoneNumberType
4 ModifiedDate datetime
Relationships
Source
Table: PhoneNumberType 3
# Column DataType
1 PhoneNumberTypeID int
PersonPhone
2 Name Name
3 ModifiedDate datetime
Relationships
Source
Table: Product 504
# Column DataType
1 ProductID int
SpecialOfferProduct ProductCostHistory ShoppingCartItem ProductInventory ProductDocument BillOfMaterials BillOfMaterials ProductProductPhoto TransactionHistory ProductReview ProductVendor WorkOrder PurchaseOrderDetail ProductListPriceHistory
2 Name Name
3 ProductNumber nvarchar(50)
4 MakeFlag Flag
5 FinishedGoodsFlag Flag
6 Color nvarchar(30)
7 SafetyStockLevel smallint
8 ReorderPoint smallint
9 StandardCost money
10 ListPrice money
11 Size nvarchar(10)
12 SizeUnitMeasureCode nchar(6)
UnitMeasure
13 WeightUnitMeasureCode nchar(6)
UnitMeasure
14 Weight decimal(8,2)
15 DaysToManufacture int
16 ProductLine nchar(4)
17 Class nchar(4)
18 Style nchar(4)
19 ProductSubcategoryID int
ProductSubcategory
20 ProductModelID int
ProductModel
21 SellStartDate datetime
22 SellEndDate datetime
23 DiscontinuedDate datetime
24 rowguid uniqueidentifier
25 ModifiedDate datetime
Relationships
Source
Table: ProductCategory 4
# Column DataType
1 ProductCategoryID int
ProductSubcategory
2 Name Name
3 rowguid uniqueidentifier
4 ModifiedDate datetime
Relationships
Source
Table: ProductCostHistory 395
# Column DataType
1 ProductID int
Product
2 StartDate datetime
3 EndDate datetime
4 StandardCost money
5 ModifiedDate datetime
Relationships
Source
Table: ProductDescription 762
# Column DataType
1 ProductDescriptionID int
ProductModelProductDescriptionCulture
2 Description nvarchar(800)
3 rowguid uniqueidentifier
4 ModifiedDate datetime
Relationships
Source
Table: ProductDocument 32
# Column DataType
1 ProductID int
Product
2 DocumentNode hierarchyid
Document
3 ModifiedDate datetime
Relationships
Source
Table: ProductInventory 1069
# Column DataType
1 ProductID int
Product
2 LocationID smallint
Location
3 Shelf nvarchar(20)
4 Bin tinyint
5 Quantity smallint
6 rowguid uniqueidentifier
7 ModifiedDate datetime
Relationships
Source
Table: ProductListPriceHistory 395
# Column DataType
1 ProductID int
Product
2 StartDate datetime
3 EndDate datetime
4 ListPrice money
5 ModifiedDate datetime
Relationships
Source
Table: ProductModel 128
# Column DataType
1 ProductModelID int
Product ProductModelIllustration ProductModelProductDescriptionCulture
2 Name Name
3 CatalogDescription xml
4 Instructions xml
5 rowguid uniqueidentifier
6 ModifiedDate datetime
Relationships
Source
Table: ProductModelIllustration 7
# Column DataType
1 ProductModelID int
ProductModel
2 IllustrationID int
Illustration
3 ModifiedDate datetime
Relationships
Source
Table: ProductModelProductDescriptionCulture 762
# Column DataType
1 ProductModelID int
ProductModel
2 ProductDescriptionID int
ProductDescription
3 CultureID nchar(12)
Culture
4 ModifiedDate datetime
Relationships
Source
Table: ProductPhoto 101
# Column DataType
1 ProductPhotoID int
ProductProductPhoto
2 ThumbNailPhoto varbinary
3 ThumbnailPhotoFileName nvarchar(100)
4 LargePhoto varbinary
5 LargePhotoFileName nvarchar(100)
6 ModifiedDate datetime
Relationships
Source
Table: ProductProductPhoto 504
# Column DataType
1 ProductID int
Product
2 ProductPhotoID int
ProductPhoto
3 Primary Flag
4 ModifiedDate datetime
Relationships
Source
Table: ProductReview 4
# Column DataType
1 ProductReviewID int
2 ProductID int
Product
3 ReviewerName Name
4 ReviewDate datetime
5 EmailAddress nvarchar(100)
6 Rating int
7 Comments nvarchar(7700)
8 ModifiedDate datetime
Relationships
Source
Table: ProductSubcategory 37
# Column DataType
1 ProductSubcategoryID int
Product
2 ProductCategoryID int
ProductCategory
3 Name Name
4 rowguid uniqueidentifier
5 ModifiedDate datetime
Relationships
Source
Table: ProductVendor 460
# Column DataType
1 ProductID int
Product
2 BusinessEntityID int
Vendor
3 AverageLeadTime int
4 StandardPrice money
5 LastReceiptCost money
6 LastReceiptDate datetime
7 MinOrderQty int
8 MaxOrderQty int
9 OnOrderQty int
10 UnitMeasureCode nchar(6)
UnitMeasure
11 ModifiedDate datetime
Relationships
Source
Table: PurchaseOrderDetail 8845
# Column DataType
1 PurchaseOrderID int
PurchaseOrderHeader
2 PurchaseOrderDetailID int
3 DueDate datetime
4 OrderQty smallint
5 ProductID int
Product
6 UnitPrice money
7 LineTotal money
8 ReceivedQty decimal(8,2)
9 RejectedQty decimal(8,2)
10 StockedQty decimal(9,2)
11 ModifiedDate datetime
Relationships
PurchaseOrderDetail
Source
Table: PurchaseOrderHeader 4012
# Column DataType
1 PurchaseOrderID int
PurchaseOrderDetail
2 RevisionNumber tinyint
3 Status tinyint
4 EmployeeID int
Employee
5 VendorID int
Vendor
6 ShipMethodID int
ShipMethod
7 OrderDate datetime
8 ShipDate datetime
9 SubTotal money
10 TaxAmt money
11 Freight money
12 TotalDue money
13 ModifiedDate datetime
Relationships
PurchaseOrderHeader
Source
Table: SalesOrderDetail 121317
# Column DataType
1 SalesOrderID int
SalesOrderHeader
2 SalesOrderDetailID int
3 CarrierTrackingNumber nvarchar(50)
4 OrderQty smallint
5 ProductID int
SpecialOfferProduct
6 SpecialOfferID int
SpecialOfferProduct
7 UnitPrice money
8 UnitPriceDiscount money
9 LineTotal numeric(38,6)
10 rowguid uniqueidentifier
11 ModifiedDate datetime
Relationships
SalesOrderDetail
Source
Table: SalesOrderHeader 31465
# Column DataType
1 SalesOrderID int
SalesOrderHeaderSalesReason SalesOrderDetail
2 RevisionNumber tinyint
3 OrderDate datetime
4 DueDate datetime
5 ShipDate datetime
6 Status tinyint
7 OnlineOrderFlag Flag
8 SalesOrderNumber nvarchar(50)
9 PurchaseOrderNumber OrderNumber
10 AccountNumber AccountNumber
11 CustomerID int
Customer
12 SalesPersonID int
SalesPerson
13 TerritoryID int
SalesTerritory
14 BillToAddressID int
Address
15 ShipToAddressID int
Address
16 ShipMethodID int
ShipMethod
17 CreditCardID int
CreditCard
18 CreditCardApprovalCode varchar(15)
19 CurrencyRateID int
CurrencyRate
20 SubTotal money
21 TaxAmt money
22 Freight money
23 TotalDue money
24 Comment nvarchar(256)
25 rowguid uniqueidentifier
26 ModifiedDate datetime
Relationships
SalesOrderHeader
Source
Table: SalesOrderHeaderSalesReason 27647
# Column DataType
1 SalesOrderID int
SalesOrderHeader
2 SalesReasonID int
SalesReason
3 ModifiedDate datetime
Relationships
Source
Table: SalesPerson 17
# Column DataType
1 BusinessEntityID int
SalesOrderHeader SalesPersonQuotaHistory SalesTerritoryHistory Store Employee
2 TerritoryID int
SalesTerritory
3 SalesQuota money
4 Bonus money
5 CommissionPct smallmoney
6 SalesYTD money
7 SalesLastYear money
8 rowguid uniqueidentifier
9 ModifiedDate datetime
Relationships
Source
Table: SalesPersonQuotaHistory 163
# Column DataType
1 BusinessEntityID int
SalesPerson
2 QuotaDate datetime
3 SalesQuota money
4 rowguid uniqueidentifier
5 ModifiedDate datetime
Relationships
Source
Table: SalesReason 10
# Column DataType
1 SalesReasonID int
SalesOrderHeaderSalesReason
2 Name Name
3 ReasonType Name
4 ModifiedDate datetime
Relationships
Source
Table: SalesTaxRate 29
# Column DataType
1 SalesTaxRateID int
2 StateProvinceID int
StateProvince
3 TaxType tinyint
4 TaxRate smallmoney
5 Name Name
6 rowguid uniqueidentifier
7 ModifiedDate datetime
Relationships
Source
Table: SalesTerritory 10
# Column DataType
1 TerritoryID int
SalesOrderHeader SalesPerson SalesTerritoryHistory StateProvince Customer
2 Name Name
3 CountryRegionCode nvarchar(6)
CountryRegion
4 Group nvarchar(100)
5 SalesYTD money
6 SalesLastYear money
7 CostYTD money
8 CostLastYear money
9 rowguid uniqueidentifier
10 ModifiedDate datetime
Relationships
Source
Table: SalesTerritoryHistory 17
# Column DataType
1 BusinessEntityID int
SalesPerson
2 TerritoryID int
SalesTerritory
3 StartDate datetime
4 EndDate datetime
5 rowguid uniqueidentifier
6 ModifiedDate datetime
Relationships
Source
Table: ScrapReason 16
# Column DataType
1 ScrapReasonID smallint
WorkOrder
2 Name Name
3 ModifiedDate datetime
Relationships
Source
Table: Shift 3
# Column DataType
1 ShiftID tinyint
EmployeeDepartmentHistory
2 Name Name
3 StartTime time
4 EndTime time
5 ModifiedDate datetime
Relationships
Source
Table: ShipMethod 5
# Column DataType
1 ShipMethodID int
SalesOrderHeader PurchaseOrderHeader
2 Name Name
3 ShipBase money
4 ShipRate money
5 rowguid uniqueidentifier
6 ModifiedDate datetime
Relationships
Source
Table: ShoppingCartItem 3
# Column DataType
1 ShoppingCartItemID int
2 ShoppingCartID nvarchar(100)
3 Quantity int
4 ProductID int
Product
5 DateCreated datetime
6 ModifiedDate datetime
Relationships
Source
Table: SpecialOffer 16
# Column DataType
1 SpecialOfferID int
SpecialOfferProduct
2 Description nvarchar(510)
3 DiscountPct smallmoney
4 Type nvarchar(100)
5 Category nvarchar(100)
6 StartDate datetime
7 EndDate datetime
8 MinQty int
9 MaxQty int
10 rowguid uniqueidentifier
11 ModifiedDate datetime
Relationships
Source
Table: SpecialOfferProduct 538
# Column DataType
1 SpecialOfferID int
SalesOrderDetail SpecialOffer
2 ProductID int
SalesOrderDetail Product
3 rowguid uniqueidentifier
4 ModifiedDate datetime
Relationships
Source
Table: StateProvince 181
# Column DataType
1 StateProvinceID int
SalesTaxRate Address
2 StateProvinceCode nchar(6)
3 CountryRegionCode nvarchar(6)
CountryRegion
4 IsOnlyStateProvinceFlag Flag
5 Name Name
6 TerritoryID int
SalesTerritory
7 rowguid uniqueidentifier
8 ModifiedDate datetime
Relationships
Source
Table: Store 701
# Column DataType
1 BusinessEntityID int
Customer BusinessEntity
2 Name Name
3 SalesPersonID int
SalesPerson
4 Demographics xml
5 rowguid uniqueidentifier
6 ModifiedDate datetime
Relationships
Source
Table: TransactionHistory 113443
# Column DataType
1 TransactionID int
2 ProductID int
Product
3 ReferenceOrderID int
4 ReferenceOrderLineID int
5 TransactionDate datetime
6 TransactionType nchar(2)
7 Quantity int
8 ActualCost money
9 ModifiedDate datetime
Relationships
Source
Table: TransactionHistoryArchive 89253
# Column DataType
1 TransactionID int
2 ProductID int
3 ReferenceOrderID int
4 ReferenceOrderLineID int
5 TransactionDate datetime
6 TransactionType nchar(2)
7 Quantity int
8 ActualCost money
9 ModifiedDate datetime
Relationships
Source
Table: UnitMeasure 38
# Column DataType
1 UnitMeasureCode nchar(6)
Product Product BillOfMaterials ProductVendor
2 Name Name
3 ModifiedDate datetime
Relationships
Source
Table: Vendor 104
# Column DataType
1 BusinessEntityID int
ProductVendor PurchaseOrderHeader BusinessEntity
2 AccountNumber AccountNumber
3 Name Name
4 CreditRating tinyint
5 PreferredVendorStatus Flag
6 ActiveFlag Flag
7 PurchasingWebServiceURL nvarchar(2048)
8 ModifiedDate datetime
Relationships
Source
Table: WorkOrder 72591
# Column DataType
1 WorkOrderID int
WorkOrderRouting
2 ProductID int
Product
3 OrderQty int
4 StockedQty int
5 ScrappedQty smallint
6 StartDate datetime
7 EndDate datetime
8 DueDate datetime
9 ScrapReasonID smallint
ScrapReason
10 ModifiedDate datetime
Relationships
WorkOrder
Source
Table: WorkOrderRouting 67131
# Column DataType
1 WorkOrderID int
WorkOrder
2 ProductID int
3 OperationSequence smallint
4 LocationID smallint
Location
5 ScheduledStartDate datetime
6 ScheduledEndDate datetime
7 ActualStartDate datetime
8 ActualEndDate datetime
9 ActualResourceHrs decimal(9,4)
10 PlannedCost money
11 ActualCost money
12 ModifiedDate datetime
Relationships
Source

Views

View: vAdditionalContactInfo
# Column DataType
1 BusinessEntityID int
2 FirstName Name
3 MiddleName Name
4 LastName Name
5 TelephoneNumber nvarchar(100)
6 TelephoneSpecialInstructions nvarchar(-1)
7 Street nvarchar(100)
8 City nvarchar(100)
9 StateProvince nvarchar(100)
10 PostalCode nvarchar(100)
11 CountryRegion nvarchar(100)
12 HomeAddressSpecialInstructions nvarchar(-1)
13 EMailAddress nvarchar(256)
14 EMailSpecialInstructions nvarchar(-1)
15 EMailTelephoneNumber nvarchar(100)
16 rowguid uniqueidentifier
17 ModifiedDate datetime
Relationships
Person
Source
View: vEmployee
# Column DataType
1 BusinessEntityID int
2 Title nvarchar(16)
3 FirstName Name
4 MiddleName Name
5 LastName Name
6 Suffix nvarchar(20)
7 JobTitle nvarchar(100)
8 PhoneNumber Phone
9 PhoneNumberType Name
10 EmailAddress nvarchar(100)
11 EmailPromotion int
12 AddressLine1 nvarchar(120)
13 AddressLine2 nvarchar(120)
14 City nvarchar(60)
15 StateProvinceName Name
16 PostalCode nvarchar(30)
17 CountryRegionName Name
18 AdditionalContactInfo xml
Relationships
Person PersonPhone PhoneNumberType StateProvince BusinessEntityAddress CountryRegion Address EmailAddress Employee
Source
View: vEmployeeDepartment
# Column DataType
1 BusinessEntityID int
2 Title nvarchar(16)
3 FirstName Name
4 MiddleName Name
5 LastName Name
6 Suffix nvarchar(20)
7 JobTitle nvarchar(100)
8 Department Name
9 GroupName Name
10 StartDate date
Relationships
EmployeeDepartmentHistory Person Department Employee
Source
View: vEmployeeDepartmentHistory
# Column DataType
1 BusinessEntityID int
2 Title nvarchar(16)
3 FirstName Name
4 MiddleName Name
5 LastName Name
6 Suffix nvarchar(20)
7 Shift Name
8 Department Name
9 GroupName Name
10 StartDate date
11 EndDate date
Relationships
EmployeeDepartmentHistory Person Shift Department Employee
Source
View: vIndividualCustomer
# Column DataType
1 BusinessEntityID int
2 Title nvarchar(16)
3 FirstName Name
4 MiddleName Name
5 LastName Name
6 Suffix nvarchar(20)
7 PhoneNumber Phone
8 PhoneNumberType Name
9 EmailAddress nvarchar(100)
10 EmailPromotion int
11 AddressType Name
12 AddressLine1 nvarchar(120)
13 AddressLine2 nvarchar(120)
14 City nvarchar(60)
15 StateProvinceName Name
16 PostalCode nvarchar(30)
17 CountryRegionName Name
18 Demographics xml
Relationships
AddressType Person PersonPhone PhoneNumberType StateProvince BusinessEntityAddress CountryRegion Customer Address EmailAddress
Source
View: vJobCandidate
# Column DataType
1 JobCandidateID int
2 BusinessEntityID int
3 Name.Prefix nvarchar(60)
4 Name.First nvarchar(60)
5 Name.Middle nvarchar(60)
6 Name.Last nvarchar(60)
7 Name.Suffix nvarchar(60)
8 Skills nvarchar(-1)
9 Addr.Type nvarchar(60)
10 Addr.Loc.CountryRegion nvarchar(200)
11 Addr.Loc.State nvarchar(200)
12 Addr.Loc.City nvarchar(200)
13 Addr.PostalCode nvarchar(40)
14 EMail nvarchar(-1)
15 WebSite nvarchar(-1)
16 ModifiedDate datetime
Relationships
JobCandidate
Source
View: vJobCandidateEducation
# Column DataType
1 JobCandidateID int
2 Edu.Level nvarchar(-1)
3 Edu.StartDate datetime
4 Edu.EndDate datetime
5 Edu.Degree nvarchar(100)
6 Edu.Major nvarchar(100)
7 Edu.Minor nvarchar(100)
8 Edu.GPA nvarchar(10)
9 Edu.GPAScale nvarchar(10)
10 Edu.School nvarchar(200)
11 Edu.Loc.CountryRegion nvarchar(200)
12 Edu.Loc.State nvarchar(200)
13 Edu.Loc.City nvarchar(200)
Relationships
JobCandidate
Source
View: vJobCandidateEmployment
# Column DataType
1 JobCandidateID int
2 Emp.StartDate datetime
3 Emp.EndDate datetime
4 Emp.OrgName nvarchar(200)
5 Emp.JobTitle nvarchar(200)
6 Emp.Responsibility nvarchar(-1)
7 Emp.FunctionCategory nvarchar(-1)
8 Emp.IndustryCategory nvarchar(-1)
9 Emp.Loc.CountryRegion nvarchar(-1)
10 Emp.Loc.State nvarchar(-1)
11 Emp.Loc.City nvarchar(-1)
Relationships
JobCandidate
Source
View: vPersonDemographics
# Column DataType
1 BusinessEntityID int
2 TotalPurchaseYTD money
3 DateFirstPurchase datetime
4 BirthDate datetime
5 MaritalStatus nvarchar(2)
6 YearlyIncome nvarchar(60)
7 Gender nvarchar(2)
8 TotalChildren int
9 NumberChildrenAtHome int
10 Education nvarchar(60)
11 Occupation nvarchar(60)
12 HomeOwnerFlag bit
13 NumberCarsOwned int
Relationships
Person
Source
View: vProductAndDescription
# Column DataType
1 ProductID int
2 Name Name
3 ProductModel Name
4 CultureID nchar(12)
5 Description nvarchar(800)
Relationships
ProductModel Product ProductDescription ProductModelProductDescriptionCulture
Source
View: vProductModelCatalogDescription
# Column DataType
1 ProductModelID int
2 Name Name
3 Summary nvarchar(-1)
4 Manufacturer nvarchar(-1)
5 Copyright nvarchar(60)
6 ProductURL nvarchar(512)
7 WarrantyPeriod nvarchar(512)
8 WarrantyDescription nvarchar(512)
9 NoOfYears nvarchar(512)
10 MaintenanceDescription nvarchar(512)
11 Wheel nvarchar(512)
12 Saddle nvarchar(512)
13 Pedal nvarchar(512)
14 BikeFrame nvarchar(-1)
15 Crankset nvarchar(512)
16 PictureAngle nvarchar(512)
17 PictureSize nvarchar(512)
18 ProductPhotoID nvarchar(512)
19 Material nvarchar(512)
20 Color nvarchar(512)
21 ProductLine nvarchar(512)
22 Style nvarchar(512)
23 RiderExperience nvarchar(2048)
24 rowguid uniqueidentifier
25 ModifiedDate datetime
Relationships
ProductModel
Source
View: vProductModelInstructions
# Column DataType
1 ProductModelID int
2 Name Name
3 Instructions nvarchar(-1)
4 LocationID int
5 SetupHours decimal(9,4)
6 MachineHours decimal(9,4)
7 LaborHours decimal(9,4)
8 LotSize int
9 Step nvarchar(2048)
10 rowguid uniqueidentifier
11 ModifiedDate datetime
Relationships
ProductModel
Source
View: vSalesPerson
# Column DataType
1 BusinessEntityID int
2 Title nvarchar(16)
3 FirstName Name
4 MiddleName Name
5 LastName Name
6 Suffix nvarchar(20)
7 JobTitle nvarchar(100)
8 PhoneNumber Phone
9 PhoneNumberType Name
10 EmailAddress nvarchar(100)
11 EmailPromotion int
12 AddressLine1 nvarchar(120)
13 AddressLine2 nvarchar(120)
14 City nvarchar(60)
15 StateProvinceName Name
16 PostalCode nvarchar(30)
17 CountryRegionName Name
18 TerritoryName Name
19 TerritoryGroup nvarchar(100)
20 SalesQuota money
21 SalesYTD money
22 SalesLastYear money
Relationships
SalesPerson Person PersonPhone SalesTerritory PhoneNumberType StateProvince BusinessEntityAddress CountryRegion Address EmailAddress Employee
Source
View: vSalesPersonSalesByFiscalYears
# Column DataType
1 SalesPersonID int
2 FullName nvarchar(304)
3 JobTitle nvarchar(100)
4 SalesTerritory Name
5 2002 money
6 2003 money
7 2004 money
Relationships
SalesOrderHeader SalesPerson Person SalesTerritory Employee
Source
View: vStateProvinceCountryRegion
# Column DataType
1 StateProvinceID int
2 StateProvinceCode nchar(6)
3 IsOnlyStateProvinceFlag Flag
4 StateProvinceName Name
5 TerritoryID int
6 CountryRegionCode nvarchar(6)
7 CountryRegionName Name
Relationships
StateProvince CountryRegion
Source
View: vStoreWithAddresses
# Column DataType
1 BusinessEntityID int
2 Name Name
3 AddressType Name
4 AddressLine1 nvarchar(120)
5 AddressLine2 nvarchar(120)
6 City nvarchar(60)
7 StateProvinceName Name
8 PostalCode nvarchar(30)
9 CountryRegionName Name
Relationships
AddressType StateProvince Store BusinessEntityAddress CountryRegion Address
Source
View: vStoreWithContacts
# Column DataType
1 BusinessEntityID int
2 Name Name
3 ContactType Name
4 Title nvarchar(16)
5 FirstName Name
6 MiddleName Name
7 LastName Name
8 Suffix nvarchar(20)
9 PhoneNumber Phone
10 PhoneNumberType Name
11 EmailAddress nvarchar(100)
12 EmailPromotion int
Relationships
Person PersonPhone PhoneNumberType Store BusinessEntityContact ContactType EmailAddress
Source
View: vStoreWithDemographics
# Column DataType
1 BusinessEntityID int
2 Name Name
3 AnnualSales money
4 AnnualRevenue money
5 BankName nvarchar(100)
6 BusinessType nvarchar(10)
7 YearOpened int
8 Specialty nvarchar(100)
9 SquareFeet int
10 Brands nvarchar(60)
11 Internet nvarchar(60)
12 NumberEmployees int
Relationships
Store
Source
View: vVendorWithAddresses
# Column DataType
1 BusinessEntityID int
2 Name Name
3 AddressType Name
4 AddressLine1 nvarchar(120)
5 AddressLine2 nvarchar(120)
6 City nvarchar(60)
7 StateProvinceName Name
8 PostalCode nvarchar(30)
9 CountryRegionName Name
Relationships
AddressType StateProvince BusinessEntityAddress Vendor CountryRegion Address
Source
View: vVendorWithContacts
# Column DataType
1 BusinessEntityID int
2 Name Name
3 ContactType Name
4 Title nvarchar(16)
5 FirstName Name
6 MiddleName Name
7 LastName Name
8 Suffix nvarchar(20)
9 PhoneNumber Phone
10 PhoneNumberType Name
11 EmailAddress nvarchar(100)
12 EmailPromotion int
Relationships
Person PersonPhone PhoneNumberType BusinessEntityContact ContactType Vendor EmailAddress
Source