Owner: Production 
Creation Date: 04/26/2006 
Located On: PRIMARY 
Data Size KB:
Index Size KB: 24 
Rows: 38 
Description: Unit of measure lookup table. 


Name Data Type Length NULL Default IsIdentity IsGUID Description
    UnitMeasureCode  nchar          Primary key. 
    Name  Name  100          Unit of measure description. 
    ModifiedDate  datetime    (getdate())      Date and time the record was last updated. 
Total: 3 column(s)


Index Primary Unique Description
  PK_UnitMeasure_UnitMeasureCode      Primary key (clustered) constraint 
  AK_UnitMeasure_Name      Unique nonclustered index. 
Total: 2 index(es)

Referencing Tables

Table Foreign Key Primary Key or Unique Constraint
  Production.Product  FK_Product_UnitMeasure_SizeUnitMeasureCode  PK_UnitMeasure_UnitMeasureCode 
  Production.Product  FK_Product_UnitMeasure_WeightUnitMeasureCode  PK_UnitMeasure_UnitMeasureCode 
  Purchasing.ProductVendor  FK_ProductVendor_UnitMeasure_UnitMeasureCode  PK_UnitMeasure_UnitMeasureCode 
  Production.BillOfMaterials  FK_BillOfMaterials_UnitMeasure_UnitMeasureCode  PK_UnitMeasure_UnitMeasureCode 
Total: 4 table(s)

Objects that [Production].[UnitMeasure] depends on

Object Name Owner Object Type Dep Level
  Name  dbo  User Defined type 
Total: 1 object(s)

Objects that depend on [Production].[UnitMeasure]

Object Name Owner Object Type Dep Level
  Product  Production  Table 
  vProductAndDescription  Production  View 
  BillOfMaterials  Production  Table 
  ProductCostHistory  Production  Table 
  ProductDocument  Production  Table 
  ProductInventory  Production  Table 
  ProductListPriceHistory  Production  Table 
  ProductProductPhoto  Production  Table 
  ProductReview  Production  Table 
  ProductVendor  Purchasing  Table 
  PurchaseOrderDetail  Purchasing  Table 
  ShoppingCartItem  Sales  Table 
  SpecialOfferProduct  Sales  Table 
  TransactionHistory  Production  Table 
  WorkOrder  Production  Table 
  ufnGetProductDealerPrice  dbo  Function 
  ufnGetProductListPrice  dbo  Function 
  ufnGetProductStandardCost  dbo  Function 
  ufnGetStock  dbo  Function 
  SalesOrderDetail  Sales  Table 
  WorkOrderRouting  Production  Table 
  uspGetBillOfMaterials  dbo  Procedure 
  uspGetWhereUsedProductID  dbo  Procedure 
  iPurchaseOrderDetail  Purchasing  Trigger 
  iWorkOrder  Production  Trigger 
  uPurchaseOrderDetail  Purchasing  Trigger 
  uWorkOrder  Production  Trigger 
  iduSalesOrderDetail  Sales  Trigger 
Total: 28 object(s)


CREATE TABLE [UnitMeasure] (
    [UnitMeasureCode] [nchar] (3) COLLATE Latin1_General_CS_AS NOT NULL ,
    [Name] [Name] NOT NULL ,
    [ModifiedDate] [datetime] NOT NULL CONSTRAINT [DF_UnitMeasure_ModifiedDate] DEFAULT (getdate()),
    )  ON [PRIMARY]

See Also

List of tables