Owner: Purchasing 
Creation Date: 04/26/2006 
Located On: PRIMARY 
Data Size KB:
Index Size KB: 40 
Description: Shipping company lookup table. 


Name Data Type Length NULL Default IsIdentity IsGUID Description
    ShipMethodID  int          Primary key for ShipMethod records. 
    Name  Name  100          Shipping company name. 
    ShipBase  money    ((0.00))      Minimum shipping charge. 
    ShipRate  money    ((0.00))      Shipping charge per pound. 
    rowguid  uniqueidentifier  16    (newid())      ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. 
    ModifiedDate  datetime    (getdate())      Date and time the record was last updated. 
Total: 6 column(s)

Identity column

Name Seed Increment Not for replication


Index Primary Unique Description
  PK_ShipMethod_ShipMethodID      Primary key (clustered) constraint 
  AK_ShipMethod_Name      Unique nonclustered index. 
  AK_ShipMethod_rowguid      Unique nonclustered index. Used to support replication samples. 
Total: 3 index(es)

Check Constraints

Name Expression
  CK_ShipMethod_ShipBase  ([ShipBase]>(0.00)) 
  CK_ShipMethod_ShipRate  ([ShipRate]>(0.00)) 
Total: 2 constraint(s)

Referencing Tables

Table Foreign Key Primary Key or Unique Constraint
  Purchasing.PurchaseOrderHeader  FK_PurchaseOrderHeader_ShipMethod_ShipMethodID  PK_ShipMethod_ShipMethodID 
  Sales.SalesOrderHeader  FK_SalesOrderHeader_ShipMethod_ShipMethodID  PK_ShipMethod_ShipMethodID 
Total: 2 table(s)

Objects that [Purchasing].[ShipMethod] depends on

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

Objects that depend on [Purchasing].[ShipMethod]

Object Name Owner Object Type Dep Level
  PurchaseOrderHeader  Purchasing  Table 
  SalesOrderHeader  Sales  Table 
  vSalesPersonSalesByFiscalYears  Sales  View 
  PurchaseOrderDetail  Purchasing  Table 
  SalesOrderDetail  Sales  Table 
  SalesOrderHeaderSalesReason  Sales  Table 
  uPurchaseOrderHeader  Purchasing  Trigger 
  uSalesOrderHeader  Sales  Trigger 
  iduSalesOrderDetail  Sales  Trigger 
  iPurchaseOrderDetail  Purchasing  Trigger 
  uPurchaseOrderDetail  Purchasing  Trigger 
Total: 11 object(s)


CREATE TABLE [ShipMethod] (
    [ShipMethodID] [int] IDENTITY (1, 1) NOT NULL ,
    [Name] [Name] NOT NULL ,
    [ShipBase] [money] NOT NULL CONSTRAINT [DF_ShipMethod_ShipBase] DEFAULT ((0.00)),
    [ShipRate] [money] NOT NULL CONSTRAINT [DF_ShipMethod_ShipRate] DEFAULT ((0.00)),
    [rowguid]  uniqueidentifier ROWGUIDCOL  NOT NULL CONSTRAINT [DF_ShipMethod_rowguid] DEFAULT (newid()),
    [ModifiedDate] [datetime] NOT NULL CONSTRAINT [DF_ShipMethod_ModifiedDate] DEFAULT (getdate()),
    )  ON [PRIMARY] ,
    CONSTRAINT [CK_ShipMethod_ShipBase] CHECK ([ShipBase]>(0.00)),
    CONSTRAINT [CK_ShipMethod_ShipRate] CHECK ([ShipRate]>(0.00))

See Also

List of tables