AdventureWorks
| Table Name: | Purchasing.ShipMethod |
| Description: | Shipping company lookup table. |
| Primary Keys: | ShipMethodID |
| Field | Type | Defaults | Nulls? | Comments |
|---|---|---|---|---|
| ShipMethodID | int - Identity | None | No | Primary key for ShipMethod records. |
| Name | nvarchar (50) | None | No | Shipping company name. |
| ShipBase | money | ((0.00)) | No | Minimum shipping charge. |
| ShipRate | money | ((0.00)) | No | Shipping charge per pound. |
| rowguid | uniqueidentifier | (newid()) | No | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. |
| ModifiedDate | datetime | (getdate()) | No | Date and time the record was last updated. |
| Index | Clustered? | Unique? | Fields |
|---|---|---|---|
| PK_ShipMethod_ShipMethodID | Yes | Yes | ShipMethodID |
| AK_ShipMethod_Name | No | Yes | Name |
| AK_ShipMethod_rowguid | No | Yes | rowguid |
| Check Constraint | Text |
|---|---|
| CK_ShipMethod_ShipBase | ([ShipBase]>(0.00)) |
| CK_ShipMethod_ShipRate | ([ShipRate]>(0.00)) |
| Primary Key as Foreign Key Constraint | Affected Table | Affected Field |
|---|---|---|
| FK_PurchaseOrderHeader_ShipMethod_ShipMethodID | Purchasing.PurchaseOrderHeader | ShipMethodID |
| FK_SalesOrderHeader_ShipMethod_ShipMethodID | Sales.SalesOrderHeader | ShipMethodID |