Object type: Table

Unit of measure lookup table.

Columns 

Name	Data type	Nullable	Description
UnitMeasureCode	nchar(3)	No	Primary key.
Name	Name	No	Unit of measure description.
ModifiedDate	datetime	No	Default value: GETDATE() Date and time the record was last updated.

Constraints 

Name	Type	Columns	Description
DF_UnitMeasure_ModifiedDate	DEFAULT	ModifiedDate	Value: GETDATE() Default constraint value of GETDATE()
PK_UnitMeasure_UnitMeasureCode	PRIMARY KEY	UnitMeasureCode	Clustered index created by a primary key constraint.

Indices 

Name	Description
AK_UnitMeasure_Name	Unique nonclustered index.

Triggers 

Name	Description
Production.uUnitMeasure	AFTER UPDATE trigger setting the ModifiedDate column in the UnitMeasure table to the current date.

Linked tables 

Name	Description
Production.BillOfMaterials	Items required to make bicycles and bicycle subassemblies. It identifies the heirarchical relationship between a parent product and its components.
Production.Product	Products sold or used in the manfacturing of sold products.
Purchasing.ProductVendor	Cross-reference table mapping vendors with the products they supply.

Modified by 

Name	Description
Production.uUnitMeasure	AFTER UPDATE trigger setting the ModifiedDate column in the UnitMeasure table to the current date.

Applies to

Tables | User

The AdventureWorks database sample was developed by Microsoft Corporation, copyright 2005. SQL Server is a trademark of Microsoft Corporation