Generated using SQL Data Dictionary demo version.

AdventureWorks2014

(Last updated on Thu, Nov 26th, 2015 at 12:26 PM)

AdventureWorks 2014 Sample OLTP Database

Tables:

Views:

Procedures:

Functions:

Tables:

• Table dbo.AWBuildVersion (1 row)

  
  

  Current version number of the AdventureWorks 2014 sample database.

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	SystemInformationID	tinyint	X
  Primary key for AWBuildVersion records.
  	Database Version	nvarchar(25)
  Version number of the database in 9.yy.mm.dd.00 format.
  	VersionDate	datetime
  Date and time the record was last updated.
  	ModifiedDate	datetime			getdate()
  Date and time the record was last updated.

  
  

  Indexes:

  
  

  • PK_AWBuildVersion_SystemInformationID

    • (Primary Key)
    • (Clustered)
    
    
    

    Primary key (clustered) constraint

    
    
    • SystemInformationID
  
  

• Table dbo.DatabaseLog (1,597 rows)

  
  

  Audit table tracking all DDL changes made to the AdventureWorks database. Data is captured by the database trigger ddlDatabaseTriggerLog.

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	DatabaseLogID	int	X
  Primary key for DatabaseLog records.
  	PostTime	datetime
  The date and time the DDL change occurred.
  	DatabaseUser	sysname(nvarchar(128))
  The user who implemented the DDL change.
  	Event	sysname(nvarchar(128))
  The type of DDL statement that was executed.
  	Schema	sysname(nvarchar(128))		X
  The schema to which the changed object belongs.
  	Object	sysname(nvarchar(128))		X
  The object that was changed by the DDL statment.
  	TSQL	nvarchar(max)
  The exact Transact-SQL statement that was executed.
  	XmlEvent	xml
  The raw XML data generated by database trigger.

  
  

  Indexes:

  
  

  • PK_DatabaseLog_DatabaseLogID

    • (Primary Key)
    
    
    

    Primary key (nonclustered) constraint

    
    
    • DatabaseLogID
  
  

• Table dbo.ErrorLog (0 rows)

  
  

  Audit table tracking errors in the the AdventureWorks database that are caught by the CATCH block of a TRY...CATCH construct. Data is inserted by stored procedure dbo.uspLogError when it is executed from inside the CATCH block of a TRY...CATCH construct.

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	ErrorLogID	int	X
  Primary key for ErrorLog records.
  	ErrorTime	datetime			getdate()
  The date and time at which the error occurred.
  	UserName	sysname(nvarchar(128))
  The user who executed the batch in which the error occurred.
  	ErrorNumber	int
  The error number of the error that occurred.
  	ErrorSeverity	int		X
  The severity of the error that occurred.
  	ErrorState	int		X
  The state number of the error that occurred.
  	ErrorProcedure	nvarchar(126)		X
  The name of the stored procedure or trigger where the error occurred.
  	ErrorLine	int		X
  The line number at which the error occurred.
  	ErrorMessage	nvarchar(4000)
  The message text of the error that occurred.

  
  

  Indexes:

  
  

  • PK_ErrorLog_ErrorLogID

    • (Primary Key)
    • (Clustered)
    
    
    

    Primary key (clustered) constraint

    
    
    • ErrorLogID
  
  

  Used by:

  
  

  • Procedure 

    dbo.uspLogError

    
    
    
    • ErrorLine
    • ErrorMessage
    • ErrorNumber
    • ErrorProcedure
    • ErrorSeverity
    • ErrorState
    • UserName
    
    

• Table HumanResources.Department (16 rows)

  
  

  Lookup table containing the departments within the Adventure Works Cycles company.

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	DepartmentID	smallint	X
  Primary key for Department records.
  UK	Name	Name(nvarchar(50))
  Name of the department.
  	GroupName	Name(nvarchar(50))
  Name of the group to which the department belongs.
  	ModifiedDate	datetime			getdate()
  Date and time the record was last updated.

  
  

  Indexes:

  
  

  • PK_Department_DepartmentID

    • (Primary Key)
    • (Clustered)
    
    
    

    Primary key (clustered) constraint

    
    
    • DepartmentID
  
  

  • AK_Department_Name

    • (Unique)
    
    
    

    Unique nonclustered index.

    
    
    • Name
  
  

  Referenced by:

  
  

  • HumanResources.EmployeeDepartmentHistory

    
    
    
    • DepartmentID
  
  

  Used by:

  
  

  • View 

    HumanResources.vEmployeeDepartment

    
    
    
    • DepartmentID
    • GroupName
    • Name
    
    
  • View 

    HumanResources.vEmployeeDepartmentHistory

    
    
    
    • DepartmentID
    • GroupName
    • Name
    
    

• Table HumanResources.Employee (290 rows)

  
  

  Employee information such as salary, department, and title.

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK, FK	BusinessEntityID	int
  Primary key for Employee records. Foreign key to BusinessEntity.BusinessEntityID.
  UK	NationalIDNumber	nvarchar(15)
  Unique national identification number such as a social security number.
  UK	LoginID	nvarchar(256)
  Network login.
  	OrganizationNode	hierarchyid		X
  Where the employee is located in corporate hierarchy.
  	OrganizationLevel	smallint		X
  The depth of the employee in the corporate hierarchy.
  	JobTitle	nvarchar(50)
  Work title such as Buyer or Sales Representative.
  	BirthDate	date
  Date of birth.
  	MaritalStatus	nchar(1)
  M = Married, S = Single
  	Gender	nchar(1)
  M = Male, F = Female
  	HireDate	date
  Employee hired on this date.
  	SalariedFlag	Flag(bit)			1
  Job classification. 0 = Hourly, not exempt from collective bargaining. 1 = Salaried, exempt from collective bargaining.
  	VacationHours	smallint			0
  Number of available vacation hours.
  	SickLeaveHours	smallint			0
  Number of available sick leave hours.
  	CurrentFlag	Flag(bit)			1
  0 = Inactive, 1 = Active
  UK	rowguid	uniqueidentifier			newid()
  ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
  	ModifiedDate	datetime			getdate()
  Date and time the record was last updated.

  
  

  Indexes:

  
  

  • PK_Employee_BusinessEntityID

    • (Primary Key)
    • (Clustered)
    
    
    

    Primary key (clustered) constraint

    
    
    • BusinessEntityID
  
  

  • AK_Employee_LoginID

    • (Unique)
    
    
    

    Unique nonclustered index.

    
    
    • LoginID
  
  

  • AK_Employee_NationalIDNumber

    • (Unique)
    
    
    

    Unique nonclustered index.

    
    
    • NationalIDNumber
  
  

  • AK_Employee_rowguid

    • (Unique)
    
    
    

    Unique nonclustered index. Used to support replication samples.

    
    
    • rowguid
  
  

  • IX_Employee_OrganizationLevel_OrganizationNode

    
    
    

    Unique nonclustered index.

    
    
    • OrganizationLevel
    • OrganizationNode
  
  

  • IX_Employee_OrganizationNode

    
    
    

    Unique nonclustered index.

    
    
    • OrganizationNode
  
  

  References:

  
  

  • Person.Person

    
    
    
    • BusinessEntityID
  
  

  Referenced by:

  
  

  • HumanResources.EmployeeDepartmentHistory

    
    
    
    • BusinessEntityID
  
  

  • HumanResources.EmployeePayHistory

    
    
    
    • BusinessEntityID
  
  

  • HumanResources.JobCandidate

    
    
    
    • BusinessEntityID
  
  

  • Production.Document

    
    
    
    • Owner (BusinessEntityID)
  
  

  • Purchasing.PurchaseOrderHeader

    
    
    
    • EmployeeID (BusinessEntityID)
  
  

  • Sales.SalesPerson

    
    
    
    • BusinessEntityID
  
  

  Triggers:

  
  

  • dEmployee

    (Instead Of Delete)
    
    

    INSTEAD OF DELETE trigger which keeps Employees from being deleted.

    
    

  Used by:

  
  

  • Function 

    dbo.ufnGetContactInformation

    
    
    
    • BusinessEntityID
    • JobTitle
    
    
  • Procedure 

    dbo.uspGetEmployeeManagers

    
    
    
    • BusinessEntityID
    • JobTitle
    • OrganizationNode
    
    
  • Procedure 

    dbo.uspGetManagerEmployees

    
    
    
    • BusinessEntityID
    • OrganizationNode
    
    
  • Procedure 

    HumanResources.uspUpdateEmployeeHireInfo

    
    
    
    • BusinessEntityID
    • CurrentFlag
    • HireDate
    • JobTitle
    
    
  • Procedure 

    HumanResources.uspUpdateEmployeeLogin

    
    
    
    • BusinessEntityID
    • CurrentFlag
    • HireDate
    • JobTitle
    • LoginID
    • OrganizationNode
    
    
  • Procedure 

    HumanResources.uspUpdateEmployeePersonalInfo

    
    
    
    • BirthDate
    • BusinessEntityID
    • Gender
    • MaritalStatus
    • NationalIDNumber
    
    
  • View 

    HumanResources.vEmployee

    
    
    
    • BusinessEntityID
    • JobTitle
    
    
  • View 

    HumanResources.vEmployeeDepartment

    
    
    
    • BusinessEntityID
    • JobTitle
    
    
  • View 

    HumanResources.vEmployeeDepartmentHistory

    
    
    
    • BusinessEntityID
    
    
  • View 

    Sales.vSalesPerson

    
    
    
    • BusinessEntityID
    • JobTitle
    
    
  • View 

    Sales.vSalesPersonSalesByFiscalYears

    
    
    
    • BusinessEntityID
    • JobTitle
    
    

• Table HumanResources.EmployeeDepartmentHistory (296 rows)

  
  

  Employee department transfers.

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK, FK	BusinessEntityID	int
  Employee identification number. Foreign key to Employee.BusinessEntityID.
  PK, FK	DepartmentID	smallint
  Department in which the employee worked including currently. Foreign key to Department.DepartmentID.
  PK, FK	ShiftID	tinyint
  Identifies which 8-hour shift the employee works. Foreign key to Shift.Shift.ID.
  PK	StartDate	date
  Date the employee started work in the department.
  	EndDate	date		X
  Date the employee left the department. NULL = Current department.
  	ModifiedDate	datetime			getdate()
  Date and time the record was last updated.

  
  

  Indexes:

  
  

  • PK_EmployeeDepartmentHistory_BusinessEntityID_StartDate_DepartmentID

    • (Primary Key)
    • (Clustered)
    
    
    

    Primary key (clustered) constraint

    
    
    • BusinessEntityID
    • StartDate
    • DepartmentID
    • ShiftID
  
  

  • IX_EmployeeDepartmentHistory_DepartmentID

    
    
    

    Nonclustered index.

    
    
    • DepartmentID
  
  

  • IX_EmployeeDepartmentHistory_ShiftID

    
    
    

    Nonclustered index.

    
    
    • ShiftID
  
  

  References:

  
  

  • HumanResources.Department

    
    
    
    • DepartmentID
  
  

  • HumanResources.Employee

    
    
    
    • BusinessEntityID
  
  

  • HumanResources.Shift

    
    
    
    • ShiftID
  
  

  Used by:

  
  

  • View 

    HumanResources.vEmployeeDepartment

    
    
    
    • BusinessEntityID
    • DepartmentID
    • EndDate
    • StartDate
    
    
  • View 

    HumanResources.vEmployeeDepartmentHistory

    
    
    
    • BusinessEntityID
    • DepartmentID
    • EndDate
    • ShiftID
    • StartDate
    
    

• Table HumanResources.EmployeePayHistory (316 rows)

  
  

  Employee pay history.

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK, FK	BusinessEntityID	int
  Employee identification number. Foreign key to Employee.BusinessEntityID.
  PK	RateChangeDate	datetime
  Date the change in pay is effective
  	Rate	money
  Salary hourly rate.
  	PayFrequency	tinyint
  1 = Salary received monthly, 2 = Salary received biweekly
  	ModifiedDate	datetime			getdate()
  Date and time the record was last updated.

  
  

  Indexes:

  
  

  • PK_EmployeePayHistory_BusinessEntityID_RateChangeDate

    • (Primary Key)
    • (Clustered)
    
    
    

    Primary key (clustered) constraint

    
    
    • BusinessEntityID
    • RateChangeDate
  
  

  References:

  
  

  • HumanResources.Employee

    
    
    
    • BusinessEntityID
  
  

  Used by:

  
  

  • Procedure 

    HumanResources.uspUpdateEmployeeHireInfo

    
    
    
    • BusinessEntityID
    • PayFrequency
    • Rate
    • RateChangeDate
    
    

• Table HumanResources.JobCandidate (13 rows)

  
  

  Résumés submitted to Human Resources by job applicants.

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	JobCandidateID	int	X
  Primary key for JobCandidate records.
  FK	BusinessEntityID	int		X
  Employee identification number if applicant was hired. Foreign key to Employee.BusinessEntityID.
  	Resume	xml		X
  Résumé in XML format.
  	ModifiedDate	datetime			getdate()
  Date and time the record was last updated.

  
  

  Indexes:

  
  

  • PK_JobCandidate_JobCandidateID

    • (Primary Key)
    • (Clustered)
    
    
    

    Primary key (clustered) constraint

    
    
    • JobCandidateID
  
  

  • IX_JobCandidate_BusinessEntityID

    
    
    

    Nonclustered index.

    
    
    • BusinessEntityID
  
  

  References:

  
  

  • HumanResources.Employee

    
    
    
    • BusinessEntityID
  
  

  Used by:

  
  

  • Procedure 

    dbo.uspSearchCandidateResumes

    
    
    
    • JobCandidateID
    • Resume
    
    
  • View 

    HumanResources.vJobCandidate

    
    
    
    • BusinessEntityID
    • JobCandidateID
    • ModifiedDate
    • Resume
    
    
  • View 

    HumanResources.vJobCandidateEducation

    
    
    
    • JobCandidateID
    • Resume
    
    
  • View 

    HumanResources.vJobCandidateEmployment

    
    
    
    • JobCandidateID
    • Resume
    
    

• Table HumanResources.Shift (3 rows)

  
  

  Work shift lookup table.

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	ShiftID	tinyint	X
  Primary key for Shift records.
  UK	Name	Name(nvarchar(50))
  Shift description.
  UK	StartTime	time
  Shift start time.
  UK	EndTime	time
  Shift end time.
  	ModifiedDate	datetime			getdate()
  Date and time the record was last updated.

  
  

  Indexes:

  
  

  • PK_Shift_ShiftID

    • (Primary Key)
    • (Clustered)
    
    
    

    Primary key (clustered) constraint

    
    
    • ShiftID
  
  

  • AK_Shift_Name

    • (Unique)
    
    
    

    Unique nonclustered index.

    
    
    • Name
  
  

  • AK_Shift_StartTime_EndTime

    • (Unique)
    
    
    

    Unique nonclustered index.

    
    
    • StartTime
    • EndTime
  
  

  Referenced by:

  
  

  • HumanResources.EmployeeDepartmentHistory

    
    
    
    • ShiftID
  
  

  Used by:

  
  

  • View 

    HumanResources.vEmployeeDepartmentHistory

    
    
    
    • Name
    • ShiftID
    
    

• Table Person.Address (19,614 rows)

  
  

  Street address information for customers, employees, and vendors.

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	AddressID	int	X
  Primary key for Address records.
  UK	AddressLine1	nvarchar(60)
  First street address line.
  UK	AddressLine2	nvarchar(60)		X
  Second street address line.
  UK	City	nvarchar(30)
  Name of the city.
  UK, FK	StateProvinceID	int
  Unique identification number for the state or province. Foreign key to StateProvince table.
  UK	PostalCode	nvarchar(15)
  Postal code for the street address.
  	SpatialLocation	geography		X
  Latitude and longitude of this address.
  UK	rowguid	uniqueidentifier			newid()
  ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
  	ModifiedDate	datetime			getdate()
  Date and time the record was last updated.

  
  

  Indexes:

  
  

  • PK_Address_AddressID

    • (Primary Key)
    • (Clustered)
    
    
    

    Primary key (clustered) constraint

    
    
    • AddressID
  
  

  • AK_Address_rowguid

    • (Unique)
    
    
    

    Unique nonclustered index. Used to support replication samples.

    
    
    • rowguid
  
  

  • IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode

    • (Unique)
    
    
    

    Nonclustered index.

    
    
    • AddressLine1
    • AddressLine2
    • City
    • StateProvinceID
    • PostalCode
  
  

  • IX_Address_StateProvinceID

    
    
    

    Nonclustered index.

    
    
    • StateProvinceID
  
  

  References:

  
  

  • Person.StateProvince

    
    
    
    • StateProvinceID
  
  

  Referenced by:

  
  

  • Person.BusinessEntityAddress

    
    
    
    • AddressID
  
  

  • Sales.SalesOrderHeader

    
    
    
    • BillToAddressID (AddressID)
  
  

  • Sales.SalesOrderHeader

    
    
    
    • ShipToAddressID (AddressID)
  
  

  Used by:

  
  

  • View 

    HumanResources.vEmployee

    
    
    
    • AddressID
    • AddressLine1
    • AddressLine2
    • City
    • PostalCode
    • StateProvinceID
    
    
  • View 

    Purchasing.vVendorWithAddresses

    
    
    
    • AddressID
    • AddressLine1
    • AddressLine2
    • City
    • PostalCode
    • StateProvinceID
    
    
  • View 

    Sales.vIndividualCustomer

    
    
    
    • AddressID
    • AddressLine1
    • AddressLine2
    • City
    • PostalCode
    • StateProvinceID
    
    
  • View 

    Sales.vSalesPerson

    
    
    
    • AddressID
    • AddressLine1
    • AddressLine2
    • City
    • PostalCode
    • StateProvinceID
    
    
  • View 

    Sales.vStoreWithAddresses

    
    
    
    • AddressID
    • AddressLine1
    • AddressLine2
    • City
    • PostalCode
    • StateProvinceID
    
    

• Table Person.AddressType (6 rows)

  
  

  Types of addresses stored in the Address table.

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	AddressTypeID	int	X
  Primary key for AddressType records.
  UK	Name	Name(nvarchar(50))
  Address type description. For example, Billing, Home, or Shipping.
  UK	rowguid	uniqueidentifier			newid()
  ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
  	ModifiedDate	datetime			getdate()
  Date and time the record was last updated.

  
  

  Indexes:

  
  

  • PK_AddressType_AddressTypeID

    • (Primary Key)
    • (Clustered)
    
    
    

    Primary key (clustered) constraint

    
    
    • AddressTypeID
  
  

  • AK_AddressType_Name

    • (Unique)
    
    
    

    Unique nonclustered index.

    
    
    • Name
  
  

  • AK_AddressType_rowguid

    • (Unique)
    
    
    

    Unique nonclustered index. Used to support replication samples.

    
    
    • rowguid
  
  

  Referenced by:

  
  

  • Person.BusinessEntityAddress

    
    
    
    • AddressTypeID
  
  

  Used by:

  
  

  • View 

    Purchasing.vVendorWithAddresses

    
    
    
    • AddressTypeID
    • Name
    
    
  • View 

    Sales.vIndividualCustomer

    
    
    
    • AddressTypeID
    • Name
    
    
  • View 

    Sales.vStoreWithAddresses

    
    
    
    • AddressTypeID
    • Name
    
    

• Table Person.BusinessEntity (20,777 rows)

  
  

  Source of the ID that connects vendors, customers, and employees with address and contact information.

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	BusinessEntityID	int	X
  Primary key for all customers, vendors, and employees.
  UK	rowguid	uniqueidentifier			newid()
  ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
  	ModifiedDate	datetime			getdate()
  Date and time the record was last updated.

  
  

  Indexes:

  
  

  • PK_BusinessEntity_BusinessEntityID

    • (Primary Key)
    • (Clustered)
    
    
    

    Primary key (clustered) constraint

    
    
    • BusinessEntityID
  
  

  • AK_BusinessEntity_rowguid

    • (Unique)
    
    
    

    Unique nonclustered index. Used to support replication samples.

    
    
    • rowguid
  
  

  Referenced by:

  
  

  • Person.BusinessEntityAddress

    
    
    
    • BusinessEntityID
  
  

  • Person.BusinessEntityContact

    
    
    
    • BusinessEntityID
  
  

  • Person.Person

    
    
    
    • BusinessEntityID
  
  

  • Purchasing.Vendor

    
    
    
    • BusinessEntityID
  
  

  • Sales.Store

    
    
    
    • BusinessEntityID
  
  

• Table Person.BusinessEntityAddress (19,614 rows)

  
  

  Cross-reference table mapping customers, vendors, and employees to their addresses.

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK, FK	BusinessEntityID	int
  Primary key. Foreign key to BusinessEntity.BusinessEntityID.
  PK, FK	AddressID	int
  Primary key. Foreign key to Address.AddressID.
  PK, FK	AddressTypeID	int
  Primary key. Foreign key to AddressType.AddressTypeID.
  UK	rowguid	uniqueidentifier			newid()
  ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
  	ModifiedDate	datetime			getdate()
  Date and time the record was last updated.

  
  

  Indexes:

  
  

  • PK_BusinessEntityAddress_BusinessEntityID_AddressID_AddressTypeID

    • (Primary Key)
    • (Clustered)
    
    
    

    Primary key (clustered) constraint

    
    
    • BusinessEntityID
    • AddressID
    • AddressTypeID
  
  

  • AK_BusinessEntityAddress_rowguid

    • (Unique)
    
    
    

    Unique nonclustered index. Used to support replication samples.

    
    
    • rowguid
  
  

  • IX_BusinessEntityAddress_AddressID

    
    
    

    Nonclustered index.

    
    
    • AddressID
  
  

  • IX_BusinessEntityAddress_AddressTypeID

    
    
    

    Nonclustered index.

    
    
    • AddressTypeID
  
  

  References:

  
  

  • Person.Address

    
    
    
    • AddressID
  
  

  • Person.AddressType

    
    
    
    • AddressTypeID
  
  

  • Person.BusinessEntity

    
    
    
    • BusinessEntityID
  
  

  Used by:

  
  

  • View 

    HumanResources.vEmployee

    
    
    
    • AddressID
    • BusinessEntityID
    
    
  • View 

    Purchasing.vVendorWithAddresses

    
    
    
    • AddressID
    • AddressTypeID
    • BusinessEntityID
    
    
  • View 

    Sales.vIndividualCustomer

    
    
    
    • AddressID
    • AddressTypeID
    • BusinessEntityID
    
    
  • View 

    Sales.vSalesPerson

    
    
    
    • AddressID
    • BusinessEntityID
    
    
  • View 

    Sales.vStoreWithAddresses

    
    
    
    • AddressID
    • AddressTypeID
    • BusinessEntityID
    
    

• Table Person.BusinessEntityContact (909 rows)

  
  

  Cross-reference table mapping stores, vendors, and employees to people

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK, FK	BusinessEntityID	int
  Primary key. Foreign key to BusinessEntity.BusinessEntityID.
  PK, FK	PersonID	int
  Primary key. Foreign key to Person.BusinessEntityID.
  PK, FK	ContactTypeID	int
  Primary key. Foreign key to ContactType.ContactTypeID.
  UK	rowguid	uniqueidentifier			newid()
  ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
  	ModifiedDate	datetime			getdate()
  Date and time the record was last updated.

  
  

  Indexes:

  
  

  • PK_BusinessEntityContact_BusinessEntityID_PersonID_ContactTypeID

    • (Primary Key)
    • (Clustered)
    
    
    

    Primary key (clustered) constraint

    
    
    • BusinessEntityID
    • PersonID
    • ContactTypeID
  
  

  • AK_BusinessEntityContact_rowguid

    • (Unique)
    
    
    

    Unique nonclustered index. Used to support replication samples.

    
    
    • rowguid
  
  

  • IX_BusinessEntityContact_ContactTypeID

    
    
    

    Nonclustered index.

    
    
    • ContactTypeID
  
  

  • IX_BusinessEntityContact_PersonID

    
    
    

    Nonclustered index.

    
    
    • PersonID
  
  

  References:

  
  

  • Person.BusinessEntity

    
    
    
    • BusinessEntityID
  
  

  • Person.ContactType

    
    
    
    • ContactTypeID
  
  

  • Person.Person

    
    
    
    • BusinessEntityID (PersonID)
  
  

  Used by:

  
  

  • Function 

    dbo.ufnGetContactInformation

    
    
    
    • BusinessEntityID
    • ContactTypeID
    • PersonID
    
    
  • View 

    Purchasing.vVendorWithContacts

    
    
    
    • BusinessEntityID
    • ContactTypeID
    • PersonID
    
    
  • View 

    Sales.vStoreWithContacts

    
    
    
    • BusinessEntityID
    • ContactTypeID
    • PersonID
    
    

• Table Person.ContactType (20 rows)

  
  

  Lookup table containing the types of business entity contacts.

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	ContactTypeID	int	X
  Primary key for ContactType records.
  UK	Name	Name(nvarchar(50))
  Contact type description.
  	ModifiedDate	datetime			getdate()
  Date and time the record was last updated.

  
  

  Indexes:

  
  

  • PK_ContactType_ContactTypeID

    • (Primary Key)
    • (Clustered)
    
    
    

    Primary key (clustered) constraint

    
    
    • ContactTypeID
  
  

  • AK_ContactType_Name

    • (Unique)
    
    
    

    Unique nonclustered index.

    
    
    • Name
  
  

  Referenced by:

  
  

  • Person.BusinessEntityContact

    
    
    
    • ContactTypeID
  
  

  Used by:

  
  

  • Function 

    dbo.ufnGetContactInformation

    
    
    
    • ContactTypeID
    • Name
    
    
  • View 

    Purchasing.vVendorWithContacts

    
    
    
    • ContactTypeID
    • Name
    
    
  • View 

    Sales.vStoreWithContacts

    
    
    
    • ContactTypeID
    • Name
    
    

• Table Person.CountryRegion (238 rows)

  
  

  Lookup table containing the ISO standard codes for countries and regions.

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	CountryRegionCode	nvarchar(3)
  ISO standard code for countries and regions.
  UK	Name	Name(nvarchar(50))
  Country or region name.
  	ModifiedDate	datetime			getdate()
  Date and time the record was last updated.

  
  

  Indexes:

  
  

  • PK_CountryRegion_CountryRegionCode

    • (Primary Key)
    • (Clustered)
    
    
    

    Primary key (clustered) constraint

    
    
    • CountryRegionCode
  
  

  • AK_CountryRegion_Name

    • (Unique)
    
    
    

    Unique nonclustered index.

    
    
    • Name
  
  

  Referenced by:

  
  

  • Person.StateProvince

    
    
    
    • CountryRegionCode
  
  

  • Sales.CountryRegionCurrency

    
    
    
    • CountryRegionCode
  
  

  • Sales.SalesTerritory

    
    
    
    • CountryRegionCode
  
  

  Used by:

  
  

  • View 

    HumanResources.vEmployee

    
    
    
    • CountryRegionCode
    • Name
    
    
  • View 

    Person.vStateProvinceCountryRegion

    
    
    
    • CountryRegionCode
    • Name
    
    
  • View 

    Purchasing.vVendorWithAddresses

    
    
    
    • CountryRegionCode
    • Name
    
    
  • View 

    Sales.vIndividualCustomer

    
    
    
    • CountryRegionCode
    • Name
    
    
  • View 

    Sales.vSalesPerson

    
    
    
    • CountryRegionCode
    • Name
    
    
  • View 

    Sales.vStoreWithAddresses

    
    
    
    • CountryRegionCode
    • Name
    
    

• Table Person.EmailAddress (19,972 rows)

  
  

  Where to send a person email.

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK, FK	BusinessEntityID	int
  Primary key. Person associated with this email address. Foreign key to Person.BusinessEntityID
  PK	EmailAddressID	int	X
  Primary key. ID of this email address.
  	EmailAddress	nvarchar(50)		X
  E-mail address for the person.
  	rowguid	uniqueidentifier			newid()
  ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
  	ModifiedDate	datetime			getdate()
  Date and time the record was last updated.

  
  

  Indexes:

  
  

  • PK_EmailAddress_BusinessEntityID_EmailAddressID

    • (Primary Key)
    • (Clustered)
    
    
    

    Primary key (clustered) constraint

    
    
    • BusinessEntityID
    • EmailAddressID
  
  

  • IX_EmailAddress_EmailAddress

    
    
    

    Nonclustered index.

    
    
    • EmailAddress
  
  

  References:

  
  

  • Person.Person

    
    
    
    • BusinessEntityID
  
  

  Used by:

  
  

  • View 

    HumanResources.vEmployee

    
    
    
    • BusinessEntityID
    • EmailAddress
    
    
  • View 

    Purchasing.vVendorWithContacts

    
    
    
    • BusinessEntityID
    • EmailAddress
    
    
  • View 

    Sales.vIndividualCustomer

    
    
    
    • BusinessEntityID
    • EmailAddress
    
    
  • View 

    Sales.vSalesPerson

    
    
    
    • BusinessEntityID
    • EmailAddress
    
    
  • View 

    Sales.vStoreWithContacts

    
    
    
    • BusinessEntityID
    • EmailAddress
    
    

• Table Person.Password (19,972 rows)

  
  

  One way hashed authentication information

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK, FK	BusinessEntityID	int
  	PasswordHash	varchar(128)
  Password for the e-mail account.
  	PasswordSalt	varchar(10)
  Random value concatenated with the password string before the password is hashed.
  	rowguid	uniqueidentifier			newid()
  ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
  	ModifiedDate	datetime			getdate()
  Date and time the record was last updated.

  
  

  Indexes:

  
  

  • PK_Password_BusinessEntityID

    • (Primary Key)
    • (Clustered)
    
    
    

    Primary key (clustered) constraint

    
    
    • BusinessEntityID
  
  

  References:

  
  

  • Person.Person

    
    
    
    • BusinessEntityID
  
  

• Table Person.Person (19,972 rows)

  
  

  Human beings involved with AdventureWorks: employees, customer contacts, and vendor contacts.

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK, FK	BusinessEntityID	int
  Primary key for Person records.
  	PersonType	nchar(2)
  Primary type of person: SC = Store Contact, IN = Individual (retail) customer, SP = Sales person, EM = Employee (non-sales), VC = Vendor contact, GC = General contact
  	NameStyle	NameStyle(bit)			0
  0 = The data in FirstName and LastName are stored in western style (first name, last name) order. 1 = Eastern style (last name, first name) order.
  	Title	nvarchar(8)		X
  A courtesy title. For example, Mr. or Ms.
  	FirstName	Name(nvarchar(50))
  First name of the person.
  	MiddleName	Name(nvarchar(50))		X
  Middle name or middle initial of the person.
  	LastName	Name(nvarchar(50))
  Last name of the person.
  	Suffix	nvarchar(10)		X
  Surname suffix. For example, Sr. or Jr.
  	EmailPromotion	int			0
  0 = Contact does not wish to receive e-mail promotions, 1 = Contact does wish to receive e-mail promotions from AdventureWorks, 2 = Contact does wish to receive e-mail promotions from AdventureWorks and selected partners.
  	AdditionalContactInfo	xml		X
  Additional contact information about the person stored in xml format.
  	Demographics	xml		X
  Personal information such as hobbies, and income collected from online shoppers. Used for sales analysis.
  UK	rowguid	uniqueidentifier			newid()
  ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
  	ModifiedDate	datetime			getdate()
  Date and time the record was last updated.

  
  

  Indexes:

  
  

  • PK_Person_BusinessEntityID

    • (Primary Key)
    • (Clustered)
    
    
    

    Primary key (clustered) constraint

    
    
    • BusinessEntityID
  
  

  • AK_Person_rowguid

    • (Unique)
    
    
    

    Unique nonclustered index. Used to support replication samples.

    
    
    • rowguid
  
  

  • IX_Person_LastName_FirstName_MiddleName

    
    
    
    • LastName
    • FirstName
    • MiddleName
  
  

  • PXML_Person_AddContact

    • (XML)
    
    
    

    Primary XML index.

    
    
    • AdditionalContactInfo
  
  

  • PXML_Person_Demographics

    • (XML)
    
    
    

    Primary XML index.

    
    
    • Demographics
  
  

  • XMLPATH_Person_Demographics

    • (XML)
    
    
    

    Secondary XML index for path.

    
    
    • Demographics
  
  

  • XMLPROPERTY_Person_Demographics

    • (XML)
    
    
    

    Secondary XML index for property.

    
    
    • Demographics
  
  

  • XMLVALUE_Person_Demographics

    • (XML)
    
    
    

    Secondary XML index for value.

    
    
    • Demographics
  
  

  References:

  
  

  • Person.BusinessEntity

    
    
    
    • BusinessEntityID
  
  

  Referenced by:

  
  

  • HumanResources.Employee

    
    
    
    • BusinessEntityID
  
  

  • Person.BusinessEntityContact

    
    
    
    • PersonID (BusinessEntityID)
  
  

  • Person.EmailAddress

    
    
    
    • BusinessEntityID
  
  

  • Person.Password

    
    
    
    • BusinessEntityID
  
  

  • Person.PersonPhone

    
    
    
    • BusinessEntityID
  
  

  • Sales.Customer

    
    
    
    • PersonID (BusinessEntityID)
  
  

  • Sales.PersonCreditCard

    
    
    
    • BusinessEntityID
  
  

  Triggers:

  
  

  • iuPerson

    (After Insert, Update)
    
    

    AFTER INSERT, UPDATE trigger inserting Individual only if the Customer does not exist in the Store table and setting the ModifiedDate column in the Person table to the current date.

    
    

  Used by:

  
  

  • Function 

    dbo.ufnGetContactInformation

    
    
    
    • BusinessEntityID
    • FirstName
    • LastName
    
    
  • Procedure 

    dbo.uspGetEmployeeManagers

    
    
    
    • BusinessEntityID
    • FirstName
    • LastName
    
    
  • Procedure 

    dbo.uspGetManagerEmployees

    
    
    
    • BusinessEntityID
    • FirstName
    • LastName
    
    
  • Trigger 

    Sales.iduSalesOrderDetail on Sales.SalesOrderDetail

    
    
    
    • BusinessEntityID
    • Demographics
    
    
  • View 

    HumanResources.vEmployee

    
    
    
    • AdditionalContactInfo
    • BusinessEntityID
    • EmailPromotion
    • FirstName
    • LastName
    • MiddleName
    • Suffix
    • Title
    
    
  • View 

    HumanResources.vEmployeeDepartment

    
    
    
    • BusinessEntityID
    • FirstName
    • LastName
    • MiddleName
    • Suffix
    • Title
    
    
  • View 

    HumanResources.vEmployeeDepartmentHistory

    
    
    
    • BusinessEntityID
    • FirstName
    • LastName
    • MiddleName
    • Suffix
    • Title
    
    
  • View 

    Person.vAdditionalContactInfo

    
    
    
    • AdditionalContactInfo
    • BusinessEntityID
    • FirstName
    • LastName
    • MiddleName
    • ModifiedDate
    • rowguid
    
    
  • View 

    Purchasing.vVendorWithContacts

    
    
    
    • BusinessEntityID
    • EmailPromotion
    • FirstName
    • LastName
    • MiddleName
    • Suffix
    • Title
    
    
  • View 

    Sales.vIndividualCustomer

    
    
    
    • BusinessEntityID
    • Demographics
    • EmailPromotion
    • FirstName
    • LastName
    • MiddleName
    • Suffix
    • Title
    
    
  • View 

    Sales.vPersonDemographics

    
    
    
    • BusinessEntityID
    • Demographics
    
    
  • View 

    Sales.vSalesPerson

    
    
    
    • BusinessEntityID
    • EmailPromotion
    • FirstName
    • LastName
    • MiddleName
    • Suffix
    • Title
    
    
  • View 

    Sales.vSalesPersonSalesByFiscalYears

    
    
    
    • BusinessEntityID
    • FirstName
    • LastName
    • MiddleName
    
    
  • View 

    Sales.vStoreWithContacts

    
    
    
    • BusinessEntityID
    • EmailPromotion
    • FirstName
    • LastName
    • MiddleName
    • Suffix
    • Title
    
    

• Table Person.PersonPhone (19,972 rows)

  
  

  Telephone number and type of a person.

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK, FK	BusinessEntityID	int
  Business entity identification number. Foreign key to Person.BusinessEntityID.
  PK	PhoneNumber	Phone(nvarchar(25))
  Telephone number identification number.
  PK, FK	PhoneNumberTypeID	int
  Kind of phone number. Foreign key to PhoneNumberType.PhoneNumberTypeID.
  	ModifiedDate	datetime			getdate()
  Date and time the record was last updated.

  
  

  Indexes:

  
  

  • PK_PersonPhone_BusinessEntityID_PhoneNumber_PhoneNumberTypeID

    • (Primary Key)
    • (Clustered)
    
    
    

    Primary key (clustered) constraint

    
    
    • BusinessEntityID
    • PhoneNumber
    • PhoneNumberTypeID
  
  

  • IX_PersonPhone_PhoneNumber

    
    
    

    Nonclustered index.

    
    
    • PhoneNumber
  
  

  References:

  
  

  • Person.Person

    
    
    
    • BusinessEntityID
  
  

  • Person.PhoneNumberType

    
    
    
    • PhoneNumberTypeID
  
  

  Used by:

  
  

  • View 

    HumanResources.vEmployee

    
    
    
    • BusinessEntityID
    • PhoneNumber
    • PhoneNumberTypeID
    
    
  • View 

    Purchasing.vVendorWithContacts

    
    
    
    • BusinessEntityID
    • PhoneNumber
    • PhoneNumberTypeID
    
    
  • View 

    Sales.vIndividualCustomer

    
    
    
    • BusinessEntityID
    • PhoneNumber
    • PhoneNumberTypeID
    
    
  • View 

    Sales.vSalesPerson

    
    
    
    • BusinessEntityID
    • PhoneNumber
    • PhoneNumberTypeID
    
    
  • View 

    Sales.vStoreWithContacts

    
    
    
    • BusinessEntityID
    • PhoneNumber
    • PhoneNumberTypeID
    
    

• Table Person.PhoneNumberType (3 rows)

  
  

  Type of phone number of a person.

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	PhoneNumberTypeID	int	X
  Primary key for telephone number type records.
  	Name	Name(nvarchar(50))
  Name of the telephone number type
  	ModifiedDate	datetime			getdate()
  Date and time the record was last updated.

  
  

  Indexes:

  
  

  • PK_PhoneNumberType_PhoneNumberTypeID

    • (Primary Key)
    • (Clustered)
    
    
    

    Primary key (clustered) constraint

    
    
    • PhoneNumberTypeID
  
  

  Referenced by:

  
  

  • Person.PersonPhone

    
    
    
    • PhoneNumberTypeID
  
  

  Used by:

  
  

  • View 

    HumanResources.vEmployee

    
    
    
    • Name
    • PhoneNumberTypeID
    
    
  • View 

    Purchasing.vVendorWithContacts

    
    
    
    • Name
    • PhoneNumberTypeID
    
    
  • View 

    Sales.vIndividualCustomer

    
    
    
    • Name
    • PhoneNumberTypeID
    
    
  • View 

    Sales.vSalesPerson

    
    
    
    • Name
    • PhoneNumberTypeID
    
    
  • View 

    Sales.vStoreWithContacts

    
    
    
    • Name
    • PhoneNumberTypeID
    
    

• Table Person.StateProvince (181 rows)

  
  

  State and province lookup table.

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	StateProvinceID	int	X
  Primary key for StateProvince records.
  UK	StateProvinceCode	nchar(3)
  ISO standard state or province code.
  UK, FK	CountryRegionCode	nvarchar(3)
  ISO standard country or region code. Foreign key to CountryRegion.CountryRegionCode.
  	IsOnlyStateProvinceFlag	Flag(bit)			1
  0 = StateProvinceCode exists. 1 = StateProvinceCode unavailable, using CountryRegionCode.
  UK	Name	Name(nvarchar(50))
  State or province description.
  FK	TerritoryID	int
  ID of the territory in which the state or province is located. Foreign key to SalesTerritory.SalesTerritoryID.
  UK	rowguid	uniqueidentifier			newid()
  ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
  	ModifiedDate	datetime			getdate()
  Date and time the record was last updated.

  
  

  Indexes:

  
  

  • PK_StateProvince_StateProvinceID

    • (Primary Key)
    • (Clustered)
    
    
    

    Primary key (clustered) constraint

    
    
    • StateProvinceID
  
  

  • AK_StateProvince_Name

    • (Unique)
    
    
    

    Unique nonclustered index.

    
    
    • Name
  
  

  • AK_StateProvince_rowguid

    • (Unique)
    
    
    

    Unique nonclustered index. Used to support replication samples.

    
    
    • rowguid
  
  

  • AK_StateProvince_StateProvinceCode_CountryRegionCode

    • (Unique)
    
    
    

    Unique nonclustered index.

    
    
    • StateProvinceCode
    • CountryRegionCode
  
  

  References:

  
  

  • Person.CountryRegion

    
    
    
    • CountryRegionCode
  
  

  • Sales.SalesTerritory

    
    
    
    • TerritoryID
  
  

  Referenced by:

  
  

  • Person.Address

    
    
    
    • StateProvinceID
  
  

  • Sales.SalesTaxRate

    
    
    
    • StateProvinceID
  
  

  Used by:

  
  

  • View 

    HumanResources.vEmployee

    
    
    
    • CountryRegionCode
    • Name
    • StateProvinceID
    
    
  • View 

    Person.vStateProvinceCountryRegion

    
    
    
    • CountryRegionCode
    • IsOnlyStateProvinceFlag
    • Name
    • StateProvinceCode
    • StateProvinceID
    • TerritoryID
    
    
  • View 

    Purchasing.vVendorWithAddresses

    
    
    
    • CountryRegionCode
    • Name
    • StateProvinceID
    
    
  • View 

    Sales.vIndividualCustomer

    
    
    
    • CountryRegionCode
    • Name
    • StateProvinceID
    
    
  • View 

    Sales.vSalesPerson

    
    
    
    • CountryRegionCode
    • Name
    • StateProvinceID
    
    
  • View 

    Sales.vStoreWithAddresses

    
    
    
    • CountryRegionCode
    • Name
    • StateProvinceID
    
    

• Table Production.BillOfMaterials (2,679 rows)

  
  

  Items required to make bicycles and bicycle subassemblies. It identifies the heirarchical relationship between a parent product and its components.

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	BillOfMaterialsID	int	X
  Primary key for BillOfMaterials records.
  UK, FK	ProductAssemblyID	int		X
  Parent product identification number. Foreign key to Product.ProductID.
  UK, FK	ComponentID	int
  Component identification number. Foreign key to Product.ProductID.
  UK	StartDate	datetime			getdate()
  Date the component started being used in the assembly item.
  	EndDate	datetime		X
  Date the component stopped being used in the assembly item.
  FK	UnitMeasureCode	nchar(3)
  Standard code identifying the unit of measure for the quantity.
  	BOMLevel	smallint
  Indicates the depth the component is from its parent (AssemblyID).
  	PerAssemblyQty	decimal(8,2)			1.00
  Quantity of the component needed to create the assembly.
  	ModifiedDate	datetime			getdate()
  Date and time the record was last updated.

  
  

  Indexes:

  
  

  • PK_BillOfMaterials_BillOfMaterialsID

    • (Primary Key)
    
    
    

    Primary key (clustered) constraint

    
    
    • BillOfMaterialsID
  
  

  • AK_BillOfMaterials_ProductAssemblyID_ComponentID_StartDate

    • (Unique)
    • (Clustered)
    
    
    

    Clustered index.

    
    
    • ProductAssemblyID
    • ComponentID
    • StartDate
  
  

  • IX_BillOfMaterials_UnitMeasureCode

    
    
    

    Nonclustered index.

    
    
    • UnitMeasureCode
  
  

  References:

  
  

  • Production.Product

    
    
    
    • ProductID (ComponentID)
  
  

  • Production.Product

    
    
    
    • ProductID (ProductAssemblyID)
  
  

  • Production.UnitMeasure

    
    
    
    • UnitMeasureCode
  
  

  Used by:

  
  

  • Procedure 

    dbo.uspGetBillOfMaterials

    
    
    
    • BOMLevel
    • ComponentID
    • EndDate
    • PerAssemblyQty
    • ProductAssemblyID
    • StartDate
    
    
  • Procedure 

    dbo.uspGetWhereUsedProductID

    
    
    
    • BOMLevel
    • ComponentID
    • EndDate
    • PerAssemblyQty
    • ProductAssemblyID
    • StartDate
    
    

• Table Production.Culture (8 rows)

  
  

  Lookup table containing the languages in which some AdventureWorks data is stored.

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	CultureID	nchar(6)
  Primary key for Culture records.
  UK	Name	Name(nvarchar(50))
  Culture description.
  	ModifiedDate	datetime			getdate()
  Date and time the record was last updated.

  
  

  Indexes:

  
  

  • PK_Culture_CultureID

    • (Primary Key)
    • (Clustered)
    
    
    

    Primary key (clustered) constraint

    
    
    • CultureID
  
  

  • AK_Culture_Name

    • (Unique)
    
    
    

    Unique nonclustered index.

    
    
    • Name
  
  

  Referenced by:

  
  

  • Production.ProductModelProductDescriptionCulture

    
    
    
    • CultureID
  
  

• Table Production.Document (13 rows)

  
  

  Product maintenance documents.

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK,  UK	DocumentNode	hierarchyid
  Primary key for Document records.
  UK	DocumentLevel	smallint		X
  Depth in the document hierarchy.
  	Title	nvarchar(50)
  Title of the document.
  FK	Owner	int
  Employee who controls the document. Foreign key to Employee.BusinessEntityID
  	FolderFlag	bit			0
  0 = This is a folder, 1 = This is a document.
  	FileName	nvarchar(400)
  File name of the document
  	FileExtension	nvarchar(8)
  File extension indicating the document type. For example, .doc or .txt.
  	Revision	nchar(5)
  Revision number of the document.
  	ChangeNumber	int			0
  Engineering change approval number.
  	Status	tinyint
  1 = Pending approval, 2 = Approved, 3 = Obsolete
  	DocumentSummary	nvarchar(max)		X
  Document abstract.
  	Document	varbinary(max)		X
  Complete document.
  UK	rowguid	uniqueidentifier			newid()
  ROWGUIDCOL number uniquely identifying the record. Required for FileStream.
  	ModifiedDate	datetime			getdate()
  Date and time the record was last updated.

  
  

  Indexes:

  
  

  • PK_Document_DocumentNode

    • (Primary Key)
    • (Clustered)
    
    
    

    Primary key (clustered) constraint

    
    
    • DocumentNode
  
  

  • AK_Document_DocumentLevel_DocumentNode

    • (Unique)
    
    
    

    Unique nonclustered index.

    
    
    • DocumentLevel
    • DocumentNode
  
  

  • AK_Document_rowguid

    • (Unique)
    
    
    

    Unique nonclustered index. Used to support FileStream.

    
    
    • rowguid
  
  

  • UQ__Document__F73921F763026E5E

    • (Unique)
    
    
    
    • rowguid
  
  

  • IX_Document_FileName_Revision

    
    
    

    Unique nonclustered index.

    
    
    • FileName
    • Revision
  
  

  References:

  
  

  • HumanResources.Employee

    
    
    
    • BusinessEntityID (Owner)
  
  

  Referenced by:

  
  

  • Production.ProductDocument

    
    
    
    • DocumentNode
  
  

• Table Production.Illustration (5 rows)

  
  

  Bicycle assembly diagrams.

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	IllustrationID	int	X
  Primary key for Illustration records.
  	Diagram	xml		X
  Illustrations used in manufacturing instructions. Stored as XML.
  	ModifiedDate	datetime			getdate()
  Date and time the record was last updated.

  
  

  Indexes:

  
  

  • PK_Illustration_IllustrationID

    • (Primary Key)
    • (Clustered)
    
    
    

    Primary key (clustered) constraint

    
    
    • IllustrationID
  
  

  Referenced by:

  
  

  • Production.ProductModelIllustration

    
    
    
    • IllustrationID
  
  

• Table Production.Location (14 rows)

  
  

  Product inventory and manufacturing locations.

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	LocationID	smallint	X
  Primary key for Location records.
  UK	Name	Name(nvarchar(50))
  Location description.
  	CostRate	smallmoney			0.00
  Standard hourly cost of the manufacturing location.
  	Availability	decimal(8,2)			0.00
  Work capacity (in hours) of the manufacturing location.
  	ModifiedDate	datetime			getdate()
  Date and time the record was last updated.

  
  

  Indexes:

  
  

  • PK_Location_LocationID

    • (Primary Key)
    • (Clustered)
    
    
    

    Primary key (clustered) constraint

    
    
    • LocationID
  
  

  • AK_Location_Name

    • (Unique)
    
    
    

    Unique nonclustered index.

    
    
    • Name
  
  

  Referenced by:

  
  

  • Production.ProductInventory

    
    
    
    • LocationID
  
  

  • Production.WorkOrderRouting

    
    
    
    • LocationID
  
  

• Table Production.Product (504 rows)

  
  

  Products sold or used in the manfacturing of sold products.

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	ProductID	int	X
  Primary key for Product records.
  UK	Name	Name(nvarchar(50))
  Name of the product.
  UK	ProductNumber	nvarchar(25)
  Unique product identification number.
  	MakeFlag	Flag(bit)			1
  0 = Product is purchased, 1 = Product is manufactured in-house.
  	FinishedGoodsFlag	Flag(bit)			1
  0 = Product is not a salable item. 1 = Product is salable.
  	Color	nvarchar(15)		X
  Product color.
  	SafetyStockLevel	smallint
  Minimum inventory quantity.
  	ReorderPoint	smallint
  Inventory level that triggers a purchase order or work order.
  	StandardCost	money
  Standard cost of the product.
  	ListPrice	money
  Selling price.
  	Size	nvarchar(5)		X
  Product size.
  FK	SizeUnitMeasureCode	nchar(3)		X
  Unit of measure for Size column.
  FK	WeightUnitMeasureCode	nchar(3)		X
  Unit of measure for Weight column.
  	Weight	decimal(8,2)		X
  Product weight.
  	DaysToManufacture	int
  Number of days required to manufacture the product.
  	ProductLine	nchar(2)		X
  R = Road, M = Mountain, T = Touring, S = Standard
  	Class	nchar(2)		X
  H = High, M = Medium, L = Low
  	Style	nchar(2)		X
  W = Womens, M = Mens, U = Universal
  FK	ProductSubcategoryID	int		X
  Product is a member of this product subcategory. Foreign key to ProductSubCategory.ProductSubCategoryID.
  FK	ProductModelID	int		X
  Product is a member of this product model. Foreign key to ProductModel.ProductModelID.
  	SellStartDate	datetime
  Date the product was available for sale.
  	SellEndDate	datetime		X
  Date the product was no longer available for sale.
  	DiscontinuedDate	datetime		X
  Date the product was discontinued.
  UK	rowguid	uniqueidentifier			newid()
  ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
  	ModifiedDate	datetime			getdate()
  Date and time the record was last updated.

  
  

  Indexes:

  
  

  • PK_Product_ProductID

    • (Primary Key)
    • (Clustered)
    
    
    

    Primary key (clustered) constraint

    
    
    • ProductID
  
  

  • AK_Product_Name

    • (Unique)
    
    
    

    Unique nonclustered index.

    
    
    • Name
  
  

  • AK_Product_ProductNumber

    • (Unique)
    
    
    

    Unique nonclustered index.

    
    
    • ProductNumber
  
  

  • AK_Product_rowguid

    • (Unique)
    
    
    

    Unique nonclustered index. Used to support replication samples.

    
    
    • rowguid
  
  

  References:

  
  

  • Production.ProductModel

    
    
    
    • ProductModelID
  
  

  • Production.ProductSubcategory

    
    
    
    • ProductSubcategoryID
  
  

  • Production.UnitMeasure

    
    
    
    • UnitMeasureCode (SizeUnitMeasureCode)
  
  

  • Production.UnitMeasure

    
    
    
    • UnitMeasureCode (WeightUnitMeasureCode)
  
  

  Referenced by:

  
  

  • Production.BillOfMaterials

    
    
    
    • ComponentID (ProductID)
  
  

  • Production.BillOfMaterials

    
    
    
    • ProductAssemblyID (ProductID)
  
  

  • Production.ProductCostHistory

    
    
    
    • ProductID
  
  

  • Production.ProductDocument

    
    
    
    • ProductID
  
  

  • Production.ProductInventory

    
    
    
    • ProductID
  
  

  • Production.ProductListPriceHistory

    
    
    
    • ProductID
  
  

  • Production.ProductProductPhoto

    
    
    
    • ProductID
  
  

  • Production.ProductReview

    
    
    
    • ProductID
  
  

  • Production.TransactionHistory

    
    
    
    • ProductID
  
  

  • Production.WorkOrder

    
    
    
    • ProductID
  
  

  • Purchasing.ProductVendor

    
    
    
    • ProductID
  
  

  • Purchasing.PurchaseOrderDetail

    
    
    
    • ProductID
  
  

  • Sales.ShoppingCartItem

    
    
    
    • ProductID
  
  

  • Sales.SpecialOfferProduct

    
    
    
    • ProductID
  
  

  Used by:

  
  

  • Function 

    dbo.ufnGetProductDealerPrice

    
    
    
    • ProductID
    
    
  • Function 

    dbo.ufnGetProductListPrice

    
    
    
    • ProductID
    
    
  • Function 

    dbo.ufnGetProductStandardCost

    
    
    
    • ProductID
    
    
  • Procedure 

    dbo.uspGetBillOfMaterials

    
    
    
    • ListPrice
    • Name
    • ProductID
    • StandardCost
    
    
  • Procedure 

    dbo.uspGetWhereUsedProductID

    
    
    
    • ListPrice
    • Name
    • ProductID
    • StandardCost
    
    
  • View 

    Production.vProductAndDescription

    
    
    
    • Name
    • ProductID
    • ProductModelID
    
    

• Table Production.ProductCategory (4 rows)

  
  

  High-level product categorization.

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	ProductCategoryID	int	X
  Primary key for ProductCategory records.
  UK	Name	Name(nvarchar(50))
  Category description.
  UK	rowguid	uniqueidentifier			newid()
  ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
  	ModifiedDate	datetime			getdate()
  Date and time the record was last updated.

  
  

  Indexes:

  
  

  • PK_ProductCategory_ProductCategoryID

    • (Primary Key)
    • (Clustered)
    
    
    

    Primary key (clustered) constraint

    
    
    • ProductCategoryID
  
  

  • AK_ProductCategory_Name

    • (Unique)
    
    
    

    Unique nonclustered index.

    
    
    • Name
  
  

  • AK_ProductCategory_rowguid

    • (Unique)
    
    
    

    Unique nonclustered index. Used to support replication samples.

    
    
    • rowguid
  
  

  Referenced by:

  
  

  • Production.ProductSubcategory

    
    
    
    • ProductCategoryID
  
  

• Table Production.ProductCostHistory (395 rows)

  
  

  Changes in the cost of a product over time.

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK, FK	ProductID	int
  Product identification number. Foreign key to Product.ProductID
  PK	StartDate	datetime
  Product cost start date.
  	EndDate	datetime		X
  Product cost end date.
  	StandardCost	money
  Standard cost of the product.
  	ModifiedDate	datetime			getdate()
  Date and time the record was last updated.

  
  

  Indexes:

  
  

  • PK_ProductCostHistory_ProductID_StartDate

    • (Primary Key)
    • (Clustered)
    
    
    

    Primary key (clustered) constraint

    
    
    • ProductID
    • StartDate
  
  

  References:

  
  

  • Production.Product

    
    
    
    • ProductID
  
  

  Used by:

  
  

  • Function 

    dbo.ufnGetProductStandardCost

    
    
    
    • EndDate
    • ProductID
    • StandardCost
    • StartDate
    
    

• Table Production.ProductDescription (762 rows)

  
  

  Product descriptions in several languages.

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	ProductDescriptionID	int	X
  Primary key for ProductDescription records.
  	Description	nvarchar(400)
  Description of the product.
  UK	rowguid	uniqueidentifier			newid()
  ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
  	ModifiedDate	datetime			getdate()
  Date and time the record was last updated.

  
  

  Indexes:

  
  

  • PK_ProductDescription_ProductDescriptionID

    • (Primary Key)
    • (Clustered)
    
    
    

    Primary key (clustered) constraint

    
    
    • ProductDescriptionID
  
  

  • AK_ProductDescription_rowguid

    • (Unique)
    
    
    

    Unique nonclustered index. Used to support replication samples.

    
    
    • rowguid
  
  

  Referenced by:

  
  

  • Production.ProductModelProductDescriptionCulture

    
    
    
    • ProductDescriptionID
  
  

  Used by:

  
  

  • View 

    Production.vProductAndDescription

    
    
    
    • Description
    • ProductDescriptionID
    
    

• Table Production.ProductDocument (32 rows)

  
  

  Cross-reference table mapping products to related product documents.

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK, FK	ProductID	int
  Product identification number. Foreign key to Product.ProductID.
  PK, FK	DocumentNode	hierarchyid
  Document identification number. Foreign key to Document.DocumentNode.
  	ModifiedDate	datetime			getdate()
  Date and time the record was last updated.

  
  

  Indexes:

  
  

  • PK_ProductDocument_ProductID_DocumentNode

    • (Primary Key)
    • (Clustered)
    
    
    

    Primary key (clustered) constraint

    
    
    • ProductID
    • DocumentNode
  
  

  References:

  
  

  • Production.Document

    
    
    
    • DocumentNode
  
  

  • Production.Product

    
    
    
    • ProductID
  
  

• Table Production.ProductInventory (1,069 rows)

  
  

  Product inventory information.

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK, FK	ProductID	int
  Product identification number. Foreign key to Product.ProductID.
  PK, FK	LocationID	smallint
  Inventory location identification number. Foreign key to Location.LocationID.
  	Shelf	nvarchar(10)
  Storage compartment within an inventory location.
  	Bin	tinyint
  Storage container on a shelf in an inventory location.
  	Quantity	smallint			0
  Quantity of products in the inventory location.
  	rowguid	uniqueidentifier			newid()
  ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
  	ModifiedDate	datetime			getdate()
  Date and time the record was last updated.

  
  

  Indexes:

  
  

  • PK_ProductInventory_ProductID_LocationID

    • (Primary Key)
    • (Clustered)
    
    
    

    Primary key (clustered) constraint

    
    
    • ProductID
    • LocationID
  
  

  References:

  
  

  • Production.Location

    
    
    
    • LocationID
  
  

  • Production.Product

    
    
    
    • ProductID
  
  

  Used by:

  
  

  • Function 

    dbo.ufnGetStock

    
    
    
    • LocationID
    • ProductID
    • Quantity
    
    

• Table Production.ProductListPriceHistory (395 rows)

  
  

  Changes in the list price of a product over time.

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK, FK	ProductID	int
  Product identification number. Foreign key to Product.ProductID
  PK	StartDate	datetime
  List price start date.
  	EndDate	datetime		X
  List price end date
  	ListPrice	money
  Product list price.
  	ModifiedDate	datetime			getdate()
  Date and time the record was last updated.

  
  

  Indexes:

  
  

  • PK_ProductListPriceHistory_ProductID_StartDate

    • (Primary Key)
    • (Clustered)
    
    
    

    Primary key (clustered) constraint

    
    
    • ProductID
    • StartDate
  
  

  References:

  
  

  • Production.Product

    
    
    
    • ProductID
  
  

  Used by:

  
  

  • Function 

    dbo.ufnGetProductDealerPrice

    
    
    
    • EndDate
    • ListPrice
    • ProductID
    • StartDate
    
    
  • Function 

    dbo.ufnGetProductListPrice

    
    
    
    • EndDate
    • ListPrice
    • ProductID
    • StartDate
    
    

• Table Production.ProductModel (128 rows)

  
  

  Product model classification.

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	ProductModelID	int	X
  Primary key for ProductModel records.
  UK	Name	Name(nvarchar(50))
  Product model description.
  	CatalogDescription	xml		X
  Detailed product catalog information in xml format.
  	Instructions	xml		X
  Manufacturing instructions in xml format.
  UK	rowguid	uniqueidentifier			newid()
  ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
  	ModifiedDate	datetime			getdate()
  Date and time the record was last updated.

  
  

  Indexes:

  
  

  • PK_ProductModel_ProductModelID

    • (Primary Key)
    • (Clustered)
    
    
    

    Primary key (clustered) constraint

    
    
    • ProductModelID
  
  

  • AK_ProductModel_Name

    • (Unique)
    
    
    

    Unique nonclustered index.

    
    
    • Name
  
  

  • AK_ProductModel_rowguid

    • (Unique)
    
    
    

    Unique nonclustered index. Used to support replication samples.

    
    
    • rowguid
  
  

  • PXML_ProductModel_CatalogDescription

    • (XML)
    
    
    

    Primary XML index.

    
    
    • CatalogDescription
  
  

  • PXML_ProductModel_Instructions

    • (XML)
    
    
    

    Primary XML index.

    
    
    • Instructions
  
  

  Referenced by:

  
  

  • Production.Product

    
    
    
    • ProductModelID
  
  

  • Production.ProductModelIllustration

    
    
    
    • ProductModelID
  
  

  • Production.ProductModelProductDescriptionCulture

    
    
    
    • ProductModelID
  
  

  Used by:

  
  

  • View 

    Production.vProductAndDescription

    
    
    
    • Name
    • ProductModelID
    
    
  • View 

    Production.vProductModelCatalogDescription

    
    
    
    • CatalogDescription
    • ModifiedDate
    • Name
    • ProductModelID
    • rowguid
    
    
  • View 

    Production.vProductModelInstructions

    
    
    
    • Instructions
    • ModifiedDate
    • Name
    • ProductModelID
    • rowguid
    
    

• Table Production.ProductModelIllustration (7 rows)

  
  

  Cross-reference table mapping product models and illustrations.

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK, FK	ProductModelID	int
  Primary key. Foreign key to ProductModel.ProductModelID.
  PK, FK	IllustrationID	int
  Primary key. Foreign key to Illustration.IllustrationID.
  	ModifiedDate	datetime			getdate()
  Date and time the record was last updated.

  
  

  Indexes:

  
  

  • PK_ProductModelIllustration_ProductModelID_IllustrationID

    • (Primary Key)
    • (Clustered)
    
    
    

    Primary key (clustered) constraint

    
    
    • ProductModelID
    • IllustrationID
  
  

  References:

  
  

  • Production.Illustration

    
    
    
    • IllustrationID
  
  

  • Production.ProductModel

    
    
    
    • ProductModelID
  
  

• Table Production.ProductModelProductDescriptionCulture (762 rows)

  
  

  Cross-reference table mapping product descriptions and the language the description is written in.

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK, FK	ProductModelID	int
  Primary key. Foreign key to ProductModel.ProductModelID.
  PK, FK	ProductDescriptionID	int
  Primary key. Foreign key to ProductDescription.ProductDescriptionID.
  PK, FK	CultureID	nchar(6)
  Culture identification number. Foreign key to Culture.CultureID.
  	ModifiedDate	datetime			getdate()
  Date and time the record was last updated.

  
  

  Indexes:

  
  

  • PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureID

    • (Primary Key)
    • (Clustered)
    
    
    

    Primary key (clustered) constraint

    
    
    • ProductModelID
    • ProductDescriptionID
    • CultureID
  
  

  References:

  
  

  • Production.Culture

    
    
    
    • CultureID
  
  

  • Production.ProductDescription

    
    
    
    • ProductDescriptionID
  
  

  • Production.ProductModel

    
    
    
    • ProductModelID
  
  

  Used by:

  
  

  • View 

    Production.vProductAndDescription

    
    
    
    • CultureID
    • ProductDescriptionID
    • ProductModelID
    
    

• Table Production.ProductPhoto (101 rows)

  
  

  Product images.

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	ProductPhotoID	int	X
  Primary key for ProductPhoto records.
  	ThumbNailPhoto	varbinary(max)		X
  Small image of the product.
  	ThumbnailPhotoFileName	nvarchar(50)		X
  Small image file name.
  	LargePhoto	varbinary(max)		X
  Large image of the product.
  	LargePhotoFileName	nvarchar(50)		X
  Large image file name.
  	ModifiedDate	datetime			getdate()
  Date and time the record was last updated.

  
  

  Indexes:

  
  

  • PK_ProductPhoto_ProductPhotoID

    • (Primary Key)
    • (Clustered)
    
    
    

    Primary key (clustered) constraint

    
    
    • ProductPhotoID
  
  

  Referenced by:

  
  

  • Production.ProductProductPhoto

    
    
    
    • ProductPhotoID
  
  

• Table Production.ProductProductPhoto (504 rows)

  
  

  Cross-reference table mapping products and product photos.

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK, FK	ProductID	int
  Product identification number. Foreign key to Product.ProductID.
  PK, FK	ProductPhotoID	int
  Product photo identification number. Foreign key to ProductPhoto.ProductPhotoID.
  	Primary	Flag(bit)			0
  0 = Photo is not the principal image. 1 = Photo is the principal image.
  	ModifiedDate	datetime			getdate()
  Date and time the record was last updated.

  
  

  Indexes:

  
  

  • PK_ProductProductPhoto_ProductID_ProductPhotoID

    • (Primary Key)
    
    
    

    Primary key (clustered) constraint

    
    
    • ProductID
    • ProductPhotoID
  
  

  References:

  
  

  • Production.Product

    
    
    
    • ProductID
  
  

  • Production.ProductPhoto

    
    
    
    • ProductPhotoID
  
  

• Table Production.ProductReview (4 rows)

  
  

  Customer reviews of products they have purchased.

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	ProductReviewID	int	X
  Primary key for ProductReview records.
  FK	ProductID	int
  Product identification number. Foreign key to Product.ProductID.
  	ReviewerName	Name(nvarchar(50))
  Name of the reviewer.
  	ReviewDate	datetime			getdate()
  Date review was submitted.
  	EmailAddress	nvarchar(50)
  Reviewer's e-mail address.
  	Rating	int
  Product rating given by the reviewer. Scale is 1 to 5 with 5 as the highest rating.
  	Comments	nvarchar(3850)		X
  Reviewer's comments
  	ModifiedDate	datetime			getdate()
  Date and time the record was last updated.

  
  

  Indexes:

  
  

  • PK_ProductReview_ProductReviewID

    • (Primary Key)
    • (Clustered)
    
    
    

    Primary key (clustered) constraint

    
    
    • ProductReviewID
  
  

  • IX_ProductReview_ProductID_Name

    
    
    

    Nonclustered index.

    
    
    • ProductID
    • ReviewerName
    • Comments (Included)
  
  

  References:

  
  

  • Production.Product

    
    
    
    • ProductID
  
  

• Table Production.ProductSubcategory (37 rows)

  
  

  Product subcategories. See ProductCategory table.

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	ProductSubcategoryID	int	X
  Primary key for ProductSubcategory records.
  FK	ProductCategoryID	int
  Product category identification number. Foreign key to ProductCategory.ProductCategoryID.
  UK	Name	Name(nvarchar(50))
  Subcategory description.
  UK	rowguid	uniqueidentifier			newid()
  ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
  	ModifiedDate	datetime			getdate()
  Date and time the record was last updated.

  
  

  Indexes:

  
  

  • PK_ProductSubcategory_ProductSubcategoryID

    • (Primary Key)
    • (Clustered)
    
    
    

    Primary key (clustered) constraint

    
    
    • ProductSubcategoryID
  
  

  • AK_ProductSubcategory_Name

    • (Unique)
    
    
    

    Unique nonclustered index.

    
    
    • Name
  
  

  • AK_ProductSubcategory_rowguid

    • (Unique)
    
    
    

    Unique nonclustered index. Used to support replication samples.

    
    
    • rowguid
  
  

  References:

  
  

  • Production.ProductCategory

    
    
    
    • ProductCategoryID
  
  

  Referenced by:

  
  

  • Production.Product

    
    
    
    • ProductSubcategoryID
  
  

• Table Production.ScrapReason (16 rows)

  
  

  Manufacturing failure reasons lookup table.

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	ScrapReasonID	smallint	X
  Primary key for ScrapReason records.
  UK	Name	Name(nvarchar(50))
  Failure description.
  	ModifiedDate	datetime			getdate()
  Date and time the record was last updated.

  
  

  Indexes:

  
  

  • PK_ScrapReason_ScrapReasonID

    • (Primary Key)
    • (Clustered)
    
    
    

    Primary key (clustered) constraint

    
    
    • ScrapReasonID
  
  

  • AK_ScrapReason_Name

    • (Unique)
    
    
    

    Unique nonclustered index.

    
    
    • Name
  
  

  Referenced by:

  
  

  • Production.WorkOrder

    
    
    
    • ScrapReasonID
  
  

• Table Production.TransactionHistory (113,443 rows)

  
  

  Record of each purchase order, sales order, or work order transaction year to date.

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	TransactionID	int	X
  Primary key for TransactionHistory records.
  FK	ProductID	int
  Product identification number. Foreign key to Product.ProductID.
  	ReferenceOrderID	int
  Purchase order, sales order, or work order identification number.
  	ReferenceOrderLineID	int			0
  Line number associated with the purchase order, sales order, or work order.
  	TransactionDate	datetime			getdate()
  Date and time of the transaction.
  	TransactionType	nchar(1)
  W = WorkOrder, S = SalesOrder, P = PurchaseOrder
  	Quantity	int
  Product quantity.
  	ActualCost	money
  Product cost.
  	ModifiedDate	datetime			getdate()
  Date and time the record was last updated.

  
  

  Indexes:

  
  

  • PK_TransactionHistory_TransactionID

    • (Primary Key)
    • (Clustered)
    
    
    

    Primary key (clustered) constraint

    
    
    • TransactionID
  
  

  • IX_TransactionHistory_ProductID

    
    
    

    Nonclustered index.

    
    
    • ProductID
  
  

  • IX_TransactionHistory_ReferenceOrderID_ReferenceOrderLineID

    
    
    

    Nonclustered index.

    
    
    • ReferenceOrderID
    • ReferenceOrderLineID
  
  

  References:

  
  

  • Production.Product

    
    
    
    • ProductID
  
  

  Used by:

  
  

  • Trigger 

    Production.iWorkOrder on Production.WorkOrder

    
    
    
    • ActualCost
    • ProductID
    • Quantity
    • ReferenceOrderID
    • TransactionDate
    • TransactionType
    
    
  • Trigger 

    Production.uWorkOrder on Production.WorkOrder

    
    
    
    • ProductID
    • Quantity
    • ReferenceOrderID
    • TransactionDate
    • TransactionType
    
    
  • Trigger 

    Purchasing.iPurchaseOrderDetail on Purchasing.PurchaseOrderDetail

    
    
    
    • ActualCost
    • ProductID
    • Quantity
    • ReferenceOrderID
    • ReferenceOrderLineID
    • TransactionDate
    • TransactionType
    
    
  • Trigger 

    Purchasing.uPurchaseOrderDetail on Purchasing.PurchaseOrderDetail

    
    
    
    • ActualCost
    • ProductID
    • Quantity
    • ReferenceOrderID
    • ReferenceOrderLineID
    • TransactionDate
    • TransactionType
    
    
  • Trigger 

    Sales.iduSalesOrderDetail on Sales.SalesOrderDetail

    
    
    
    • ActualCost
    • ProductID
    • Quantity
    • ReferenceOrderID
    • ReferenceOrderLineID
    • TransactionDate
    • TransactionType
    
    

• Table Production.TransactionHistoryArchive (89,253 rows)

  
  

  Transactions for previous years.

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	TransactionID	int
  Primary key for TransactionHistoryArchive records.
  	ProductID	int
  Product identification number. Foreign key to Product.ProductID.
  	ReferenceOrderID	int
  Purchase order, sales order, or work order identification number.
  	ReferenceOrderLineID	int			0
  Line number associated with the purchase order, sales order, or work order.
  	TransactionDate	datetime			getdate()
  Date and time of the transaction.
  	TransactionType	nchar(1)
  W = Work Order, S = Sales Order, P = Purchase Order
  	Quantity	int
  Product quantity.
  	ActualCost	money
  Product cost.
  	ModifiedDate	datetime			getdate()
  Date and time the record was last updated.

  
  

  Indexes:

  
  

  • PK_TransactionHistoryArchive_TransactionID

    • (Primary Key)
    • (Clustered)
    
    
    

    Primary key (clustered) constraint

    
    
    • TransactionID
  
  

  • IX_TransactionHistoryArchive_ProductID

    
    
    

    Nonclustered index.

    
    
    • ProductID
  
  

  • IX_TransactionHistoryArchive_ReferenceOrderID_ReferenceOrderLineID

    
    
    

    Nonclustered index.

    
    
    • ReferenceOrderID
    • ReferenceOrderLineID
  
  

• Table Production.UnitMeasure (38 rows)

  
  

  Unit of measure lookup table.

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	UnitMeasureCode	nchar(3)
  Primary key.
  UK	Name	Name(nvarchar(50))
  Unit of measure description.
  	ModifiedDate	datetime			getdate()
  Date and time the record was last updated.

  
  

  Indexes:

  
  

  • PK_UnitMeasure_UnitMeasureCode

    • (Primary Key)
    • (Clustered)
    
    
    

    Primary key (clustered) constraint

    
    
    • UnitMeasureCode
  
  

  • AK_UnitMeasure_Name

    • (Unique)
    
    
    

    Unique nonclustered index.

    
    
    • Name
  
  

  Referenced by:

  
  

  • Production.BillOfMaterials

    
    
    
    • UnitMeasureCode
  
  

  • Production.Product

    
    
    
    • SizeUnitMeasureCode (UnitMeasureCode)
  
  

  • Production.Product

    
    
    
    • WeightUnitMeasureCode (UnitMeasureCode)
  
  

  • Purchasing.ProductVendor

    
    
    
    • UnitMeasureCode
  
  

• Table Production.WorkOrder (72,591 rows)

  
  

  Manufacturing work orders.

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	WorkOrderID	int	X
  Primary key for WorkOrder records.
  FK	ProductID	int
  Product identification number. Foreign key to Product.ProductID.
  	OrderQty	int
  Product quantity to build.
  	StockedQty	int
  Quantity built and put in inventory.
  	ScrappedQty	smallint
  Quantity that failed inspection.
  	StartDate	datetime
  Work order start date.
  	EndDate	datetime		X
  Work order end date.
  	DueDate	datetime
  Work order due date.
  FK	ScrapReasonID	smallint		X
  Reason for inspection failure.
  	ModifiedDate	datetime			getdate()
  Date and time the record was last updated.

  
  

  Indexes:

  
  

  • PK_WorkOrder_WorkOrderID

    • (Primary Key)
    • (Clustered)
    
    
    

    Primary key (clustered) constraint

    
    
    • WorkOrderID
  
  

  • IX_WorkOrder_ProductID

    
    
    

    Nonclustered index.

    
    
    • ProductID
  
  

  • IX_WorkOrder_ScrapReasonID

    
    
    

    Nonclustered index.

    
    
    • ScrapReasonID
  
  

  References:

  
  

  • Production.Product

    
    
    
    • ProductID
  
  

  • Production.ScrapReason

    
    
    
    • ScrapReasonID
  
  

  Referenced by:

  
  

  • Production.WorkOrderRouting

    
    
    
    • WorkOrderID
  
  

  Triggers:

  
  

  • iWorkOrder

    (After Insert)
    
    

    AFTER INSERT trigger that inserts a row in the TransactionHistory table.

    
    

  • uWorkOrder

    (After Update)
    
    

    AFTER UPDATE trigger that inserts a row in the TransactionHistory table, updates ModifiedDate in the WorkOrder table.

    
    

• Table Production.WorkOrderRouting (67,131 rows)

  
  

  Work order details.

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK, FK	WorkOrderID	int
  Primary key. Foreign key to WorkOrder.WorkOrderID.
  PK	ProductID	int
  Primary key. Foreign key to Product.ProductID.
  PK	OperationSequence	smallint
  Primary key. Indicates the manufacturing process sequence.
  FK	LocationID	smallint
  Manufacturing location where the part is processed. Foreign key to Location.LocationID.
  	ScheduledStartDate	datetime
  Planned manufacturing start date.
  	ScheduledEndDate	datetime
  Planned manufacturing end date.
  	ActualStartDate	datetime		X
  Actual start date.
  	ActualEndDate	datetime		X
  Actual end date.
  	ActualResourceHrs	decimal(9,4)		X
  Number of manufacturing hours used.
  	PlannedCost	money
  Estimated manufacturing cost.
  	ActualCost	money		X
  Actual manufacturing cost.
  	ModifiedDate	datetime			getdate()
  Date and time the record was last updated.

  
  

  Indexes:

  
  

  • PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence

    • (Primary Key)
    • (Clustered)
    
    
    

    Primary key (clustered) constraint

    
    
    • WorkOrderID
    • ProductID
    • OperationSequence
  
  

  • IX_WorkOrderRouting_ProductID

    
    
    

    Nonclustered index.

    
    
    • ProductID
  
  

  References:

  
  

  • Production.Location

    
    
    
    • LocationID
  
  

  • Production.WorkOrder

    
    
    
    • WorkOrderID
  
  

• Table Purchasing.ProductVendor (460 rows)

  
  

  Cross-reference table mapping vendors with the products they supply.

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK, FK	ProductID	int
  Primary key. Foreign key to Product.ProductID.
  PK, FK	BusinessEntityID	int
  Primary key. Foreign key to Vendor.BusinessEntityID.
  	AverageLeadTime	int
  The average span of time (in days) between placing an order with the vendor and receiving the purchased product.
  	StandardPrice	money
  The vendor's usual selling price.
  	LastReceiptCost	money		X
  The selling price when last purchased.
  	LastReceiptDate	datetime		X
  Date the product was last received by the vendor.
  	MinOrderQty	int
  The maximum quantity that should be ordered.
  	MaxOrderQty	int
  The minimum quantity that should be ordered.
  	OnOrderQty	int		X
  The quantity currently on order.
  FK	UnitMeasureCode	nchar(3)
  The product's unit of measure.
  	ModifiedDate	datetime			getdate()
  Date and time the record was last updated.

  
  

  Indexes:

  
  

  • PK_ProductVendor_ProductID_BusinessEntityID

    • (Primary Key)
    • (Clustered)
    
    
    

    Primary key (clustered) constraint

    
    
    • ProductID
    • BusinessEntityID
  
  

  • IX_ProductVendor_BusinessEntityID

    
    
    

    Nonclustered index.

    
    
    • BusinessEntityID
  
  

  • IX_ProductVendor_UnitMeasureCode

    
    
    

    Nonclustered index.

    
    
    • UnitMeasureCode
  
  

  References:

  
  

  • Production.Product

    
    
    
    • ProductID
  
  

  • Production.UnitMeasure

    
    
    
    • UnitMeasureCode
  
  

  • Purchasing.Vendor

    
    
    
    • BusinessEntityID
  
  

• Table Purchasing.PurchaseOrderDetail (8,845 rows)

  
  

  Individual products associated with a specific purchase order. See PurchaseOrderHeader.

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK, FK	PurchaseOrderID	int
  Primary key. Foreign key to PurchaseOrderHeader.PurchaseOrderID.
  PK	PurchaseOrderDetailID	int	X
  Primary key. One line number per purchased product.
  	DueDate	datetime
  Date the product is expected to be received.
  	OrderQty	smallint
  Quantity ordered.
  FK	ProductID	int
  Product identification number. Foreign key to Product.ProductID.
  	UnitPrice	money
  Vendor's selling price of a single product.
  	LineTotal	money
  Per product subtotal. Computed as OrderQty * UnitPrice.
  	ReceivedQty	decimal(8,2)
  Quantity actually received from the vendor.
  	RejectedQty	decimal(8,2)
  Quantity rejected during inspection.
  	StockedQty	decimal(9,2)
  Quantity accepted into inventory. Computed as ReceivedQty - RejectedQty.
  	ModifiedDate	datetime			getdate()
  Date and time the record was last updated.

  
  

  Indexes:

  
  

  • PK_PurchaseOrderDetail_PurchaseOrderID_PurchaseOrderDetailID

    • (Primary Key)
    • (Clustered)
    
    
    

    Primary key (clustered) constraint

    
    
    • PurchaseOrderID
    • PurchaseOrderDetailID
  
  

  • IX_PurchaseOrderDetail_ProductID

    
    
    

    Nonclustered index.

    
    
    • ProductID
  
  

  References:

  
  

  • Production.Product

    
    
    
    • ProductID
  
  

  • Purchasing.PurchaseOrderHeader

    
    
    
    • PurchaseOrderID
  
  

  Triggers:

  
  

  • iPurchaseOrderDetail

    (After Insert)
    
    

    AFTER INSERT trigger that inserts a row in the TransactionHistory table and updates the PurchaseOrderHeader.SubTotal column.

    
    

  • uPurchaseOrderDetail

    (After Update)
    
    

    AFTER UPDATE trigger that inserts a row in the TransactionHistory table, updates ModifiedDate in PurchaseOrderDetail and updates the PurchaseOrderHeader.SubTotal column.

    
    

• Table Purchasing.PurchaseOrderHeader (4,012 rows)

  
  

  General purchase order information. See PurchaseOrderDetail.

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	PurchaseOrderID	int	X
  Primary key.
  	RevisionNumber	tinyint			0
  Incremental number to track changes to the purchase order over time.
  	Status	tinyint			1
  Order current status. 1 = Pending; 2 = Approved; 3 = Rejected; 4 = Complete
  FK	EmployeeID	int
  Employee who created the purchase order. Foreign key to Employee.BusinessEntityID.
  FK	VendorID	int
  Vendor with whom the purchase order is placed. Foreign key to Vendor.BusinessEntityID.
  FK	ShipMethodID	int
  Shipping method. Foreign key to ShipMethod.ShipMethodID.
  	OrderDate	datetime			getdate()
  Purchase order creation date.
  	ShipDate	datetime		X
  Estimated shipment date from the vendor.
  	SubTotal	money			0.00
  Purchase order subtotal. Computed as SUM(PurchaseOrderDetail.LineTotal)for the appropriate PurchaseOrderID.
  	TaxAmt	money			0.00
  Tax amount.
  	Freight	money			0.00
  Shipping cost.
  	TotalDue	money
  Total due to vendor. Computed as Subtotal + TaxAmt + Freight.
  	ModifiedDate	datetime			getdate()
  Date and time the record was last updated.

  
  

  Indexes:

  
  

  • PK_PurchaseOrderHeader_PurchaseOrderID

    • (Primary Key)
    • (Clustered)
    
    
    

    Primary key (clustered) constraint

    
    
    • PurchaseOrderID
  
  

  • IX_PurchaseOrderHeader_EmployeeID

    
    
    

    Nonclustered index.

    
    
    • EmployeeID
  
  

  • IX_PurchaseOrderHeader_VendorID

    
    
    

    Nonclustered index.

    
    
    • VendorID
  
  

  References:

  
  

  • HumanResources.Employee

    
    
    
    • BusinessEntityID (EmployeeID)
  
  

  • Purchasing.ShipMethod

    
    
    
    • ShipMethodID
  
  

  • Purchasing.Vendor

    
    
    
    • BusinessEntityID (VendorID)
  
  

  Referenced by:

  
  

  • Purchasing.PurchaseOrderDetail

    
    
    
    • PurchaseOrderID
  
  

  Triggers:

  
  

  • uPurchaseOrderHeader

    (After Update)
    
    

    AFTER UPDATE trigger that updates the RevisionNumber and ModifiedDate columns in the PurchaseOrderHeader table.

    
    

  Used by:

  
  

  • Trigger 

    Purchasing.iPurchaseOrderDetail on Purchasing.PurchaseOrderDetail

    
    
    
    • PurchaseOrderID
    • SubTotal
    
    
  • Trigger 

    Purchasing.uPurchaseOrderDetail on Purchasing.PurchaseOrderDetail

    
    
    
    • PurchaseOrderID
    • SubTotal
    
    

• Table Purchasing.ShipMethod (5 rows)

  
  

  Shipping company lookup table.

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	ShipMethodID	int	X
  Primary key for ShipMethod records.
  UK	Name	Name(nvarchar(50))
  Shipping company name.
  	ShipBase	money			0.00
  Minimum shipping charge.
  	ShipRate	money			0.00
  Shipping charge per pound.
  UK	rowguid	uniqueidentifier			newid()
  ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
  	ModifiedDate	datetime			getdate()
  Date and time the record was last updated.

  
  

  Indexes:

  
  

  • PK_ShipMethod_ShipMethodID

    • (Primary Key)
    • (Clustered)
    
    
    

    Primary key (clustered) constraint

    
    
    • ShipMethodID
  
  

  • AK_ShipMethod_Name

    • (Unique)
    
    
    

    Unique nonclustered index.

    
    
    • Name
  
  

  • AK_ShipMethod_rowguid

    • (Unique)
    
    
    

    Unique nonclustered index. Used to support replication samples.

    
    
    • rowguid
  
  

  Referenced by:

  
  

  • Purchasing.PurchaseOrderHeader

    
    
    
    • ShipMethodID
  
  

  • Sales.SalesOrderHeader

    
    
    
    • ShipMethodID
  
  

• Table Purchasing.Vendor (104 rows)

  
  

  Companies from whom Adventure Works Cycles purchases parts or other goods.

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK, FK	BusinessEntityID	int
  Primary key for Vendor records. Foreign key to BusinessEntity.BusinessEntityID
  UK	AccountNumber	AccountNumber(nvarchar(15))
  Vendor account (identification) number.
  	Name	Name(nvarchar(50))
  Company name.
  	CreditRating	tinyint
  1 = Superior, 2 = Excellent, 3 = Above average, 4 = Average, 5 = Below average
  	PreferredVendorStatus	Flag(bit)			1
  0 = Do not use if another vendor is available. 1 = Preferred over other vendors supplying the same product.
  	ActiveFlag	Flag(bit)			1
  0 = Vendor no longer used. 1 = Vendor is actively used.
  	PurchasingWebServiceURL	nvarchar(1024)		X
  Vendor URL.
  	ModifiedDate	datetime			getdate()
  Date and time the record was last updated.

  
  

  Indexes:

  
  

  • PK_Vendor_BusinessEntityID

    • (Primary Key)
    • (Clustered)
    
    
    

    Primary key (clustered) constraint

    
    
    • BusinessEntityID
  
  

  • AK_Vendor_AccountNumber

    • (Unique)
    
    
    

    Unique nonclustered index.

    
    
    • AccountNumber
  
  

  References:

  
  

  • Person.BusinessEntity

    
    
    
    • BusinessEntityID
  
  

  Referenced by:

  
  

  • Purchasing.ProductVendor

    
    
    
    • BusinessEntityID
  
  

  • Purchasing.PurchaseOrderHeader

    
    
    
    • VendorID (BusinessEntityID)
  
  

  Triggers:

  
  

  • dVendor

    (Instead Of Delete)
    
    

    INSTEAD OF DELETE trigger which keeps Vendors from being deleted.

    
    

  Used by:

  
  

  • Function 

    dbo.ufnGetContactInformation

    
    
    
    • BusinessEntityID
    
    
  • View 

    Purchasing.vVendorWithAddresses

    
    
    
    • BusinessEntityID
    • Name
    
    
  • View 

    Purchasing.vVendorWithContacts

    
    
    
    • BusinessEntityID
    • Name
    
    

• Table Sales.CountryRegionCurrency (109 rows)

  
  

  Cross-reference table mapping ISO currency codes to a country or region.

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK, FK	CountryRegionCode	nvarchar(3)
  ISO code for countries and regions. Foreign key to CountryRegion.CountryRegionCode.
  PK, FK	CurrencyCode	nchar(3)
  ISO standard currency code. Foreign key to Currency.CurrencyCode.
  	ModifiedDate	datetime			getdate()
  Date and time the record was last updated.

  
  

  Indexes:

  
  

  • PK_CountryRegionCurrency_CountryRegionCode_CurrencyCode

    • (Primary Key)
    • (Clustered)
    
    
    

    Primary key (clustered) constraint

    
    
    • CountryRegionCode
    • CurrencyCode
  
  

  • IX_CountryRegionCurrency_CurrencyCode

    
    
    

    Nonclustered index.

    
    
    • CurrencyCode
  
  

  References:

  
  

  • Person.CountryRegion

    
    
    
    • CountryRegionCode
  
  

  • Sales.Currency

    
    
    
    • CurrencyCode
  
  

• Table Sales.CreditCard (19,118 rows)

  
  

  Customer credit card information.

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	CreditCardID	int	X
  Primary key for CreditCard records.
  	CardType	nvarchar(50)
  Credit card name.
  UK	CardNumber	nvarchar(25)
  Credit card number.
  	ExpMonth	tinyint
  Credit card expiration month.
  	ExpYear	smallint
  Credit card expiration year.
  	ModifiedDate	datetime			getdate()
  Date and time the record was last updated.

  
  

  Indexes:

  
  

  • PK_CreditCard_CreditCardID

    • (Primary Key)
    • (Clustered)
    
    
    

    Primary key (clustered) constraint

    
    
    • CreditCardID
  
  

  • AK_CreditCard_CardNumber

    • (Unique)
    
    
    

    Unique nonclustered index.

    
    
    • CardNumber
  
  

  Referenced by:

  
  

  • Sales.PersonCreditCard

    
    
    
    • CreditCardID
  
  

  • Sales.SalesOrderHeader

    
    
    
    • CreditCardID
  
  

• Table Sales.Currency (105 rows)

  
  

  Lookup table containing standard ISO currencies.

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	CurrencyCode	nchar(3)
  The ISO code for the Currency.
  UK	Name	Name(nvarchar(50))
  Currency name.
  	ModifiedDate	datetime			getdate()
  Date and time the record was last updated.

  
  

  Indexes:

  
  

  • PK_Currency_CurrencyCode

    • (Primary Key)
    • (Clustered)
    
    
    

    Primary key (clustered) constraint

    
    
    • CurrencyCode
  
  

  • AK_Currency_Name

    • (Unique)
    
    
    

    Unique nonclustered index.

    
    
    • Name
  
  

  Referenced by:

  
  

  • Sales.CountryRegionCurrency

    
    
    
    • CurrencyCode
  
  

  • Sales.CurrencyRate

    
    
    
    • FromCurrencyCode (CurrencyCode)
  
  

  • Sales.CurrencyRate

    
    
    
    • ToCurrencyCode (CurrencyCode)
  
  

• Table Sales.CurrencyRate (13,532 rows)

  
  

  Currency exchange rates.

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	CurrencyRateID	int	X
  Primary key for CurrencyRate records.
  UK	CurrencyRateDate	datetime
  Date and time the exchange rate was obtained.
  UK, FK	FromCurrencyCode	nchar(3)
  Exchange rate was converted from this currency code.
  UK, FK	ToCurrencyCode	nchar(3)
  Exchange rate was converted to this currency code.
  	AverageRate	money
  Average exchange rate for the day.
  	EndOfDayRate	money
  Final exchange rate for the day.
  	ModifiedDate	datetime			getdate()
  Date and time the record was last updated.

  
  

  Indexes:

  
  

  • PK_CurrencyRate_CurrencyRateID

    • (Primary Key)
    • (Clustered)
    
    
    

    Primary key (clustered) constraint

    
    
    • CurrencyRateID
  
  

  • AK_CurrencyRate_CurrencyRateDate_FromCurrencyCode_ToCurrencyCode

    • (Unique)
    
    
    

    Unique nonclustered index.

    
    
    • CurrencyRateDate
    • FromCurrencyCode
    • ToCurrencyCode
  
  

  References:

  
  

  • Sales.Currency

    
    
    
    • CurrencyCode (FromCurrencyCode)
  
  

  • Sales.Currency

    
    
    
    • CurrencyCode (ToCurrencyCode)
  
  

  Referenced by:

  
  

  • Sales.SalesOrderHeader

    
    
    
    • CurrencyRateID
  
  

• Table Sales.Customer (19,820 rows)

  
  

  Current customer information. Also see the Person and Store tables.

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	CustomerID	int	X
  Primary key.
  FK	PersonID	int		X
  Foreign key to Person.BusinessEntityID
  FK	StoreID	int		X
  Foreign key to Store.BusinessEntityID
  FK	TerritoryID	int		X
  ID of the territory in which the customer is located. Foreign key to SalesTerritory.SalesTerritoryID.
  UK	AccountNumber	varchar(10)
  Unique number identifying the customer assigned by the accounting system.
  UK	rowguid	uniqueidentifier			newid()
  ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
  	ModifiedDate	datetime			getdate()
  Date and time the record was last updated.

  
  

  Indexes:

  
  

  • PK_Customer_CustomerID

    • (Primary Key)
    • (Clustered)
    
    
    

    Primary key (clustered) constraint

    
    
    • CustomerID
  
  

  • AK_Customer_AccountNumber

    • (Unique)
    
    
    

    Unique nonclustered index.

    
    
    • AccountNumber
  
  

  • AK_Customer_rowguid

    • (Unique)
    
    
    

    Unique nonclustered index. Used to support replication samples.

    
    
    • rowguid
  
  

  • IX_Customer_TerritoryID

    
    
    

    Nonclustered index.

    
    
    • TerritoryID
  
  

  References:

  
  

  • Person.Person

    
    
    
    • BusinessEntityID (PersonID)
  
  

  • Sales.SalesTerritory

    
    
    
    • TerritoryID
  
  

  • Sales.Store

    
    
    
    • BusinessEntityID (StoreID)
  
  

  Referenced by:

  
  

  • Sales.SalesOrderHeader

    
    
    
    • CustomerID
  
  

  Used by:

  
  

  • Function 

    dbo.ufnGetContactInformation

    
    
    
    • PersonID
    • StoreID
    
    
  • Trigger 

    Sales.iduSalesOrderDetail on Sales.SalesOrderDetail

    
    
    
    • CustomerID
    • PersonID
    
    
  • View 

    Sales.vIndividualCustomer

    
    
    
    • PersonID
    • StoreID
    
    

• Table Sales.PersonCreditCard (19,118 rows)

  
  

  Cross-reference table mapping people to their credit card information in the CreditCard table.

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK, FK	BusinessEntityID	int
  Business entity identification number. Foreign key to Person.BusinessEntityID.
  PK, FK	CreditCardID	int
  Credit card identification number. Foreign key to CreditCard.CreditCardID.
  	ModifiedDate	datetime			getdate()
  Date and time the record was last updated.

  
  

  Indexes:

  
  

  • PK_PersonCreditCard_BusinessEntityID_CreditCardID

    • (Primary Key)
    • (Clustered)
    
    
    

    Primary key (clustered) constraint

    
    
    • BusinessEntityID
    • CreditCardID
  
  

  References:

  
  

  • Person.Person

    
    
    
    • BusinessEntityID
  
  

  • Sales.CreditCard

    
    
    
    • CreditCardID
  
  

• Table Sales.SalesOrderDetail (121,317 rows)

  
  

  Individual products associated with a specific sales order. See SalesOrderHeader.

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK, FK	SalesOrderID	int
  Primary key. Foreign key to SalesOrderHeader.SalesOrderID.
  PK	SalesOrderDetailID	int	X
  Primary key. One incremental unique number per product sold.
  	CarrierTrackingNumber	nvarchar(25)		X
  Shipment tracking number supplied by the shipper.
  	OrderQty	smallint
  Quantity ordered per product.
  FK	ProductID	int
  Product sold to customer. Foreign key to Product.ProductID.
  FK	SpecialOfferID	int
  Promotional code. Foreign key to SpecialOffer.SpecialOfferID.
  	UnitPrice	money
  Selling price of a single product.
  	UnitPriceDiscount	money			0.0
  Discount amount.
  	LineTotal	numeric(38,6)
  Per product subtotal. Computed as UnitPrice * (1 - UnitPriceDiscount) * OrderQty.
  UK	rowguid	uniqueidentifier			newid()
  ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
  	ModifiedDate	datetime			getdate()
  Date and time the record was last updated.

  
  

  Indexes:

  
  

  • PK_SalesOrderDetail_SalesOrderID_SalesOrderDetailID

    • (Primary Key)
    • (Clustered)
    
    
    

    Primary key (clustered) constraint

    
    
    • SalesOrderID
    • SalesOrderDetailID
  
  

  • AK_SalesOrderDetail_rowguid

    • (Unique)
    
    
    

    Unique nonclustered index. Used to support replication samples.

    
    
    • rowguid
  
  

  • IX_SalesOrderDetail_ProductID

    
    
    

    Nonclustered index.

    
    
    • ProductID
  
  

  References:

  
  

  • Sales.SalesOrderHeader

    
    
    
    • SalesOrderID
  
  

  • Sales.SpecialOfferProduct

    
    
    
    • ProductID
    • SpecialOfferID
  
  

  Triggers:

  
  

  • iduSalesOrderDetail

    (After Insert, Update, Delete)
    
    

    AFTER INSERT, DELETE, UPDATE trigger that inserts a row in the TransactionHistory table, updates ModifiedDate in SalesOrderDetail and updates the SalesOrderHeader.SubTotal column.

    
    

• Table Sales.SalesOrderHeader (31,465 rows)

  
  

  General sales order information.

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	SalesOrderID	int	X
  Primary key.
  	RevisionNumber	tinyint			0
  Incremental number to track changes to the sales order over time.
  	OrderDate	datetime			getdate()
  Dates the sales order was created.
  	DueDate	datetime
  Date the order is due to the customer.
  	ShipDate	datetime		X
  Date the order was shipped to the customer.
  	Status	tinyint			1
  Order current status. 1 = In process; 2 = Approved; 3 = Backordered; 4 = Rejected; 5 = Shipped; 6 = Cancelled
  	OnlineOrderFlag	Flag(bit)			1
  0 = Order placed by sales person. 1 = Order placed online by customer.
  UK	SalesOrderNumber	nvarchar(25)
  Unique sales order identification number.
  	PurchaseOrderNumber	OrderNumber(nvarchar(25))		X
  Customer purchase order number reference.
  	AccountNumber	AccountNumber(nvarchar(15))		X
  Financial accounting number reference.
  FK	CustomerID	int
  Customer identification number. Foreign key to Customer.BusinessEntityID.
  FK	SalesPersonID	int		X
  Sales person who created the sales order. Foreign key to SalesPerson.BusinessEntityID.
  FK	TerritoryID	int		X
  Territory in which the sale was made. Foreign key to SalesTerritory.SalesTerritoryID.
  FK	BillToAddressID	int
  Customer billing address. Foreign key to Address.AddressID.
  FK	ShipToAddressID	int
  Customer shipping address. Foreign key to Address.AddressID.
  FK	ShipMethodID	int
  Shipping method. Foreign key to ShipMethod.ShipMethodID.
  FK	CreditCardID	int		X
  Credit card identification number. Foreign key to CreditCard.CreditCardID.
  	CreditCardApprovalCode	varchar(15)		X
  Approval code provided by the credit card company.
  FK	CurrencyRateID	int		X
  Currency exchange rate used. Foreign key to CurrencyRate.CurrencyRateID.
  	SubTotal	money			0.00
  Sales subtotal. Computed as SUM(SalesOrderDetail.LineTotal)for the appropriate SalesOrderID.
  	TaxAmt	money			0.00
  Tax amount.
  	Freight	money			0.00
  Shipping cost.
  	TotalDue	money
  Total due from customer. Computed as Subtotal + TaxAmt + Freight.
  	Comment	nvarchar(128)		X
  Sales representative comments.
  UK	rowguid	uniqueidentifier			newid()
  ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
  	ModifiedDate	datetime			getdate()
  Date and time the record was last updated.

  
  

  Indexes:

  
  

  • PK_SalesOrderHeader_SalesOrderID

    • (Primary Key)
    • (Clustered)
    
    
    

    Primary key (clustered) constraint

    
    
    • SalesOrderID
  
  

  • AK_SalesOrderHeader_rowguid

    • (Unique)
    
    
    

    Unique nonclustered index. Used to support replication samples.

    
    
    • rowguid
  
  

  • AK_SalesOrderHeader_SalesOrderNumber

    • (Unique)
    
    
    

    Unique nonclustered index.

    
    
    • SalesOrderNumber
  
  

  • IX_SalesOrderHeader_CustomerID

    
    
    

    Nonclustered index.

    
    
    • CustomerID
  
  

  • IX_SalesOrderHeader_SalesPersonID

    
    
    

    Nonclustered index.

    
    
    • SalesPersonID
  
  

  References:

  
  

  • Person.Address

    
    
    
    • AddressID (BillToAddressID)
  
  

  • Person.Address

    
    
    
    • AddressID (ShipToAddressID)
  
  

  • Purchasing.ShipMethod

    
    
    
    • ShipMethodID
  
  

  • Sales.CreditCard

    
    
    
    • CreditCardID
  
  

  • Sales.CurrencyRate

    
    
    
    • CurrencyRateID
  
  

  • Sales.Customer

    
    
    
    • CustomerID
  
  

  • Sales.SalesPerson

    
    
    
    • BusinessEntityID (SalesPersonID)
  
  

  • Sales.SalesTerritory

    
    
    
    • TerritoryID
  
  

  Referenced by:

  
  

  • Sales.SalesOrderDetail

    
    
    
    • SalesOrderID
  
  

  • Sales.SalesOrderHeaderSalesReason

    
    
    
    • SalesOrderID
  
  

  Triggers:

  
  

  • uSalesOrderHeader

    (After Update)
    
    

    AFTER UPDATE trigger that updates the RevisionNumber and ModifiedDate columns in the SalesOrderHeader table.Updates the SalesYTD column in the SalesPerson and SalesTerritory tables.

    
    

  Used by:

  
  

  • Trigger 

    Sales.iduSalesOrderDetail on Sales.SalesOrderDetail

    
    
    
    • CustomerID
    • SalesOrderID
    • SubTotal
    
    
  • View 

    Sales.vSalesPersonSalesByFiscalYears

    
    
    
    • OrderDate
    • SalesPersonID
    • SubTotal
    
    

• Table Sales.SalesOrderHeaderSalesReason (27,647 rows)

  
  

  Cross-reference table mapping sales orders to sales reason codes.

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK, FK	SalesOrderID	int
  Primary key. Foreign key to SalesOrderHeader.SalesOrderID.
  PK, FK	SalesReasonID	int
  Primary key. Foreign key to SalesReason.SalesReasonID.
  	ModifiedDate	datetime			getdate()
  Date and time the record was last updated.

  
  

  Indexes:

  
  

  • PK_SalesOrderHeaderSalesReason_SalesOrderID_SalesReasonID

    • (Primary Key)
    • (Clustered)
    
    
    

    Primary key (clustered) constraint

    
    
    • SalesOrderID
    • SalesReasonID
  
  

  References:

  
  

  • Sales.SalesOrderHeader

    
    
    
    • SalesOrderID
  
  

  • Sales.SalesReason

    
    
    
    • SalesReasonID
  
  

• Table Sales.SalesPerson (17 rows)

  
  

  Sales representative current information.

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK, FK	BusinessEntityID	int
  Primary key for SalesPerson records. Foreign key to Employee.BusinessEntityID
  FK	TerritoryID	int		X
  Territory currently assigned to. Foreign key to SalesTerritory.SalesTerritoryID.
  	SalesQuota	money		X
  Projected yearly sales.
  	Bonus	money			0.00
  Bonus due if quota is met.
  	CommissionPct	smallmoney			0.00
  Commision percent received per sale.
  	SalesYTD	money			0.00
  Sales total year to date.
  	SalesLastYear	money			0.00
  Sales total of previous year.
  UK	rowguid	uniqueidentifier			newid()
  ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
  	ModifiedDate	datetime			getdate()
  Date and time the record was last updated.

  
  

  Indexes:

  
  

  • PK_SalesPerson_BusinessEntityID

    • (Primary Key)
    • (Clustered)
    
    
    

    Primary key (clustered) constraint

    
    
    • BusinessEntityID
  
  

  • AK_SalesPerson_rowguid

    • (Unique)
    
    
    

    Unique nonclustered index. Used to support replication samples.

    
    
    • rowguid
  
  

  References:

  
  

  • HumanResources.Employee

    
    
    
    • BusinessEntityID
  
  

  • Sales.SalesTerritory

    
    
    
    • TerritoryID
  
  

  Referenced by:

  
  

  • Sales.SalesOrderHeader

    
    
    
    • SalesPersonID (BusinessEntityID)
  
  

  • Sales.SalesPersonQuotaHistory

    
    
    
    • BusinessEntityID
  
  

  • Sales.SalesTerritoryHistory

    
    
    
    • BusinessEntityID
  
  

  • Sales.Store

    
    
    
    • SalesPersonID (BusinessEntityID)
  
  

  Used by:

  
  

  • Trigger 

    Sales.uSalesOrderHeader on Sales.SalesOrderHeader

    
    
    
    • BusinessEntityID
    • SalesYTD
    
    
  • View 

    Sales.vSalesPerson

    
    
    
    • BusinessEntityID
    • SalesLastYear
    • SalesQuota
    • SalesYTD
    • TerritoryID
    
    
  • View 

    Sales.vSalesPersonSalesByFiscalYears

    
    
    
    • BusinessEntityID
    • TerritoryID
    
    

• Table Sales.SalesPersonQuotaHistory (163 rows)

  
  

  Sales performance tracking.

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK, FK	BusinessEntityID	int
  Sales person identification number. Foreign key to SalesPerson.BusinessEntityID.
  PK	QuotaDate	datetime
  Sales quota date.
  	SalesQuota	money
  Sales quota amount.
  UK	rowguid	uniqueidentifier			newid()
  ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
  	ModifiedDate	datetime			getdate()
  Date and time the record was last updated.

  
  

  Indexes:

  
  

  • PK_SalesPersonQuotaHistory_BusinessEntityID_QuotaDate

    • (Primary Key)
    • (Clustered)
    
    
    

    Primary key (clustered) constraint

    
    
    • BusinessEntityID
    • QuotaDate
  
  

  • AK_SalesPersonQuotaHistory_rowguid

    • (Unique)
    
    
    

    Unique nonclustered index. Used to support replication samples.

    
    
    • rowguid
  
  

  References:

  
  

  • Sales.SalesPerson

    
    
    
    • BusinessEntityID
  
  

• Table Sales.SalesReason (10 rows)

  
  

  Lookup table of customer purchase reasons.

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	SalesReasonID	int	X
  Primary key for SalesReason records.
  	Name	Name(nvarchar(50))
  Sales reason description.
  	ReasonType	Name(nvarchar(50))
  Category the sales reason belongs to.
  	ModifiedDate	datetime			getdate()
  Date and time the record was last updated.

  
  

  Indexes:

  
  

  • PK_SalesReason_SalesReasonID

    • (Primary Key)
    • (Clustered)
    
    
    

    Primary key (clustered) constraint

    
    
    • SalesReasonID
  
  

  Referenced by:

  
  

  • Sales.SalesOrderHeaderSalesReason

    
    
    
    • SalesReasonID
  
  

• Table Sales.SalesTaxRate (29 rows)

  
  

  Tax rate lookup table.

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	SalesTaxRateID	int	X
  Primary key for SalesTaxRate records.
  UK, FK	StateProvinceID	int
  State, province, or country/region the sales tax applies to.
  UK	TaxType	tinyint
  1 = Tax applied to retail transactions, 2 = Tax applied to wholesale transactions, 3 = Tax applied to all sales (retail and wholesale) transactions.
  	TaxRate	smallmoney			0.00
  Tax rate amount.
  	Name	Name(nvarchar(50))
  Tax rate description.
  UK	rowguid	uniqueidentifier			newid()
  ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
  	ModifiedDate	datetime			getdate()
  Date and time the record was last updated.

  
  

  Indexes:

  
  

  • PK_SalesTaxRate_SalesTaxRateID

    • (Primary Key)
    • (Clustered)
    
    
    

    Primary key (clustered) constraint

    
    
    • SalesTaxRateID
  
  

  • AK_SalesTaxRate_rowguid

    • (Unique)
    
    
    

    Unique nonclustered index. Used to support replication samples.

    
    
    • rowguid
  
  

  • AK_SalesTaxRate_StateProvinceID_TaxType

    • (Unique)
    
    
    

    Unique nonclustered index.

    
    
    • StateProvinceID
    • TaxType
  
  

  References:

  
  

  • Person.StateProvince

    
    
    
    • StateProvinceID
  
  

• Table Sales.SalesTerritory (10 rows)

  
  

  Sales territory lookup table.

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	TerritoryID	int	X
  Primary key for SalesTerritory records.
  UK	Name	Name(nvarchar(50))
  Sales territory description
  FK	CountryRegionCode	nvarchar(3)
  ISO standard country or region code. Foreign key to CountryRegion.CountryRegionCode.
  	Group	nvarchar(50)
  Geographic area to which the sales territory belong.
  	SalesYTD	money			0.00
  Sales in the territory year to date.
  	SalesLastYear	money			0.00
  Sales in the territory the previous year.
  	CostYTD	money			0.00
  Business costs in the territory year to date.
  	CostLastYear	money			0.00
  Business costs in the territory the previous year.
  UK	rowguid	uniqueidentifier			newid()
  ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
  	ModifiedDate	datetime			getdate()
  Date and time the record was last updated.

  
  

  Indexes:

  
  

  • PK_SalesTerritory_TerritoryID

    • (Primary Key)
    • (Clustered)
    
    
    

    Primary key (clustered) constraint

    
    
    • TerritoryID
  
  

  • AK_SalesTerritory_Name

    • (Unique)
    
    
    

    Unique nonclustered index.

    
    
    • Name
  
  

  • AK_SalesTerritory_rowguid

    • (Unique)
    
    
    

    Unique nonclustered index. Used to support replication samples.

    
    
    • rowguid
  
  

  References:

  
  

  • Person.CountryRegion

    
    
    
    • CountryRegionCode
  
  

  Referenced by:

  
  

  • Person.StateProvince

    
    
    
    • TerritoryID
  
  

  • Sales.Customer

    
    
    
    • TerritoryID
  
  

  • Sales.SalesOrderHeader

    
    
    
    • TerritoryID
  
  

  • Sales.SalesPerson

    
    
    
    • TerritoryID
  
  

  • Sales.SalesTerritoryHistory

    
    
    
    • TerritoryID
  
  

  Used by:

  
  

  • Trigger 

    Sales.uSalesOrderHeader on Sales.SalesOrderHeader

    
    
    
    • SalesYTD
    • TerritoryID
    
    
  • View 

    Sales.vSalesPerson

    
    
    
    • Group
    • Name
    • TerritoryID
    
    
  • View 

    Sales.vSalesPersonSalesByFiscalYears

    
    
    
    • Name
    • TerritoryID
    
    

• Table Sales.SalesTerritoryHistory (17 rows)

  
  

  Sales representative transfers to other sales territories.

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK, FK	BusinessEntityID	int
  Primary key. The sales rep. Foreign key to SalesPerson.BusinessEntityID.
  PK, FK	TerritoryID	int
  Primary key. Territory identification number. Foreign key to SalesTerritory.SalesTerritoryID.
  PK	StartDate	datetime
  Primary key. Date the sales representive started work in the territory.
  	EndDate	datetime		X
  Date the sales representative left work in the territory.
  UK	rowguid	uniqueidentifier			newid()
  ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
  	ModifiedDate	datetime			getdate()
  Date and time the record was last updated.

  
  

  Indexes:

  
  

  • PK_SalesTerritoryHistory_BusinessEntityID_StartDate_TerritoryID

    • (Primary Key)
    • (Clustered)
    
    
    

    Primary key (clustered) constraint

    
    
    • BusinessEntityID
    • StartDate
    • TerritoryID
  
  

  • AK_SalesTerritoryHistory_rowguid

    • (Unique)
    
    
    

    Unique nonclustered index. Used to support replication samples.

    
    
    • rowguid
  
  

  References:

  
  

  • Sales.SalesPerson

    
    
    
    • BusinessEntityID
  
  

  • Sales.SalesTerritory

    
    
    
    • TerritoryID
  
  

• Table Sales.ShoppingCartItem (3 rows)

  
  

  Contains online customer orders until the order is submitted or cancelled.

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	ShoppingCartItemID	int	X
  Primary key for ShoppingCartItem records.
  	ShoppingCartID	nvarchar(50)
  Shopping cart identification number.
  	Quantity	int			1
  Product quantity ordered.
  FK	ProductID	int
  Product ordered. Foreign key to Product.ProductID.
  	DateCreated	datetime			getdate()
  Date the time the record was created.
  	ModifiedDate	datetime			getdate()
  Date and time the record was last updated.

  
  

  Indexes:

  
  

  • PK_ShoppingCartItem_ShoppingCartItemID

    • (Primary Key)
    • (Clustered)
    
    
    

    Primary key (clustered) constraint

    
    
    • ShoppingCartItemID
  
  

  • IX_ShoppingCartItem_ShoppingCartID_ProductID

    
    
    

    Nonclustered index.

    
    
    • ShoppingCartID
    • ProductID
  
  

  References:

  
  

  • Production.Product

    
    
    
    • ProductID
  
  

• Table Sales.SpecialOffer (16 rows)

  
  

  Sale discounts lookup table.

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK	SpecialOfferID	int	X
  Primary key for SpecialOffer records.
  	Description	nvarchar(255)
  Discount description.
  	DiscountPct	smallmoney			0.00
  Discount precentage.
  	Type	nvarchar(50)
  Discount type category.
  	Category	nvarchar(50)
  Group the discount applies to such as Reseller or Customer.
  	StartDate	datetime
  Discount start date.
  	EndDate	datetime
  Discount end date.
  	MinQty	int			0
  Minimum discount percent allowed.
  	MaxQty	int		X
  Maximum discount percent allowed.
  UK	rowguid	uniqueidentifier			newid()
  ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
  	ModifiedDate	datetime			getdate()
  Date and time the record was last updated.

  
  

  Indexes:

  
  

  • PK_SpecialOffer_SpecialOfferID

    • (Primary Key)
    • (Clustered)
    
    
    

    Primary key (clustered) constraint

    
    
    • SpecialOfferID
  
  

  • AK_SpecialOffer_rowguid

    • (Unique)
    
    
    

    Unique nonclustered index. Used to support replication samples.

    
    
    • rowguid
  
  

  Referenced by:

  
  

  • Sales.SpecialOfferProduct

    
    
    
    • SpecialOfferID
  
  

• Table Sales.SpecialOfferProduct (538 rows)

  
  

  Cross-reference table mapping products to special offer discounts.

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK, FK	SpecialOfferID	int
  Primary key for SpecialOfferProduct records.
  PK, FK	ProductID	int
  Product identification number. Foreign key to Product.ProductID.
  UK	rowguid	uniqueidentifier			newid()
  ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
  	ModifiedDate	datetime			getdate()
  Date and time the record was last updated.

  
  

  Indexes:

  
  

  • PK_SpecialOfferProduct_SpecialOfferID_ProductID

    • (Primary Key)
    • (Clustered)
    
    
    

    Primary key (clustered) constraint

    
    
    • SpecialOfferID
    • ProductID
  
  

  • AK_SpecialOfferProduct_rowguid

    • (Unique)
    
    
    

    Unique nonclustered index. Used to support replication samples.

    
    
    • rowguid
  
  

  • IX_SpecialOfferProduct_ProductID

    
    
    

    Nonclustered index.

    
    
    • ProductID
  
  

  References:

  
  

  • Production.Product

    
    
    
    • ProductID
  
  

  • Sales.SpecialOffer

    
    
    
    • SpecialOfferID
  
  

  Referenced by:

  
  

  • Sales.SalesOrderDetail

    
    
    
    • ProductID
    • SpecialOfferID
  
  

• Table Sales.Store (701 rows)

  
  

  Customers (resellers) of Adventure Works products.

  
  

  	Column	Data Type	Identity	Nullable	Default
  PK, FK	BusinessEntityID	int
  Primary key. Foreign key to Customer.BusinessEntityID.
  	Name	Name(nvarchar(50))
  Name of the store.
  FK	SalesPersonID	int		X
  ID of the sales person assigned to the customer. Foreign key to SalesPerson.BusinessEntityID.
  	Demographics	xml		X
  Demographic informationg about the store such as the number of employees, annual sales and store type.
  UK	rowguid	uniqueidentifier			newid()
  ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
  	ModifiedDate	datetime			getdate()
  Date and time the record was last updated.

  
  

  Indexes:

  
  

  • PK_Store_BusinessEntityID

    • (Primary Key)
    • (Clustered)
    
    
    

    Primary key (clustered) constraint

    
    
    • BusinessEntityID
  
  

  • AK_Store_rowguid

    • (Unique)
    
    
    

    Unique nonclustered index. Used to support replication samples.

    
    
    • rowguid
  
  

  • IX_Store_SalesPersonID

    
    
    

    Nonclustered index.

    
    
    • SalesPersonID
  
  

  • PXML_Store_Demographics

    • (XML)
    
    
    

    Primary XML index.

    
    
    • Demographics
  
  

  References:

  
  

  • Person.BusinessEntity

    
    
    
    • BusinessEntityID
  
  

  • Sales.SalesPerson

    
    
    
    • BusinessEntityID (SalesPersonID)
  
  

  Referenced by:

  
  

  • Sales.Customer

    
    
    
    • StoreID (BusinessEntityID)
  
  

  Used by:

  
  

  • Function 

    dbo.ufnGetContactInformation

    
    
    
    • BusinessEntityID
    
    
  • View 

    Sales.vStoreWithAddresses

    
    
    
    • BusinessEntityID
    • Name
    
    
  • View 

    Sales.vStoreWithContacts

    
    
    
    • BusinessEntityID
    • Name
    
    
  • View 

    Sales.vStoreWithDemographics

    
    
    
    • BusinessEntityID
    • Demographics
    • Name