|
Key
|
ID
|
Name
|
Data Type
|
Size(Precision,Scale)
|
Nulls
|
Default
|
|
|
OrderID
|
int
|
0
|
|
|
| |
The primary key for each order.
|
|
|
|
CustomerID
|
nchar
|
5
|
|
|
| |
The customer for this order.
|
|
|
|
EmployeeID
|
int
|
0
|
|
|
| |
The salesman for this order.
|
|
|
|
OrderDate
|
datetime
|
0
|
|
|
| |
The date the order was placed.
|
|
|
|
RequiredDate
|
datetime
|
0
|
|
|
| |
The date that the order is required.
|
|
|
|
ShippedDate
|
datetime
|
0
|
|
|
| |
The date that the order was shipped.
|
|
|
|
ShipVia
|
int
|
0
|
|
|
| |
The shipping method for this order.
|
|
|
|
Freight
|
money
|
0
|
|
(0)
|
| |
The cost to ship this order.
|
|
|
|
ShipName
|
nvarchar
|
40
|
|
|
| |
The person's name to ship this order to.
|
|
|
|
ShipAddress
|
nvarchar
|
60
|
|
|
| |
The street address to ship the order to.
|
|
|
|
ShipCity
|
nvarchar
|
15
|
|
|
| |
The city to ship the order to.
|
|
|
|
ShipRegion
|
nvarchar
|
15
|
|
|
| |
The region to ship the order to.
|
|
|
|
ShipPostalCode
|
nvarchar
|
10
|
|
|
| |
The postal code to ship the order to.
|
|
|
|
ShipCountry
|
nvarchar
|
15
|
|
|
| |
The country to ship the order to.
|
Orders (Created 8/6/2000 1:34:06 AM)