AdventureWorks
| Table Name: | Production.UnitMeasure |
| Description: | Unit of measure lookup table. |
| Primary Keys: | UnitMeasureCode |
| Field | Type | Defaults | Nulls? | Comments |
|---|---|---|---|---|
| UnitMeasureCode | nchar (3) | None | No | Primary key. |
| Name | nvarchar (50) | None | No | Unit of measure description. |
| ModifiedDate | datetime | (getdate()) | No | Date and time the record was last updated. |
| Index | Clustered? | Unique? | Fields |
|---|---|---|---|
| PK_UnitMeasure_UnitMeasureCode | Yes | Yes | UnitMeasureCode |
| AK_UnitMeasure_Name | No | Yes | Name |
| Primary Key as Foreign Key Constraint | Affected Table | Affected Field |
|---|---|---|
| FK_BillOfMaterials_UnitMeasure_UnitMeasureCode | Production.BillOfMaterials | UnitMeasureCode |
| FK_Product_UnitMeasure_SizeUnitMeasureCode | Production.Product | SizeUnitMeasureCode |
| FK_Product_UnitMeasure_WeightUnitMeasureCode | Production.Product | WeightUnitMeasureCode |
| FK_ProductVendor_UnitMeasure_UnitMeasureCode | Purchasing.ProductVendor | UnitMeasureCode |