AdventureWorks - table columns

All table columns

parent	column	definition	comment
AWBuildVersion	SystemInformationID	tinyint identity NOT NULL	Primary key for AWBuildVersion records.
AWBuildVersion	Database Version	nvarchar(25) NOT NULL	Version number of the database in 9.yy.mm.dd.00 format.
AWBuildVersion	VersionDate	datetime NOT NULL	Date and time the record was last updated.
AWBuildVersion	ModifiedDate	datetime NOT NULL = (getdate())	Date and time the record was last updated.
DatabaseLog	DatabaseLogID	int identity NOT NULL	Primary key for DatabaseLog records.
DatabaseLog	PostTime	datetime NOT NULL	The date and time the DDL change occurred.
DatabaseLog	DatabaseUser	sysname NOT NULL	The user who implemented the DDL change.
DatabaseLog	Event	sysname NOT NULL	The type of DDL statement that was executed.
DatabaseLog	Schema	sysname NULL	The schema to which the changed object belongs.
DatabaseLog	Object	sysname NULL	The object that was changed by the DDL statment.
DatabaseLog	TSQL	nvarchar(max) NOT NULL	The exact Transact-SQL statement that was executed.
DatabaseLog	XmlEvent	xml NOT NULL	The raw XML data generated by database trigger.
ErrorLog	ErrorLogID	int identity NOT NULL	Primary key for ErrorLog records.
ErrorLog	ErrorTime	datetime NOT NULL = (getdate())	The date and time at which the error occurred.
ErrorLog	UserName	sysname NOT NULL	The user who executed the batch in which the error occurred.
ErrorLog	ErrorNumber	int NOT NULL	The error number of the error that occurred.
ErrorLog	ErrorSeverity	int NULL	The severity of the error that occurred.
ErrorLog	ErrorState	int NULL	The state number of the error that occurred.
ErrorLog	ErrorProcedure	nvarchar(126) NULL	The name of the stored procedure or trigger where the error occurred.
ErrorLog	ErrorLine	int NULL	The line number at which the error occurred.
ErrorLog	ErrorMessage	nvarchar(4000) NOT NULL	The message text of the error that occurred.
Department	DepartmentID	smallint identity NOT NULL	Primary key for Department records.
Department	Name	Name NOT NULL	Name of the department.
Department	GroupName	Name NOT NULL	Name of the group to which the department belongs.
Department	ModifiedDate	datetime NOT NULL = (getdate())	Date and time the record was last updated.
Employee	EmployeeID	int identity NOT NULL	Primary key for Employee records.
Employee	NationalIDNumber	nvarchar(15) NOT NULL	Unique national identification number such as a social security number.
Employee	ContactID	int NOT NULL	Identifies the employee in the Contact table. Foreign key to Contact.ContactID.
Employee	LoginID	nvarchar(256) NOT NULL	Network login.
Employee	ManagerID	int NULL	Manager to whom the employee is assigned. Foreign Key to Employee.M
Employee	Title	nvarchar(50) NOT NULL	Work title such as Buyer or Sales Representative.
Employee	BirthDate	datetime NOT NULL	Date of birth.
Employee	MaritalStatus	nchar(1) NOT NULL	M = Married, S = Single
Employee	Gender	nchar(1) NOT NULL	M = Male, F = Female
Employee	HireDate	datetime NOT NULL	Employee hired on this date.
Employee	SalariedFlag	Flag NOT NULL = ((1))	Job classification. 0 = Hourly, not exempt from collective bargaining. 1 = Salaried, exempt from collective bargaining.
Employee	VacationHours	smallint NOT NULL = ((0))	Number of available vacation hours.
Employee	SickLeaveHours	smallint NOT NULL = ((0))	Number of available sick leave hours.
Employee	CurrentFlag	Flag NOT NULL = ((1))	0 = Inactive, 1 = Active
Employee	rowguid	uniqueidentifier NOT NULL = (newid())	ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
Employee	ModifiedDate	datetime NOT NULL = (getdate())	Date and time the record was last updated.
EmployeeAddress	EmployeeID	int NOT NULL	Primary key. Foreign key to Employee.EmployeeID.
EmployeeAddress	AddressID	int NOT NULL	Primary key. Foreign key to Address.AddressID.
EmployeeAddress	rowguid	uniqueidentifier NOT NULL = (newid())	ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
EmployeeAddress	ModifiedDate	datetime NOT NULL = (getdate())	Date and time the record was last updated.
EmployeeDepartmentHistory	EmployeeID	int NOT NULL	Employee identification number. Foreign key to Employee.EmployeeID.
EmployeeDepartmentHistory	DepartmentID	smallint NOT NULL	Department in which the employee worked including currently. Foreign key to Department.DepartmentID.
EmployeeDepartmentHistory	ShiftID	tinyint NOT NULL	Identifies which 8-hour shift the employee works. Foreign key to Shift.Shift.ID.
EmployeeDepartmentHistory	StartDate	datetime NOT NULL	Date the employee started work in the department.
EmployeeDepartmentHistory	EndDate	datetime NULL	Date the employee left the department. NULL = Current department.
EmployeeDepartmentHistory	ModifiedDate	datetime NOT NULL = (getdate())	Date and time the record was last updated.
EmployeePayHistory	EmployeeID	int NOT NULL	Employee identification number. Foreign key to Employee.EmployeeID.
EmployeePayHistory	RateChangeDate	datetime NOT NULL	Date the change in pay is effective
EmployeePayHistory	Rate	money NOT NULL	Salary hourly rate.
EmployeePayHistory	PayFrequency	tinyint NOT NULL	1 = Salary received monthly, 2 = Salary received biweekly
EmployeePayHistory	ModifiedDate	datetime NOT NULL = (getdate())	Date and time the record was last updated.
JobCandidate	JobCandidateID	int identity NOT NULL	Primary key for JobCandidate records.
JobCandidate	EmployeeID	int NULL	Employee identification number if applicant was hired. Foreign key to Employee.EmployeeID.
JobCandidate	Resume	xml NULL	Résumé in XML format.
JobCandidate	ModifiedDate	datetime NOT NULL = (getdate())	Date and time the record was last updated.
Shift	ShiftID	tinyint identity NOT NULL	Primary key for Shift records.
Shift	Name	Name NOT NULL	Shift description.
Shift	StartTime	datetime NOT NULL	Shift start time.
Shift	EndTime	datetime NOT NULL	Shift end time.
Shift	ModifiedDate	datetime NOT NULL = (getdate())	Date and time the record was last updated.
Address	AddressID	int identity NOT NULL	Primary key for Address records.
Address	AddressLine1	nvarchar(60) NOT NULL	First street address line.
Address	AddressLine2	nvarchar(60) NULL	Second street address line.
Address	City	nvarchar(30) NOT NULL	Name of the city.
Address	StateProvinceID	int NOT NULL	Unique identification number for the state or province. Foreign key to StateProvince table.
Address	PostalCode	nvarchar(15) NOT NULL	Postal code for the street address.
Address	rowguid	uniqueidentifier NOT NULL = (newid())	ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
Address	ModifiedDate	datetime NOT NULL = (getdate())	Date and time the record was last updated.
AddressType	AddressTypeID	int identity NOT NULL	Primary key for AddressType records.
AddressType	Name	Name NOT NULL	Address type description. For example, Billing, Home, or Shipping.
AddressType	rowguid	uniqueidentifier NOT NULL = (newid())	ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
AddressType	ModifiedDate	datetime NOT NULL = (getdate())	Date and time the record was last updated.
Contact	ContactID	int identity NOT NULL	Primary key for Contact records.
Contact	NameStyle	NameStyle NOT NULL = ((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.
Contact	Title	nvarchar(8) NULL	A courtesy title. For example, Mr. or Ms.
Contact	FirstName	Name NOT NULL	First name of the person.
Contact	MiddleName	Name NULL	Middle name or middle initial of the person.
Contact	LastName	Name NOT NULL	Last name of the person.
Contact	Suffix	nvarchar(10) NULL	Surname suffix. For example, Sr. or Jr.
Contact	EmailAddress	nvarchar(50) NULL	E-mail address for the person.
Contact	EmailPromotion	int NOT NULL = ((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.
Contact	Phone	Phone NULL	Phone number associated with the person.
Contact	PasswordHash	varchar(128) NOT NULL	Password for the e-mail account.
Contact	PasswordSalt	varchar(10) NOT NULL	Random value concatenated with the password string before the password is hashed.
Contact	AdditionalContactInfo	xml NULL	Additional contact information about the person stored in xml format.
Contact	rowguid	uniqueidentifier NOT NULL = (newid())	ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
Contact	ModifiedDate	datetime NOT NULL = (getdate())	Date and time the record was last updated.
ContactType	ContactTypeID	int identity NOT NULL	Primary key for ContactType records.
ContactType	Name	Name NOT NULL	Contact type description.
ContactType	ModifiedDate	datetime NOT NULL = (getdate())	Date and time the record was last updated.
CountryRegion	CountryRegionCode	nvarchar(3) NOT NULL	ISO standard code for countries and regions.
CountryRegion	Name	Name NOT NULL	Country or region name.
CountryRegion	ModifiedDate	datetime NOT NULL = (getdate())	Date and time the record was last updated.
StateProvince	StateProvinceID	int identity NOT NULL	Primary key for StateProvince records.
StateProvince	StateProvinceCode	nchar(3) NOT NULL	ISO standard state or province code.
StateProvince	CountryRegionCode	nvarchar(3) NOT NULL	ISO standard country or region code. Foreign key to CountryRegion.CountryRegionCode.
StateProvince	IsOnlyStateProvinceFlag	Flag NOT NULL = ((1))	0 = StateProvinceCode exists. 1 = StateProvinceCode unavailable, using CountryRegionCode.
StateProvince	Name	Name NOT NULL	State or province description.
StateProvince	TerritoryID	int NOT NULL	ID of the territory in which the state or province is located. Foreign key to SalesTerritory.SalesTerritoryID.
StateProvince	rowguid	uniqueidentifier NOT NULL = (newid())	ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
StateProvince	ModifiedDate	datetime NOT NULL = (getdate())	Date and time the record was last updated.
BillOfMaterials	BillOfMaterialsID	int identity NOT NULL	Primary key for BillOfMaterials records.
BillOfMaterials	ProductAssemblyID	int NULL	Parent product identification number. Foreign key to Product.ProductID.
BillOfMaterials	ComponentID	int NOT NULL	Component identification number. Foreign key to Product.ProductID.
BillOfMaterials	StartDate	datetime NOT NULL = (getdate())	Date the component started being used in the assembly item.
BillOfMaterials	EndDate	datetime NULL	Date the component stopped being used in the assembly item.
BillOfMaterials	UnitMeasureCode	nchar(3) NOT NULL	Standard code identifying the unit of measure for the quantity.
BillOfMaterials	BOMLevel	smallint NOT NULL	Indicates the depth the component is from its parent (AssemblyID).
BillOfMaterials	PerAssemblyQty	decimal(8,2) NOT NULL = ((1.00))	Quantity of the component needed to create the assembly.
BillOfMaterials	ModifiedDate	datetime NOT NULL = (getdate())	Date and time the record was last updated.
Culture	CultureID	nchar(6) NOT NULL	Primary key for Culture records.
Culture	Name	Name NOT NULL	Culture description.
Culture	ModifiedDate	datetime NOT NULL = (getdate())	Date and time the record was last updated.
Document	DocumentID	int identity NOT NULL	Primary key for Document records.
Document	Title	nvarchar(50) NOT NULL	Title of the document.
Document	FileName	nvarchar(400) NOT NULL	Directory path and file name of the document
Document	FileExtension	nvarchar(8) NOT NULL	File extension indicating the document type. For example, .doc or .txt.
Document	Revision	nchar(5) NOT NULL	Revision number of the document.
Document	ChangeNumber	int NOT NULL = ((0))	Engineering change approval number.
Document	Status	tinyint NOT NULL	1 = Pending approval, 2 = Approved, 3 = Obsolete
Document	DocumentSummary	nvarchar(max) NULL	Document abstract.
Document	Document	varbinary NULL	Complete document.
Document	ModifiedDate	datetime NOT NULL = (getdate())	Date and time the record was last updated.
Illustration	IllustrationID	int identity NOT NULL	Primary key for Illustration records.
Illustration	Diagram	xml NULL	Illustrations used in manufacturing instructions. Stored as XML.
Illustration	ModifiedDate	datetime NOT NULL = (getdate())	Date and time the record was last updated.
Location	LocationID	smallint identity NOT NULL	Primary key for Location records.
Location	Name	Name NOT NULL	Location description.
Location	CostRate	smallmoney NOT NULL = ((0.00))	Standard hourly cost of the manufacturing location.
Location	Availability	decimal(8,2) NOT NULL = ((0.00))	Work capacity (in hours) of the manufacturing location.
Location	ModifiedDate	datetime NOT NULL = (getdate())	Date and time the record was last updated.
Product	ProductID	int identity NOT NULL	Primary key for Product records.
Product	Name	Name NOT NULL	Name of the product.
Product	ProductNumber	nvarchar(25) NOT NULL	Unique product identification number.
Product	MakeFlag	Flag NOT NULL = ((1))	0 = Product is purchased, 1 = Product is manufactured in-house.
Product	FinishedGoodsFlag	Flag NOT NULL = ((1))	0 = Product is not a salable item. 1 = Product is salable.
Product	Color	nvarchar(15) NULL	Product color.
Product	SafetyStockLevel	smallint NOT NULL	Minimum inventory quantity.
Product	ReorderPoint	smallint NOT NULL	Inventory level that triggers a purchase order or work order.
Product	StandardCost	money NOT NULL	Standard cost of the product.
Product	ListPrice	money NOT NULL	Selling price.
Product	Size	nvarchar(5) NULL	Product size.
Product	SizeUnitMeasureCode	nchar(3) NULL	Unit of measure for Size column.
Product	WeightUnitMeasureCode	nchar(3) NULL	Unit of measure for Weight column.
Product	Weight	decimal(8,2) NULL	Product weight.
Product	DaysToManufacture	int NOT NULL	Number of days required to manufacture the product.
Product	ProductLine	nchar(2) NULL	R = Road, M = Mountain, T = Touring, S = Standard
Product	Class	nchar(2) NULL	H = High, M = Medium, L = Low
Product	Style	nchar(2) NULL	W = Womens, M = Mens, U = Universal
Product	ProductSubcategoryID	int NULL	Product is a member of this product subcategory. Foreign key to ProductSubCategory.ProductSubCategoryID.
Product	ProductModelID	int NULL	Product is a member of this product model. Foreign key to ProductModel.ProductModelID.
Product	SellStartDate	datetime NOT NULL	Date the product was available for sale.
Product	SellEndDate	datetime NULL	Date the product was no longer available for sale.
Product	DiscontinuedDate	datetime NULL	Date the product was discontinued.
Product	rowguid	uniqueidentifier NOT NULL = (newid())	ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
Product	ModifiedDate	datetime NOT NULL = (getdate())	Date and time the record was last updated.
ProductCategory	ProductCategoryID	int identity NOT NULL	Primary key for ProductCategory records.
ProductCategory	Name	Name NOT NULL	Category description.
ProductCategory	rowguid	uniqueidentifier NOT NULL = (newid())	ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ProductCategory	ModifiedDate	datetime NOT NULL = (getdate())	Date and time the record was last updated.
ProductCostHistory	ProductID	int NOT NULL	Product identification number. Foreign key to Product.ProductID
ProductCostHistory	StartDate	datetime NOT NULL	Product cost start date.
ProductCostHistory	EndDate	datetime NULL	Product cost end date.
ProductCostHistory	StandardCost	money NOT NULL	Standard cost of the product.
ProductCostHistory	ModifiedDate	datetime NOT NULL = (getdate())	Date and time the record was last updated.
ProductDescription	ProductDescriptionID	int identity NOT NULL	Primary key for ProductDescription records.
ProductDescription	Description	nvarchar(400) NOT NULL	Description of the product.
ProductDescription	rowguid	uniqueidentifier NOT NULL = (newid())	ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ProductDescription	ModifiedDate	datetime NOT NULL = (getdate())	Date and time the record was last updated.
ProductDocument	ProductID	int NOT NULL	Product identification number. Foreign key to Product.ProductID.
ProductDocument	DocumentID	int NOT NULL	Document identification number. Foreign key to Document.DocumentID.
ProductDocument	ModifiedDate	datetime NOT NULL = (getdate())	Date and time the record was last updated.
ProductInventory	ProductID	int NOT NULL	Product identification number. Foreign key to Product.ProductID.
ProductInventory	LocationID	smallint NOT NULL	Inventory location identification number. Foreign key to Location.LocationID.
ProductInventory	Shelf	nvarchar(10) NOT NULL	Storage compartment within an inventory location.
ProductInventory	Bin	tinyint NOT NULL	Storage container on a shelf in an inventory location.
ProductInventory	Quantity	smallint NOT NULL = ((0))	Quantity of products in the inventory location.
ProductInventory	rowguid	uniqueidentifier NOT NULL = (newid())	ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ProductInventory	ModifiedDate	datetime NOT NULL = (getdate())	Date and time the record was last updated.
ProductListPriceHistory	ProductID	int NOT NULL	Product identification number. Foreign key to Product.ProductID
ProductListPriceHistory	StartDate	datetime NOT NULL	List price start date.
ProductListPriceHistory	EndDate	datetime NULL	List price end date
ProductListPriceHistory	ListPrice	money NOT NULL	Product list price.
ProductListPriceHistory	ModifiedDate	datetime NOT NULL = (getdate())	Date and time the record was last updated.
ProductModel	ProductModelID	int identity NOT NULL	Primary key for ProductModel records.
ProductModel	Name	Name NOT NULL	Product model description.
ProductModel	CatalogDescription	xml NULL	Detailed product catalog information in xml format.
ProductModel	Instructions	xml NULL	Manufacturing instructions in xml format.
ProductModel	rowguid	uniqueidentifier NOT NULL = (newid())	ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ProductModel	ModifiedDate	datetime NOT NULL = (getdate())	Date and time the record was last updated.
ProductModelIllustration	ProductModelID	int NOT NULL	Primary key. Foreign key to ProductModel.ProductModelID.
ProductModelIllustration	IllustrationID	int NOT NULL	Primary key. Foreign key to Illustration.IllustrationID.
ProductModelIllustration	ModifiedDate	datetime NOT NULL = (getdate())	Date and time the record was last updated.
ProductModelProductDescriptionCulture	ProductModelID	int NOT NULL	Primary key. Foreign key to ProductModel.ProductModelID.
ProductModelProductDescriptionCulture	ProductDescriptionID	int NOT NULL	Primary key. Foreign key to ProductDescription.ProductDescriptionID.
ProductModelProductDescriptionCulture	CultureID	nchar(6) NOT NULL	Culture identification number. Foreign key to Culture.CultureID.
ProductModelProductDescriptionCulture	ModifiedDate	datetime NOT NULL = (getdate())	Date and time the record was last updated.
ProductPhoto	ProductPhotoID	int identity NOT NULL	Primary key for ProductPhoto records.
ProductPhoto	ThumbNailPhoto	varbinary NULL	Small image of the product.
ProductPhoto	ThumbnailPhotoFileName	nvarchar(50) NULL	Small image file name.
ProductPhoto	LargePhoto	varbinary NULL	Large image of the product.
ProductPhoto	LargePhotoFileName	nvarchar(50) NULL	Large image file name.
ProductPhoto	ModifiedDate	datetime NOT NULL = (getdate())	Date and time the record was last updated.
ProductProductPhoto	ProductID	int NOT NULL	Product identification number. Foreign key to Product.ProductID.
ProductProductPhoto	ProductPhotoID	int NOT NULL	Product photo identification number. Foreign key to ProductPhoto.ProductPhotoID.
ProductProductPhoto	Primary	Flag NOT NULL = ((0))	0 = Photo is not the principal image. 1 = Photo is the principal image.
ProductProductPhoto	ModifiedDate	datetime NOT NULL = (getdate())	Date and time the record was last updated.
ProductReview	ProductReviewID	int identity NOT NULL	Primary key for ProductReview records.
ProductReview	ProductID	int NOT NULL	Product identification number. Foreign key to Product.ProductID.
ProductReview	ReviewerName	Name NOT NULL	Name of the reviewer.
ProductReview	ReviewDate	datetime NOT NULL = (getdate())	Date review was submitted.
ProductReview	EmailAddress	nvarchar(50) NOT NULL	Reviewer's e-mail address.
ProductReview	Rating	int NOT NULL	Product rating given by the reviewer. Scale is 1 to 5 with 5 as the highest rating.
ProductReview	Comments	nvarchar(3850) NULL	Reviewer's comments
ProductReview	ModifiedDate	datetime NOT NULL = (getdate())	Date and time the record was last updated.
ProductSubcategory	ProductSubcategoryID	int identity NOT NULL	Primary key for ProductSubcategory records.
ProductSubcategory	ProductCategoryID	int NOT NULL	Product category identification number. Foreign key to ProductCategory.ProductCategoryID.
ProductSubcategory	Name	Name NOT NULL	Subcategory description.
ProductSubcategory	rowguid	uniqueidentifier NOT NULL = (newid())	ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ProductSubcategory	ModifiedDate	datetime NOT NULL = (getdate())	Date and time the record was last updated.
ScrapReason	ScrapReasonID	smallint identity NOT NULL	Primary key for ScrapReason records.
ScrapReason	Name	Name NOT NULL	Failure description.
ScrapReason	ModifiedDate	datetime NOT NULL = (getdate())	Date and time the record was last updated.
TransactionHistory	TransactionID	int identity NOT NULL	Primary key for TransactionHistory records.
TransactionHistory	ProductID	int NOT NULL	Product identification number. Foreign key to Product.ProductID.
TransactionHistory	ReferenceOrderID	int NOT NULL	Purchase order, sales order, or work order identification number.
TransactionHistory	ReferenceOrderLineID	int NOT NULL = ((0))	Line number associated with the purchase order, sales order, or work order.
TransactionHistory	TransactionDate	datetime NOT NULL = (getdate())	Date and time of the transaction.
TransactionHistory	TransactionType	nchar(1) NOT NULL	W = WorkOrder, S = SalesOrder, P = PurchaseOrder
TransactionHistory	Quantity	int NOT NULL	Product quantity.
TransactionHistory	ActualCost	money NOT NULL	Product cost.
TransactionHistory	ModifiedDate	datetime NOT NULL = (getdate())	Date and time the record was last updated.
TransactionHistoryArchive	TransactionID	int NOT NULL	Primary key for TransactionHistoryArchive records.
TransactionHistoryArchive	ProductID	int NOT NULL	Product identification number. Foreign key to Product.ProductID.
TransactionHistoryArchive	ReferenceOrderID	int NOT NULL	Purchase order, sales order, or work order identification number.
TransactionHistoryArchive	ReferenceOrderLineID	int NOT NULL = ((0))	Line number associated with the purchase order, sales order, or work order.
TransactionHistoryArchive	TransactionDate	datetime NOT NULL = (getdate())	Date and time of the transaction.
TransactionHistoryArchive	TransactionType	nchar(1) NOT NULL	W = Work Order, S = Sales Order, P = Purchase Order
TransactionHistoryArchive	Quantity	int NOT NULL	Product quantity.
TransactionHistoryArchive	ActualCost	money NOT NULL	Product cost.
TransactionHistoryArchive	ModifiedDate	datetime NOT NULL = (getdate())	Date and time the record was last updated.
UnitMeasure	UnitMeasureCode	nchar(3) NOT NULL	Primary key.
UnitMeasure	Name	Name NOT NULL	Unit of measure description.
UnitMeasure	ModifiedDate	datetime NOT NULL = (getdate())	Date and time the record was last updated.
WorkOrder	WorkOrderID	int identity NOT NULL	Primary key for WorkOrder records.
WorkOrder	ProductID	int NOT NULL	Product identification number. Foreign key to Product.ProductID.
WorkOrder	OrderQty	int NOT NULL	Product quantity to build.
WorkOrder	StockedQty	int NOT NULL	Quantity built and put in inventory.
WorkOrder	ScrappedQty	smallint NOT NULL	Quantity that failed inspection.
WorkOrder	StartDate	datetime NOT NULL	Work order start date.
WorkOrder	EndDate	datetime NULL	Work order end date.
WorkOrder	DueDate	datetime NOT NULL	Work order due date.
WorkOrder	ScrapReasonID	smallint NULL	Reason for inspection failure.
WorkOrder	ModifiedDate	datetime NOT NULL = (getdate())	Date and time the record was last updated.
WorkOrderRouting	WorkOrderID	int NOT NULL	Primary key. Foreign key to WorkOrder.WorkOrderID.
WorkOrderRouting	ProductID	int NOT NULL	Primary key. Foreign key to Product.ProductID.
WorkOrderRouting	OperationSequence	smallint NOT NULL	Primary key. Indicates the manufacturing process sequence.
WorkOrderRouting	LocationID	smallint NOT NULL	Manufacturing location where the part is processed. Foreign key to Location.LocationID.
WorkOrderRouting	ScheduledStartDate	datetime NOT NULL	Planned manufacturing start date.
WorkOrderRouting	ScheduledEndDate	datetime NOT NULL	Planned manufacturing end date.
WorkOrderRouting	ActualStartDate	datetime NULL	Actual start date.
WorkOrderRouting	ActualEndDate	datetime NULL	Actual end date.
WorkOrderRouting	ActualResourceHrs	decimal(9,4) NULL	Number of manufacturing hours used.
WorkOrderRouting	PlannedCost	money NOT NULL	Estimated manufacturing cost.
WorkOrderRouting	ActualCost	money NULL	Actual manufacturing cost.
WorkOrderRouting	ModifiedDate	datetime NOT NULL = (getdate())	Date and time the record was last updated.
ProductVendor	ProductID	int NOT NULL	Primary key. Foreign key to Product.ProductID.
ProductVendor	VendorID	int NOT NULL	Primary key. Foreign key to Vendor.VendorID.
ProductVendor	AverageLeadTime	int NOT NULL	The average span of time (in days) between placing an order with the vendor and receiving the purchased product.
ProductVendor	StandardPrice	money NOT NULL	The vendor's usual selling price.
ProductVendor	LastReceiptCost	money NULL	The selling price when last purchased.
ProductVendor	LastReceiptDate	datetime NULL	Date the product was last received by the vendor.
ProductVendor	MinOrderQty	int NOT NULL	The maximum quantity that should be ordered.
ProductVendor	MaxOrderQty	int NOT NULL	The minimum quantity that should be ordered.
ProductVendor	OnOrderQty	int NULL	The quantity currently on order.
ProductVendor	UnitMeasureCode	nchar(3) NOT NULL	The product's unit of measure.
ProductVendor	ModifiedDate	datetime NOT NULL = (getdate())	Date and time the record was last updated.
PurchaseOrderDetail	PurchaseOrderID	int NOT NULL	Primary key. Foreign key to PurchaseOrderHeader.PurchaseOrderID.
PurchaseOrderDetail	PurchaseOrderDetailID	int identity NOT NULL	Primary key. One line number per purchased product.
PurchaseOrderDetail	DueDate	datetime NOT NULL	Date the product is expected to be received.
PurchaseOrderDetail	OrderQty	smallint NOT NULL	Quantity ordered.
PurchaseOrderDetail	ProductID	int NOT NULL	Product identification number. Foreign key to Product.ProductID.
PurchaseOrderDetail	UnitPrice	money NOT NULL	Vendor's selling price of a single product.
PurchaseOrderDetail	LineTotal	money NOT NULL	Per product subtotal. Computed as OrderQty * UnitPrice.
PurchaseOrderDetail	ReceivedQty	decimal(8,2) NOT NULL	Quantity actually received from the vendor.
PurchaseOrderDetail	RejectedQty	decimal(8,2) NOT NULL	Quantity rejected during inspection.
PurchaseOrderDetail	StockedQty	decimal(9,2) NOT NULL	Quantity accepted into inventory. Computed as ReceivedQty - RejectedQty.
PurchaseOrderDetail	ModifiedDate	datetime NOT NULL = (getdate())	Date and time the record was last updated.
PurchaseOrderHeader	PurchaseOrderID	int identity NOT NULL	Primary key.
PurchaseOrderHeader	RevisionNumber	tinyint NOT NULL = ((0))	Incremental number to track changes to the purchase order over time.
PurchaseOrderHeader	Status	tinyint NOT NULL = ((1))	Order current status. 1 = Pending; 2 = Approved; 3 = Rejected; 4 = Complete
PurchaseOrderHeader	EmployeeID	int NOT NULL	Employee who created the purchase order. Foreign key to Employee.EmployeeID.
PurchaseOrderHeader	VendorID	int NOT NULL	Vendor with whom the purchase order is placed. Foreign key to Vendor.VendorID.
PurchaseOrderHeader	ShipMethodID	int NOT NULL	Shipping method. Foreign key to ShipMethod.ShipMethodID.
PurchaseOrderHeader	OrderDate	datetime NOT NULL = (getdate())	Purchase order creation date.
PurchaseOrderHeader	ShipDate	datetime NULL	Estimated shipment date from the vendor.
PurchaseOrderHeader	SubTotal	money NOT NULL = ((0.00))	Purchase order subtotal. Computed as SUM(PurchaseOrderDetail.LineTotal)for the appropriate PurchaseOrderID.
PurchaseOrderHeader	TaxAmt	money NOT NULL = ((0.00))	Tax amount.
PurchaseOrderHeader	Freight	money NOT NULL = ((0.00))	Shipping cost.
PurchaseOrderHeader	TotalDue	money NOT NULL	Total due to vendor. Computed as Subtotal + TaxAmt + Freight.
PurchaseOrderHeader	ModifiedDate	datetime NOT NULL = (getdate())	Date and time the record was last updated.
ShipMethod	ShipMethodID	int identity NOT NULL	Primary key for ShipMethod records.
ShipMethod	Name	Name NOT NULL	Shipping company name.
ShipMethod	ShipBase	money NOT NULL = ((0.00))	Minimum shipping charge.
ShipMethod	ShipRate	money NOT NULL = ((0.00))	Shipping charge per pound.
ShipMethod	rowguid	uniqueidentifier NOT NULL = (newid())	ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ShipMethod	ModifiedDate	datetime NOT NULL = (getdate())	Date and time the record was last updated.
Vendor	VendorID	int identity NOT NULL	Primary key for Vendor records.
Vendor	AccountNumber	AccountNumber NOT NULL	Vendor account (identification) number.
Vendor	Name	Name NOT NULL	Company name.
Vendor	CreditRating	tinyint NOT NULL	1 = Superior, 2 = Excellent, 3 = Above average, 4 = Average, 5 = Below average
Vendor	PreferredVendorStatus	Flag NOT NULL = ((1))	0 = Do not use if another vendor is available. 1 = Preferred over other vendors supplying the same product.
Vendor	ActiveFlag	Flag NOT NULL = ((1))	0 = Vendor no longer used. 1 = Vendor is actively used.
Vendor	PurchasingWebServiceURL	nvarchar(1024) NULL	Vendor URL.
Vendor	ModifiedDate	datetime NOT NULL = (getdate())	Date and time the record was last updated.
VendorAddress	VendorID	int NOT NULL	Primary key. Foreign key to Vendor.VendorID.
VendorAddress	AddressID	int NOT NULL	Primary key. Foreign key to Address.AddressID.
VendorAddress	AddressTypeID	int NOT NULL	Address type. Foreign key to AddressType.AddressTypeID.
VendorAddress	ModifiedDate	datetime NOT NULL = (getdate())	Date and time the record was last updated.
VendorContact	VendorID	int NOT NULL	Primary key.
VendorContact	ContactID	int NOT NULL	Contact (Vendor employee) identification number. Foreign key to Contact.ContactID.
VendorContact	ContactTypeID	int NOT NULL	Contact type such as sales manager, or sales agent.
VendorContact	ModifiedDate	datetime NOT NULL = (getdate())	Date and time the record was last updated.
ContactCreditCard	ContactID	int NOT NULL	Customer identification number. Foreign key to Contact.ContactID.
ContactCreditCard	CreditCardID	int NOT NULL	Credit card identification number. Foreign key to CreditCard.CreditCardID.
ContactCreditCard	ModifiedDate	datetime NOT NULL = (getdate())	Date and time the record was last updated.
CountryRegionCurrency	CountryRegionCode	nvarchar(3) NOT NULL	ISO code for countries and regions. Foreign key to CountryRegion.CountryRegionCode.
CountryRegionCurrency	CurrencyCode	nchar(3) NOT NULL	ISO standard currency code. Foreign key to Currency.CurrencyCode.
CountryRegionCurrency	ModifiedDate	datetime NOT NULL = (getdate())	Date and time the record was last updated.
CreditCard	CreditCardID	int identity NOT NULL	Primary key for CreditCard records.
CreditCard	CardType	nvarchar(50) NOT NULL	Credit card name.
CreditCard	CardNumber	nvarchar(25) NOT NULL	Credit card number.
CreditCard	ExpMonth	tinyint NOT NULL	Credit card expiration month.
CreditCard	ExpYear	smallint NOT NULL	Credit card expiration year.
CreditCard	ModifiedDate	datetime NOT NULL = (getdate())	Date and time the record was last updated.
Currency	CurrencyCode	nchar(3) NOT NULL	The ISO code for the Currency.
Currency	Name	Name NOT NULL	Currency name.
Currency	ModifiedDate	datetime NOT NULL = (getdate())	Date and time the record was last updated.
CurrencyRate	CurrencyRateID	int identity NOT NULL	Primary key for CurrencyRate records.
CurrencyRate	CurrencyRateDate	datetime NOT NULL	Date and time the exchange rate was obtained.
CurrencyRate	FromCurrencyCode	nchar(3) NOT NULL	Exchange rate was converted from this currency code.
CurrencyRate	ToCurrencyCode	nchar(3) NOT NULL	Exchange rate was converted to this currency code.
CurrencyRate	AverageRate	money NOT NULL	Average exchange rate for the day.
CurrencyRate	EndOfDayRate	money NOT NULL	Final exchange rate for the day.
CurrencyRate	ModifiedDate	datetime NOT NULL = (getdate())	Date and time the record was last updated.
Customer	CustomerID	int identity NOT NULL	Primary key for Customer records.
Customer	TerritoryID	int NULL	ID of the territory in which the customer is located. Foreign key to SalesTerritory.SalesTerritoryID.
Customer	AccountNumber	varchar(10) NOT NULL	Unique number identifying the customer assigned by the accounting system.
Customer	CustomerType	nchar(1) NOT NULL	Customer type: I = Individual, S = Store
Customer	rowguid	uniqueidentifier NOT NULL = (newid())	ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
Customer	ModifiedDate	datetime NOT NULL = (getdate())	Date and time the record was last updated.
CustomerAddress	CustomerID	int NOT NULL	Primary key. Foreign key to Customer.CustomerID.
CustomerAddress	AddressID	int NOT NULL	Primary key. Foreign key to Address.AddressID.
CustomerAddress	AddressTypeID	int NOT NULL	Address type. Foreign key to AddressType.AddressTypeID.
CustomerAddress	rowguid	uniqueidentifier NOT NULL = (newid())	ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
CustomerAddress	ModifiedDate	datetime NOT NULL = (getdate())	Date and time the record was last updated.
Individual	CustomerID	int NOT NULL	Unique customer identification number. Foreign key to Customer.CustomerID.
Individual	ContactID	int NOT NULL	Identifies the customer in the Contact table. Foreign key to Contact.ContactID.
Individual	Demographics	xml NULL	Personal information such as hobbies, and income collected from online shoppers. Used for sales analysis.
Individual	ModifiedDate	datetime NOT NULL = (getdate())	Date and time the record was last updated.
SalesOrderDetail	SalesOrderID	int NOT NULL	Primary key. Foreign key to SalesOrderHeader.SalesOrderID.
SalesOrderDetail	SalesOrderDetailID	int identity NOT NULL	Primary key. One incremental unique number per product sold.
SalesOrderDetail	CarrierTrackingNumber	nvarchar(25) NULL	Shipment tracking number supplied by the shipper.
SalesOrderDetail	OrderQty	smallint NOT NULL	Quantity ordered per product.
SalesOrderDetail	ProductID	int NOT NULL	Product sold to customer. Foreign key to Product.ProductID.
SalesOrderDetail	SpecialOfferID	int NOT NULL	Promotional code. Foreign key to SpecialOffer.SpecialOfferID.
SalesOrderDetail	UnitPrice	money NOT NULL	Selling price of a single product.
SalesOrderDetail	UnitPriceDiscount	money NOT NULL = ((0.0))	Discount amount.
SalesOrderDetail	LineTotal	numeric(38,6) NOT NULL	Per product subtotal. Computed as UnitPrice * (1 - UnitPriceDiscount) * OrderQty.
SalesOrderDetail	rowguid	uniqueidentifier NOT NULL = (newid())	ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
SalesOrderDetail	ModifiedDate	datetime NOT NULL = (getdate())	Date and time the record was last updated.
SalesOrderHeader	SalesOrderID	int identity NOT NULL	Primary key.
SalesOrderHeader	RevisionNumber	tinyint NOT NULL = ((0))	Incremental number to track changes to the sales order over time.
SalesOrderHeader	OrderDate	datetime NOT NULL = (getdate())	Dates the sales order was created.
SalesOrderHeader	DueDate	datetime NOT NULL	Date the order is due to the customer.
SalesOrderHeader	ShipDate	datetime NULL	Date the order was shipped to the customer.
SalesOrderHeader	Status	tinyint NOT NULL = ((1))	Order current status. 1 = In process; 2 = Approved; 3 = Backordered; 4 = Rejected; 5 = Shipped; 6 = Cancelled
SalesOrderHeader	OnlineOrderFlag	Flag NOT NULL = ((1))	0 = Order placed by sales person. 1 = Order placed online by customer.
SalesOrderHeader	SalesOrderNumber	nvarchar(25) NOT NULL	Unique sales order identification number.
SalesOrderHeader	PurchaseOrderNumber	OrderNumber NULL	Customer purchase order number reference.
SalesOrderHeader	AccountNumber	AccountNumber NULL	Financial accounting number reference.
SalesOrderHeader	CustomerID	int NOT NULL	Customer identification number. Foreign key to Customer.CustomerID.
SalesOrderHeader	ContactID	int NOT NULL	Customer contact identification number. Foreign key to Contact.ContactID.
SalesOrderHeader	SalesPersonID	int NULL	Sales person who created the sales order. Foreign key to SalesPerson.SalePersonID.
SalesOrderHeader	TerritoryID	int NULL	Territory in which the sale was made. Foreign key to SalesTerritory.SalesTerritoryID.
SalesOrderHeader	BillToAddressID	int NOT NULL	Customer billing address. Foreign key to Address.AddressID.
SalesOrderHeader	ShipToAddressID	int NOT NULL	Customer shipping address. Foreign key to Address.AddressID.
SalesOrderHeader	ShipMethodID	int NOT NULL	Shipping method. Foreign key to ShipMethod.ShipMethodID.
SalesOrderHeader	CreditCardID	int NULL	Credit card identification number. Foreign key to CreditCard.CreditCardID.
SalesOrderHeader	CreditCardApprovalCode	varchar(15) NULL	Approval code provided by the credit card company.
SalesOrderHeader	CurrencyRateID	int NULL	Currency exchange rate used. Foreign key to CurrencyRate.CurrencyRateID.
SalesOrderHeader	SubTotal	money NOT NULL = ((0.00))	Sales subtotal. Computed as SUM(SalesOrderDetail.LineTotal)for the appropriate SalesOrderID.
SalesOrderHeader	TaxAmt	money NOT NULL = ((0.00))	Tax amount.
SalesOrderHeader	Freight	money NOT NULL = ((0.00))	Shipping cost.
SalesOrderHeader	TotalDue	money NOT NULL	Total due from customer. Computed as Subtotal + TaxAmt + Freight.
SalesOrderHeader	Comment	nvarchar(128) NULL	Sales representative comments.
SalesOrderHeader	rowguid	uniqueidentifier NOT NULL = (newid())	ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
SalesOrderHeader	ModifiedDate	datetime NOT NULL = (getdate())	Date and time the record was last updated.
SalesOrderHeaderSalesReason	SalesOrderID	int NOT NULL	Primary key. Foreign key to SalesOrderHeader.SalesOrderID.
SalesOrderHeaderSalesReason	SalesReasonID	int NOT NULL	Primary key. Foreign key to SalesReason.SalesReasonID.
SalesOrderHeaderSalesReason	ModifiedDate	datetime NOT NULL = (getdate())	Date and time the record was last updated.
SalesPerson	SalesPersonID	int NOT NULL	Primary key for SalesPerson records.
SalesPerson	TerritoryID	int NULL	Territory currently assigned to. Foreign key to SalesTerritory.SalesTerritoryID.
SalesPerson	SalesQuota	money NULL	Projected yearly sales.
SalesPerson	Bonus	money NOT NULL = ((0.00))	Bonus due if quota is met.
SalesPerson	CommissionPct	smallmoney NOT NULL = ((0.00))	Commision percent received per sale.
SalesPerson	SalesYTD	money NOT NULL = ((0.00))	Sales total year to date.
SalesPerson	SalesLastYear	money NOT NULL = ((0.00))	Sales total of previous year.
SalesPerson	rowguid	uniqueidentifier NOT NULL = (newid())	ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
SalesPerson	ModifiedDate	datetime NOT NULL = (getdate())	Date and time the record was last updated.
SalesPersonQuotaHistory	SalesPersonID	int NOT NULL	Sales person identification number. Foreign key to SalesPerson.SalesPersonID.
SalesPersonQuotaHistory	QuotaDate	datetime NOT NULL	Sales quota date.
SalesPersonQuotaHistory	SalesQuota	money NOT NULL	Sales quota amount.
SalesPersonQuotaHistory	rowguid	uniqueidentifier NOT NULL = (newid())	ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
SalesPersonQuotaHistory	ModifiedDate	datetime NOT NULL = (getdate())	Date and time the record was last updated.
SalesReason	SalesReasonID	int identity NOT NULL	Primary key for SalesReason records.
SalesReason	Name	Name NOT NULL	Sales reason description.
SalesReason	ReasonType	Name NOT NULL	Category the sales reason belongs to.
SalesReason	ModifiedDate	datetime NOT NULL = (getdate())	Date and time the record was last updated.
SalesTaxRate	SalesTaxRateID	int identity NOT NULL	Primary key for SalesTaxRate records.
SalesTaxRate	StateProvinceID	int NOT NULL	State, province, or country/region the sales tax applies to.
SalesTaxRate	TaxType	tinyint NOT NULL	1 = Tax applied to retail transactions, 2 = Tax applied to wholesale transactions, 3 = Tax applied to all sales (retail and wholesale) transactions.
SalesTaxRate	TaxRate	smallmoney NOT NULL = ((0.00))	Tax rate amount.
SalesTaxRate	Name	Name NOT NULL	Tax rate description.
SalesTaxRate	rowguid	uniqueidentifier NOT NULL = (newid())	ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
SalesTaxRate	ModifiedDate	datetime NOT NULL = (getdate())	Date and time the record was last updated.
SalesTerritory	TerritoryID	int identity NOT NULL	Primary key for SalesTerritory records.
SalesTerritory	Name	Name NOT NULL	Sales territory description
SalesTerritory	CountryRegionCode	nvarchar(3) NOT NULL	ISO standard country or region code. Foreign key to CountryRegion.CountryRegionCode.
SalesTerritory	Group	nvarchar(50) NOT NULL	Geographic area to which the sales territory belong.
SalesTerritory	SalesYTD	money NOT NULL = ((0.00))	Sales in the territory year to date.
SalesTerritory	SalesLastYear	money NOT NULL = ((0.00))	Sales in the territory the previous year.
SalesTerritory	CostYTD	money NOT NULL = ((0.00))	Business costs in the territory year to date.
SalesTerritory	CostLastYear	money NOT NULL = ((0.00))	Business costs in the territory the previous year.
SalesTerritory	rowguid	uniqueidentifier NOT NULL = (newid())	ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
SalesTerritory	ModifiedDate	datetime NOT NULL = (getdate())	Date and time the record was last updated.
SalesTerritoryHistory	SalesPersonID	int NOT NULL	Primary key for SalesTerritoryHistory records.
SalesTerritoryHistory	TerritoryID	int NOT NULL	Territory identification number. Foreign key to SalesTerritory.SalesTerritoryID.
SalesTerritoryHistory	StartDate	datetime NOT NULL	Date the sales representive started work in the territory.
SalesTerritoryHistory	EndDate	datetime NULL	Date the sales representative left work in the territory.
SalesTerritoryHistory	rowguid	uniqueidentifier NOT NULL = (newid())	ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
SalesTerritoryHistory	ModifiedDate	datetime NOT NULL = (getdate())	Date and time the record was last updated.
ShoppingCartItem	ShoppingCartItemID	int identity NOT NULL	Primary key for ShoppingCartItem records.
ShoppingCartItem	ShoppingCartID	nvarchar(50) NOT NULL	Shopping cart identification number.
ShoppingCartItem	Quantity	int NOT NULL = ((1))	Product quantity ordered.
ShoppingCartItem	ProductID	int NOT NULL	Product ordered. Foreign key to Product.ProductID.
ShoppingCartItem	DateCreated	datetime NOT NULL = (getdate())	Date the time the record was created.
ShoppingCartItem	ModifiedDate	datetime NOT NULL = (getdate())	Date and time the record was last updated.
SpecialOffer	SpecialOfferID	int identity NOT NULL	Primary key for SpecialOffer records.
SpecialOffer	Description	nvarchar(255) NOT NULL	Discount description.
SpecialOffer	DiscountPct	smallmoney NOT NULL = ((0.00))	Discount precentage.
SpecialOffer	Type	nvarchar(50) NOT NULL	Discount type category.
SpecialOffer	Category	nvarchar(50) NOT NULL	Group the discount applies to such as Reseller or Customer.
SpecialOffer	StartDate	datetime NOT NULL	Discount start date.
SpecialOffer	EndDate	datetime NOT NULL	Discount end date.
SpecialOffer	MinQty	int NOT NULL = ((0))	Minimum discount percent allowed.
SpecialOffer	MaxQty	int NULL	Maximum discount percent allowed.
SpecialOffer	rowguid	uniqueidentifier NOT NULL = (newid())	ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
SpecialOffer	ModifiedDate	datetime NOT NULL = (getdate())	Date and time the record was last updated.
SpecialOfferProduct	SpecialOfferID	int NOT NULL	Primary key for SpecialOfferProduct records.
SpecialOfferProduct	ProductID	int NOT NULL	Product identification number. Foreign key to Product.ProductID.
SpecialOfferProduct	rowguid	uniqueidentifier NOT NULL = (newid())	ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
SpecialOfferProduct	ModifiedDate	datetime NOT NULL = (getdate())	Date and time the record was last updated.
Store	CustomerID	int NOT NULL	Primary key. Foreign key to Customer.CustomerID.
Store	Name	Name NOT NULL	Name of the store.
Store	SalesPersonID	int NULL	ID of the sales person assigned to the customer. Foreign key to SalesPerson.SalesPersonID.
Store	Demographics	xml NULL	Demographic informationg about the store such as the number of employees, annual sales and store type.
Store	rowguid	uniqueidentifier NOT NULL = (newid())	ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
Store	ModifiedDate	datetime NOT NULL = (getdate())	Date and time the record was last updated.
StoreContact	CustomerID	int NOT NULL	Store identification number. Foreign key to Customer.CustomerID.
StoreContact	ContactID	int NOT NULL	Contact (store employee) identification number. Foreign key to Contact.ContactID.
StoreContact	ContactTypeID	int NOT NULL	Contact type such as owner or purchasing agent. Foreign key to ContactType.ContactTypeID.
StoreContact	rowguid	uniqueidentifier NOT NULL = (newid())	ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
StoreContact	ModifiedDate	datetime NOT NULL = (getdate())	Date and time the record was last updated.
vEmployee	EmployeeID	int NOT NULL
vEmployee	Title	nvarchar(8) NULL
vEmployee	FirstName	Name NOT NULL
vEmployee	MiddleName	Name NULL
vEmployee	LastName	Name NOT NULL
vEmployee	Suffix	nvarchar(10) NULL
vEmployee	JobTitle	nvarchar(50) NOT NULL
vEmployee	Phone	Phone NULL
vEmployee	EmailAddress	nvarchar(50) NULL
vEmployee	EmailPromotion	int NOT NULL
vEmployee	AddressLine1	nvarchar(60) NOT NULL
vEmployee	AddressLine2	nvarchar(60) NULL
vEmployee	City	nvarchar(30) NOT NULL
vEmployee	StateProvinceName	Name NOT NULL
vEmployee	PostalCode	nvarchar(15) NOT NULL
vEmployee	CountryRegionName	Name NOT NULL
vEmployee	AdditionalContactInfo	xml NULL
vEmployeeDepartment	EmployeeID	int NOT NULL
vEmployeeDepartment	Title	nvarchar(8) NULL
vEmployeeDepartment	FirstName	Name NOT NULL
vEmployeeDepartment	MiddleName	Name NULL
vEmployeeDepartment	LastName	Name NOT NULL
vEmployeeDepartment	Suffix	nvarchar(10) NULL
vEmployeeDepartment	JobTitle	nvarchar(50) NOT NULL
vEmployeeDepartment	Department	Name NOT NULL
vEmployeeDepartment	GroupName	Name NOT NULL
vEmployeeDepartment	StartDate	datetime NOT NULL
vEmployeeDepartmentHistory	EmployeeID	int NOT NULL
vEmployeeDepartmentHistory	Title	nvarchar(8) NULL
vEmployeeDepartmentHistory	FirstName	Name NOT NULL
vEmployeeDepartmentHistory	MiddleName	Name NULL
vEmployeeDepartmentHistory	LastName	Name NOT NULL
vEmployeeDepartmentHistory	Suffix	nvarchar(10) NULL
vEmployeeDepartmentHistory	Shift	Name NOT NULL
vEmployeeDepartmentHistory	Department	Name NOT NULL
vEmployeeDepartmentHistory	GroupName	Name NOT NULL
vEmployeeDepartmentHistory	StartDate	datetime NOT NULL
vEmployeeDepartmentHistory	EndDate	datetime NULL
vJobCandidate	JobCandidateID	int identity NOT NULL
vJobCandidate	EmployeeID	int NULL
vJobCandidate	Name.Prefix	nvarchar(30) NULL
vJobCandidate	Name.First	nvarchar(30) NULL
vJobCandidate	Name.Middle	nvarchar(30) NULL
vJobCandidate	Name.Last	nvarchar(30) NULL
vJobCandidate	Name.Suffix	nvarchar(30) NULL
vJobCandidate	Skills	nvarchar(max) NULL
vJobCandidate	Addr.Type	nvarchar(30) NULL
vJobCandidate	Addr.Loc.CountryRegion	nvarchar(100) NULL
vJobCandidate	Addr.Loc.State	nvarchar(100) NULL
vJobCandidate	Addr.Loc.City	nvarchar(100) NULL
vJobCandidate	Addr.PostalCode	nvarchar(20) NULL
vJobCandidate	EMail	nvarchar(max) NULL
vJobCandidate	WebSite	nvarchar(max) NULL
vJobCandidate	ModifiedDate	datetime NOT NULL
vJobCandidateEducation	JobCandidateID	int identity NOT NULL
vJobCandidateEducation	Edu.Level	nvarchar(max) NULL
vJobCandidateEducation	Edu.StartDate	datetime NULL
vJobCandidateEducation	Edu.EndDate	datetime NULL
vJobCandidateEducation	Edu.Degree	nvarchar(50) NULL
vJobCandidateEducation	Edu.Major	nvarchar(50) NULL
vJobCandidateEducation	Edu.Minor	nvarchar(50) NULL
vJobCandidateEducation	Edu.GPA	nvarchar(5) NULL
vJobCandidateEducation	Edu.GPAScale	nvarchar(5) NULL
vJobCandidateEducation	Edu.School	nvarchar(100) NULL
vJobCandidateEducation	Edu.Loc.CountryRegion	nvarchar(100) NULL
vJobCandidateEducation	Edu.Loc.State	nvarchar(100) NULL
vJobCandidateEducation	Edu.Loc.City	nvarchar(100) NULL
vJobCandidateEmployment	JobCandidateID	int identity NOT NULL
vJobCandidateEmployment	Emp.StartDate	datetime NULL
vJobCandidateEmployment	Emp.EndDate	datetime NULL
vJobCandidateEmployment	Emp.OrgName	nvarchar(100) NULL
vJobCandidateEmployment	Emp.JobTitle	nvarchar(100) NULL
vJobCandidateEmployment	Emp.Responsibility	nvarchar(max) NULL
vJobCandidateEmployment	Emp.FunctionCategory	nvarchar(max) NULL
vJobCandidateEmployment	Emp.IndustryCategory	nvarchar(max) NULL
vJobCandidateEmployment	Emp.Loc.CountryRegion	nvarchar(max) NULL
vJobCandidateEmployment	Emp.Loc.State	nvarchar(max) NULL
vJobCandidateEmployment	Emp.Loc.City	nvarchar(max) NULL
vAdditionalContactInfo	ContactID	int identity NOT NULL
vAdditionalContactInfo	FirstName	Name NOT NULL
vAdditionalContactInfo	MiddleName	Name NULL
vAdditionalContactInfo	LastName	Name NOT NULL
vAdditionalContactInfo	TelephoneNumber	nvarchar(50) NULL
vAdditionalContactInfo	TelephoneSpecialInstructions	nvarchar(max) NULL
vAdditionalContactInfo	Street	nvarchar(50) NULL
vAdditionalContactInfo	City	nvarchar(50) NULL
vAdditionalContactInfo	StateProvince	nvarchar(50) NULL
vAdditionalContactInfo	PostalCode	nvarchar(50) NULL
vAdditionalContactInfo	CountryRegion	nvarchar(50) NULL
vAdditionalContactInfo	HomeAddressSpecialInstructions	nvarchar(max) NULL
vAdditionalContactInfo	EMailAddress	nvarchar(128) NULL
vAdditionalContactInfo	EMailSpecialInstructions	nvarchar(max) NULL
vAdditionalContactInfo	EMailTelephoneNumber	nvarchar(50) NULL
vAdditionalContactInfo	rowguid	uniqueidentifier NOT NULL
vAdditionalContactInfo	ModifiedDate	datetime NOT NULL
vStateProvinceCountryRegion	StateProvinceID	int NOT NULL
vStateProvinceCountryRegion	StateProvinceCode	nchar(3) NOT NULL
vStateProvinceCountryRegion	IsOnlyStateProvinceFlag	Flag NOT NULL
vStateProvinceCountryRegion	StateProvinceName	Name NOT NULL
vStateProvinceCountryRegion	TerritoryID	int NOT NULL
vStateProvinceCountryRegion	CountryRegionCode	nvarchar(3) NOT NULL
vStateProvinceCountryRegion	CountryRegionName	Name NOT NULL
vProductAndDescription	ProductID	int NOT NULL
vProductAndDescription	Name	Name NOT NULL
vProductAndDescription	ProductModel	Name NOT NULL
vProductAndDescription	CultureID	nchar(6) NOT NULL
vProductAndDescription	Description	nvarchar(400) NOT NULL
vProductModelCatalogDescription	ProductModelID	int identity NOT NULL
vProductModelCatalogDescription	Name	Name NOT NULL
vProductModelCatalogDescription	Summary	nvarchar(max) NULL
vProductModelCatalogDescription	Manufacturer	nvarchar(max) NULL
vProductModelCatalogDescription	Copyright	nvarchar(30) NULL
vProductModelCatalogDescription	ProductURL	nvarchar(256) NULL
vProductModelCatalogDescription	WarrantyPeriod	nvarchar(256) NULL
vProductModelCatalogDescription	WarrantyDescription	nvarchar(256) NULL
vProductModelCatalogDescription	NoOfYears	nvarchar(256) NULL
vProductModelCatalogDescription	MaintenanceDescription	nvarchar(256) NULL
vProductModelCatalogDescription	Wheel	nvarchar(256) NULL
vProductModelCatalogDescription	Saddle	nvarchar(256) NULL
vProductModelCatalogDescription	Pedal	nvarchar(256) NULL
vProductModelCatalogDescription	BikeFrame	nvarchar(max) NULL
vProductModelCatalogDescription	Crankset	nvarchar(256) NULL
vProductModelCatalogDescription	PictureAngle	nvarchar(256) NULL
vProductModelCatalogDescription	PictureSize	nvarchar(256) NULL
vProductModelCatalogDescription	ProductPhotoID	nvarchar(256) NULL
vProductModelCatalogDescription	Material	nvarchar(256) NULL
vProductModelCatalogDescription	Color	nvarchar(256) NULL
vProductModelCatalogDescription	ProductLine	nvarchar(256) NULL
vProductModelCatalogDescription	Style	nvarchar(256) NULL
vProductModelCatalogDescription	RiderExperience	nvarchar(1024) NULL
vProductModelCatalogDescription	rowguid	uniqueidentifier NOT NULL
vProductModelCatalogDescription	ModifiedDate	datetime NOT NULL
vProductModelInstructions	ProductModelID	int identity NOT NULL
vProductModelInstructions	Name	Name NOT NULL
vProductModelInstructions	Instructions	nvarchar(max) NULL
vProductModelInstructions	LocationID	int NULL
vProductModelInstructions	SetupHours	decimal(9,4) NULL
vProductModelInstructions	MachineHours	decimal(9,4) NULL
vProductModelInstructions	LaborHours	decimal(9,4) NULL
vProductModelInstructions	LotSize	int NULL
vProductModelInstructions	Step	nvarchar(1024) NULL
vProductModelInstructions	rowguid	uniqueidentifier NOT NULL
vProductModelInstructions	ModifiedDate	datetime NOT NULL
vVendor	VendorID	int NOT NULL
vVendor	Name	Name NOT NULL
vVendor	ContactType	Name NOT NULL
vVendor	Title	nvarchar(8) NULL
vVendor	FirstName	Name NOT NULL
vVendor	MiddleName	Name NULL
vVendor	LastName	Name NOT NULL
vVendor	Suffix	nvarchar(10) NULL
vVendor	Phone	Phone NULL
vVendor	EmailAddress	nvarchar(50) NULL
vVendor	EmailPromotion	int NOT NULL
vVendor	AddressLine1	nvarchar(60) NOT NULL
vVendor	AddressLine2	nvarchar(60) NULL
vVendor	City	nvarchar(30) NOT NULL
vVendor	StateProvinceName	Name NOT NULL
vVendor	PostalCode	nvarchar(15) NOT NULL
vVendor	CountryRegionName	Name NOT NULL
vIndividualCustomer	CustomerID	int NOT NULL
vIndividualCustomer	Title	nvarchar(8) NULL
vIndividualCustomer	FirstName	Name NOT NULL
vIndividualCustomer	MiddleName	Name NULL
vIndividualCustomer	LastName	Name NOT NULL
vIndividualCustomer	Suffix	nvarchar(10) NULL
vIndividualCustomer	Phone	Phone NULL
vIndividualCustomer	EmailAddress	nvarchar(50) NULL
vIndividualCustomer	EmailPromotion	int NOT NULL
vIndividualCustomer	AddressType	Name NOT NULL
vIndividualCustomer	AddressLine1	nvarchar(60) NOT NULL
vIndividualCustomer	AddressLine2	nvarchar(60) NULL
vIndividualCustomer	City	nvarchar(30) NOT NULL
vIndividualCustomer	StateProvinceName	Name NOT NULL
vIndividualCustomer	PostalCode	nvarchar(15) NOT NULL
vIndividualCustomer	CountryRegionName	Name NOT NULL
vIndividualCustomer	Demographics	xml NULL
vIndividualDemographics	CustomerID	int NOT NULL
vIndividualDemographics	TotalPurchaseYTD	money NULL
vIndividualDemographics	DateFirstPurchase	datetime NULL
vIndividualDemographics	BirthDate	datetime NULL
vIndividualDemographics	MaritalStatus	nvarchar(1) NULL
vIndividualDemographics	YearlyIncome	nvarchar(30) NULL
vIndividualDemographics	Gender	nvarchar(1) NULL
vIndividualDemographics	TotalChildren	int NULL
vIndividualDemographics	NumberChildrenAtHome	int NULL
vIndividualDemographics	Education	nvarchar(30) NULL
vIndividualDemographics	Occupation	nvarchar(30) NULL
vIndividualDemographics	HomeOwnerFlag	bit NULL
vIndividualDemographics	NumberCarsOwned	int NULL
vSalesPerson	SalesPersonID	int NOT NULL
vSalesPerson	Title	nvarchar(8) NULL
vSalesPerson	FirstName	Name NOT NULL
vSalesPerson	MiddleName	Name NULL
vSalesPerson	LastName	Name NOT NULL
vSalesPerson	Suffix	nvarchar(10) NULL
vSalesPerson	JobTitle	nvarchar(50) NOT NULL
vSalesPerson	Phone	Phone NULL
vSalesPerson	EmailAddress	nvarchar(50) NULL
vSalesPerson	EmailPromotion	int NOT NULL
vSalesPerson	AddressLine1	nvarchar(60) NOT NULL
vSalesPerson	AddressLine2	nvarchar(60) NULL
vSalesPerson	City	nvarchar(30) NOT NULL
vSalesPerson	StateProvinceName	Name NOT NULL
vSalesPerson	PostalCode	nvarchar(15) NOT NULL
vSalesPerson	CountryRegionName	Name NOT NULL
vSalesPerson	TerritoryName	Name NULL
vSalesPerson	TerritoryGroup	nvarchar(50) NULL
vSalesPerson	SalesQuota	money NULL
vSalesPerson	SalesYTD	money NOT NULL
vSalesPerson	SalesLastYear	money NOT NULL
vSalesPersonSalesByFiscalYears	SalesPersonID	int NULL
vSalesPersonSalesByFiscalYears	FullName	nvarchar(152) NULL
vSalesPersonSalesByFiscalYears	Title	nvarchar(50) NOT NULL
vSalesPersonSalesByFiscalYears	SalesTerritory	Name NOT NULL
vSalesPersonSalesByFiscalYears	2002	money NULL
vSalesPersonSalesByFiscalYears	2003	money NULL
vSalesPersonSalesByFiscalYears	2004	money NULL
vStoreWithDemographics	CustomerID	int NOT NULL
vStoreWithDemographics	Name	Name NOT NULL
vStoreWithDemographics	ContactType	Name NOT NULL
vStoreWithDemographics	Title	nvarchar(8) NULL
vStoreWithDemographics	FirstName	Name NOT NULL
vStoreWithDemographics	MiddleName	Name NULL
vStoreWithDemographics	LastName	Name NOT NULL
vStoreWithDemographics	Suffix	nvarchar(10) NULL
vStoreWithDemographics	Phone	Phone NULL
vStoreWithDemographics	EmailAddress	nvarchar(50) NULL
vStoreWithDemographics	EmailPromotion	int NOT NULL
vStoreWithDemographics	AddressType	Name NOT NULL
vStoreWithDemographics	AddressLine1	nvarchar(60) NOT NULL
vStoreWithDemographics	AddressLine2	nvarchar(60) NULL
vStoreWithDemographics	City	nvarchar(30) NOT NULL
vStoreWithDemographics	StateProvinceName	Name NOT NULL
vStoreWithDemographics	PostalCode	nvarchar(15) NOT NULL
vStoreWithDemographics	CountryRegionName	Name NOT NULL
vStoreWithDemographics	AnnualSales	money NULL
vStoreWithDemographics	AnnualRevenue	money NULL
vStoreWithDemographics	BankName	nvarchar(50) NULL
vStoreWithDemographics	BusinessType	nvarchar(5) NULL
vStoreWithDemographics	YearOpened	int NULL
vStoreWithDemographics	Specialty	nvarchar(50) NULL
vStoreWithDemographics	SquareFeet	int NULL
vStoreWithDemographics	Brands	nvarchar(30) NULL
vStoreWithDemographics	Internet	nvarchar(30) NULL
vStoreWithDemographics	NumberEmployees	int NULL