Production.Location - AdventureWorks

AdventureWorks

- AdventureWorks

Documentation	AdventureWorks
Schema	Production
Name	Location
Module	Inventory

Product inventory and manufacturing locations.

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		LocationID	smallint		Identity		Primary key for Location records.
Primary key for Location records. Identity
	2		Name	nvarchar(50)				Location description.
Location description.
	3		CostRate	smallmoney		Default: 0.00		Standard hourly cost of the manufacturing location.
Standard hourly cost of the manufacturing location. Default: 0.00
	4		Availability	decimal(8, 2)		Default: 0.00		Work capacity (in hours) of the manufacturing location.
Work capacity (in hours) of the manufacturing location. Default: 0.00
	5		ModifiedDate	datetime		Default: getdate()		Date and time the record was last updated.
Date and time the record was last updated. Default: getdate()

Relations

Foreign table		Primary table	Join	Title / Name / Description
Production.ProductInventory		Production.Location	Production.ProductInventory.LocationID = Production.Location.LocationID	FK_ProductInventory_Location_LocationID Foreign key constraint referencing Location.LocationID.
Production.ProductInventory.LocationID = Production.Location.LocationID Name: FK_ProductInventory_Location_LocationID Foreign key constraint referencing Location.LocationID.
Production.WorkOrderRouting		Production.Location	Production.WorkOrderRouting.LocationID = Production.Location.LocationID	FK_WorkOrderRouting_Location_LocationID Foreign key constraint referencing Location.LocationID.
Production.WorkOrderRouting.LocationID = Production.Location.LocationID Name: FK_WorkOrderRouting_Location_LocationID Foreign key constraint referencing Location.LocationID.

Unique keys

	Key name	Columns	Description
	PK_Location_LocationID	LocationID	Primary key (clustered) constraint
Primary key (clustered) constraint
	AK_Location_Name	Name	Unique nonclustered index.
Unique nonclustered index.

Used by

Name
Production.Location
Production.ProductInventory
Production.WorkOrderRouting

Exported: 2019-02-04 23:13, Last imported: 2018-03-07 11:56