Production.Location

Table: 'Production.Location'

5 fields. 140 bytes.

Product inventory and manufacturing locations.

Field Name	Data Type	Size	Original Type	Default	Nullable	Description	Check
LocationID	smallint identity		smallint		Not null	Primary key for Location records.
Name	Name		nvarchar(50)		Not null	Location description.
CostRate	smallmoney	10,4	decimal(10,4)	(0.00)	Not null	Standard hourly cost of the manufacturing location.	([CostRate]>=(0.00))
Availability	decimal	8,2		(0.00)	Not null	Work capacity (in hours) of the manufacturing location.	([Availability]>=(0.00))
ModifiedDate	datetime			getdate()	Not null	Date and time the record was last updated.

Extended Properties

The object has no extended properties.

Primary key for table 'Production.Location'

Primary Key Name	Field Name
PK_Location_LocationID	LocationID

There are no Foreign Keys for this table.

Indexes for table 'Production.Location', 2 items

Index Name	Description	Clustered	Unique	Fields
PK_Location_LocationID	Clustered index created by a primary key constraint.	Yes	Yes	LocationID
AK_Location_Name	Unique nonclustered index.	No	Yes	Name

Triggers for table 'Production.Location', 1 item

Name	Description	Type	Enabled
uLocation	AFTER UPDATE trigger setting the ModifiedDate column in the Location table to the current date.	after Update	Yes

Dependencies for table 'Production.Location', 3 items

Object Name	Type	Field Name
Production.CK_Location_Availability	check cns	N/A
Production.CK_Location_CostRate	check cns	N/A
Production.uLocation	trigger	N/A