From dbscript Online Help
wikibot
| Table
|
Purchasing.ShipMethod
|
| Column
|
Data Type
|
Nullable
|
Default
|
PK
|
Index
|
| ShipMethodID
|
int
|
not null
|
|
PK_ShipMethod_ShipMethodID
|
|
| Name
|
dbo.Name
|
not null
|
|
|
AK_ShipMethod_Name
|
| ShipBase
|
money
|
not null
|
((0.00))
|
|
|
| ShipRate
|
money
|
not null
|
((0.00))
|
|
|
| rowguid
|
uniqueidentifier
|
not null
|
(newid())
|
|
AK_ShipMethod_rowguid
|
| ModifiedDate
|
datetime
|
not null
|
(getdate())
|
|
|
wikivalues
| Table Values
|
Purchasing.ShipMethod
|
| ShipMethodID
|
Name
|
ShipBase
|
ShipRate
|
| 1
|
XRQ - TRUCK GROUND
|
3.95
|
0.99
|
| 2
|
ZY - EXPRESS
|
9.95
|
1.99
|
| 3
|
OVERSEAS - DELUXE
|
29.95
|
2.99
|
| 4
|
OVERNIGHT J-FAST
|
21.95
|
1.29
|
| 5
|
CARGO TRANSPORT 5
|
8.99
|
1.49
|
automatically generated
| Table
|
Purchasing.ShipMethod
|
| Description
|
Shipping company lookup table.
|
| Column
|
Data Type
|
Nullable
|
Default
|
Description
|
PK / Index
|
| ShipMethodID
|
int
|
not null
|
|
Primary key for ShipMethod records.
|
PK_ShipMethod_ShipMethodID
|
| Name
|
Name
|
not null
|
|
Shipping company name.
|
AK_ShipMethod_Name
|
| ShipBase
|
money
|
not null
|
(0.00)
|
Minimum shipping charge.
|
|
| ShipRate
|
money
|
not null
|
(0.00)
|
Shipping charge per pound.
|
|
| rowguid
|
uniqueidentifier
|
not null
|
(NEWID())
|
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
|
AK_ShipMethod_rowguid
|
| ModifiedDate
|
datetime
|
not null
|
(GETDATE())
|
Date and time the record was last updated.
|
|
