From dbscript Online Help
|
|
| Line 136: |
Line 136: |
| | | | |
| | |} | | |} |
| | + | |
| | + | |
| | == wikivalues == | | == wikivalues == |
| | | | |
Latest revision as of 09:56, 27 August 2011
wikibot[edit]
| Table
|
Purchasing.ShipMethod
|
| Description
|
Shipping company lookup table.
|
Columns[edit]
| Column
|
Data Type
|
Nullable
|
Default
|
Description
|
| ShipMethodID
|
int
|
not null
|
|
Primary key for ShipMethod records.
|
| Name
|
dbo.Name
|
not null
|
|
Shipping company 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.
|
| ModifiedDate
|
datetime
|
not null
|
(getdate())
|
Date and time the record was last updated.
|
Primary Key[edit]
| Primary Key
|
Columns
|
| PK_ShipMethod_ShipMethodID
|
ShipMethodID
|
Indexes[edit]
| Index
|
Type
|
Columns
|
| AK_ShipMethod_Name
|
Unique
|
Name
|
| AK_ShipMethod_rowguid
|
Unique
|
rowguid
|
Check Constraints[edit]
| Check Constraint
|
Expression
|
Description
|
| CK_ShipMethod_ShipBase
|
([ShipBase]>(0.00))
|
Check constraint [ShipBase] > (0.00)
|
| CK_ShipMethod_ShipRate
|
([ShipRate]>(0.00))
|
Check constraint [ShipRate] > (0.00)
|
Detail Tables[edit]
References[edit]
| Dependency Type
|
Object Type
|
Referenced Object
|
| Data Type
|
Type
|
dbo.Name
|
| Schema
|
Schema
|
Purchasing
|
wikivalues[edit]
| 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[edit]
| 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.
|
| Dependency Type
|
Object Type
|
Referenced Object
|
| Data Type
|
Type
|
dbo.Name
|
| Schema
|
Schema
|
Purchasing
|
