Tables | SQL 2005 Adventure Works OLTP |
Product inventory and manufacturing locations.
Columns
Name Data type Nullable Description LocationID smallint No Column has identity seed value of 1 with a step value of 1.
Primary key for Location records.Name Name No Location description. CostRate smallmoney No Default value: 0.00
Standard hourly cost of the manufacturing location.Availability decimal(8, 2) No Default value: 0.00
Work capacity (in hours) of the manufacturing location.ModifiedDate datetime No Default value: GETDATE()
Date and time the record was last updated.
Constraints
Name Type Columns Description DF_Location_CostRate DEFAULT CostRate Value: 0.00
Default constraint value of 0.0DF_Location_Availability DEFAULT Availability Value: 0.00
Default constraint value of 0.00DF_Location_ModifiedDate DEFAULT ModifiedDate Value: GETDATE()
Default constraint value of GETDATE()CK_Location_CostRate CHECK N/A Value: ([CostRate] >= 0.00)
Check constraint [CostRate]>=(0.00)CK_Location_Availability CHECK N/A Value: ([Availability] >= 0.00)
Check constraint [Availability]>=(0.00)PK_Location_LocationID PRIMARY KEY LocationID Clustered index created by a primary key constraint.
Indices
Name Description AK_Location_Name Unique nonclustered index.
Triggers
Name Description Production.uLocation AFTER UPDATE trigger setting the ModifiedDate column in the Location table to the current date.
Linked tables
Name Description Production.ProductInventory Product inventory information. Production.WorkOrderRouting Work order details.
Modified by
Name Description Production.uLocation AFTER UPDATE trigger setting the ModifiedDate column in the Location table to the current date.
Applies to
Tables | User