Production.Location Table

Description

Product inventory and manufacturing locations.

Properties

Creation Date	27/10/2017 14:33
File Group	PRIMARY
Text File Group
System Object
Published for Replication
Rows	14
Data Space Used	8.00 KB
Index Space Used	24.00 KB

Columns

Column Name	Description	Datatype	Length	Default
LocationID	Primary key for Location records.	SmallInt	2
Name	Location description.	dbo.Name	50
CostRate	Standard hourly cost of the manufacturing location.	Currency	8	((0.00))
Availability	Work capacity (in hours) of the manufacturing location.	Numeric	9 (8,2)	((0.00))
ModifiedDate	Date and time the record was last updated.	DBTimeStamp	4	(getdate())

Indexes

Index	Description	Primary	Unique
AK_Location_Name	Unique nonclustered index.
PK_Location_LocationID	Primary key (clustered) constraint

Check Constraints

Name	Description	Expression
CK_Location_Availability	Check constraint [Availability] >= (0.00)	([Availability]>=(0.00))
CK_Location_CostRate	Check constraint [CostRate] >= (0.00)	([CostRate]>=(0.00))

Relationships

Relationship	Description
FK_ProductInventory_Location_LocationID	Foreign key constraint referencing Location.LocationID.
FK_WorkOrderRouting_Location_LocationID	Foreign key constraint referencing Location.LocationID.

Objects that depend on Production.Location

Database Object	Object Type	Description	Dep Level
Production.ProductInventory	Table	Product inventory information.	1
dbo.ufnGetStock	User Defined Function	Scalar function returning the quantity of inventory in LocationID 6 (Miscellaneous Storage)for a specified ProductID.	2
Production.WorkOrderRouting	Table	Work order details.	1

Objects that Production.Location depends on

	Database Object	Object Type	Description	Dep Level
	dbo.Name	User Defined Data Type		1

SQL

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [Production].[Location](
    [LocationID] [smallint] IDENTITY(1,1) NOT NULL,
    [Name] [dbo].[Name] NOT NULL,
    [CostRate] [smallmoney] NOT NULL,
    [Availability] [decimal](8, 2) NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_Location_LocationID] PRIMARY KEY CLUSTERED 
(
    [LocationID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

ALTER TABLE [Production].[Location] ADD  CONSTRAINT [DF_Location_CostRate]  DEFAULT ((0.00)) FOR [CostRate]
ALTER TABLE [Production].[Location] ADD  CONSTRAINT [DF_Location_Availability]  DEFAULT ((0.00)) FOR [Availability]
ALTER TABLE [Production].[Location] ADD  CONSTRAINT [DF_Location_ModifiedDate]  DEFAULT (getdate()) FOR [ModifiedDate]
ALTER TABLE [Production].[Location]  WITH CHECK ADD  CONSTRAINT [CK_Location_Availability] CHECK  (([Availability]>=(0.00)))
ALTER TABLE [Production].[Location] CHECK CONSTRAINT [CK_Location_Availability]
ALTER TABLE [Production].[Location]  WITH CHECK ADD  CONSTRAINT [CK_Location_CostRate] CHECK  (([CostRate]>=(0.00)))
ALTER TABLE [Production].[Location] CHECK CONSTRAINT [CK_Location_CostRate]

Related Objects