| Column | Data Type | Nullable | Default | Description / PK / Index |
| LocationID | smallint | not null | | Primary key for Location records.
PK_Location_LocationID |
| Name | dbo.Name | not null | | Location description.
AK_Location_Name |
| CostRate | smallmoney | not null | ((0.00)) | Standard hourly cost of the manufacturing location.
|
| Availability | decimal(8, 2) | not null | ((0.00)) | Work capacity (in hours) of the manufacturing location.
|
| ModifiedDate | datetime | not null | (getdate()) | Date and time the record was last updated.
|