AdventureWorks
| Table Name: | Production.Location |
| Description: | Product inventory and manufacturing locations. |
| Primary Keys: | LocationID |
| Field | Type | Defaults | Nulls? | Comments |
|---|---|---|---|---|
| LocationID | smallint - Identity | None | No | Primary key for Location records. |
| Name | nvarchar (50) | None | No | Location description. |
| CostRate | smallmoney | ((0.00)) | No | Standard hourly cost of the manufacturing location. |
| Availability | decimal (8, 2) | ((0.00)) | No | Work capacity (in hours) of the manufacturing location. |
| ModifiedDate | datetime | (getdate()) | No | Date and time the record was last updated. |
| Index | Clustered? | Unique? | Fields |
|---|---|---|---|
| PK_Location_LocationID | Yes | Yes | LocationID |
| AK_Location_Name | No | Yes | Name |
| Check Constraint | Text |
|---|---|
| CK_Location_CostRate | ([CostRate]>=(0.00)) |
| CK_Location_Availability | ([Availability]>=(0.00)) |
| Primary Key as Foreign Key Constraint | Affected Table | Affected Field |
|---|---|---|
| FK_ProductInventory_Location_LocationID | Production.ProductInventory | LocationID |
| FK_WorkOrderRouting_Location_LocationID | Production.WorkOrderRouting | LocationID |