AdventureWorks

Basic Index   Expanded Index

Table Name:Production.Location
Description:Product inventory and manufacturing locations.
Primary Keys:LocationID
FieldTypeDefaultsNulls?Comments
LocationIDsmallint - IdentityNoneNoPrimary key for Location records.
Namenvarchar (50)NoneNoLocation description.
CostRatesmallmoney((0.00))NoStandard hourly cost of the manufacturing location.
Availabilitydecimal (8, 2)((0.00))NoWork capacity (in hours) of the manufacturing location.
ModifiedDatedatetime(getdate())NoDate and time the record was last updated.

IndexClustered?Unique?Fields
PK_Location_LocationIDYesYesLocationID
AK_Location_NameNoYesName

Check ConstraintText
CK_Location_CostRate([CostRate]>=(0.00))
CK_Location_Availability([Availability]>=(0.00))

No internal foreign key constraints
Primary Key as Foreign Key ConstraintAffected TableAffected Field
FK_ProductInventory_Location_LocationIDProduction.ProductInventoryLocationID
FK_WorkOrderRouting_Location_LocationIDProduction.WorkOrderRoutingLocationID

No triggers