Purchasing.ShipMethod

Table: 'Purchasing.ShipMethod'

6 fields. 178 bytes.

Shipping company lookup table.

Field Name Data Type Size Original Type Default Nullable Description Check

ShipMethodID int identity int Not null Primary key for ShipMethod records.

Name Name nvarchar(50) Not null Shipping company name.

ShipBase money 19,4 decimal(19,4) (0.00) Not null Minimum shipping charge. ([ShipBase]>(0.00))

ShipRate money 19,4 decimal(19,4) (0.00) Not null Shipping charge per pound. ([ShipRate]>(0.00))

rowguid uniqueidentifier newid() Not null ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.

ModifiedDate datetime getdate() Not null Date and time the record was last updated.

Field Name	Data Type	Size	Original Type	Default	Nullable	Description	Check
ShipMethodID	int identity		int		Not null	Primary key for ShipMethod records.
Name	Name		nvarchar(50)		Not null	Shipping company name.
ShipBase	money	19,4	decimal(19,4)	(0.00)	Not null	Minimum shipping charge.	([ShipBase]>(0.00))
ShipRate	money	19,4	decimal(19,4)	(0.00)	Not null	Shipping charge per pound.	([ShipRate]>(0.00))
rowguid	uniqueidentifier			newid()	Not null	ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDate	datetime			getdate()	Not null	Date and time the record was last updated.

Extended Properties

The object has no extended properties.

Primary key for table 'Purchasing.ShipMethod'

Primary Key Name Field Name

PK_ShipMethod_ShipMethodID ShipMethodID

There are no Foreign Keys for this table.

Primary Key Name	Field Name
PK_ShipMethod_ShipMethodID	ShipMethodID

Indexes for table 'Purchasing.ShipMethod', 3 items

Index Name Description Clustered Unique Fields

PK_ShipMethod_ShipMethodID Clustered index created by a primary key constraint. Yes Yes ShipMethodID

AK_ShipMethod_Name Unique nonclustered index. No Yes Name

AK_ShipMethod_rowguid Unique nonclustered index. Used to support replication samples. No Yes rowguid

Index Name	Description	Clustered	Unique	Fields
PK_ShipMethod_ShipMethodID	Clustered index created by a primary key constraint.	Yes	Yes	ShipMethodID
AK_ShipMethod_Name	Unique nonclustered index.	No	Yes	Name
AK_ShipMethod_rowguid	Unique nonclustered index. Used to support replication samples.	No	Yes	rowguid

Triggers for table 'Purchasing.ShipMethod', 1 item

Name Description Type Enabled

uShipMethod AFTER UPDATE trigger setting the ModifiedDate column in the ShipMethod table to the current date. after Update Yes

Name	Description	Type	Enabled
uShipMethod	AFTER UPDATE trigger setting the ModifiedDate column in the ShipMethod table to the current date.	after Update	Yes

Dependencies for table 'Purchasing.ShipMethod', 3 items

Object Name Type Field Name

Purchasing.CK_ShipMethod_ShipBase check cns N/A

Purchasing.CK_ShipMethod_ShipRate check cns N/A

Purchasing.uShipMethod trigger N/A

Object Name	Type	Field Name
Purchasing.CK_ShipMethod_ShipBase	check cns	N/A
Purchasing.CK_ShipMethod_ShipRate	check cns	N/A
Purchasing.uShipMethod	trigger	N/A