Table: 'Purchasing.ShipMethod'

6 fields. 178 bytes.

Shipping company lookup table.

Field NameData TypeSizeOriginal TypeDefaultNullableDescriptionCheck
ShipMethodIDint identity int Not nullPrimary key for ShipMethod records. 
NameName nvarchar(50) Not nullShipping company name. 
ShipBasemoney19,4decimal(19,4)(0.00)Not nullMinimum shipping charge.([ShipBase]>(0.00))
ShipRatemoney19,4decimal(19,4)(0.00)Not nullShipping charge per pound.([ShipRate]>(0.00))
rowguiduniqueidentifier  newid()Not nullROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. 
ModifiedDatedatetime  getdate()Not nullDate and time the record was last updated. 

Extended Properties

The object has no extended properties.

Primary key for table 'Purchasing.ShipMethod'

Primary Key NameField Name
There are no Foreign Keys for this table.

Indexes for table 'Purchasing.ShipMethod', 3 items

Index NameDescriptionClusteredUniqueFields
PK_ShipMethod_ShipMethodIDClustered index created by a primary key constraint.YesYesShipMethodID
AK_ShipMethod_NameUnique nonclustered index.NoYesName
AK_ShipMethod_rowguidUnique nonclustered index. Used to support replication samples.NoYesrowguid

Triggers for table 'Purchasing.ShipMethod', 1 item

uShipMethodAFTER 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 NameTypeField Name
Purchasing.CK_ShipMethod_ShipBasecheck cnsN/A
Purchasing.CK_ShipMethod_ShipRatecheck cnsN/A