Database reference - AdventureWorks

AdventureWorks -  tables -  [Production].[Location]

Description

Product inventory and manufacturing locations. 

Table properties

namevalue
name[Production].[Location]
createdMar 19 2009 9:08PM
modifiedMar 19 2009 9:08PM 
ansi nullson 
quoted identifieron 
row count14
Size of data8 kb
Size of indexes24 kb
Maximum size of a single row219 bytes

Columns

columndatatypelengthbytesdefaultnullsPKFKUQcomputedcomment
LocationIDsmallint identity(1,1)52 no  yes    no  Primary key for Location records. 
NameName50200 no      no  Location description. 
CostRatesmallmoney104((0.00))no      no  Standard hourly cost of the manufacturing location. 
Availabilitydecimal(8,2)85((0.00))no      no  Work capacity (in hours) of the manufacturing location. 
ModifiedDatedatetime238(getdate())no      no  Date and time the record was last updated. 

Indexes

namedescriptioncolumncomment
AK_Location_Namenonclustered, unique located on PRIMARYNameUnique nonclustered index. 
PK_Location_LocationIDclustered, unique, primary key located on PRIMARYLocationIDClustered index created by a primary key constraint. 

Referenced by

name
ProductInventory
WorkOrderRouting

Foreign key graph

LocationProductInventoryWorkOrderRouting

Check constraints

namecolumncomment
CK_Location_CostRateCostRate    Check constraint [CostRate] >= (0.00) 
CK_Location_AvailabilityAvailability    Check constraint [Availability] >= (0.00) 

Defaults

default namecolumncomment
DF_Location_CostRateCostRateDefault constraint value of 0.0 
DF_Location_AvailabilityAvailabilityDefault constraint value of 0.00 
DF_Location_ModifiedDateModifiedDateDefault constraint value of GETDATE() 

Dependency graph

DF_Location_AvailabilityDF_Location_CostRateDF_Location_ModifiedDateNameLocationCK_Location_AvailabilityCK_Location_CostRateAK_Location_NamePK_Location_LocationID

Objects that [Production].[Location] depends on

nameobject typelevel
Nametype1

Sample rows

LocationIDNameCostRateAvailabilityModifiedDate
1  Tool Crib  0.0000  0.00  6/1/1998 12:00:00 AM 
2  Sheet Metal Racks  0.0000  0.00  6/1/1998 12:00:00 AM 
3  Paint Shop  0.0000  0.00  6/1/1998 12:00:00 AM 
4  Paint Storage  0.0000  0.00  6/1/1998 12:00:00 AM 
5  Metal Storage  0.0000  0.00  6/1/1998 12:00:00 AM 
6  Miscellaneous Storage  0.0000  0.00  6/1/1998 12:00:00 AM 
7  Finished Goods Storage  0.0000  0.00  6/1/1998 12:00:00 AM 
10  Frame Forming  22.5000  96.00  6/1/1998 12:00:00 AM 
20  Frame Welding  25.0000  108.00  6/1/1998 12:00:00 AM 
30  Debur and Polish  14.5000  120.00  6/1/1998 12:00:00 AM 

Code

CREATE TABLE [Production].[Location](
    [LocationID] [smallint] IDENTITY(1,1) NOT NULL,
    [Name] [dbo].[Name] NOT NULL,
    [LocationID] [smallint] IDENTITY(1,1) 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]  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]
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]

Powered by Yoyodyne © 1971