Properties

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

Columns

		Name	Data Type	Length	NULL	Default	IsIdentity	IsGUID	Description
		ShipMethodID	int	4					Primary key for ShipMethod records.
		Name	Name	100					Shipping company name.
		ShipBase	money	8		((0.00))			Minimum shipping charge.
		ShipRate	money	8		((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	8		(getdate())			Date and time the record was last updated.

Total: 6 column(s)

Identity column

	Name	Seed	Increment	Not for replication
	ShipMethodID	1	1

Indexes

	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	1

Total: 1 object(s)

Objects that depend on [Purchasing].[ShipMethod]

	Object Name	Owner	Object Type	Dep Level
	PurchaseOrderHeader	Purchasing	Table	1
	SalesOrderHeader	Sales	Table	1
	vSalesPersonSalesByFiscalYears	Sales	View	2
	PurchaseOrderDetail	Purchasing	Table	2
	SalesOrderDetail	Sales	Table	2
	SalesOrderHeaderSalesReason	Sales	Table	2
	uPurchaseOrderHeader	Purchasing	Trigger	2
	uSalesOrderHeader	Sales	Trigger	2
	iduSalesOrderDetail	Sales	Trigger	3
	iPurchaseOrderDetail	Purchasing	Trigger	3
	uPurchaseOrderDetail	Purchasing	Trigger	3

Total: 11 object(s)

SQL

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()),
    CONSTRAINT [PK_ShipMethod_ShipMethodID] PRIMARY KEY  CLUSTERED
    (
        [ShipMethodID]
    )  ON [PRIMARY] ,
    CONSTRAINT [CK_ShipMethod_ShipBase] CHECK ([ShipBase]>(0.00)),
    CONSTRAINT [CK_ShipMethod_ShipRate] CHECK ([ShipRate]>(0.00))
) ON [PRIMARY]
GO

See Also

List of tables