Purchasing.ShipMethod
| Documentation | AdventureWorks |
| Schema | Purchasing |
| Name | ShipMethod |
| Module | Purchasing |
Shipping company lookup table.
Columns
| Key | Name | Data type | Null | Attributes | References | Description | ||
|---|---|---|---|---|---|---|---|---|
| 1 | ShipMethodID | int | Identity | Primary key for ShipMethod records. | ||||
| Primary key for ShipMethod records. Identity |
||||||||
| 2 | Name | nvarchar(50) | Shipping company name. | |||||
| Shipping company name. |
||||||||
| 3 | ShipBase | money | Default: 0.00 | Minimum shipping charge. | ||||
| Minimum shipping charge. Default: 0.00 |
||||||||
| 4 | ShipRate | money | Default: 0.00 | Shipping charge per pound. | ||||
| Shipping charge per pound. Default: 0.00 |
||||||||
| 5 | rowguid | uniqueidentifier | Default: newid() | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. | ||||
| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. Default: newid() |
||||||||
| 6 | ModifiedDate | datetime | Default: getdate() | Date and time the record was last updated. | ||||
| Date and time the record was last updated. Default: getdate() |
||||||||
Relations
| Foreign table | Primary table | Join | Title / Name / Description | |
|---|---|---|---|---|
| Purchasing.PurchaseOrderHeader | Purchasing.ShipMethod | Purchasing.PurchaseOrderHeader.ShipMethodID = Purchasing.ShipMethod.ShipMethodID | FK_PurchaseOrderHeader_ShipMethod_ShipMethodID Foreign key constraint referencing ShipMethod.ShipMethodID. |
|
|
Purchasing.PurchaseOrderHeader.ShipMethodID = Purchasing.ShipMethod.ShipMethodID Name: FK_PurchaseOrderHeader_ShipMethod_ShipMethodIDForeign key constraint referencing ShipMethod.ShipMethodID. |
||||
| Sales.SalesOrderHeader | Purchasing.ShipMethod | Sales.SalesOrderHeader.ShipMethodID = Purchasing.ShipMethod.ShipMethodID | FK_SalesOrderHeader_ShipMethod_ShipMethodID Foreign key constraint referencing ShipMethod.ShipMethodID. |
|
|
Sales.SalesOrderHeader.ShipMethodID = Purchasing.ShipMethod.ShipMethodID Name: FK_SalesOrderHeader_ShipMethod_ShipMethodIDForeign key constraint referencing ShipMethod.ShipMethodID. |
||||
Unique keys
| Key name | Columns | Description | |
|---|---|---|---|
| PK_ShipMethod_ShipMethodID | ShipMethodID | Primary key (clustered) constraint | |
| Primary key (clustered) constraint | |||
| AK_ShipMethod_Name | Name | Unique nonclustered index. | |
| Unique nonclustered index. | |||
| AK_ShipMethod_rowguid | rowguid | Unique nonclustered index. Used to support replication samples. | |
| Unique nonclustered index. Used to support replication samples. | |||
Used by
| Name |
|---|
|
Purchasing.ShipMethod
|
Exported: 2019-02-04 23:13, Last imported: 2018-03-07 11:56